eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on STANDARD

Line 1952: sum(nvl(mss.safety_stock_quantity*msi.standard_cost, 0)) AS achieved_ss_dollars,

1948: NULL AS week_next_date,
1949: NULL AS period_start_date,
1950: 'N' AS last_week_of_period,
1951: sum(nvl(mss.safety_stock_quantity, 0)) AS achieved_ss_qty,
1952: sum(nvl(mss.safety_stock_quantity*msi.standard_cost, 0)) AS achieved_ss_dollars,
1953: sum(nvl(mss.achieved_days_of_supply, 0)) AS achieved_ss_days,
1954: sum(nvl(mss.target_safety_stock, 0)) AS target_ss_qty,
1955: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,
1956: sum(nvl(mss.target_days_of_supply, 0)) AS target_ss_days,

Line 1955: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,

1951: sum(nvl(mss.safety_stock_quantity, 0)) AS achieved_ss_qty,
1952: sum(nvl(mss.safety_stock_quantity*msi.standard_cost, 0)) AS achieved_ss_dollars,
1953: sum(nvl(mss.achieved_days_of_supply, 0)) AS achieved_ss_days,
1954: sum(nvl(mss.target_safety_stock, 0)) AS target_ss_qty,
1955: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,
1956: sum(nvl(mss.target_days_of_supply, 0)) AS target_ss_days,
1957: sum(nvl(mss.user_defined_safety_stocks, 0)) AS userdef_ss_qty,
1958: sum(nvl(mss.user_defined_safety_stocks * msi.standard_cost, 0)) AS userdef_ss_dollars,
1959: sum(nvl(mss.user_defined_dos, 0)) AS userdef_ss_days,

Line 1958: sum(nvl(mss.user_defined_safety_stocks * msi.standard_cost, 0)) AS userdef_ss_dollars,

1954: sum(nvl(mss.target_safety_stock, 0)) AS target_ss_qty,
1955: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,
1956: sum(nvl(mss.target_days_of_supply, 0)) AS target_ss_days,
1957: sum(nvl(mss.user_defined_safety_stocks, 0)) AS userdef_ss_qty,
1958: sum(nvl(mss.user_defined_safety_stocks * msi.standard_cost, 0)) AS userdef_ss_dollars,
1959: sum(nvl(mss.user_defined_dos, 0)) AS userdef_ss_days,
1960: 0 AS nr_ss_records,
1961: NULL AS inv_value_dollars,
1962: NULL AS period_type,

Line 2023: sum(nvl(mss.safety_stock_quantity*msi.standard_cost, 0)) AS achieved_ss_dollars,

2019: NULL AS week_next_date,
2020: NULL AS period_start_date,
2021: 'N' AS last_week_of_period,
2022: sum(nvl(mss.safety_stock_quantity, 0)) AS achieved_ss_qty,
2023: sum(nvl(mss.safety_stock_quantity*msi.standard_cost, 0)) AS achieved_ss_dollars,
2024: sum(nvl(mss.achieved_days_of_supply, 0)) AS achieved_ss_days,
2025: sum(nvl(mss.target_safety_stock, 0)) AS target_ss_qty,
2026: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,
2027: sum(nvl(mss.target_days_of_supply, 0)) AS target_ss_days,

Line 2026: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,

2022: sum(nvl(mss.safety_stock_quantity, 0)) AS achieved_ss_qty,
2023: sum(nvl(mss.safety_stock_quantity*msi.standard_cost, 0)) AS achieved_ss_dollars,
2024: sum(nvl(mss.achieved_days_of_supply, 0)) AS achieved_ss_days,
2025: sum(nvl(mss.target_safety_stock, 0)) AS target_ss_qty,
2026: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,
2027: sum(nvl(mss.target_days_of_supply, 0)) AS target_ss_days,
2028: sum(nvl(mss.user_defined_safety_stocks, 0)) AS userdef_ss_qty,
2029: sum(nvl(mss.user_defined_safety_stocks * msi.standard_cost, 0)) AS userdef_ss_dollars,
2030: sum(nvl(mss.user_defined_dos, 0)) AS userdef_ss_days,

Line 2029: sum(nvl(mss.user_defined_safety_stocks * msi.standard_cost, 0)) AS userdef_ss_dollars,

2025: sum(nvl(mss.target_safety_stock, 0)) AS target_ss_qty,
2026: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,
2027: sum(nvl(mss.target_days_of_supply, 0)) AS target_ss_days,
2028: sum(nvl(mss.user_defined_safety_stocks, 0)) AS userdef_ss_qty,
2029: sum(nvl(mss.user_defined_safety_stocks * msi.standard_cost, 0)) AS userdef_ss_dollars,
2030: sum(nvl(mss.user_defined_dos, 0)) AS userdef_ss_days,
2031: 0 AS total_unpooled_safety_stock,
2032: 0 AS demand_var_ss_percent,
2033: 0 AS mfg_ltvar_ss_percent,

Line 2187: mss.safety_stock_quantity*msi.standard_cost

2183: NULL AS week_next_date,
2184: NULL AS period_start_date,
2185: 'N' AS last_week_of_period,
2186: mss.safety_stock_quantity AS achieved_ss_qty,
2187: mss.safety_stock_quantity*msi.standard_cost
2188: AS achieved_ss_dollars,
2189: mss.achieved_days_of_supply AS achieved_ss_days,
2190: mss.target_safety_stock AS target_ss_qty,
2191: mss.target_safety_stock * msi.standard_cost

Line 2191: mss.target_safety_stock * msi.standard_cost

2187: mss.safety_stock_quantity*msi.standard_cost
2188: AS achieved_ss_dollars,
2189: mss.achieved_days_of_supply AS achieved_ss_days,
2190: mss.target_safety_stock AS target_ss_qty,
2191: mss.target_safety_stock * msi.standard_cost
2192: AS target_ss_dollars,
2193: mss.target_days_of_supply AS target_ss_days,
2194: mss.user_defined_safety_stocks AS userdef_ss_qty,
2195: mss.user_defined_safety_stocks * msi.standard_cost

Line 2195: mss.user_defined_safety_stocks * msi.standard_cost

2191: mss.target_safety_stock * msi.standard_cost
2192: AS target_ss_dollars,
2193: mss.target_days_of_supply AS target_ss_days,
2194: mss.user_defined_safety_stocks AS userdef_ss_qty,
2195: mss.user_defined_safety_stocks * msi.standard_cost
2196: AS userdef_ss_dollars,
2197: mss.user_defined_dos AS userdef_ss_days,
2198: 0 AS nr_ss_records,
2199: NULL AS inv_value_dollars,