DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on BOM_SUB_COMPS_INTERFACE

Line 5231: UPDATE BOM_SUB_COMPS_INTERFACE

5227: WHERE PROCESS_FLAG = 1
5228: AND BATCH_ID = p_batch_id
5229: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5230:
5231: UPDATE BOM_SUB_COMPS_INTERFACE
5232: SET ASSEMBLY_ITEM_NUMBER = p_item_number
5233: WHERE PROCESS_FLAG = 1
5234: AND BATCH_ID = p_batch_id
5235: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 5237: UPDATE BOM_SUB_COMPS_INTERFACE

5233: WHERE PROCESS_FLAG = 1
5234: AND BATCH_ID = p_batch_id
5235: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5236:
5237: UPDATE BOM_SUB_COMPS_INTERFACE
5238: SET COMPONENT_ITEM_NUMBER = p_item_number
5239: WHERE PROCESS_FLAG = 1
5240: AND BATCH_ID = p_batch_id
5241: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 5243: UPDATE BOM_SUB_COMPS_INTERFACE

5239: WHERE PROCESS_FLAG = 1
5240: AND BATCH_ID = p_batch_id
5241: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5242:
5243: UPDATE BOM_SUB_COMPS_INTERFACE
5244: SET SUBSTITUTE_COMP_NUMBER = p_item_number
5245: WHERE PROCESS_FLAG = 1
5246: AND BATCH_ID = p_batch_id
5247: AND ( SUBSTITUTE_COMP_NUMBER = p_old_item_number OR SUBCOM_SOURCE_SYSTEM_REFERENCE = p_ss_ref );