DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK dependencies on STANDARD

Line 731: mss.safety_stock_quantity*msi.standard_cost

727: NULL AS week_nr, NULL AS period_start_date, NULL AS period_nr,
728: NULL AS bucket_type,
729: 'N' AS last_week_of_period,
730: mss.safety_stock_quantity AS achieved_ss_qty,
731: mss.safety_stock_quantity*msi.standard_cost
732: AS achieved_ss_dollars,
733: mss.achieved_days_of_supply AS achieved_ss_days,
734: mss.target_safety_stock AS target_ss_qty,
735: mss.target_safety_stock * msi.standard_cost

Line 735: mss.target_safety_stock * msi.standard_cost

731: mss.safety_stock_quantity*msi.standard_cost
732: AS achieved_ss_dollars,
733: mss.achieved_days_of_supply AS achieved_ss_days,
734: mss.target_safety_stock AS target_ss_qty,
735: mss.target_safety_stock * msi.standard_cost
736: AS target_ss_dollars,
737: mss.target_days_of_supply AS target_ss_days,
738: mss.user_defined_safety_stocks AS userdef_ss_qty,
739: mss.user_defined_safety_stocks * msi.standard_cost

Line 739: mss.user_defined_safety_stocks * msi.standard_cost

735: mss.target_safety_stock * msi.standard_cost
736: AS target_ss_dollars,
737: mss.target_days_of_supply AS target_ss_days,
738: mss.user_defined_safety_stocks AS userdef_ss_qty,
739: mss.user_defined_safety_stocks * msi.standard_cost
740: AS userdef_ss_dollars,
741: mss.user_defined_dos AS userdef_ss_days,
742: 0 AS num_safety_stock,
743: NULL AS delivered_quantity,