APPS.GME_BATCH_STEP_CHG_PVT dependencies on MTL_SYSTEM_ITEMS

Line 268: -- Bug 8708957 - Correct cursor to use mtl_system_items and proper joins also.

264: will be applied in the step. The sequence type will be found for operation
265: specific or global, hence there will be two outer joins */
266: l_api_name CONSTANT VARCHAR2 (30) := 'set_sequence_dependent_id';
267:
268: -- Bug 8708957 - Correct cursor to use mtl_system_items and proper joins also.
269: CURSOR get_batch_details (v_batch_id NUMBER)
270: IS
271: SELECT gsr.batchstep_resource_id, 1 sds_type, gst.seq_dep_id
272: FROM gme_batch_header gbh

Line 278: ,mtl_system_items iim -- 8708957 - Change this from ic_item_mst to mtl_system_items

274: ,gme_batch_steps gbs
275: ,gme_batch_step_activities gsa
276: ,gme_batch_step_resources gsr
277: ,cr_rsrc_dtl crd
278: ,mtl_system_items iim -- 8708957 - Change this from ic_item_mst to mtl_system_items
279: ,gmp_sequence_types gst
280: -- 8708957 - two more tables added
281: ,mtl_item_categories mic
282: ,mtl_default_category_sets dcs

Line 311: ,mtl_system_items iim2 -- 8708957 - Change this from ic_item_mst to mtl_system_items

307: ,gme_batch_step_activities gsa2
308: ,gme_batch_step_resources gsr2
309: ,cr_rsrc_dtl crd2
310: ,gmp_sequence_types gst2
311: ,mtl_system_items iim2 -- 8708957 - Change this from ic_item_mst to mtl_system_items
312: -- 8708957 - two more tables added
313: ,mtl_item_categories mic2
314: ,mtl_default_category_sets dcs2
315: WHERE gbh2.batch_id = v_batch_id