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_RESOURCES

Line 498: GME_BATCH_STEP_RESOURCES gbr,

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
501: AND gbs.batchstep_id = gba.batchstep_id
502: AND gbs.batchstep_id = gbr.batchstep_id

Line 658: ||' gme_batch_step_resources gsr, '

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

Line 1371: v_in_step_res_row gme_batch_step_resources%ROWTYPE; /* Added for NOCOPY */

1367: v_uom_code VARCHAR2(3) ;
1368: v_rsrc_usage NUMBER ;
1369: v_assigned_unit NUMBER ;
1370:
1371: v_in_step_res_row gme_batch_step_resources%ROWTYPE; /* Added for NOCOPY */
1372: v_step_res_row gme_batch_step_resources%ROWTYPE;
1373:
1374: l INTEGER ;
1375: tran_status NUMBER ;

Line 1372: v_step_res_row gme_batch_step_resources%ROWTYPE;

1368: v_rsrc_usage NUMBER ;
1369: v_assigned_unit NUMBER ;
1370:
1371: v_in_step_res_row gme_batch_step_resources%ROWTYPE; /* Added for NOCOPY */
1372: v_step_res_row gme_batch_step_resources%ROWTYPE;
1373:
1374: l INTEGER ;
1375: tran_status NUMBER ;
1376:

Line 1411: UPDATE gme_batch_step_resources

1407: pnew_act_res := v_step_resource_id ;
1408:
1409: IF paps_data_use = 0 THEN
1410: -- APS way
1411: UPDATE gme_batch_step_resources
1412: SET
1413: plan_start_date = pstart_date,
1414: plan_cmplt_date = pend_date,
1415: plan_rsrc_usage = prsrc_usage,

Line 1430: UPDATE gme_batch_step_resources

1426: batchstep_resource_id = v_step_resource_id;
1427:
1428: ELSE
1429: -- GME way
1430: UPDATE gme_batch_step_resources
1431: SET
1432: plan_start_date = pstart_date,
1433: plan_cmplt_date = pend_date,
1434: sequence_dependent_id = psetup_id , -- For R12.0

Line 1455: IF NOT GME_BATCH_STEP_RESOURCES_DBL.fetch_row(v_in_step_res_row,

1451: ELSE
1452: -- Alternate resource
1453: v_in_step_res_row.batchstep_resource_id := v_step_resource_id;
1454:
1455: IF NOT GME_BATCH_STEP_RESOURCES_DBL.fetch_row(v_in_step_res_row,
1456: v_step_res_row) THEN
1457: return_status := -2;
1458: ELSE
1459: v_step_res_row.plan_start_date := pstart_date;

Line 1487: DELETE gme_batch_step_resources

1483: e_msg := e_msg || ' Step End date greater than start date.';
1484:
1485: END IF;
1486:
1487: DELETE gme_batch_step_resources
1488: WHERE batchstep_resource_id = v_step_resource_id;
1489:
1490: IF SQL%NOTFOUND THEN
1491: return_status := -4;

Line 1493: IF NOT GME_BATCH_STEP_RESOURCES_DBL.insert_row

1489:
1490: IF SQL%NOTFOUND THEN
1491: return_status := -4;
1492: ELSE
1493: IF NOT GME_BATCH_STEP_RESOURCES_DBL.insert_row
1494: (v_step_res_row, v_in_step_res_row) THEN
1495: return_status := -5;
1496: ELSE
1497: pnew_act_res := v_in_step_res_row.batchstep_resource_id;

Line 1683: gme_batch_step_resources gsr,

1679: gsr.plan_start_date,
1680: gsr.plan_cmplt_date,
1681: crd.schedule_ind
1682: FROM
1683: gme_batch_step_resources gsr,
1684: cr_rsrc_dtl crd,
1685: mtl_units_of_measure u1,
1686: mtl_units_of_measure u2
1687: WHERE

Line 1742: gme_batch_step_resources

1738: v_trn_start_date := v_start_date + v_offset_interval;
1739: v_trn_end_date := v_start_date + v_offset_interval;
1740:
1741: UPDATE
1742: gme_batch_step_resources
1743: SET
1744: plan_start_date = v_trn_start_date,
1745: plan_cmplt_date = v_trn_end_date,
1746: last_update_date = SYSDATE,

Line 1768: gme_batch_step_resources

1764: v_trn_start_date := v_start_date;
1765: v_trn_end_date := v_end_date;
1766:
1767: UPDATE
1768: gme_batch_step_resources
1769: SET
1770: plan_start_date = v_trn_start_date,
1771: plan_cmplt_date = v_trn_end_date,
1772: last_update_date = SYSDATE,

Line 1805: gme_batch_step_resources

1801: v_trn_start_date := v_start_date ;
1802: v_trn_end_date := temp_date ;
1803:
1804: UPDATE
1805: gme_batch_step_resources
1806: SET
1807: plan_start_date = v_trn_start_date,
1808: plan_cmplt_date = v_trn_end_date,
1809: last_update_date = SYSDATE,

Line 2193: gme_batch_step_resources

2189: CURSOR lock_batch_resources IS
2190: SELECT
2191: batch_id
2192: FROM
2193: gme_batch_step_resources
2194: WHERE
2195: batch_id = v_batch_id
2196: FOR UPDATE NOWAIT;
2197:

Line 2700: ||' gme_batch_step_resources gsr,'

2696: ||' gsa.plan_cmplt_date, '
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 '

Line 2841: -- gme_batch_step_resources gsr,

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