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 2126: ,mtl_system_items_interface msii

2122: ,msii.source_system_id
2123: ,msii.bundle_id
2124: ,G_REQUEST_ID
2125: FROM ego_item_associations eia
2126: ,mtl_system_items_interface msii
2127: ,mtl_parameters mp
2128: WHERE eia.inventory_item_id = p_src_item_id
2129: -- AND msii.organization_id = mp.organization_id Copy_Item_Id will be populated only for master org items
2130: --AND mp.organization_id = mp.master_organization_id Copy all triple intersections

Line 2284: ,mtl_system_items_interface msii

2280: ,msii.bundle_id
2281: ,G_REQUEST_ID
2282: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2283: FROM ego_item_associations eia
2284: ,mtl_system_items_interface msii
2285: ,mtl_parameters mp
2286: ,mtl_system_items_interface msii2
2287: WHERE eia.inventory_item_id = msii2.style_item_id
2288: AND msii.organization_id = mp.organization_id

Line 2286: ,mtl_system_items_interface msii2

2282: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2283: FROM ego_item_associations eia
2284: ,mtl_system_items_interface msii
2285: ,mtl_parameters mp
2286: ,mtl_system_items_interface msii2
2287: WHERE eia.inventory_item_id = msii2.style_item_id
2288: AND msii.organization_id = mp.organization_id
2289: AND msii.set_process_id = p_batch_id
2290: AND eia.data_level_id = G_ITEM_SUPPLIERSITE_ORG_LEVEL

Line 2362: ,mtl_system_items_interface msii

2358: ,msii.bundle_id
2359: ,G_REQUEST_ID
2360: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2361: FROM ego_item_associations eia
2362: ,mtl_system_items_interface msii
2363: ,mtl_parameters mp
2364: WHERE eia.inventory_item_id = msii.style_item_id
2365: AND msii.organization_id = mp.organization_id
2366: --AND mp.organization_id = mp.master_organization_id

Line 2433: ,mtl_system_items_interface_s.NEXTVAL

2429: ,eiai1.primary_flag
2430: ,eiai1.status_code
2431: ,G_CREATE
2432: ,G_REC_TO_BE_PROCESSED
2433: ,mtl_system_items_interface_s.NEXTVAL
2434: ,NULL
2435: ,NULL
2436: ,NULL
2437: ,G_REQUEST_ID

Line 2676: ,mtl_system_items_interface_s.NEXTVAL

2672: ,eiai.primary_flag
2673: ,eiai.status_code
2674: ,G_CREATE
2675: ,G_REC_TO_BE_PROCESSED
2676: ,mtl_system_items_interface_s.NEXTVAL
2677: ,G_REQUEST_ID
2678: ,G_SKIP_SECURIY_CHECK -- Bug 6459846
2679: FROM ego_item_associations_intf eiai, mtl_system_items_b_kfv msibk,
2680: mtl_parameters mp