DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on BOM_REF_DESGS_INTERFACE

Line 5249: UPDATE BOM_REF_DESGS_INTERFACE

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 );
5248:
5249: UPDATE BOM_REF_DESGS_INTERFACE
5250: SET ASSEMBLY_ITEM_NUMBER = p_item_number
5251: WHERE PROCESS_FLAG = 1
5252: AND BATCH_ID = p_batch_id
5253: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );

Line 5255: UPDATE BOM_REF_DESGS_INTERFACE

5251: WHERE PROCESS_FLAG = 1
5252: AND BATCH_ID = p_batch_id
5253: AND ( ASSEMBLY_ITEM_NUMBER = p_old_item_number OR PARENT_SOURCE_SYSTEM_REFERENCE = p_ss_ref );
5254:
5255: UPDATE BOM_REF_DESGS_INTERFACE
5256: SET COMPONENT_ITEM_NUMBER = p_item_number
5257: WHERE PROCESS_FLAG = 1
5258: AND BATCH_ID = p_batch_id
5259: AND ( COMPONENT_ITEM_NUMBER = p_old_item_number OR COMP_SOURCE_SYSTEM_REFERENCE = p_ss_ref );