DBA Data[Home] [Help]

APPS.GMP_WPS_WRITER dependencies on GME_BATCH_STEPS

Line 158: gme_batch_steps gbs

154: SELECT
155: gbs.last_update_date,
156: gbs.step_status
157: FROM
158: gme_batch_steps gbs
159: WHERE
160: gbs.batch_id = v_batch_id
161: AND gbs.batchstep_no = v_step_no;
162:

Line 206: gme_batch_steps

202: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
203: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
204:
205: UPDATE
206: gme_batch_steps
207: SET
208: plan_start_date = v_start_date,
209: plan_cmplt_date = v_end_date,
210: last_update_date = SYSDATE,

Line 338: gme_batch_steps gbs,

334: SELECT
335: gsa.last_update_date,
336: gbs.step_status
337: FROM
338: gme_batch_steps gbs,
339: gme_batch_step_activities gsa
340: WHERE
341: gbs.batchstep_id = v_step_id
342: AND gbs.batchstep_id = gsa.batchstep_id

Line 565: gme_batch_steps gbs,

561: crd.resources,
562: gsr.usage_um,
563: gsr.batchstep_activity_id
564: FROM
565: gme_batch_steps gbs,
566: gme_batch_step_resources gsr,
567: cr_rsrc_dtl crd
568: WHERE
569: gbs.batchstep_id = v_step_id

Line 1082: gme_batch_steps

1078: CURSOR lock_batch_steps IS
1079: SELECT
1080: batch_id
1081: FROM
1082: gme_batch_steps
1083: WHERE
1084: batch_id = v_batch_id
1085: FOR UPDATE NOWAIT;
1086: