[Home] [Help]
282: --Planned Warranty order, ?pabram....????????
283: c_row_total_supply constant integer:= 25;
284: --Total Supply, sum of pivot-row-types 11 thru 24
285: c_row_ss_supply constant integer:= 26;
286: --Safety Stock (Days of Supply), msc_safety_stocks.achieved_days_of_supply
287: --c_row_total_uncons_dmd constant integer:= 27;
288: --Total unconstrained demand --out of design
289: c_row_ss_level constant integer:= 28;
290: --Safety Stock Level, msc_safety_stocks.achieved_service_level
286: --Safety Stock (Days of Supply), msc_safety_stocks.achieved_days_of_supply
287: --c_row_total_uncons_dmd constant integer:= 27;
288: --Total unconstrained demand --out of design
289: c_row_ss_level constant integer:= 28;
290: --Safety Stock Level, msc_safety_stocks.achieved_service_level
291: c_row_target_level constant integer:= 29;
292: --Target Level, msc_safety_stocks.target_service_level
293: c_row_max_level constant integer:= 30;
294: --Maximum Level, msc_inventory_levels.max_quantity
288: --Total unconstrained demand --out of design
289: c_row_ss_level constant integer:= 28;
290: --Safety Stock Level, msc_safety_stocks.achieved_service_level
291: c_row_target_level constant integer:= 29;
292: --Target Level, msc_safety_stocks.target_service_level
293: c_row_max_level constant integer:= 30;
294: --Maximum Level, msc_inventory_levels.max_quantity
295: c_row_pab constant integer:= 31;
296: --Projected Available Balance,
1685: mss.period_start_date old_date,
1686: sum(mss.achieved_days_of_supply) new_quantity,
1687: sum(mss.safety_stock_quantity) old_quantity
1688: from
1689: msc_safety_stocks mss,
1690: msc_analysis_query maq,
1691: msc_form_query mfq1, -- org-list
1692: msc_form_query mfq2 -- item-list
1693: where maq.query_id = p_query_id