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_STEP_CHARGES

Line 2818: DELETE from GME_BATCH_STEP_CHARGES

2814: BEGIN
2815: BEGIN
2816: -- NOTE: The steps wll not be having activity Sequence Number ??
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

Line 2838: -- UPDATE GME_BATCH_STEP_CHARGES

2834: /* mattt remember the case where we have more than one activity involved
2835: in the charge hence you will get two rows back here. we need to just use
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

Line 2843: -- WHERE gsa.batchstep_id = GME_BATCH_STEP_CHARGES.batchstep_id

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
2847: -- AND gsr.batchstep_activity_id = gsa.batchstep_activity_id

Line 2848: -- AND gsr.resources = GME_BATCH_STEP_CHARGES.resources

2844: -- AND gsa.batchstep_id = gbs.batchstep_id
2845: -- AND gsa.batchstep_id = gbs.batchstep_id
2846: -- AND gsr.batch_id = gsa.batch_id
2847: -- AND gsr.batchstep_activity_id = gsa.batchstep_activity_id
2848: -- AND gsr.resources = GME_BATCH_STEP_CHARGES.resources
2849: -- AND gbs.batch_id = pbatch_id
2850: -- AND gbs.step_status = 2 )
2851: -- WHERE batch_id = pbatch_id ;
2852:

Line 2854: INSERT INTO GME_BATCH_STEP_CHARGES

2850: -- AND gbs.step_status = 2 )
2851: -- WHERE batch_id = pbatch_id ;
2852:
2853: -- For WIP steps No inserts
2854: INSERT INTO GME_BATCH_STEP_CHARGES
2855: (
2856: BATCH_ID,
2857: BATCHSTEP_ID,
2858: ACTIVITY_SEQUENCE_NUMBER,