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 511: GME_BATCH_STEP_RESOURCES gbr,

507: SET attribute9 = ( SELECT gbr.batchstep_resource_id
508: FROM GME_BATCH_HEADER gbh,
509: GME_BATCH_STEPS gbs,
510: GME_BATCH_STEP_ACTIVITIES gba,
511: GME_BATCH_STEP_RESOURCES gbr,
512: CR_RSRC_DTL crd
513: WHERE gbh.batch_id = gbs.batch_id
514: AND gbs.batchstep_id = gba.batchstep_id
515: AND gbs.batchstep_id = gbr.batchstep_id

Line 672: ||' gme_batch_step_resources gsr, '

668: ||' - gsa.last_update_date), 1,1,0,1,-1,-500) bsa_last_update '
669: -- For R12.0
670: ||' FROM gme_batch_step_activities gsa, '
671: ||' gme_batch_steps gbs, '
672: ||' gme_batch_step_resources gsr, '
673: ||' cr_rsrc_dtl crd ' -- For R12.0
674: ||' WHERE '
675: ||' gsr.batch_id = gsa.batch_id '
676: ||' AND gsr.batchstep_activity_id = gsa.batchstep_activity_id '

Line 1221: ||' gme_batch_step_resources gme ' --Bug: 8616967 Vpedarla

1217: ||' gao.inventory_item_id ' --Bug: 8616967 Vpedarla
1218: ||' FROM gmp_aps_output_dtl gad, '
1219: ||' gmp_aps_output_tbl gao, '
1220: ||' cr_rsrc_dtl crd , '
1221: ||' gme_batch_step_resources gme ' --Bug: 8616967 Vpedarla
1222: ||' WHERE '
1223: ||' gad.load_type in (4,9) '
1224: ||' AND gad.parent_header_id = gao.header_id '
1225: ||' AND gad.group_id = gao.process_id '

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

1442: v_uom_code VARCHAR2(3) ;
1443: v_rsrc_usage NUMBER ;
1444: v_assigned_unit NUMBER ;
1445:
1446: v_in_step_res_row gme_batch_step_resources%ROWTYPE; /* Added for NOCOPY */
1447: v_step_res_row gme_batch_step_resources%ROWTYPE;
1448:
1449: l INTEGER ;
1450: tran_status NUMBER ;

Line 1447: v_step_res_row gme_batch_step_resources%ROWTYPE;

1443: v_rsrc_usage NUMBER ;
1444: v_assigned_unit NUMBER ;
1445:
1446: v_in_step_res_row gme_batch_step_resources%ROWTYPE; /* Added for NOCOPY */
1447: v_step_res_row gme_batch_step_resources%ROWTYPE;
1448:
1449: l INTEGER ;
1450: tran_status NUMBER ;
1451: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;

Line 1451: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;

1447: v_step_res_row gme_batch_step_resources%ROWTYPE;
1448:
1449: l INTEGER ;
1450: tran_status NUMBER ;
1451: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;
1452: l_return_status VARCHAR2 (1);
1453: temp_calc number;
1454:
1455: BEGIN

Line 1488: log_message(' updaing gme_batch_step_resources ');

1484:
1485: IF v_o_resources = v_n_resources THEN
1486: pnew_act_res := v_step_resource_id ;
1487:
1488: log_message(' updaing gme_batch_step_resources ');
1489:
1490: IF paps_data_use = 0 THEN
1491: log_message(' gme_batch_step_resources APS way');
1492: -- APS way

Line 1491: log_message(' gme_batch_step_resources APS way');

1487:
1488: log_message(' updaing gme_batch_step_resources ');
1489:
1490: IF paps_data_use = 0 THEN
1491: log_message(' gme_batch_step_resources APS way');
1492: -- APS way
1493: UPDATE gme_batch_step_resources
1494: SET
1495: plan_start_date = pstart_date,

Line 1493: UPDATE gme_batch_step_resources

1489:
1490: IF paps_data_use = 0 THEN
1491: log_message(' gme_batch_step_resources APS way');
1492: -- APS way
1493: UPDATE gme_batch_step_resources
1494: SET
1495: plan_start_date = pstart_date,
1496: plan_cmplt_date = pend_date,
1497: plan_rsrc_usage = prsrc_usage,

Line 1511: log_message(' gme_batch_step_resources GME way');

1507: WHERE
1508: batchstep_resource_id = v_step_resource_id;
1509:
1510: ELSE
1511: log_message(' gme_batch_step_resources GME way');
1512: -- GME way
1513: UPDATE gme_batch_step_resources
1514: SET
1515: plan_start_date = pstart_date,

Line 1513: UPDATE gme_batch_step_resources

1509:
1510: ELSE
1511: log_message(' gme_batch_step_resources GME way');
1512: -- GME way
1513: UPDATE gme_batch_step_resources
1514: SET
1515: plan_start_date = pstart_date,
1516: plan_cmplt_date = pend_date,
1517: sequence_dependent_id = psetup_id , -- For R12.0

Line 1538: IF NOT GME_BATCH_STEP_RESOURCES_DBL.fetch_row(v_in_step_res_row,

1534: ELSE
1535: -- Alternate resource
1536: v_in_step_res_row.batchstep_resource_id := v_step_resource_id;
1537:
1538: IF NOT GME_BATCH_STEP_RESOURCES_DBL.fetch_row(v_in_step_res_row,
1539: v_step_res_row) THEN
1540: return_status := -2;
1541: ELSE
1542: v_step_res_row.plan_start_date := pstart_date;

Line 1590: DELETE gme_batch_step_resources

1586: e_msg := e_msg || ' Step End date greater than start date.';
1587:
1588: END IF;
1589:
1590: DELETE gme_batch_step_resources
1591: WHERE batchstep_resource_id = v_step_resource_id;
1592:
1593: IF SQL%NOTFOUND THEN
1594: return_status := -4;

Line 1596: IF NOT GME_BATCH_STEP_RESOURCES_DBL.insert_row

1592:
1593: IF SQL%NOTFOUND THEN
1594: return_status := -4;
1595: ELSE
1596: IF NOT GME_BATCH_STEP_RESOURCES_DBL.insert_row
1597: (v_step_res_row, v_in_step_res_row) THEN
1598: return_status := -5;
1599: ELSE
1600: pnew_act_res := v_in_step_res_row.batchstep_resource_id;

Line 1789: gme_batch_step_resources gsr,

1785: gsr.plan_start_date,
1786: gsr.plan_cmplt_date,
1787: crd.schedule_ind
1788: FROM
1789: gme_batch_step_resources gsr,
1790: cr_rsrc_dtl crd,
1791: mtl_units_of_measure u1,
1792: mtl_units_of_measure u2
1793: WHERE

Line 1844: gme_batch_step_resources

1840: END IF;
1841: v_trn_start_date := v_start_date + v_offset_interval;
1842: v_trn_end_date := v_start_date + v_offset_interval;
1843: UPDATE
1844: gme_batch_step_resources
1845: SET
1846: plan_start_date = v_trn_start_date,
1847: plan_cmplt_date = v_trn_end_date,
1848: last_update_date = SYSDATE,

Line 1867: gme_batch_step_resources

1863: AND line_id= v_zero_res_id ;
1864: v_trn_start_date := v_start_date;
1865: v_trn_end_date := v_end_date;
1866: UPDATE
1867: gme_batch_step_resources
1868: SET
1869: plan_start_date = v_trn_start_date,
1870: plan_cmplt_date = v_trn_end_date,
1871: last_update_date = SYSDATE,

Line 1899: gme_batch_step_resources

1895:
1896: v_trn_start_date := v_start_date ;
1897: v_trn_end_date := temp_date ;
1898: UPDATE
1899: gme_batch_step_resources
1900: SET
1901: plan_start_date = v_trn_start_date,
1902: plan_cmplt_date = v_trn_end_date,
1903: last_update_date = SYSDATE,

Line 2287: gme_batch_step_resources

2283: CURSOR lock_batch_resources IS
2284: SELECT
2285: batch_id
2286: FROM
2287: gme_batch_step_resources
2288: WHERE
2289: batch_id = v_batch_id
2290: FOR UPDATE NOWAIT;
2291:

Line 2803: ||' gme_batch_step_resources gsr,'

2799: ||' gsa.plan_cmplt_date, '
2800: ||' DECODE(nvl(gsa.sequence_dependent_ind,0),1,1,0) , '
2801: ||' max((gsr.plan_rsrc_usage/gsr.plan_rsrc_count)) actual_usage '
2802: ||' FROM gme_batch_step_activities gsa,'
2803: ||' gme_batch_step_resources gsr,'
2804: ||' gme_batch_steps gbs '
2805: ||' WHERE gsa.batch_id = :p_batch_id '
2806: ||' AND gbs.batch_id = gsa.batch_id '
2807: ||' AND gsr.batch_id = gsa.batch_id '

Line 2944: -- gme_batch_step_resources gsr,

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