[Home] [Help]
287: --Planned Warranty order, ?pabram....????????
288: c_row_total_supply constant integer:= 25;
289: --Total Supply, sum of pivot-row-types 11 thru 24
290: c_row_ss_supply constant integer:= 26;
291: --Safety Stock (Days of Supply), msc_safety_stocks.achieved_days_of_supply
292: --c_row_total_uncons_dmd constant integer:= 27;
293: --Total unconstrained demand --out of design
294: c_row_ss_level constant integer:= 28;
295: --Safety Stock Level, msc_safety_stocks.achieved_service_level
291: --Safety Stock (Days of Supply), msc_safety_stocks.achieved_days_of_supply
292: --c_row_total_uncons_dmd constant integer:= 27;
293: --Total unconstrained demand --out of design
294: c_row_ss_level constant integer:= 28;
295: --Safety Stock Level, msc_safety_stocks.achieved_service_level
296: c_row_target_level constant integer:= 29;
297: --Target Level, msc_safety_stocks.target_service_level
298: c_row_max_level constant integer:= 30;
299: --Maximum Level, msc_inventory_levels.max_quantity
293: --Total unconstrained demand --out of design
294: c_row_ss_level constant integer:= 28;
295: --Safety Stock Level, msc_safety_stocks.achieved_service_level
296: c_row_target_level constant integer:= 29;
297: --Target Level, msc_safety_stocks.target_service_level
298: c_row_max_level constant integer:= 30;
299: --Maximum Level, msc_inventory_levels.max_quantity
300: c_row_pab constant integer:= 31;
301: --Projected Available Balance,
1577: mss.inventory_item_id,
1578: mss.period_start_date,
1579: sum(mss.achieved_days_of_supply) achieved_days_of_supply,
1580: sum(mss.safety_stock_quantity) safety_stock_quantity
1581: from msc_safety_stocks mss,
1582: msc_form_query mfq1, -- org-list
1583: msc_form_query mfq2 -- item-list
1584: where mss.plan_id= g_plan_id
1585: and mfq1.query_id = g_org_query_id