DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on BOM_REF_DESGS_INTERFACE

Line 6033: UPDATE BOM_REF_DESGS_INTERFACE

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 );
6032:
6033: UPDATE BOM_REF_DESGS_INTERFACE
6034: SET ASSEMBLY_ITEM_NUMBER = p_item_number
6035: WHERE PROCESS_FLAG = 1
6036: AND BATCH_ID = p_batch_id
6037: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 6039: UPDATE BOM_REF_DESGS_INTERFACE

6035: WHERE PROCESS_FLAG = 1
6036: AND BATCH_ID = p_batch_id
6037: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
6038:
6039: UPDATE BOM_REF_DESGS_INTERFACE
6040: SET COMPONENT_ITEM_NUMBER = p_item_number
6041: WHERE PROCESS_FLAG = 1
6042: AND BATCH_ID = p_batch_id
6043: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );