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.

[Home] [Help]

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 275: ,gme_batch_step_activities gsa

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
279: ,gmp_sequence_types gst

Line 307: ,gme_batch_step_activities gsa2

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
311: ,mtl_system_items iim2 -- 8708957 - Change this from ic_item_mst to mtl_system_items

Line 344: ,gme_batch_step_activities gsa

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
348: ,gmp_sequence_types gst

Line 367: ,gme_batch_step_activities gsa2

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
371: ,ic_item_mst iim2

Line 463: ,gme_batch_step_activities gsa

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

Line 759: FROM gme_batch_step_activities a, gme_batch_step_resources r

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
761: AND r.batchstep_activity_id = a.batchstep_activity_id
762: AND a.batchstep_id = v_batchstep_id
763: AND r.batchstep_id = v_batchstep_id