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.FLM_MMM_CALCULATION dependencies on FLM_MMM_OP_RESOURCES

Line 1216: FROM flm_mmm_op_resources

1212: CURSOR all_res_assigned IS
1213: SELECT resource_id,
1214: standard_operation_id op_id,
1215: resource_assigned
1216: FROM flm_mmm_op_resources
1217: WHERE plan_id = i_plan_id
1218: AND organization_id = i_organization_id
1219: AND operation_type = i_calc_op_type;
1220:

Line 1242: DELETE FROM flm_mmm_op_resources

1238: l_resources(i).resource_assigned := nvl(res_rec.resource_assigned, 0);
1239: i := i+1;
1240: END LOOP;
1241:
1242: DELETE FROM flm_mmm_op_resources
1243: WHERE plan_id = i_plan_id
1244: AND organization_id = i_organization_id
1245: AND operation_type = i_calc_op_type;
1246:

Line 1296: FROM flm_mmm_op_resources

1292: l_total_rs > 0 THEN
1293: BEGIN
1294: SELECT resource_assigned
1295: INTO l_resource_assigned
1296: FROM flm_mmm_op_resources
1297: WHERE plan_id = -1
1298: AND organization_id = i_organization_id
1299: AND standard_operation_id = op_rec.standard_operation_id
1300: AND resource_id = l_res_id;

