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_OPERATIONS

Line 990: FROM flm_mmm_operations

986:
987: CURSOR all_ipks IS
988: SELECT standard_operation_id op_id,
989: ipk_assigned
990: FROM flm_mmm_operations
991: WHERE plan_id = i_plan_id
992: AND organization_id = i_organization_id
993: AND operation_type = i_calc_op_type;
994:

Line 1009: DELETE FROM flm_mmm_operations

1005: l_ipks(ipk_rec.op_id).standard_operation_id := ipk_rec.op_id;
1006: l_ipks(ipk_rec.op_id).ipk_assigned := ipk_rec.ipk_assigned;
1007: END LOOP;
1008:
1009: DELETE FROM flm_mmm_operations
1010: WHERE plan_id = i_plan_id
1011: AND organization_id = i_organization_id
1012: AND operation_type = i_calc_op_type;
1013:

Line 1030: FROM flm_mmm_operations

1026: ELSE
1027: BEGIN
1028: SELECT ipk_assigned
1029: INTO l_ipk_assigned
1030: FROM flm_mmm_operations
1031: WHERE plan_id = -1
1032: AND organization_id = i_organization_id
1033: AND standard_operation_id = op_takt_rec.standard_operation_id;
1034:

Line 1043: INSERT INTO flm_mmm_operations (

1039: END;
1040:
1041: END IF;
1042:
1043: INSERT INTO flm_mmm_operations (
1044: plan_id,
1045: organization_id,
1046: standard_operation_id,
1047: created_by,

Line 1094: FROM flm_mmm_operations

1090: l_elapsed_wt NUMBER;
1091:
1092: CURSOR operations IS
1093: SELECT standard_operation_id
1094: FROM flm_mmm_operations
1095: WHERE plan_id = i_plan_id
1096: AND organization_id = i_organization_id
1097: AND operation_type = i_calc_op_type;
1098:

Line 1120: UPDATE flm_mmm_operations

1116: AND standard_operation_id = op_rec.standard_operation_id
1117: GROUP BY standard_operation_id;
1118:
1119: -- update operation records
1120: UPDATE flm_mmm_operations
1121: SET machine_weighted_time = l_machine_wt,
1122: labor_weighted_time = l_labor_wt,
1123: elapsed_weighted_time = l_elapsed_wt
1124: WHERE plan_id = i_plan_id

Line 1165: FROM flm_mmm_operations fmo,

1161: fmo.operation_type,
1162: fmo.line_id,
1163: fmo.operation_takt,
1164: fml.hours_per_day
1165: FROM flm_mmm_operations fmo,
1166: flm_mmm_lines fml
1167: WHERE fmo.plan_id = i_plan_id
1168: AND fmo.organization_id = i_organization_id
1169: AND fmo.operation_type = i_calc_op_type

Line 1181: FROM flm_mmm_operations op,

1177: it.assembly_item_id,
1178: it.process_volume,
1179: sum(bor.usage_rate_or_amount * nvl(muc.conversion_rate, 0) /
1180: nvl(l_hour_conv, 1)) resource_usage
1181: FROM flm_mmm_operations op,
1182: flm_mmm_op_items it,
1183: bom_operational_routings brtg,
1184: bom_operation_sequences bos1,
1185: bom_operation_sequences bos2,

Line 1447: FROM flm_mmm_operations fmo,

1443: SELECT fmo.standard_operation_id,
1444: fmo.operation_takt,
1445: fmo.ipk_assigned,
1446: fml.hours_per_day
1447: FROM flm_mmm_operations fmo,
1448: flm_mmm_lines fml
1449: WHERE fmo.plan_id = i_plan_id
1450: AND fmo.organization_id = i_organization_id
1451: AND fml.plan_id = i_plan_id

Line 1484: UPDATE flm_mmm_operations

1480:
1481: END LOOP;
1482:
1483: -- IPK Needed = 0;
1484: UPDATE flm_mmm_operations
1485: SET ipk_needed = 0
1486: WHERE plan_id = i_plan_id
1487: AND organization_id = i_organization_id
1488: AND operation_type = i_calc_op_type;

Line 1512: -- Update FLM_MMM_OPERATIONS

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:
1512: -- Update FLM_MMM_OPERATIONS
1513: IF l_max_rs_usage > 0 THEN
1514: UPDATE flm_mmm_operations
1515: SET ipk_needed =
1516: ceil((l_max_rs_usage - op_rec.operation_takt)/l_max_rs_usage *

Line 1514: UPDATE flm_mmm_operations

1510: AND standard_operation_id = op_rec.standard_operation_id;
1511:
1512: -- Update FLM_MMM_OPERATIONS
1513: IF l_max_rs_usage > 0 THEN
1514: UPDATE flm_mmm_operations
1515: SET ipk_needed =
1516: ceil((l_max_rs_usage - op_rec.operation_takt)/l_max_rs_usage *
1517: op_rec.hours_per_day / op_rec.operation_takt)
1518: WHERE plan_id = i_plan_id

Line 1523: UPDATE flm_mmm_operations

1519: AND organization_id = i_organization_id
1520: AND standard_operation_id = op_rec.standard_operation_id;
1521:
1522: ELSE -- No Resource Usage, set IPK = 0
1523: UPDATE flm_mmm_operations
1524: SET ipk_needed = 0
1525: WHERE plan_id = i_plan_id
1526: AND organization_id = i_organization_id
1527: AND standard_operation_id = op_rec.standard_operation_id;

Line 1535: UPDATE flm_mmm_operations

1531: END IF; -- operation_takt > 0 AND op_rec.hours_per_day
1532:
1533: END LOOP;
1534:
1535: UPDATE flm_mmm_operations
1536: SET ipk_needed = 0
1537: WHERE plan_id = i_plan_id
1538: AND organization_id = i_organization_id
1539: AND ipk_needed < 0;

Line 1569: -- Update FLM_MMM_OPERATIONS, Set IPK Needed

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:
1569: -- Update FLM_MMM_OPERATIONS, Set IPK Needed
1570: l_ipk_needed := ceil((l_max_rs_usage - op_rec.operation_takt) /
1571: l_max_rs_usage * op_rec.hours_per_day /
1572: op_rec.operation_takt);
1573:

Line 1578: UPDATE flm_mmm_operations

1574: IF l_ipk_needed < 0 OR l_ipk_needed IS NULL THEN
1575: l_ipk_needed := 0;
1576: END IF;
1577:
1578: UPDATE flm_mmm_operations
1579: SET ipk_needed = l_ipk_needed
1580: WHERE plan_id = i_plan_id
1581: AND organization_id = i_organization_id
1582: AND standard_operation_id = op_rec.standard_operation_id;

Line 1623: UPDATE flm_mmm_operations

1619:
1620: END LOOP;
1621:
1622: -- IPK Needed = IPK Assigned
1623: UPDATE flm_mmm_operations
1624: SET ipk_needed = ipk_assigned
1625: WHERE plan_id = i_plan_id
1626: AND organization_id = i_organization_id
1627: AND operation_type = i_calc_op_type;

Line 1669: FROM flm_mmm_operations fmo,

1665: CURSOR op_parameter IS
1666: SELECT fmo.operation_takt,
1667: fmo.ipk_assigned,
1668: fml.hours_per_day
1669: FROM flm_mmm_operations fmo,
1670: flm_mmm_lines fml
1671: WHERE fmo.plan_id = i_plan_id
1672: AND fmo.organization_id = i_organization_id
1673: AND fmo.standard_operation_id = i_standard_operation_id

Line 1733: -- Update FLM_MMM_OPERATIONS, Set IPK Needed

1729: WHERE plan_id = i_plan_id
1730: AND organization_id = i_organization_id
1731: AND standard_operation_id = i_standard_operation_id;
1732:
1733: -- Update FLM_MMM_OPERATIONS, Set IPK Needed
1734: l_ipk_needed := ceil((l_max_rs_usage - l_operation_takt) /
1735: l_max_rs_usage * l_hours_per_day /
1736: l_operation_takt);
1737: IF G_DEBUG THEN

Line 1745: UPDATE flm_mmm_operations

1741: IF l_ipk_needed < 0 OR l_ipk_needed IS NULL THEN
1742: l_ipk_needed := 0;
1743: END IF;
1744:
1745: UPDATE flm_mmm_operations
1746: SET ipk_needed = l_ipk_needed
1747: WHERE plan_id = i_plan_id
1748: AND organization_id = i_organization_id
1749: AND standard_operation_id = i_standard_operation_id;

Line 1794: UPDATE flm_mmm_operations

1790:
1791: END IF;
1792:
1793: -- IPK Needed = IPK Assigned
1794: UPDATE flm_mmm_operations
1795: SET ipk_needed = ipk_assigned
1796: WHERE plan_id = i_plan_id
1797: AND organization_id = i_organization_id
1798: AND standard_operation_id = i_standard_operation_id;

Line 1833: FROM flm_mmm_operations

1829: AND calculation_operation_type = i_calc_op_type;
1830:
1831: CURSOR operations IS
1832: SELECT standard_operation_id
1833: FROM flm_mmm_operations
1834: WHERE plan_id = i_plan_id
1835: AND organization_id = i_organization_id
1836: AND operation_type = i_calc_op_type;
1837:

Line 1848: FROM flm_mmm_operations

1844: AND resource_assigned > 0;
1845:
1846: CURSOR line_takt_assigned(i_line_id NUMBER) IS
1847: SELECT max(op_takt_as_assigned/operation_takt) max_ratio
1848: FROM flm_mmm_operations
1849: WHERE plan_id = i_plan_id
1850: AND organization_id = i_organization_id
1851: AND line_id = i_line_id
1852: AND operation_type = i_calc_op_type

Line 1877: UPDATE flm_mmm_operations

1873: IF l_takt_assigned IS NULL THEN -- No Resource Required?
1874: l_takt_assigned := 0;
1875: END IF;
1876:
1877: UPDATE flm_mmm_operations
1878: SET op_takt_as_assigned = l_takt_assigned,
1879: last_updated_by = fnd_global.user_id,
1880: last_update_date = sysdate,
1881: last_update_login = fnd_global.user_id

Line 1887: UPDATE flm_mmm_operations

1883: AND organization_id = i_organization_id
1884: AND standard_operation_id = op_rec.standard_operation_id;
1885:
1886: ELSE
1887: UPDATE flm_mmm_operations
1888: SET op_takt_as_assigned = NULL,
1889: last_updated_by = fnd_global.user_id,
1890: last_update_date = sysdate,
1891: last_update_login = fnd_global.user_id

Line 1905: FROM flm_mmm_operations

1901: FOR line_rec IN lines LOOP -- Each Line
1902: -- Unknown Operation TAKT?
1903: SELECT count(*)
1904: INTO l_count
1905: FROM flm_mmm_operations
1906: WHERE plan_id = i_plan_id
1907: AND organization_id = i_organization_id
1908: AND operation_type = i_calc_op_type
1909: AND line_id = line_rec.line_id

Line 1972: FROM flm_mmm_operations

1968: AND calculation_operation_type = i_calc_op_type;
1969:
1970: CURSOR operations IS
1971: SELECT standard_operation_id
1972: FROM flm_mmm_operations
1973: WHERE plan_id = i_plan_id
1974: AND organization_id = i_organization_id
1975: AND operation_type = i_calc_op_type;
1976:

Line 1988: FROM flm_mmm_operations

1984: AND resource_assigned > 0;
1985:
1986: CURSOR res_overcapacity_ln(i_line_id NUMBER) IS
1987: SELECT max(bottleneck_resource_percent) over_pct
1988: FROM flm_mmm_operations
1989: WHERE plan_id = i_plan_id
1990: AND organization_id = i_organization_id
1991: AND line_id = i_line_id
1992: AND operation_type = i_calc_op_type;

Line 1996: FROM flm_mmm_operations

1992: AND operation_type = i_calc_op_type;
1993:
1994: CURSOR ipk_overcapacity(i_line_id NUMBER) IS
1995: SELECT max(100*(ipk_needed-ipk_assigned)/ipk_assigned) over_pct
1996: FROM flm_mmm_operations
1997: WHERE plan_id = i_plan_id
1998: AND organization_id = i_organization_id
1999: AND line_id = i_line_id
2000: AND operation_type = i_calc_op_type

Line 2025: UPDATE flm_mmm_operations

2021: IF l_res_over_pct < 0 OR l_res_over_pct IS NULL THEN
2022: l_res_over_pct := 0;
2023: END IF;
2024:
2025: UPDATE flm_mmm_operations
2026: SET bottleneck_resource_percent = l_res_over_pct,
2027: last_updated_by = fnd_global.user_id,
2028: last_update_date = sysdate,
2029: last_update_login = fnd_global.user_id

Line 2035: UPDATE flm_mmm_operations

2031: AND organization_id = i_organization_id
2032: AND standard_operation_id = op_rec.standard_operation_id;
2033:
2034: ELSE
2035: UPDATE flm_mmm_operations
2036: SET bottleneck_resource_percent = NULL,
2037: last_updated_by = fnd_global.user_id,
2038: last_update_date = sysdate,
2039: last_update_login = fnd_global.user_id

Line 2052: FROM flm_mmm_operations

2048: FOR line_rec IN lines LOOP
2049: -- Resource
2050: SELECT count(*)
2051: INTO l_count
2052: FROM flm_mmm_operations
2053: WHERE plan_id = i_plan_id
2054: AND organization_id = i_organization_id
2055: AND line_id = line_rec.line_id
2056: AND operation_type = i_calc_op_type

Line 2075: FROM flm_mmm_operations

2071:
2072: -- IPK
2073: SELECT count(*)
2074: INTO l_count
2075: FROM flm_mmm_operations
2076: WHERE plan_id = i_plan_id
2077: AND organization_id = i_organization_id
2078: AND line_id = line_rec.line_id
2079: AND operation_type = i_calc_op_type

Line 2147: FROM flm_mmm_operations

2143: AND calculation_operation_type = i_calc_op_type;
2144:
2145: CURSOR operations IS
2146: SELECT standard_operation_id
2147: FROM flm_mmm_operations
2148: WHERE plan_id = i_plan_id
2149: AND organization_id = i_organization_id
2150: AND operation_type = i_calc_op_type;
2151:

Line 2162: FROM flm_mmm_operations

2158: AND standard_operation_id = i_operation_id;
2159:
2160: CURSOR res_undercapacity_ln(i_line_id NUMBER) IS
2161: SELECT max(resource_undercapacity) under_pct
2162: FROM flm_mmm_operations
2163: WHERE plan_id = i_plan_id
2164: AND organization_id = i_organization_id
2165: AND line_id = i_line_id
2166: AND operation_type = i_calc_op_type;

Line 2171: FROM flm_mmm_operations

2167:
2168: -- retrieve all ipk assigned and needed
2169: CURSOR ipk_assigned_needed(i_line_id NUMBER) IS
2170: SELECT ipk_assigned, ipk_needed
2171: FROM flm_mmm_operations
2172: WHERE plan_id = i_plan_id
2173: AND organization_id = i_organization_id
2174: AND line_id = i_line_id
2175: AND operation_type = i_calc_op_type;

Line 2202: UPDATE flm_mmm_operations

2198:
2199: END IF;
2200: END LOOP;
2201:
2202: UPDATE flm_mmm_operations
2203: SET resource_undercapacity = l_res_under_pct,
2204: last_updated_by = fnd_global.user_id,
2205: last_update_date = sysdate,
2206: last_update_login = fnd_global.user_id

Line 2274: FROM flm_mmm_operations

2270:
2271: CURSOR operations IS
2272: SELECT line_id,
2273: standard_operation_id
2274: FROM flm_mmm_operations
2275: WHERE plan_id = i_plan_id
2276: AND organization_id = i_organization_id
2277: AND operation_type = i_calc_op_type;
2278:

Line 2305: UPDATE flm_mmm_operations

2301: AND bos.operation_type = i_calc_op_type
2302: AND bos.standard_operation_id = operation_rec.standard_operation_id;
2303:
2304: IF (l_operation_process_volume <> 0) THEN
2305: UPDATE flm_mmm_operations
2306: SET process_efficiency = l_weighted_process_efficiency / l_operation_process_volume
2307: WHERE plan_id = i_plan_id
2308: AND organization_id = i_organization_id
2309: AND standard_operation_id = operation_rec.standard_operation_id;

Line 2339: -- FLM_MMM_OPERATIONS delete if not re-plan

2335: AND organization_id = i_organization_id
2336: AND calculation_operation_type = i_calc_op_type;
2337: END IF;
2338:
2339: -- FLM_MMM_OPERATIONS delete if not re-plan
2340: -- if re-plan, the records will be changed(delete, then insert)
2341: -- when calculating operation takt.
2342: -- this is because we might need to use its ipk_assigned information
2343: IF NOT (i_replan_flag = C_REPLAN_FLAG_YES) THEN

Line 2344: DELETE FROM flm_mmm_operations

2340: -- if re-plan, the records will be changed(delete, then insert)
2341: -- when calculating operation takt.
2342: -- this is because we might need to use its ipk_assigned information
2343: IF NOT (i_replan_flag = C_REPLAN_FLAG_YES) THEN
2344: DELETE FROM flm_mmm_operations
2345: WHERE plan_id = i_plan_id
2346: AND organization_id = i_organization_id
2347: AND operation_type = i_calc_op_type;
2348: END IF;

Line 2656: FROM flm_mmm_operations

2652: FOR UPDATE NOWAIT;
2653:
2654: CURSOR lock_op IS
2655: SELECT standard_operation_id
2656: FROM flm_mmm_operations
2657: WHERE plan_id = i_plan_id
2658: AND organization_id = i_organization_id
2659: AND operation_type = i_calc_op_type
2660: FOR UPDATE NOWAIT;

Line 2682: FROM flm_mmm_operations

2678: FOR UPDATE NOWAIT;
2679:
2680: CURSOR lock_op_line IS
2681: SELECT standard_operation_id
2682: FROM flm_mmm_operations
2683: WHERE plan_id = i_plan_id
2684: AND organization_id = i_organization_id
2685: AND operation_type = i_calc_op_type
2686: AND line_id = i_line_id

Line 2700: FROM flm_mmm_operations

2696: FOR UPDATE NOWAIT;
2697:
2698: CURSOR lock_op_op IS
2699: SELECT standard_operation_id
2700: FROM flm_mmm_operations
2701: WHERE plan_id = i_plan_id
2702: AND organization_id = i_organization_id
2703: AND operation_type = i_calc_op_type
2704: AND standard_operation_id = i_standard_operation_id

Line 2729: UPDATE flm_mmm_operations

2725: WHERE plan_id = i_plan_id
2726: AND organization_id = i_organization_id
2727: AND operation_type = i_calc_op_type;
2728:
2729: UPDATE flm_mmm_operations
2730: SET ipk_assigned = ipk_needed,
2731: last_updated_by = fnd_global.user_id,
2732: last_update_date = sysdate,
2733: last_update_login = fnd_global.user_id

Line 2777: UPDATE flm_mmm_operations

2773: AND organization_id = i_organization_id
2774: AND operation_type = i_calc_op_type
2775: AND line_id = i_line_id;
2776:
2777: UPDATE flm_mmm_operations
2778: SET ipk_assigned = ipk_needed,
2779: last_updated_by = fnd_global.user_id,
2780: last_update_date = sysdate,
2781: last_update_login = fnd_global.user_id

Line 2808: UPDATE flm_mmm_operations

2804: AND organization_id = i_organization_id
2805: AND operation_type = i_calc_op_type
2806: AND standard_operation_id = i_standard_operation_id;
2807:
2808: UPDATE flm_mmm_operations
2809: SET ipk_assigned = ipk_needed,
2810: last_updated_by = fnd_global.user_id,
2811: last_update_date = sysdate,
2812: last_update_login = fnd_global.user_id

Line 2862: FROM flm_mmm_operations

2858: CURSOR all_operations IS
2859: SELECT standard_operation_id operation_id,
2860: ipk_assigned,
2861: line_id
2862: FROM flm_mmm_operations
2863: WHERE plan_id = i_plan_id
2864: AND organization_id = i_organization_id
2865: AND operation_type = i_operation_type;
2866:

Line 2882: FROM flm_mmm_operations

2878: -- IPKs
2879: FOR op_rec IN all_operations LOOP
2880: SELECT count(*)
2881: INTO l_count
2882: FROM flm_mmm_operations
2883: WHERE organization_id = i_organization_id
2884: AND plan_id = -1
2885: AND standard_operation_id = op_rec.operation_id;
2886:

Line 2888: UPDATE flm_mmm_operations

2884: AND plan_id = -1
2885: AND standard_operation_id = op_rec.operation_id;
2886:
2887: IF l_count > 0 THEN
2888: UPDATE flm_mmm_operations
2889: SET ipk_assigned = op_rec.ipk_assigned,
2890: last_updated_by = fnd_global.user_id,
2891: last_update_date = sysdate,
2892: last_update_login = fnd_global.user_id

Line 2898: INSERT INTO FLM_MMM_OPERATIONS (

2894: AND plan_id = -1
2895: AND standard_operation_id = op_rec.operation_id;
2896:
2897: ELSE
2898: INSERT INTO FLM_MMM_OPERATIONS (
2899: PLAN_ID,
2900: ORGANIZATION_ID,
2901: STANDARD_OPERATION_ID,
2902: LAST_UPDATE_DATE,