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 271: FROM gme_batch_header gbh

267:
268: CURSOR get_batch_details (v_batch_id NUMBER)
269: IS
270: SELECT gsr.batchstep_resource_id, 1 sds_type, gst.seq_dep_id
271: FROM gme_batch_header gbh
272: ,gmd_recipe_validity_rules gvr
273: ,gme_batch_steps gbs
274: ,gme_batch_step_activities gsa
275: ,gme_batch_step_resources gsr

Line 294: FROM gme_batch_header gbh2

290: AND iim.seq_category_id = gst.category_id
291: AND gbs.oprn_id = gst.oprn_id
292: UNION ALL
293: SELECT gsr2.batchstep_resource_id, 2 sds_type, gst2.seq_dep_id
294: FROM gme_batch_header gbh2
295: ,gmd_recipe_validity_rules gvr2
296: ,gme_batch_steps gbs2
297: ,gme_batch_step_activities gsa2
298: ,gme_batch_step_resources gsr2

Line 388: FROM gme_batch_header gbh

384: the batch also has to be pending or WIP for this to happen */
385: CURSOR get_batches
386: IS
387: SELECT gbh.batch_id
388: FROM gme_batch_header gbh
389: WHERE gbh.batch_status IN (1, 2)
390: AND gbh.batch_id IN (
391: SELECT gbh1.batch_id
392: FROM gme_batch_header gbh1

Line 392: FROM gme_batch_header gbh1

388: FROM gme_batch_header gbh
389: WHERE gbh.batch_status IN (1, 2)
390: AND gbh.batch_id IN (
391: SELECT gbh1.batch_id
392: FROM gme_batch_header gbh1
393: ,gme_batch_step_activities gsa
394: WHERE gbh.batch_status IN (1, 2)
395: AND gbh.batch_id = gsa.batch_id
396: AND gsa.sequence_dependent_ind = 1);