APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on EGO_ITEM_ASSOCIATIONS_INTF

Line 577: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI

573: FROM MTL_ITEM_BULKLOAD_RECS
574: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
575:
576: -- Updating items association rows
577: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
578: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
579: PROCESS_FLAG = C_INIT_PROCESS_FLAG,
580: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID
581: FROM EGO_IMPORT_BATCHES_B

Line 692: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI

688: (SELECT BUNDLE_ID
689: FROM MTL_ITEM_BULKLOAD_RECS
690: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
691:
692: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
693: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
694: FROM ap_supplier_sites_all asa,
695: ap_supplier_sites_all asa2,
696: mtl_system_items_interface msii

Line 728: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI

724: (SELECT BUNDLE_ID
725: FROM MTL_ITEM_BULKLOAD_RECS
726: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
727:
728: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
729: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
730: FROM ap_supplier_sites_all asa,
731: ap_supplier_sites_all asa2,
732: mtl_system_items_interface msii

Line 1635: INSERT INTO EGO_ITEM_ASSOCIATIONS_INTF(

1631: IF l_supplier_id IS NULL
1632: THEN
1633: RAISE EGO_ORC_INVALID_GLN;
1634: ELSE
1635: INSERT INTO EGO_ITEM_ASSOCIATIONS_INTF(
1636: transaction_id,
1637: batch_id,
1638: source_system_id,
1639: source_system_reference,

Line 1714: INSERT INTO EGO_ITEM_ASSOCIATIONS_INTF(

1710:
1711: -- bug:6485109 Insert a row for item supplier site for item supplier site org
1712: IF ( l_supplier_attr_level = 'ITEM_SUP_SITE_ORG')
1713: THEN
1714: INSERT INTO EGO_ITEM_ASSOCIATIONS_INTF(
1715: transaction_id,
1716: batch_id,
1717: source_system_id,
1718: source_system_reference,

Line 1758: INSERT INTO EGO_ITEM_ASSOCIATIONS_INTF(

1754: );
1755:
1756: END IF;
1757:
1758: INSERT INTO EGO_ITEM_ASSOCIATIONS_INTF(
1759: transaction_id,
1760: batch_id,
1761: source_system_id,
1762: source_system_reference,