[Home] [Help]
460: nvl(fs.quantity_completed, 0)) *
461: (bic.component_quantity/bic.component_yield_factor)
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,
543: nvl(fs.quantity_completed, 0)) *
544: (bic.component_quantity/bic.component_yield_factor)
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,
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,
685: mrp_system_items items,
686: mrp_sub_inventories msi
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,
745: mrp_system_items items,
746: mrp_sub_inventories msi
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,
870: mrp_plans plans,
871: mrp_system_items items
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,
954: mrp_load_parameters load,
955: mrp_system_items items
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,
1663: mrp_system_items items,
1664: mrp_plan_organizations_v mpov /*1402080*/
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
1727: OR (arg_res_level = 2
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
1776: OR (arg_res_level = 2
1777: AND mipv.borrow_project_id is NULL)
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
1819: WHERE (arg_res_level = 1
1820: OR (arg_res_level = 2
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
1870: OR (arg_res_level = 2
1871: AND mipv.borrow_project_id is NULL)
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
1912: WHERE (arg_res_level = 1
1913: OR (arg_res_level = 2
2231: to_date(1, 'J') old_date,
2232: NVL(SUM(moq.primary_transaction_quantity),0) new_quantity,
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,
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
2692: OR (arg_res_level = 2
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
2823: OR (arg_res_level = 2
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
3004: AND dates.calendar_code = param.calendar_code
3107: param.organization_code
3108: INTO item_name,
3109: org_code
3110: FROM mtl_item_flexfields items,
3111: mtl_parameters param
3112: WHERE param.organization_id = items.organization_id
3113: AND items.inventory_item_id = inv_item_id
3114: AND items.organization_id = org_id;
3115: