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 2921: DELETE from GME_BATCH_STEP_CHARGES

2917: BEGIN
2918: BEGIN
2919: -- NOTE: The steps wll not be having activity Sequence Number ??
2920: -- For WIP steps No deletes
2921: DELETE from GME_BATCH_STEP_CHARGES
2922: WHERE batch_id = pbatch_id
2923: AND BATCHSTEP_ID IN ( SELECT batchstep_id
2924: FROM gme_batch_steps
2925: WHERE batch_id = pbatch_id

Line 2941: -- UPDATE GME_BATCH_STEP_CHARGES

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

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

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
2948: -- AND gsa.batchstep_id = gbs.batchstep_id
2949: -- AND gsr.batch_id = gsa.batch_id
2950: -- AND gsr.batchstep_activity_id = gsa.batchstep_activity_id

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

2947: -- AND gsa.batchstep_id = gbs.batchstep_id
2948: -- AND gsa.batchstep_id = gbs.batchstep_id
2949: -- AND gsr.batch_id = gsa.batch_id
2950: -- AND gsr.batchstep_activity_id = gsa.batchstep_activity_id
2951: -- AND gsr.resources = GME_BATCH_STEP_CHARGES.resources
2952: -- AND gbs.batch_id = pbatch_id
2953: -- AND gbs.step_status = 2 )
2954: -- WHERE batch_id = pbatch_id ;
2955:

Line 2957: INSERT INTO GME_BATCH_STEP_CHARGES

2953: -- AND gbs.step_status = 2 )
2954: -- WHERE batch_id = pbatch_id ;
2955:
2956: -- For WIP steps No inserts
2957: INSERT INTO GME_BATCH_STEP_CHARGES
2958: (
2959: BATCH_ID,
2960: BATCHSTEP_ID,
2961: ACTIVITY_SEQUENCE_NUMBER,