[Home] [Help]
239: SUM(GREATEST( 0, (jobs.net_quantity - jobs.quantity_completed
240: - jobs.quantity_scrapped))) new_quantity,
241: SUM(GREATEST( 0, (jobs.net_quantity - jobs.quantity_completed
242: - jobs.quantity_scrapped))) old_quantity
243: FROM mrp_form_query list,
244: wip_discrete_jobs jobs,
245: mrp_system_items items,
246: mrp_sub_inventories msi
247: WHERE (arg_res_level = 1
289: jobs.scheduled_completion_date old_date,
290: SUM(GREATEST(0, (jobs.net_quantity - jobs.quantity_completed
291: - jobs.quantity_scrapped))*NVL(items.shrinkage_rate, 0)) new_quantity,
292: 0 old_quantity
293: FROM mrp_form_query list,
294: wip_discrete_jobs jobs,
295: mrp_system_items items,
296: mrp_sub_inventories msi
297: WHERE (arg_res_level = 1
341: SUM(ops.required_quantity - ops.quantity_issued -
342: (NVL(wo.cumulative_scrap_quantity,0)*NVL(ops.quantity_per_assembly, 1))
343: ) new_quantity,
344: 0 old_quantity
345: FROM mrp_form_query list,
346: wip_operations wo,
347: wip_requirement_operations ops,
348: wip_discrete_jobs jobs,
349: mrp_system_items items,
405: SUM(GREATEST( 0, (flow_sched.planned_quantity -
406: flow_sched.quantity_completed))) new_quantity,
407: SUM(GREATEST( 0, (flow_sched.planned_quantity -
408: flow_sched.quantity_completed))) old_quantity
409: FROM mrp_form_query list,
410: wip_flow_schedules flow_sched,
411: mrp_system_items items,
412: mrp_sub_inventories msi
413: WHERE (arg_res_level = 1
466: mrp_system_items msi_assy,
467: bom_bill_of_materials bbm,
468: bom_inventory_components bic,
469: mrp_system_items items,
470: mrp_form_query list,
471: mrp_sub_inventories msi
472: WHERE (arg_res_level = 1
473: OR (arg_res_level = 2
474: AND fs.project_id is NULL)
549: mrp_system_items msi_assy,
550: bom_bill_of_materials bbm,
551: bom_inventory_components bic,
552: mrp_system_items items,
553: mrp_form_query list,
554: mrp_sub_inventories msi
555: WHERE (arg_res_level = 1
556: OR (arg_res_level = 2
557: AND fs.project_id is NULL)
626: flow_sched.quantity_completed) *
627: nvl(items.shrinkage_rate, 0)))) old_quantity
628: FROM wip_flow_schedules flow_sched,
629: mrp_system_items items,
630: mrp_form_query list,
631: mrp_sub_inventories msi
632: WHERE (arg_res_level = 1
633: OR (arg_res_level = 2
634: AND flow_sched.project_id is NULL)
676: sched.first_unit_completion_date, dates.calendar_date )) new_quantity ,
677: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,
678: sched.daily_production_rate, sched.quantity_completed,
679: sched.first_unit_completion_date, dates.calendar_date )) old_quantity
680: FROM mrp_form_query list,
681: bom_calendar_dates dates,
682: mtl_parameters param,
683: wip_repetitive_schedules sched,
684: wip_repetitive_items rep_items,
736: dates.calendar_date old_date,
737: SUM(sched.daily_production_rate*NVL(items.shrinkage_rate, 0))
738: new_quantity,
739: 0 old_quantity
740: FROM mrp_form_query list,
741: bom_calendar_dates dates,
742: mtl_parameters param,
743: wip_repetitive_schedules sched,
744: wip_repetitive_items rep_items,
796: ops.date_required new_date,
797: ops.date_required old_date,
798: SUM(ops.required_quantity - ops.quantity_issued) new_quantity,
799: 0 old_quantity
800: FROM mrp_form_query list,
801: wip_requirement_operations ops,
802: wip_repetitive_schedules sched,
803: mrp_system_items items,
804: WIP_REPETITIVE_ITEMS rep_items,
861: dates.calendar_date old_date,
862: SUM(DECODE(sched.rate_end_date, NULL, sched.schedule_quantity,
863: sched.repetitive_daily_rate)) new_quantity,
864: 0 old_quantity
865: FROM mrp_form_query list,
866: bom_calendar_dates dates,
867: mtl_parameters param,
868: mrp_schedule_dates sched,
869: mrp_plan_schedules_v plan_sched,
945: dates.calendar_date new_date,
946: dates.calendar_date old_date,
947: SUM(fcst.current_forecast_quantity) new_quantity,
948: 0 old_quantity
949: FROM mrp_form_query list,
950: bom_calendar_dates dates,
951: mtl_parameters param,
952: mrp_forecast_dates fcst,
953: mrp_forecast_designators desig,
1036: SUM(ms.to_org_primary_quantity) old_quantity
1037: FROM po_distributions_all pd,
1038: mtl_supply ms,
1039: mrp_system_items items,
1040: mrp_form_query list,
1041: mrp_sub_inventories msi
1042: WHERE (arg_res_level = 1
1043: OR (arg_res_level = 2
1044: AND pd.project_id is NULL)
1094: FROM po_req_distributions_all pd,
1095: po_requisition_lines_all pl,
1096: mrp_system_items items,
1097: mtl_supply ms,
1098: mrp_form_query list,
1099: mrp_sub_inventories msi
1100: WHERE (arg_res_level = 1
1101: OR (arg_res_level = 2
1102: AND pd.project_id is NULL)
1145: SUM(ms.to_org_primary_quantity) old_quantity
1146: FROM mtl_secondary_inventories msub,
1147: mrp_system_items items,
1148: mtl_supply ms,
1149: mrp_form_query list,
1150: mrp_sub_inventories msi
1151: WHERE (arg_res_level = 1
1152: OR (arg_res_level = 2
1153: AND msub.project_id is NULL)
1202: FROM mrp_system_items items,
1203: po_req_distributions_all pd,
1204: po_requisition_lines_all prl,
1205: mtl_supply ms,
1206: mrp_form_query list,
1207: mrp_sub_inventories msi
1208: WHERE (arg_res_level = 1
1209: OR (arg_res_level = 2
1210: AND pd.project_id is NULL)
1265: FROM po_requisition_lines_all pl,
1266: po_req_distributions_all pd,
1267: mrp_system_items items,
1268: mtl_supply ms,
1269: mrp_form_query list,
1270: mrp_sub_inventories msi
1271: WHERE (arg_res_level = 1
1272: OR (arg_res_level = 2
1273: AND pd.project_id is NULL)
1318: SUM(ms.to_org_primary_quantity) old_quantity
1319: FROM mtl_secondary_inventories msub,
1320: mrp_system_items items,
1321: mtl_supply ms,
1322: mrp_form_query list,
1323: mrp_sub_inventories msi
1324: WHERE (arg_res_level = 1
1325: OR (arg_res_level = 2
1326: AND msub.project_id is NULL)
1372: SUM(ms.to_org_primary_quantity) old_quantity
1373: FROM po_distributions_all pd,
1374: mrp_system_items items,
1375: mtl_supply ms,
1376: mrp_form_query list,
1377: mrp_sub_inventories msi
1378: WHERE (arg_res_level = 1
1379: OR (arg_res_level = 2
1380: AND pd.project_id is NULL)
1429: 0 old_quantity
1430: FROM po_distributions_all pd,
1431: mrp_system_items items,
1432: mtl_supply ms,
1433: mrp_form_query list,
1434: mrp_sub_inventories msi
1435: WHERE (arg_res_level = 1
1436: OR (arg_res_level = 2
1437: AND pd.project_id is NULL)
1486: FROM po_req_distributions_all pd,
1487: po_requisition_lines_all pl,
1488: mrp_system_items items,
1489: mtl_supply ms,
1490: mrp_form_query list,
1491: mrp_sub_inventories msi
1492: WHERE (arg_res_level = 1
1493: OR (arg_res_level = 2
1494: AND pd.project_id is NULL)
1538: 0 old_quantity
1539: FROM mtl_secondary_inventories msub,
1540: mrp_system_items items,
1541: mtl_supply ms,
1542: mrp_form_query list,
1543: mrp_sub_inventories msi
1544: WHERE (arg_res_level = 1
1545: OR (arg_res_level = 2
1546: AND msub.project_id is NULL)
1593: 0 old_quantity
1594: FROM mrp_system_items items,
1595: po_req_distributions_all pd,
1596: mtl_supply ms,
1597: mrp_form_query list,
1598: mrp_sub_inventories msi
1599: WHERE (arg_res_level = 1
1600: OR (arg_res_level = 2
1601: AND pd.project_id is NULL)
1654: reqs.using_requirements_quantity, daily_demand_rate)*
1655: ((NVL(recom.new_order_quantity, 0)
1656: - NVL(implemented_quantity, 0))/NVL(recom.new_order_quantity,1)))) new_quantity,
1657: 0 old_quantity
1658: FROM mrp_form_query list,
1659: bom_calendar_dates dates,
1660: mtl_parameters param,
1661: mrp_recommendations recom,
1662: mrp_gross_requirements reqs,
1718: SUM(DECODE(reqs.assembly_demand_comp_date,
1719: NULL, using_requirements_quantity,
1720: daily_demand_rate)) new_quantity,
1721: 0 old_quantity
1722: FROM mrp_form_query list,
1723: mtl_parameters param,
1724: mrp_gross_requirements reqs,
1725: bom_calendar_dates dates
1726: WHERE (arg_res_level = 1
1767: mipv.payback_date new_date,
1768: mipv.payback_date old_date,
1769: sum(mipv.quantity) new_quantity,
1770: 0 old_quantity
1771: FROM mrp_form_query list,
1772: mrp_project_parameters pa,
1773: mtl_parameters param,
1774: mrp_item_borrow_payback_qty_v mipv
1775: WHERE (arg_res_level = 1
1810: mubq.payback_date new_date,
1811: mubq.payback_date old_date,
1812: sum(mubq.quantity-nvl(mupq.quantity, 0)) new_quantity,
1813: 0 old_quantity
1814: FROM mrp_form_query list,
1815: mrp_project_parameters pa,
1816: mtl_parameters param,
1817: mrp_unit_borrow_qty_v mubq,
1818: mrp_unit_payback_qty_v mupq
1861: mipv.payback_date new_date,
1862: mipv.payback_date old_date,
1863: sum(mipv.quantity) new_quantity,
1864: sum(mipv.quantity) old_quantity
1865: FROM mrp_form_query list,
1866: mrp_project_parameters pa,
1867: mtl_parameters param,
1868: mrp_item_borrow_payback_qty_v mipv
1869: WHERE (arg_res_level = 1
1903: mubq.payback_date new_date,
1904: mubq.payback_date old_date,
1905: sum(mubq.quantity-nvl(mupq.quantity, 0)) new_quantity,
1906: sum(mubq.quantity-nvl(mupq.quantity, 0)) old_quantity
1907: FROM mrp_form_query list,
1908: mrp_project_parameters pa,
1909: mtl_parameters param,
1910: mrp_unit_borrow_qty_v mubq,
1911: mrp_unit_payback_qty_v mupq
1957: SUM(GREATEST(0, nvl(rec.firm_quantity, rec.new_order_quantity) -
1958: (nvl(rec.implemented_quantity, 0)
1959: + nvl(rec.quantity_in_process, 0)))) new_quantity,
1960: 0 old_quantity
1961: FROM mrp_form_query list,
1962: mrp_recommendations rec
1963: WHERE (arg_res_level = 1
1964: OR (arg_res_level = 2
1965: AND rec.project_id is NULL)
1999: rec.new_schedule_date new_date,
2000: rec.old_schedule_date old_date,
2001: SUM(-1 * rec.new_order_quantity),
2002: 0 old_quantity
2003: FROM mrp_form_query list,
2004: mrp_recommendations rec
2005: WHERE (arg_res_level = 1
2006: OR (arg_res_level = 2
2007: AND rec.project_id is NULL)
2039: rec.new_schedule_date new_date,
2040: rec.old_schedule_date old_date,
2041: SUM(rec.new_order_quantity*NVL(items.shrinkage_rate, 0)) new_quantity,
2042: 0 old_quantity
2043: FROM mrp_form_query list,
2044: mrp_recommendations rec,
2045: mrp_system_items items
2046: WHERE (arg_res_level = 1
2047: OR (arg_res_level = 2
2087: 0 old_quantity
2088: FROM oe_order_lines_all sl,
2089: mtl_demand_omoe demand,
2090: mrp_system_items items,
2091: mrp_form_query list
2092: WHERE (arg_res_level = 1
2093: OR (arg_res_level = 2
2094: AND sl.project_id is NULL)
2095: OR (DECODE(arg_res_level,
2135: DECODE (NVL(items.rounding_control_type, DO_NOT_ROUND),
2136: DO_ROUND, CEIL(NVL(safety.safety_stock_quantity, 0)),
2137: NVL(safety.safety_stock_quantity, 0)),
2138: 0 old_quantity
2139: FROM mrp_form_query list,
2140: mtl_safety_stocks safety,
2141: mrp_system_items items
2142: WHERE TRUNC(safety.effectivity_date) < last_date
2143: AND TRUNC(safety.effectivity_date) >=
2172: mtl_onhand_quantities_detail moq,
2173: mrp_sub_inventories sub,
2174: mrp_system_items items,
2175: mrp_plan_organizations_v orgs,
2176: mrp_form_query list
2177: WHERE (arg_res_level = 1
2178: OR (arg_res_level = 2
2179: AND mil.project_id is NULL)
2180: OR (DECODE(arg_res_level,
2238: MTL_LOT_NUMBERS mln,
2239: MTL_ITEM_LOCATIONS mil,
2240: PJM_PROJECT_PARAMETERS mpp,
2241: mrp_sub_inventories sub,
2242: mrp_form_query list
2243: WHERE (arg_res_level = 1
2244: OR (arg_res_level = 2
2245: AND mil.project_id is NULL)
2246: OR (DECODE(arg_res_level,
2315: MTL_LOT_NUMBERS mln,
2316: MTL_ITEM_LOCATIONS mil,
2317: PJM_PROJECT_PARAMETERS mpp,
2318: mrp_sub_inventories sub,
2319: mrp_form_query list
2320: WHERE
2321: (arg_res_level = 1
2322: OR (arg_res_level = 2
2323: AND mil.project_id is NULL)
2369: mrp_system_items masis,
2370: MTL_Material_Transactions_Temp mmtt,
2371: MTL_ITEM_LOCATIONS mil,
2372: mrp_sub_inventories sub,
2373: mrp_form_query list
2374: WHERE
2375: (arg_res_level = 1
2376: OR (arg_res_level = 2
2377: AND mmtt.project_id is NULL)
2438: mrp_system_items masis,
2439: MTL_Material_Transactions_Temp mmtt,
2440: MTL_ITEM_LOCATIONS mil,
2441: mrp_sub_inventories sub,
2442: mrp_form_query list
2443: WHERE
2444: (arg_res_level = 1
2445: OR(arg_res_level = 2 AND mmtt.project_id is NULL)
2446: OR(DECODE(arg_res_level,3,nvl(mrp_get_project.planning_group(mmtt.project_id),'-23453'),
2506: mrp_system_items masis,
2507: MTL_Material_Transactions_Temp mmtt,
2508: MTL_ITEM_LOCATIONS mil,
2509: mrp_sub_inventories sub,
2510: mrp_form_query list
2511: WHERE
2512: (arg_res_level = 1
2513: OR(arg_res_level = 2 AND mmtt.project_id is NULL)
2514: OR(DECODE(arg_res_level,3,nvl(mrp_get_project.planning_group(mmtt.project_id),'-23453'),
2577: MTL_TRANSACTION_TYPES MTT,
2578: PJM_PROJECT_PARAMETERS mpp,
2579: MRP_PLAN_ORGANIZATIONS_V ORG,
2580: MRP_SYSTEM_ITEMS ITEMS,
2581: MRP_FORM_QUERY list
2582: where
2583: (arg_res_level = 1
2584: OR(arg_res_level = 2 AND MTRL.project_id is NULL)
2585: OR(DECODE(arg_res_level,3,nvl(mrp_get_project.planning_group(MTRL.project_id),'-23453'),
2622: to_date(1, 'J'),
2623: to_date(1, 'J'),
2624: 0,
2625: 0
2626: FROM mrp_form_query list
2627: WHERE list.query_id = item_list_id
2628: ORDER BY
2629: 1, 2, 5, 3;
2630:
2683: FLOW_SCHED_BY, -1,
2684: 1)
2685: , 0)) new_quantity,
2686: SUM(NVL(rec.old_order_quantity,0)) old_quantity
2687: FROM mrp_form_query list,
2688: mtl_parameters param,
2689: mrp_recommendations rec,
2690: bom_calendar_dates dates
2691: WHERE (arg_res_level = 1
2814: SUM(DECODE(mgr.assembly_demand_comp_date,
2815: NULL, using_requirements_quantity,
2816: daily_demand_rate)) new_quantity,
2817: 0 old_quantity
2818: FROM mrp_form_query list,
2819: mtl_parameters param,
2820: mrp_gross_requirements mgr,
2821: bom_calendar_dates dates
2822: WHERE (arg_res_level = 1
2913: avail.schedule_date new_date,
2914: avail.schedule_date old_date,
2915: avail.quantity_available new_quantity,
2916: 0 old_quantity
2917: FROM mrp_form_query list,
2918: mrp_available_to_promise avail
2919: WHERE avail.schedule_date < last_date
2920: AND avail.organization_id = list.number2
2921: AND avail.compile_designator = list.char1
2931: items.nettable_quantity new_quantity,
2932: 0 old_quantity
2933: FROM mrp_plans plans,
2934: mrp_onhand_quantities items,
2935: mrp_form_query list
2936: WHERE ((arg_res_level = 1 )
2937: OR (arg_res_level = 2
2938: AND items.project_id is null)
2939: OR (DECODE(arg_res_level, 3, nvl(items.planning_group,'-23453'),
2960: items.nettable_inventory_quantity new_quantity,
2961: 0 old_quantity
2962: FROM mrp_plans plans,
2963: mrp_system_items items,
2964: mrp_form_query list
2965: WHERE arg_res_level = 1
2966: AND (plans.curr_reservation_level = 4 OR
2967: plans.curr_reservation_level is NULL)
2968: AND plans.organization_id = arg_plan_organization_id
2980: safety.period_start_date old_date,
2981: safety.safety_stock_quantity new_quantity,
2982: 0 old_quantity
2983: FROM mrp_safety_stock safety,
2984: mrp_form_query list
2985: WHERE safety.period_start_date < last_date
2986: AND safety.organization_id = list.number2
2987: AND safety.compile_designator = list.char1
2988: AND safety.inventory_item_id = list.number1
2995: dates.calendar_date new_date,
2996: dates.calendar_date old_date,
2997: sched.daily_rate new_quantity,
2998: 0 old_quantity
2999: FROM mrp_form_query list,
3000: mtl_parameters param,
3001: mrp_aggregate_rates sched,
3002: bom_calendar_dates dates
3003: WHERE dates.exception_set_id = param.calendar_exception_set_id
3023: to_date(1, 'J'),
3024: to_date(1, 'J'),
3025: 0,
3026: 0
3027: FROM mrp_form_query list
3028: WHERE list.query_id = item_list_id
3029:
3030: ORDER BY
3031: 1, 2, 5, 3;