APPS.EGO_MASS_UPDATE_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 91: INSERT INTO mtl_system_items_interface

87: -- Insert all Item-Org pairs into Item Open Interface Table - MSII with
88: -- the same set_process_id. This will be changed in update loop.
89: -- =====================================================================
90:
91: INSERT INTO mtl_system_items_interface
92: ( process_flag
93: , set_process_id
94: , transaction_type
95: , inventory_item_id

Line 189: UPDATE mtl_system_items_interface

185: /* SELECT mtl_system_items_intf_sets_s.NEXTVAL
186: INTO l_batch_set_process_id
187: FROM dual;
188:
189: UPDATE mtl_system_items_interface
190: SET set_process_id = l_batch_set_process_id
191: WHERE set_process_id = l_set_process_id
192: AND ROWNUM <= l_max_batch_size;
193:

Line 238: , MTL_SYSTEM_ITEMS_INTERFACE_S.nextval --- TRANSACTION_ID

234: , msii.organization_id
235: , mp.starting_revision
236: , SYSDATE
237: , SYSDATE
238: , MTL_SYSTEM_ITEMS_INTERFACE_S.nextval --- TRANSACTION_ID
239: , 1
240: , 'CREATE'
241: , l_set_process_id --l_batch_set_process_id
242: , SYSDATE

Line 251: FROM mtl_system_items_interface msii,

247: , FND_GLOBAL.conc_request_id
248: , FND_GLOBAL.prog_appl_id
249: , FND_GLOBAL.conc_program_id
250: , SYSDATE
251: FROM mtl_system_items_interface msii,
252: mtl_parameters mp
253: WHERE msii.set_process_id = l_set_process_id
254: AND mp.organization_id = msii.organization_id;
255: