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.GMP_APS_WRITER dependencies on GME_BATCH_STEPS

Line 336: ||' FROM gme_batch_steps '

332: ||' - last_update_date), 1,1,0,1,-1,-600) bo_last_update, '
333: ||' step_status , '
334: ||' COUNT(distinct batchstep_no) '
335: ||' OVER (PARTITION BY batch_id) oper_count '
336: ||' FROM gme_batch_steps '
337: -- B5714301, changed the position of operation count
338: -- ||' WHERE batch_id = :pbatch1 '
339: ||' WHERE batchstep_id IN ( select batchstep_id from gme_batch_steps '
340: ||' WHERE batch_id = :pbatch1 ) '

Line 339: ||' WHERE batchstep_id IN ( select batchstep_id from gme_batch_steps '

335: ||' OVER (PARTITION BY batch_id) oper_count '
336: ||' FROM gme_batch_steps '
337: -- B5714301, changed the position of operation count
338: -- ||' WHERE batch_id = :pbatch1 '
339: ||' WHERE batchstep_id IN ( select batchstep_id from gme_batch_steps '
340: ||' WHERE batch_id = :pbatch1 ) '
341: ||' AND step_status in (1,2) '
342: ||' AND delete_mark = 0 '
343: -- B5473156, This check is not required as per scenario in the bug

Line 496: GME_BATCH_STEPS gbs,

492:
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

Line 657: ||' gme_batch_steps gbs, '

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 '
661: ||' gsr.batch_id = gsa.batch_id '

Line 1971: gme_batch_steps gbs

1967: BEGIN
1968: SELECT count(*) INTO v_plan_charges
1969: FROM
1970: gmp_aps_output_dtl gad,
1971: gme_batch_steps gbs
1972: WHERE gad.wip_entity_id = pbatch_id
1973: AND gad.load_type = 10
1974: AND gbs.batch_id = gad.wip_entity_id
1975: AND gbs.batchstep_no = pstep_no

Line 1993: UPDATE gme_batch_steps

1989: -- For New Batch only B5454215
1990:
1991: IF v_plan_charges <> 0 THEN
1992:
1993: UPDATE gme_batch_steps
1994: SET plan_start_date = pstart_date,
1995: plan_cmplt_date = pend_date,
1996: due_date = pdue_date,
1997: -- For R12.0

Line 2007: UPDATE gme_batch_steps

2003: AND batchstep_id = pstep_id ;
2004:
2005: ELSE
2006:
2007: UPDATE gme_batch_steps
2008: SET plan_start_date = pstart_date,
2009: plan_cmplt_date = pend_date,
2010: -- For R12.0
2011: due_date = pdue_date,

Line 2024: UPDATE gme_batch_steps

2020: ELSE
2021:
2022: IF v_plan_charges <> 0 THEN
2023:
2024: UPDATE gme_batch_steps
2025: SET plan_start_date = pstart_date,
2026: plan_cmplt_date = pend_date,
2027: -- For R12.0
2028: plan_charges = DECODE(step_status,1,v_plan_charges,plan_charges),

Line 2037: UPDATE gme_batch_steps

2033: AND batchstep_id = pstep_id ;
2034:
2035: ELSE
2036:
2037: UPDATE gme_batch_steps
2038: SET plan_start_date = pstart_date,
2039: plan_cmplt_date = pend_date,
2040: last_update_date = SYSDATE,
2041: last_updated_by = puser_id

Line 2173: gme_batch_steps

2169: CURSOR lock_batch_steps IS
2170: SELECT
2171: batch_id
2172: FROM
2173: gme_batch_steps
2174: WHERE
2175: batch_id = v_batch_id
2176: FOR UPDATE NOWAIT;
2177:

Line 2701: ||' gme_batch_steps gbs '

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 '
2704: ||' AND gsr.batch_id = gsa.batch_id '
2705: ||' AND gsa.delete_mark = 0 '

Line 2821: FROM gme_batch_steps

2817: -- For WIP steps No deletes
2818: DELETE from GME_BATCH_STEP_CHARGES
2819: WHERE batch_id = pbatch_id
2820: AND BATCHSTEP_ID IN ( SELECT batchstep_id
2821: FROM gme_batch_steps
2822: WHERE batch_id = pbatch_id
2823: AND step_status = 1 );
2824: EXCEPTION
2825: WHEN NO_DATA_FOUND THEN

Line 2842: -- gme_batch_steps gbs

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
2845: -- AND gsa.batchstep_id = gbs.batchstep_id
2846: -- AND gsr.batch_id = gsa.batch_id

Line 2885: gme_batch_steps gbs,

2881: gad.creation_date,
2882: gad.created_by
2883: FROM gmp_aps_output_dtl gad,
2884: gmp_aps_output_tbl gao,
2885: gme_batch_steps gbs,
2886: cr_rsrc_dtl crd
2887: WHERE gad.parent_header_id = gao.header_id
2888: AND gad.group_id = gao.process_id
2889: AND gad.organization_id = gao.organization_id