APPS.GME_BATCH_STEP_CHG_PVT dependencies on GME_BATCH_STEPS

Line 274: ,gme_batch_steps gbs

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
277: ,cr_rsrc_dtl crd
278: ,mtl_system_items iim -- 8708957 - Change this from ic_item_mst to mtl_system_items

Line 306: ,gme_batch_steps gbs2

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
309: ,cr_rsrc_dtl crd2
310: ,gmp_sequence_types gst2

Line 343: ,gme_batch_steps gbs

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
346: ,cr_rsrc_dtl crd
347: ,ic_item_mst iim

Line 366: ,gme_batch_steps gbs2

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
369: ,cr_rsrc_dtl crd2
370: ,gmp_sequence_types gst2

Line 503: FROM gme_batch_steps

499:
500: CURSOR cur_get_batchstep_ids (v_batch_id NUMBER)
501: IS
502: SELECT batchstep_id
503: FROM gme_batch_steps
504: WHERE batch_id = v_batch_id;
505:
506: CURSOR cur_is_charge_associated (
507: v_batch_id NUMBER

Line 623: FROM gme_batch_steps

619:
620: CURSOR cur_get_batchstep_ids (v_batch_id NUMBER)
621: IS
622: SELECT batchstep_id
623: FROM gme_batch_steps
624: WHERE batch_id = v_batch_id;
625:
626: CURSOR cur_is_charge_associated (
627: v_batch_id NUMBER

Line 749: p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE

745: Rishi Varma B3718176 14-07-2004
746: Created.
747: =============================================================================================*/
748: PROCEDURE calc_activity_sequence_number (
749: p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
750: ,p_resources IN gme_batch_step_resources.resources%TYPE
751: ,x_act_seq_num OUT NOCOPY NUMBER
752: ,x_return_status OUT NOCOPY VARCHAR2)
753: IS

Line 756: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)

752: ,x_return_status OUT NOCOPY VARCHAR2)
753: IS
754: CURSOR cur_get_seq_dep_ind (
755: v_resources gme_batch_step_resources.resources%TYPE
756: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)
757: IS
758: SELECT MIN (a.sequence_dependent_ind)
759: FROM gme_batch_step_activities a, gme_batch_step_resources r
760: WHERE r.resources = v_resources