APPS.MSC_SDA_PKG dependencies on MSC_INVENTORY_LEVELS

Line 299: --Maximum Level, msc_inventory_levels.max_quantity

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,
302: --pivot-row-types c_row_pab(i-1) + c_row_total_supply(i) - c_row_total_dmd(i)
303: c_row_poh constant integer:= 32;

Line 1866: msc_inventory_levels mil,

1862: mil.inventory_date old_date,
1863: max(mil.max_quantity) new_quantity,
1864: 0 old_quantity
1865: from
1866: msc_inventory_levels mil,
1867: msc_analysis_query maq,
1868: msc_form_query mfq1, -- org-list
1869: msc_form_query mfq2 -- item-list
1870: where maq.query_id = p_query_id