Index: branches/IBSRegularRelease/TIBCOApp/IBSDataAccessService/BW/IBSDataAccessService/Processes/ActionProcess/WorkOrder/SearchAsset.process
===================================================================
diff -u -r183938 -r241022
--- branches/IBSRegularRelease/TIBCOApp/IBSDataAccessService/BW/IBSDataAccessService/Processes/ActionProcess/WorkOrder/SearchAsset.process	(.../SearchAsset.process)	(revision 183938)
+++ branches/IBSRegularRelease/TIBCOApp/IBSDataAccessService/BW/IBSDataAccessService/Processes/ActionProcess/WorkOrder/SearchAsset.process	(.../SearchAsset.process)	(revision 241022)
@@ -1254,7 +1254,7 @@
 A.VIN_DECD_MOD_NM "VIN_DECODE_MODEL", A.VIN_DECD_ENGN_NM "VIN_DECODE_ENGINE",A.VIN_DECD_YR_NUM "VIN_DECODE_YEAR",B.AST_EXT_ID "ASSET_EXT_ID",B.SER_NUM "SERIAL_NO",B.TYP_CD "TYPE",B.AST_EXT_DESC "EXTDESC",B.MK_NM "EXTMAKE" ,
 B.MOD_NM "EXTMODEL",B.YR_NUM "EXTYEAR",B.IBS_AST_ID "EXTASSETID",A.IS_LD_SUC "IsLoadSuccess"
 from  AST A, AST_EXT B 
-where  UPPER(A.IBS_AST_ID) = ?
+where  A.IBS_AST_ID = ?
 and A.IBS_AST_ID = B.IBS_AST_ID(+)</statement>
             <Prepared_Param_DataType>
                 <parameter>
Index: branches/IBSRegularRelease/TIBCOApp/IBSManageWorkOrder/BW/IBSManageWorkOrder/Processes/ActionProcess/WorkOrder/SearchAsset.process
===================================================================
diff -u -r223728 -r241022
--- branches/IBSRegularRelease/TIBCOApp/IBSManageWorkOrder/BW/IBSManageWorkOrder/Processes/ActionProcess/WorkOrder/SearchAsset.process	(.../SearchAsset.process)	(revision 223728)
+++ branches/IBSRegularRelease/TIBCOApp/IBSManageWorkOrder/BW/IBSManageWorkOrder/Processes/ActionProcess/WorkOrder/SearchAsset.process	(.../SearchAsset.process)	(revision 241022)
@@ -1285,7 +1285,7 @@
 A.VIN_DECD_MOD_NM "VIN_DECODE_MODEL", A.VIN_DECD_ENGN_NM "VIN_DECODE_ENGINE",A.VIN_DECD_YR_NUM "VIN_DECODE_YEAR",B.AST_EXT_ID "ASSET_EXT_ID",B.SER_NUM "SERIAL_NO",B.TYP_CD "TYPE",B.AST_EXT_DESC "EXTDESC",B.MK_NM "EXTMAKE" ,
 B.MOD_NM "EXTMODEL",B.YR_NUM "EXTYEAR",B.IBS_AST_ID "EXTASSETID",A.IS_LD_SUC "IsLoadSuccess"
 from  AST A, AST_EXT B 
-where  UPPER(A.IBS_AST_ID) = ?
+where  A.IBS_AST_ID = ?
 and A.IBS_AST_ID = B.IBS_AST_ID(+)</statement>
             <Prepared_Param_DataType>
                 <parameter>
Index: branches/IBSRegularRelease/TIBCOApp/IBSFMSWorkOrder/BW/IBSFMSWorkOrder/Processes/ActionProcess/WorkOrder/SearchAsset.process
===================================================================
diff -u -r231441 -r241022
--- branches/IBSRegularRelease/TIBCOApp/IBSFMSWorkOrder/BW/IBSFMSWorkOrder/Processes/ActionProcess/WorkOrder/SearchAsset.process	(.../SearchAsset.process)	(revision 231441)
+++ branches/IBSRegularRelease/TIBCOApp/IBSFMSWorkOrder/BW/IBSFMSWorkOrder/Processes/ActionProcess/WorkOrder/SearchAsset.process	(.../SearchAsset.process)	(revision 241022)
@@ -1255,7 +1255,7 @@
 A.VIN_DECD_MOD_NM "VIN_DECODE_MODEL", A.VIN_DECD_ENGN_NM "VIN_DECODE_ENGINE",A.VIN_DECD_YR_NUM "VIN_DECODE_YEAR",B.AST_EXT_ID "ASSET_EXT_ID",B.SER_NUM "SERIAL_NO",B.TYP_CD "TYPE",B.AST_EXT_DESC "EXTDESC",B.MK_NM "EXTMAKE" ,
 B.MOD_NM "EXTMODEL",B.YR_NUM "EXTYEAR",B.IBS_AST_ID "EXTASSETID",A.IS_LD_SUC "IsLoadSuccess"
 from  AST A, AST_EXT B 
-where  UPPER(A.IBS_AST_ID) = ?
+where  A.IBS_AST_ID = ?
 and A.IBS_AST_ID = B.IBS_AST_ID(+)</statement>
             <Prepared_Param_DataType>
                 <parameter>
Index: branches/IBSRegularRelease/TIBCOApp/IBSInvoiceMgmt/BW/IBSInvoiceMgmt/Processes/ActionProcess/WorkOrder/SearchAsset.process
===================================================================
diff -u -r234068 -r241022
--- branches/IBSRegularRelease/TIBCOApp/IBSInvoiceMgmt/BW/IBSInvoiceMgmt/Processes/ActionProcess/WorkOrder/SearchAsset.process	(.../SearchAsset.process)	(revision 234068)
+++ branches/IBSRegularRelease/TIBCOApp/IBSInvoiceMgmt/BW/IBSInvoiceMgmt/Processes/ActionProcess/WorkOrder/SearchAsset.process	(.../SearchAsset.process)	(revision 241022)
@@ -1254,7 +1254,7 @@
 A.VIN_DECD_MOD_NM "VIN_DECODE_MODEL", A.VIN_DECD_ENGN_NM "VIN_DECODE_ENGINE",A.VIN_DECD_YR_NUM "VIN_DECODE_YEAR",B.AST_EXT_ID "ASSET_EXT_ID",B.SER_NUM "SERIAL_NO",B.TYP_CD "TYPE",B.AST_EXT_DESC "EXTDESC",B.MK_NM "EXTMAKE" ,
 B.MOD_NM "EXTMODEL",B.YR_NUM "EXTYEAR",B.IBS_AST_ID "EXTASSETID",A.IS_LD_SUC "IsLoadSuccess"
 from  AST A, AST_EXT B 
-where  UPPER(A.IBS_AST_ID) = ?
+where  A.IBS_AST_ID = ?
 and A.IBS_AST_ID = B.IBS_AST_ID(+)</statement>
             <Prepared_Param_DataType>
                 <parameter>