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_STEP_ACTIVITIES

Line 26: FROM gme_batch_step_activities gsa

22: ,gsa.offset_interval, gsa.activity
23: ,gsa.batchstep_activity_id
24: ,NVL (gsa.sequence_dependent_ind, -1)
25: sequence_dependent_ind
26: FROM gme_batch_step_activities gsa
27: WHERE gsa.batch_id = v_batch_id
28: ORDER BY 1, 2, 3, 4, 5;
29:
30: v_batch_id NUMBER := 0;

Line 33: batchstep_id gme_batch_step_activities.batchstep_id%TYPE

29:
30: v_batch_id NUMBER := 0;
31:
32: TYPE act_rec IS RECORD (
33: batchstep_id gme_batch_step_activities.batchstep_id%TYPE
34: ,seq_dep_order NUMBER
35: ,offset_interval gme_batch_step_activities.offset_interval%TYPE
36: ,activity gme_batch_step_activities.activity%TYPE
37: ,batchstep_activity_id gme_batch_step_activities.batchstep_activity_id%TYPE

Line 35: ,offset_interval gme_batch_step_activities.offset_interval%TYPE

31:
32: TYPE act_rec IS RECORD (
33: batchstep_id gme_batch_step_activities.batchstep_id%TYPE
34: ,seq_dep_order NUMBER
35: ,offset_interval gme_batch_step_activities.offset_interval%TYPE
36: ,activity gme_batch_step_activities.activity%TYPE
37: ,batchstep_activity_id gme_batch_step_activities.batchstep_activity_id%TYPE
38: ,seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE
39: );

Line 36: ,activity gme_batch_step_activities.activity%TYPE

32: TYPE act_rec IS RECORD (
33: batchstep_id gme_batch_step_activities.batchstep_id%TYPE
34: ,seq_dep_order NUMBER
35: ,offset_interval gme_batch_step_activities.offset_interval%TYPE
36: ,activity gme_batch_step_activities.activity%TYPE
37: ,batchstep_activity_id gme_batch_step_activities.batchstep_activity_id%TYPE
38: ,seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE
39: );
40:

Line 37: ,batchstep_activity_id gme_batch_step_activities.batchstep_activity_id%TYPE

33: batchstep_id gme_batch_step_activities.batchstep_id%TYPE
34: ,seq_dep_order NUMBER
35: ,offset_interval gme_batch_step_activities.offset_interval%TYPE
36: ,activity gme_batch_step_activities.activity%TYPE
37: ,batchstep_activity_id gme_batch_step_activities.batchstep_activity_id%TYPE
38: ,seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE
39: );
40:
41: TYPE act_tbl IS TABLE OF act_rec

Line 38: ,seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE

34: ,seq_dep_order NUMBER
35: ,offset_interval gme_batch_step_activities.offset_interval%TYPE
36: ,activity gme_batch_step_activities.activity%TYPE
37: ,batchstep_activity_id gme_batch_step_activities.batchstep_activity_id%TYPE
38: ,seq_dep_ind gme_batch_step_activities.sequence_dependent_ind%TYPE
39: );
40:
41: TYPE act_tbl IS TABLE OF act_rec
42: INDEX BY BINARY_INTEGER;

Line 112: UPDATE gme_batch_step_activities

108: || 'seq. dep. id is'
109: || act_tab (i).seq_dep_ind);
110: END IF;
111:
112: UPDATE gme_batch_step_activities
113: SET sequence_dependent_ind = act_tab (i).seq_dep_ind
114: ,last_update_date = SYSDATE
115: ,last_updated_by = gme_common_pvt.g_user_ident
116: ,last_update_login = gme_common_pvt.g_login_id

Line 192: UPDATE gme_batch_step_activities

188: || 'seq. dep. id is'
189: || act_tab (i).seq_dep_ind);
190: END IF;
191:
192: UPDATE gme_batch_step_activities
193: SET sequence_dependent_ind = act_tab (i).seq_dep_ind
194: ,last_update_date = SYSDATE
195: ,last_updated_by = gme_common_pvt.g_user_ident
196: ,last_update_login =

Line 274: ,gme_batch_step_activities gsa

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
276: ,cr_rsrc_dtl crd
277: ,ic_item_mst iim
278: ,gmp_sequence_types gst

Line 297: ,gme_batch_step_activities gsa2

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
299: ,cr_rsrc_dtl crd2
300: ,gmp_sequence_types gst2
301: ,ic_item_mst iim2

Line 393: ,gme_batch_step_activities gsa

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);
397:

Line 689: FROM gme_batch_step_activities a, gme_batch_step_resources r

685: v_resources gme_batch_step_resources.resources%TYPE
686: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)
687: IS
688: SELECT MIN (a.sequence_dependent_ind)
689: FROM gme_batch_step_activities a, gme_batch_step_resources r
690: WHERE r.resources = v_resources
691: AND r.batchstep_activity_id = a.batchstep_activity_id
692: AND a.batchstep_id = v_batchstep_id
693: AND r.batchstep_id = v_batchstep_id