APPS.GMP_APS_WRITER dependencies on GME_BATCH_STEP_ACTIVITIES

Line 510: GME_BATCH_STEP_ACTIVITIES gba,

506: UPDATE GMP_APS_OUTPUT_DTL gad
507: SET attribute9 = ( SELECT gbr.batchstep_resource_id
508: FROM GME_BATCH_HEADER gbh,
509: GME_BATCH_STEPS gbs,
510: GME_BATCH_STEP_ACTIVITIES gba,
511: GME_BATCH_STEP_RESOURCES gbr,
512: CR_RSRC_DTL crd
513: WHERE gbh.batch_id = gbs.batch_id
514: AND gbs.batchstep_id = gba.batchstep_id

Line 670: ||' FROM gme_batch_step_activities gsa, '

666: ||' - gsr.last_update_date), 1,1,0,1,-1,-500) bsr_last_update, '
667: ||' DECODE(sign(:LUP2 '
668: ||' - gsa.last_update_date), 1,1,0,1,-1,-500) bsa_last_update '
669: -- For R12.0
670: ||' FROM gme_batch_step_activities gsa, '
671: ||' gme_batch_steps gbs, '
672: ||' gme_batch_step_resources gsr, '
673: ||' cr_rsrc_dtl crd ' -- For R12.0
674: ||' WHERE '

Line 1820: UPDATE gme_batch_step_activities

1816: v_zero_res_id := 0;
1817: v_offset_interval := 0;
1818: temp_date := NULL;
1819:
1820: UPDATE gme_batch_step_activities
1821: SET
1822: plan_start_date = v_start_date,
1823: plan_cmplt_date = v_end_date,
1824: last_update_date = SYSDATE,

Line 2277: gme_batch_step_activities

2273: CURSOR lock_batch_activities IS
2274: SELECT
2275: batch_id
2276: FROM
2277: gme_batch_step_activities
2278: WHERE
2279: batch_id = v_batch_id
2280: FOR UPDATE NOWAIT;
2281:

Line 2802: ||' FROM gme_batch_step_activities gsa,'

2798: ||' gsa.plan_start_date, '
2799: ||' gsa.plan_cmplt_date, '
2800: ||' DECODE(nvl(gsa.sequence_dependent_ind,0),1,1,0) , '
2801: ||' max((gsr.plan_rsrc_usage/gsr.plan_rsrc_count)) actual_usage '
2802: ||' FROM gme_batch_step_activities gsa,'
2803: ||' gme_batch_step_resources gsr,'
2804: ||' gme_batch_steps gbs '
2805: ||' WHERE gsa.batch_id = :p_batch_id '
2806: ||' AND gbs.batch_id = gsa.batch_id '

Line 2841: UPDATE gme_batch_step_activities

2837: batch_size := act_count - 1;
2838:
2839: FOR p IN 1..batch_size
2840: LOOP
2841: UPDATE gme_batch_step_activities
2842: SET offset_interval = offset_tab(p).final_offset
2843: WHERE batch_id = v_batch_id
2844: AND batchstep_id = offset_tab(p).batchstep_id
2845: AND batchstep_activity_id = offset_tab(p).batchstep_activity_id

Line 2943: -- FROM gme_batch_step_activities gsa,

2939: the first activity where charegeble resources exist
2940: Hence Minmimum activity seq Number is taken */
2941: -- UPDATE GME_BATCH_STEP_CHARGES
2942: -- set ACTIVITY_SEQUENCE_NUMBER = (SELECT min(gsa.sequence_dependent_ind)
2943: -- FROM gme_batch_step_activities gsa,
2944: -- gme_batch_step_resources gsr,
2945: -- gme_batch_steps gbs
2946: -- WHERE gsa.batchstep_id = GME_BATCH_STEP_CHARGES.batchstep_id
2947: -- AND gsa.batchstep_id = gbs.batchstep_id