[Home] [Help]
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
248: OR (arg_res_level = 2
249: AND jobs.project_id is NULL)
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
298: OR (arg_res_level = 2
299: AND jobs.project_id is NULL)
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,
350: mrp_sub_inventories msi
351: WHERE (arg_res_level = 1
352: OR (arg_res_level = 2
353: AND jobs.project_id is NULL)
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
414: OR (arg_res_level = 2
415: AND flow_sched.project_id is NULL)
462: * bic.planning_factor/100))) old_quantity
463: FROM bom_calendar_dates dates,
464: mtl_parameters mp,
465: wip_flow_schedules fs,
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,
465: wip_flow_schedules fs,
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
545: * bic.planning_factor/100)) old_quantity
546: FROM bom_calendar_dates dates,
547: mtl_parameters mp,
548: wip_flow_schedules fs,
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,
548: wip_flow_schedules fs,
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
625: SUM(GREATEST( 0, ((flow_sched.planned_quantity -
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
681: bom_calendar_dates dates,
682: mtl_parameters param,
683: wip_repetitive_schedules sched,
684: wip_repetitive_items rep_items,
685: mrp_system_items items,
686: mrp_sub_inventories msi
687: WHERE rep_items.primary_item_id = items.inventory_item_id
688: and rep_items.organization_id = items.organization_id
689: and rep_items.wip_entity_id = sched.wip_entity_id
741: bom_calendar_dates dates,
742: mtl_parameters param,
743: wip_repetitive_schedules sched,
744: wip_repetitive_items rep_items,
745: mrp_system_items items,
746: mrp_sub_inventories msi
747: WHERE rep_items.primary_item_id = items.inventory_item_id
748: and rep_items.organization_id = items.organization_id
749: and rep_items.wip_entity_id = sched.wip_entity_id
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,
805: mrp_sub_inventories msi
806: WHERE ops.organization_id = items.organization_id
807: and ops.inventory_item_id = items.inventory_item_id
867: mtl_parameters param,
868: mrp_schedule_dates sched,
869: mrp_plan_schedules_v plan_sched,
870: mrp_plans plans,
871: mrp_system_items items
872: WHERE (arg_res_level = 1
873: OR (arg_res_level = 2
874: AND sched.project_id is NULL)
875: OR (DECODE(arg_res_level,
951: mtl_parameters param,
952: mrp_forecast_dates fcst,
953: mrp_forecast_designators desig,
954: mrp_load_parameters load,
955: mrp_system_items items
956: WHERE (arg_res_level = 1
957: OR (arg_res_level = 2
958: AND fcst.project_id is NULL)
959: OR (DECODE(arg_res_level,
1035: SUM(ms.to_org_primary_quantity) new_quantity,
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
1092: SUM(nvl(ms.to_org_primary_quantity, 0) * pd.req_line_quantity/pl.quantity)
1093: old_quantity
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
1143: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1144: SUM(ms.to_org_primary_quantity)new_quantity,
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
1198: SUM(nvl(ms.to_org_primary_quantity,0) * pd.req_line_quantity/
1199: prl.quantity) new_quantity,
1200: SUM(nvl(ms.to_org_primary_quantity,0) * pd.req_line_quantity/
1201: prl.quantity) old_quantity
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,
1263: SUM(nvl(ms.TO_ORG_PRIMARY_QUANTITY, 0) * pd.req_line_quantity /
1264: pl.quantity) old_quantity
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
1316: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1317: SUM(ms.to_org_primary_quantity)new_quantity,
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
1370: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1371: SUM(ms.to_org_primary_quantity) new_quantity,
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
1427: SUM(ms.to_org_primary_quantity * DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1428: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
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
1484: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1485: 0 old_quantity
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
1536: SUM(nvl(ms.to_org_primary_quantity,0) * DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1537: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
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
1590: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1591: SUM(nvl(ms.to_org_primary_quantity,0) *DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1592: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
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
1659: bom_calendar_dates dates,
1660: mtl_parameters param,
1661: mrp_recommendations recom,
1662: mrp_gross_requirements reqs,
1663: mrp_system_items items,
1664: mrp_plan_organizations_v mpov /*1402080*/
1665: WHERE (arg_res_level = 1
1666: OR (arg_res_level = 2
1667: AND reqs.project_id is NULL)
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
2048: AND rec.project_id is NULL)
2049: OR (DECODE(arg_res_level,
2086: demand.reservation_quantity) ) new_quantity,
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)
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) >=
2144: (SELECT NVL(TRUNC(max(effectivity_date)), TRUNC(SYSDATE))
2145: FROM mtl_safety_stocks
2170: mtl_item_locations mil,
2171: mtl_lot_numbers lots,
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
2233: 0 old_quantity
2234: FROM MTL_Onhand_Quantities_detail moq,
2235: mtl_parameters param,
2236: mtl_material_statuses mms,
2237: mrp_system_items masis,
2238: MTL_LOT_NUMBERS mln,
2239: MTL_ITEM_LOCATIONS mil,
2240: PJM_PROJECT_PARAMETERS mpp,
2241: mrp_sub_inventories sub,
2306: masis.compile_designator,
2307: msn.Current_Locator_ID Locator_ID,
2308: msn.Lot_Number
2309: FROM MTL_SERIAL_NUMBERS msn,
2310: mrp_system_items masis
2311: WHERE msn.Current_Status IN ( 3,5)
2312: AND masis.Organization_ID= msn.Current_Organization_ID
2313: AND masis.Inventory_Item_ID= msn.Inventory_Item_ID
2314: AND masis.Effectivity_Control= 2 ) x,
2365: to_date(1, 'J') old_date,
2366: NVL(SUM(mmtt.Primary_Quantity) , 0) new_quantity,
2367: 0 old_quantity
2368: FROM PJM_PROJECT_PARAMETERS mpp,
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
2434: to_date(1, 'J') old_date,
2435: NVL(SUM(mmtt.Primary_Quantity ) , 0) new_quantity,
2436: 0 old_quantity
2437: FROM PJM_PROJECT_PARAMETERS mpp,
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
2502: 0 old_quantity
2503: FROM PJM_PROJECT_PARAMETERS mpp,
2504: MTL_Serial_Numbers_Temp msnt,
2505: MTL_SERIAL_NUMBERS msn,
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
2576: MTL_TXN_REQUEST_HEADERS MTRH,
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)
2959: to_date(1, 'J') old_date,
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)
3118: -- -------------------------
3119:
3120: SELECT calculate_atp
3121: INTO atp_flag
3122: FROM mrp_system_items
3123: WHERE compile_designator = arg_compile_designator
3124: AND inventory_item_id = inv_item_id
3125: AND organization_id = org_id;
3126: