DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on BOM_SUB_COMPS_INTERFACE

Line 6015: UPDATE BOM_SUB_COMPS_INTERFACE

6011: WHERE PROCESS_FLAG = 1
6012: AND BATCH_ID = p_batch_id
6013: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
6014:
6015: UPDATE BOM_SUB_COMPS_INTERFACE
6016: SET ASSEMBLY_ITEM_NUMBER = p_item_number
6017: WHERE PROCESS_FLAG = 1
6018: AND BATCH_ID = p_batch_id
6019: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 6021: UPDATE BOM_SUB_COMPS_INTERFACE

6017: WHERE PROCESS_FLAG = 1
6018: AND BATCH_ID = p_batch_id
6019: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
6020:
6021: UPDATE BOM_SUB_COMPS_INTERFACE
6022: SET COMPONENT_ITEM_NUMBER = p_item_number
6023: WHERE PROCESS_FLAG = 1
6024: AND BATCH_ID = p_batch_id
6025: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 6027: UPDATE BOM_SUB_COMPS_INTERFACE

6023: WHERE PROCESS_FLAG = 1
6024: AND BATCH_ID = p_batch_id
6025: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
6026:
6027: UPDATE BOM_SUB_COMPS_INTERFACE
6028: SET SUBSTITUTE_COMP_NUMBER = p_item_number
6029: WHERE PROCESS_FLAG = 1
6030: AND BATCH_ID = p_batch_id
6031: AND ( SUBSTITUTE_COMP_NUMBER = p_old_item_number OR SUBCOM_SOURCE_SYSTEM_REFERENCE = p_ss_ref );