eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_BATCH_STEP_CHG_PVT dependencies on GME_BATCH_HEADER

Line 229: FROM gme_batch_header gbh

225: /* select only pending or wip batches */
226: CURSOR get_batches
227: IS
228: SELECT gbh.batch_id
229: FROM gme_batch_header gbh
230: WHERE gbh.batch_status IN (1, 2);
231:
232: v_batch_id NUMBER := 0;
233: BEGIN

Line 272: FROM gme_batch_header gbh

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
273: ,gmd_recipe_validity_rules gvr
274: ,gme_batch_steps gbs
275: ,gme_batch_step_activities gsa
276: ,gme_batch_step_resources gsr

Line 304: FROM gme_batch_header gbh2

300: -- 8708957 - 14 is the seeded value for Sequence Dependency Class. DO NOT CHANGE !!
301: AND dcs.FUNCTIONAL_AREA_ID = 14
302: UNION ALL
303: SELECT gsr2.batchstep_resource_id, 2 sds_type, gst2.seq_dep_id
304: FROM gme_batch_header gbh2
305: ,gmd_recipe_validity_rules gvr2
306: ,gme_batch_steps gbs2
307: ,gme_batch_step_activities gsa2
308: ,gme_batch_step_resources gsr2

Line 341: FROM gme_batch_header gbh

337: /*
338: CURSOR get_batch_details (v_batch_id NUMBER)
339: IS
340: SELECT gsr.batchstep_resource_id, 1 sds_type, gst.seq_dep_id
341: FROM gme_batch_header gbh
342: ,gmd_recipe_validity_rules gvr
343: ,gme_batch_steps gbs
344: ,gme_batch_step_activities gsa
345: ,gme_batch_step_resources gsr

Line 364: FROM gme_batch_header gbh2

360: AND iim.seq_category_id = gst.category_id
361: AND gbs.oprn_id = gst.oprn_id
362: UNION ALL
363: SELECT gsr2.batchstep_resource_id, 2 sds_type, gst2.seq_dep_id
364: FROM gme_batch_header gbh2
365: ,gmd_recipe_validity_rules gvr2
366: ,gme_batch_steps gbs2
367: ,gme_batch_step_activities gsa2
368: ,gme_batch_step_resources gsr2

Line 458: FROM gme_batch_header gbh

454: the batch also has to be pending or WIP for this to happen */
455: CURSOR get_batches
456: IS
457: SELECT gbh.batch_id
458: FROM gme_batch_header gbh
459: WHERE gbh.batch_status IN (1, 2)
460: AND gbh.batch_id IN (
461: SELECT gbh1.batch_id
462: FROM gme_batch_header gbh1

Line 462: FROM gme_batch_header gbh1

458: FROM gme_batch_header gbh
459: WHERE gbh.batch_status IN (1, 2)
460: AND gbh.batch_id IN (
461: SELECT gbh1.batch_id
462: FROM gme_batch_header gbh1
463: ,gme_batch_step_activities gsa
464: WHERE gbh.batch_status IN (1, 2)
465: AND gbh.batch_id = gsa.batch_id
466: AND gsa.sequence_dependent_ind = 1);