Line 1308: INSERT INTO flm_mmm_op_resources (

1304: l_resource_assigned := NULL;
1305:
1306: END;
1307:
1308: INSERT INTO flm_mmm_op_resources (
1309: plan_id,
1310: organization_id,
1311: resource_id,
1312: standard_operation_id,

Line 1351: FROM flm_mmm_op_resources

1347: l_total_pv > 0 AND l_total_rs > 0 THEN
1348: BEGIN
1349: SELECT resource_assigned
1350: INTO l_resource_assigned
1351: FROM flm_mmm_op_resources
1352: WHERE plan_id = -1
1353: AND organization_id = i_organization_id
1354: AND standard_operation_id = op_rec.standard_operation_id
1355: AND resource_id = l_res_id;

Line 1363: INSERT INTO flm_mmm_op_resources (

1359: l_resource_assigned := NULL;
1360:
1361: END;
1362:
1363: INSERT INTO flm_mmm_op_resources (
1364: plan_id,
1365: organization_id,
1366: resource_id,
1367: standard_operation_id,

Line 1401: UPDATE flm_mmm_op_resources

1397: IF i_replan_flag = C_REPLAN_FLAG_YES AND
1398: l_resources.COUNT > 0 THEN
1399: i := 0;
1400: LOOP
1401: UPDATE flm_mmm_op_resources
1402: SET resource_assigned = l_resources(i).resource_assigned
1403: WHERE plan_id = i_plan_id
1404: AND organization_id = i_organization_id
1405: AND resource_id = l_resources(i).resource_id

Line 1437: FROM flm_mmm_op_resources fmor

1433: SELECT resource_id,
1434: standard_operation_id,
1435: weighted_resource_usage,
1436: resource_assigned
1437: FROM flm_mmm_op_resources fmor
1438: WHERE plan_id = i_plan_id
1439: AND organization_id = i_organization_id
1440: AND operation_type = i_calc_op_type;
1441:

Line 1473: UPDATE flm_mmm_op_resources

1469: IF i_calculate_option = C_CALC_OPTION_NO_IPK THEN
1470: -- Resource Needed = Weighted Resource Usage / Operation TAKT
1471: FOR op_rec IN operations LOOP
1472: IF op_rec.operation_takt > 0 THEN -- otherwise, sth must be wrong with the op, leave it null
1473: UPDATE flm_mmm_op_resources
1474: SET resource_needed = weighted_resource_usage / op_rec.operation_takt
1475: WHERE plan_id = i_plan_id
1476: AND organization_id = i_organization_id
1477: AND standard_operation_id = op_rec.standard_operation_id;

Line 1492: UPDATE flm_mmm_op_resources fmor

1488: AND operation_type = i_calc_op_type;
1489:
1490: ELSIF i_calculate_option = C_CALC_OPTION_ONE_RESOURCE THEN
1491: -- Resource Needed = 1
1492: UPDATE flm_mmm_op_resources fmor
1493: SET resource_needed = 1
1494: WHERE plan_id = i_plan_id
1495: AND organization_id = i_organization_id
1496: AND operation_type = i_calc_op_type;

Line 1507: FROM flm_mmm_op_resources

1503: IF op_rec.operation_takt > 0 AND op_rec.hours_per_day > 0 THEN
1504: -- Max Weigthed Resource Usage
1505: SELECT max(nvl(weighted_resource_usage,0))
1506: INTO l_max_rs_usage
1507: FROM flm_mmm_op_resources
1508: WHERE plan_id = i_plan_id
1509: AND organization_id = i_organization_id
1510: AND standard_operation_id = op_rec.standard_operation_id;
1511:

Line 1551: FROM flm_mmm_op_resources

1547: FOR op_rec IN operations LOOP
1548: -- if any required resource is not assigned, we can not perform the calculation here
1549: SELECT count(*)
1550: INTO l_count
1551: FROM flm_mmm_op_resources
1552: WHERE plan_id = i_plan_id
1553: AND organization_id = i_organization_id
1554: AND standard_operation_id = op_rec.standard_operation_id
1555: AND (resource_assigned IS NULL OR

Line 1564: FROM flm_mmm_op_resources

1560:
1561: -- Max ( Weigthed Resource Usage / Resource Assigned )
1562: SELECT max(weighted_resource_usage / nvl(resource_assigned, 0)) -- ???
1563: INTO l_max_rs_usage
1564: FROM flm_mmm_op_resources
1565: WHERE plan_id = i_plan_id
1566: AND organization_id = i_organization_id
1567: AND standard_operation_id = op_rec.standard_operation_id;
1568:

Line 1586: UPDATE flm_mmm_op_resources

1582: AND standard_operation_id = op_rec.standard_operation_id;
1583:
1584: -- Resource Needed = ( Hours Per Day/Operation TAKT - IPK Needed) *
1585: -- Weighted Resource Usage / Hours Per Day
1586: UPDATE flm_mmm_op_resources
1587: SET resource_needed =
1588: (op_rec.hours_per_day/op_rec.operation_takt - l_ipk_needed) *
1589: weighted_resource_usage / op_rec.hours_per_day
1590: WHERE plan_id = i_plan_id

Line 1603: UPDATE flm_mmm_op_resources

1599: FOR op_rec IN operations LOOP
1600: IF op_rec.hours_per_day > 0 THEN
1601: -- Resource Needed = ( Hours Per Day/Operation TAKT - IPK Assigned) *
1602: -- Weighted Resource Usage / Hours Per Day
1603: UPDATE flm_mmm_op_resources
1604: SET resource_needed =
1605: (op_rec.hours_per_day/op_rec.operation_takt - nvl(op_rec.ipk_assigned, 0)) *
1606: weighted_resource_usage / op_rec.hours_per_day
1607: WHERE plan_id = i_plan_id

Line 1611: UPDATE flm_mmm_op_resources

1607: WHERE plan_id = i_plan_id
1608: AND organization_id = i_organization_id
1609: AND standard_operation_id = op_rec.standard_operation_id;
1610:
1611: UPDATE flm_mmm_op_resources
1612: SET resource_needed = 0
1613: WHERE plan_id = i_plan_id
1614: AND organization_id = i_organization_id
1615: AND standard_operation_id = op_rec.standard_operation_id

Line 1660: FROM flm_mmm_op_resources fmor

1656: SELECT resource_id,
1657: standard_operation_id,
1658: weighted_resource_usage,
1659: resource_assigned
1660: FROM flm_mmm_op_resources fmor
1661: WHERE plan_id = i_plan_id
1662: AND organization_id = i_organization_id
1663: AND standard_operation_id = i_standard_operation_id;
1664:

Line 1716: FROM flm_mmm_op_resources

1712: -- if any required resource is not assigned, then we can not perform
1713: -- the calculation here
1714: SELECT count(*)
1715: INTO l_count
1716: FROM flm_mmm_op_resources
1717: WHERE plan_id = i_plan_id
1718: AND organization_id = i_organization_id
1719: AND standard_operation_id = i_standard_operation_id
1720: AND (resource_assigned IS NULL OR

Line 1728: FROM flm_mmm_op_resources

1724: l_hours_per_day > 0 THEN -- no unassigned resource
1725: -- Max ( Weigthed Resource Usage / Resource Assigned )
1726: SELECT max(weighted_resource_usage / resource_assigned)
1727: INTO l_max_rs_usage
1728: FROM flm_mmm_op_resources
1729: WHERE plan_id = i_plan_id
1730: AND organization_id = i_organization_id
1731: AND standard_operation_id = i_standard_operation_id;
1732:

Line 1753: UPDATE flm_mmm_op_resources

1749: AND standard_operation_id = i_standard_operation_id;
1750:
1751: -- Resource Needed = ( Hours Per Day/Operation TAKT - IPK Needed) *
1752: -- Weighted Resource Usage / Hours Per Day
1753: UPDATE flm_mmm_op_resources
1754: SET resource_needed =
1755: (l_hours_per_day/l_operation_takt - l_ipk_needed) *
1756: weighted_resource_usage / l_hours_per_day
1757: WHERE plan_id = i_plan_id

Line 1761: UPDATE flm_mmm_op_resources

1757: WHERE plan_id = i_plan_id
1758: AND organization_id = i_organization_id
1759: AND standard_operation_id = i_standard_operation_id;
1760:
1761: UPDATE flm_mmm_op_resources
1762: SET resource_needed = 0
1763: WHERE plan_id = i_plan_id
1764: AND organization_id = i_organization_id
1765: AND standard_operation_id = i_standard_operation_id

Line 1776: UPDATE flm_mmm_op_resources

1772: -- Resource Needed = ( Hours Per Day/Operation TAKT - IPK Assigned) *
1773: -- Weighted Resource Usage / Hours Per Day
1774: --debug_log('op takt: '||l_operation_takt);
1775: --debug_log('ipk assigned: '||l_ipk_assigned);
1776: UPDATE flm_mmm_op_resources
1777: SET resource_needed =
1778: (l_hours_per_day/l_operation_takt - nvl(l_ipk_assigned, 0)) *
1779: weighted_resource_usage / l_hours_per_day
1780: WHERE plan_id = i_plan_id

Line 1784: UPDATE flm_mmm_op_resources

1780: WHERE plan_id = i_plan_id
1781: AND organization_id = i_organization_id
1782: AND standard_operation_id = i_standard_operation_id;
1783:
1784: UPDATE flm_mmm_op_resources
1785: SET resource_needed = 0
1786: WHERE plan_id = i_plan_id
1787: AND organization_id = i_organization_id
1788: AND standard_operation_id = i_standard_operation_id

Line 1840: FROM flm_mmm_op_resources

1836: AND operation_type = i_calc_op_type;
1837:
1838: CURSOR op_takt_assigned(i_operation_id NUMBER) IS
1839: SELECT max(weighted_resource_usage/resource_assigned) takt_assigned
1840: FROM flm_mmm_op_resources
1841: WHERE plan_id = i_plan_id
1842: AND organization_id = i_organization_id
1843: AND standard_operation_id = i_operation_id
1844: AND resource_assigned > 0;

Line 1861: FROM flm_mmm_op_resources

1857: FOR op_rec IN operations LOOP -- For each operation
1858: -- Infinite Over Limit?
1859: SELECT count(*)
1860: INTO l_count
1861: FROM flm_mmm_op_resources
1862: WHERE plan_id = i_plan_id
1863: AND organization_id = i_organization_id
1864: AND standard_operation_id = op_rec.standard_operation_id
1865: AND weighted_resource_usage > 0

Line 1980: FROM flm_mmm_op_resources

1976:
1977: CURSOR res_overcapacity_op(i_operation_id NUMBER) IS
1978: SELECT
1979: max(100*(resource_needed-resource_assigned)/resource_assigned) over_pct
1980: FROM flm_mmm_op_resources
1981: WHERE plan_id = i_plan_id
1982: AND organization_id = i_organization_id
1983: AND standard_operation_id = i_operation_id
1984: AND resource_assigned > 0;

Line 2009: FROM flm_mmm_op_resources

2005: FOR op_rec IN operations LOOP -- For each operation
2006: -- Infinite Over Capacity?
2007: SELECT count(*)
2008: INTO l_count
2009: FROM flm_mmm_op_resources
2010: WHERE plan_id = i_plan_id
2011: AND organization_id = i_organization_id
2012: AND standard_operation_id = op_rec.standard_operation_id
2013: AND (resource_needed > 0 or resource_needed is null)

Line 2155: FROM flm_mmm_op_resources

2151:
2152: -- retrieve all resource assigned and needed
2153: CURSOR res_assigned_needed(i_operation_id NUMBER) IS
2154: SELECT resource_assigned,resource_needed
2155: FROM flm_mmm_op_resources
2156: WHERE plan_id = i_plan_id
2157: AND organization_id = i_organization_id
2158: AND standard_operation_id = i_operation_id;
2159:

Line 2356: -- FLM_MMM_OP_RESOURCES, delete if not re-plan

2352: WHERE plan_id = i_plan_id
2353: AND organization_id = i_organization_id
2354: AND operation_type = i_calc_op_type;
2355:
2356: -- FLM_MMM_OP_RESOURCES, delete if not re-plan
2357: -- if re-plan, the records will be changed(delete, then insert)
2358: -- when calculating weighted resource usage
2359: -- this is because we might need to use its resource_assigned information
2360: IF NOT (i_replan_flag = C_REPLAN_FLAG_YES) THEN

Line 2361: DELETE FROM flm_mmm_op_resources

2357: -- if re-plan, the records will be changed(delete, then insert)
2358: -- when calculating weighted resource usage
2359: -- this is because we might need to use its resource_assigned information
2360: IF NOT (i_replan_flag = C_REPLAN_FLAG_YES) THEN
2361: DELETE FROM flm_mmm_op_resources
2362: WHERE plan_id = i_plan_id
2363: AND organization_id = i_organization_id
2364: AND operation_type = i_calc_op_type;
2365: END IF;

Line 2648: FROM flm_mmm_op_resources

2644: l_dummy NUMBER;
2645:
2646: CURSOR lock_res IS
2647: SELECT resource_id
2648: FROM flm_mmm_op_resources
2649: WHERE plan_id = i_plan_id
2650: AND organization_id = i_organization_id
2651: AND operation_type = i_calc_op_type
2652: FOR UPDATE NOWAIT;

Line 2664: FROM flm_mmm_op_resources

2660: FOR UPDATE NOWAIT;
2661:
2662: CURSOR lock_res_res IS
2663: SELECT resource_id
2664: FROM flm_mmm_op_resources
2665: WHERE plan_id = i_plan_id
2666: AND organization_id = i_organization_id
2667: AND operation_type = i_calc_op_type
2668: AND resource_id = i_resource_id

Line 2673: FROM flm_mmm_op_resources

2669: FOR UPDATE NOWAIT;
2670:
2671: CURSOR lock_res_line IS
2672: SELECT resource_id
2673: FROM flm_mmm_op_resources
2674: WHERE plan_id = i_plan_id
2675: AND organization_id = i_organization_id
2676: AND operation_type = i_calc_op_type
2677: AND line_id = i_line_id

Line 2691: FROM flm_mmm_op_resources

2687: FOR UPDATE NOWAIT;
2688:
2689: CURSOR lock_res_op IS
2690: SELECT resource_id
2691: FROM flm_mmm_op_resources
2692: WHERE plan_id = i_plan_id
2693: AND organization_id = i_organization_id
2694: AND operation_type = i_calc_op_type
2695: AND standard_operation_id = i_standard_operation_id

Line 2720: UPDATE flm_mmm_op_resources

2716: NULL;
2717: END LOOP;
2718:
2719: -- update records
2720: UPDATE flm_mmm_op_resources
2721: SET resource_assigned = resource_needed,
2722: last_updated_by = fnd_global.user_id,
2723: last_update_date = sysdate,
2724: last_update_login = fnd_global.user_id

Line 2745: UPDATE flm_mmm_op_resources

2741: NULL;
2742: END LOOP;
2743:
2744: -- update records
2745: UPDATE flm_mmm_op_resources
2746: SET resource_assigned = resource_needed,
2747: last_updated_by = fnd_global.user_id,
2748: last_update_date = sysdate,
2749: last_update_login = fnd_global.user_id

Line 2767: UPDATE flm_mmm_op_resources

2763: NULL;
2764: END LOOP;
2765:
2766: -- update records
2767: UPDATE flm_mmm_op_resources
2768: SET resource_assigned = resource_needed,
2769: last_updated_by = fnd_global.user_id,
2770: last_update_date = sysdate,
2771: last_update_login = fnd_global.user_id

Line 2798: UPDATE flm_mmm_op_resources

2794: NULL;
2795: END LOOP;
2796:
2797: -- update records
2798: UPDATE flm_mmm_op_resources
2799: SET resource_assigned = resource_needed,
2800: last_updated_by = fnd_global.user_id,
2801: last_update_date = sysdate,
2802: last_update_login = fnd_global.user_id

Line 2872: FROM flm_mmm_op_resources

2868: SELECT resource_id,
2869: standard_operation_id operation_id,
2870: resource_assigned,
2871: line_id
2872: FROM flm_mmm_op_resources
2873: WHERE plan_id = i_plan_id
2874: AND organization_id = i_organization_id
2875: AND operation_type = i_operation_type;
2876:

Line 2931: FROM flm_mmm_op_resources

2927: -- Resources
2928: FOR res_rec IN all_resources LOOP
2929: SELECT count(*)
2930: INTO l_count
2931: FROM flm_mmm_op_resources
2932: WHERE organization_id = i_organization_id
2933: AND plan_id = -1
2934: AND resource_id = res_rec.resource_id
2935: AND standard_operation_id = res_rec.operation_id;

Line 2938: UPDATE flm_mmm_op_resources

2934: AND resource_id = res_rec.resource_id
2935: AND standard_operation_id = res_rec.operation_id;
2936:
2937: IF l_count > 0 THEN
2938: UPDATE flm_mmm_op_resources
2939: SET resource_assigned = res_rec.resource_assigned,
2940: last_updated_by = fnd_global.user_id,
2941: last_update_date = sysdate,
2942: last_update_login = fnd_global.user_id

Line 2949: INSERT INTO FLM_MMM_OP_RESOURCES (

2945: AND resource_id = res_rec.resource_id
2946: AND standard_operation_id = res_rec.operation_id;
2947:
2948: ELSE
2949: INSERT INTO FLM_MMM_OP_RESOURCES (
2950: PLAN_ID,
2951: ORGANIZATION_ID,
2952: RESOURCE_ID,
2953: STANDARD_OPERATION_ID,