APPS.GMP_APS_WRITER dependencies on GME_BATCH_STEP_ACTIVITIES

Line 497: GME_BATCH_STEP_ACTIVITIES gba,

493: UPDATE GMP_APS_OUTPUT_DTL gad
494: SET attribute9 = ( SELECT gbr.batchstep_resource_id
495: FROM GME_BATCH_HEADER gbh,
496: GME_BATCH_STEPS gbs,
497: GME_BATCH_STEP_ACTIVITIES gba,
498: GME_BATCH_STEP_RESOURCES gbr,
499: CR_RSRC_DTL crd
500: WHERE gbh.batch_id = gbs.batch_id
501: AND gbs.batchstep_id = gba.batchstep_id

Line 656: ||' FROM gme_batch_step_activities gsa, '

652: ||' - gsr.last_update_date), 1,1,0,1,-1,-500) bsr_last_update, '
653: ||' DECODE(sign(:LUP2 '
654: ||' - gsa.last_update_date), 1,1,0,1,-1,-500) bsa_last_update '
655: -- For R12.0
656: ||' FROM gme_batch_step_activities gsa, '
657: ||' gme_batch_steps gbs, '
658: ||' gme_batch_step_resources gsr, '
659: ||' cr_rsrc_dtl crd ' -- For R12.0
660: ||' WHERE '

Line 1714: UPDATE gme_batch_step_activities

1710: v_zero_res_id := 0;
1711: v_offset_interval := 0;
1712: temp_date := NULL;
1713:
1714: UPDATE gme_batch_step_activities
1715: SET
1716: plan_start_date = v_start_date,
1717: plan_cmplt_date = v_end_date,
1718: last_update_date = SYSDATE,

Line 2183: gme_batch_step_activities

2179: CURSOR lock_batch_activities IS
2180: SELECT
2181: batch_id
2182: FROM
2183: gme_batch_step_activities
2184: WHERE
2185: batch_id = v_batch_id
2186: FOR UPDATE NOWAIT;
2187:

Line 2699: ||' FROM gme_batch_step_activities gsa,'

2695: ||' gsa.plan_start_date, '
2696: ||' gsa.plan_cmplt_date, '
2697: ||' DECODE(nvl(gsa.sequence_dependent_ind,0),1,1,0) , '
2698: ||' max((gsr.plan_rsrc_usage/gsr.plan_rsrc_count)) actual_usage '
2699: ||' FROM gme_batch_step_activities gsa,'
2700: ||' gme_batch_step_resources gsr,'
2701: ||' gme_batch_steps gbs '
2702: ||' WHERE gsa.batch_id = :p_batch_id '
2703: ||' AND gbs.batch_id = gsa.batch_id '

Line 2738: UPDATE gme_batch_step_activities

2734: batch_size := act_count - 1;
2735:
2736: FOR p IN 1..batch_size
2737: LOOP
2738: UPDATE gme_batch_step_activities
2739: SET offset_interval = offset_tab(p).final_offset
2740: WHERE batch_id = v_batch_id
2741: AND batchstep_id = offset_tab(p).batchstep_id
2742: AND batchstep_activity_id = offset_tab(p).batchstep_activity_id

Line 2840: -- FROM gme_batch_step_activities gsa,

2836: the first activity where charegeble resources exist
2837: Hence Minmimum activity seq Number is taken */
2838: -- UPDATE GME_BATCH_STEP_CHARGES
2839: -- set ACTIVITY_SEQUENCE_NUMBER = (SELECT min(gsa.sequence_dependent_ind)
2840: -- FROM gme_batch_step_activities gsa,
2841: -- gme_batch_step_resources gsr,
2842: -- gme_batch_steps gbs
2843: -- WHERE gsa.batchstep_id = GME_BATCH_STEP_CHARGES.batchstep_id
2844: -- AND gsa.batchstep_id = gbs.batchstep_id