APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 610: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

606: FROM MTL_ITEM_BULKLOAD_RECS
607: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
608:
609: -- Updating bill components rows
610: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
611: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
612: PROCESS_FLAG = 1
613: WHERE BUNDLE_ID IN
614: (SELECT BUNDLE_ID

Line 658: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI

654: (SELECT BUNDLE_ID
655: FROM MTL_ITEM_BULKLOAD_RECS
656: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
657:
658: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
659: SET ORGANIZATION_ID = (SELECT ORGANIZATION_ID
660: FROM MTL_SYSTEM_ITEMS_INTERFACE
661: WHERE BUNDLE_ID = BICI.BUNDLE_ID
662: AND ROWNUM = 1),

Line 1891: INSERT INTO BOM_INVENTORY_COMPS_INTERFACE(

1887: );
1888:
1889: FOR l_xml_component IN c_component(l_xml_structure.structures)
1890: LOOP
1891: INSERT INTO BOM_INVENTORY_COMPS_INTERFACE(
1892: transaction_id,
1893: batch_id,
1894: --source_system_id,
1895: parent_source_system_reference,