APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 130: SET transaction_id = mtl_system_items_interface_s.nextval

126: AND transaction_id IS NULL
127: )
128: LOOP
129: UPDATE ego_item_associations_intf
130: SET transaction_id = mtl_system_items_interface_s.nextval
131: WHERE ROWID = l_null_tx_rec.ROWID;
132: END LOOP;
133: -- Set the process flag to in process
134: UPDATE ego_item_associations_intf

Line 2059: ,mtl_system_items_interface msii

2055: ,msii.source_system_id
2056: ,msii.bundle_id
2057: ,G_REQUEST_ID
2058: FROM ego_item_associations eia
2059: ,mtl_system_items_interface msii
2060: ,mtl_parameters mp
2061: WHERE eia.inventory_item_id = p_src_item_id
2062: -- AND msii.organization_id = mp.organization_id Copy_Item_Id will be populated only for master org items
2063: --AND mp.organization_id = mp.master_organization_id Copy all triple intersections

Line 2216: ,mtl_system_items_interface msii

2212: ,msii.bundle_id
2213: ,G_REQUEST_ID
2214: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2215: FROM ego_item_associations eia
2216: ,mtl_system_items_interface msii
2217: ,mtl_parameters mp
2218: ,mtl_system_items_interface msii2
2219: WHERE eia.inventory_item_id = msii2.style_item_id
2220: AND msii.organization_id = mp.organization_id

Line 2218: ,mtl_system_items_interface msii2

2214: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2215: FROM ego_item_associations eia
2216: ,mtl_system_items_interface msii
2217: ,mtl_parameters mp
2218: ,mtl_system_items_interface msii2
2219: WHERE eia.inventory_item_id = msii2.style_item_id
2220: AND msii.organization_id = mp.organization_id
2221: AND msii.set_process_id = p_batch_id
2222: AND eia.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL

Line 2294: ,mtl_system_items_interface msii

2290: ,msii.bundle_id
2291: ,G_REQUEST_ID
2292: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2293: FROM ego_item_associations eia
2294: ,mtl_system_items_interface msii
2295: ,mtl_parameters mp
2296: WHERE eia.inventory_item_id = msii.style_item_id
2297: AND msii.organization_id = mp.organization_id
2298: --AND mp.organization_id = mp.master_organization_id

Line 2365: ,mtl_system_items_interface_s.NEXTVAL

2361: ,eiai1.primary_flag
2362: ,eiai1.status_code
2363: ,G_CREATE
2364: ,G_REC_TO_BE_PROCESSED
2365: ,mtl_system_items_interface_s.NEXTVAL
2366: ,NULL
2367: ,NULL
2368: ,NULL
2369: ,G_REQUEST_ID

Line 2608: ,mtl_system_items_interface_s.NEXTVAL

2604: ,eiai.primary_flag
2605: ,eiai.status_code
2606: ,G_CREATE
2607: ,G_REC_TO_BE_PROCESSED
2608: ,mtl_system_items_interface_s.NEXTVAL
2609: ,G_REQUEST_ID
2610: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2611: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk,
2612: mtl_parameters mp