APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on STANDARD

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

1622: NULL AS week_next_date,
1623: NULL AS period_start_date,
1624: 'N' AS last_week_of_period,
1625: sum(nvl(mss.safety_stock_quantity, 0)) AS achieved_ss_qty,
1626: sum(nvl(mss.safety_stock_quantity*msi.standard_cost, 0)) AS achieved_ss_dollars,
1627: sum(nvl(mss.achieved_days_of_supply, 0)) AS achieved_ss_days,
1628: sum(nvl(mss.target_safety_stock, 0)) AS target_ss_qty,
1629: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,
1630: sum(nvl(mss.target_days_of_supply, 0)) AS target_ss_days,

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

1625: sum(nvl(mss.safety_stock_quantity, 0)) AS achieved_ss_qty,
1626: sum(nvl(mss.safety_stock_quantity*msi.standard_cost, 0)) AS achieved_ss_dollars,
1627: sum(nvl(mss.achieved_days_of_supply, 0)) AS achieved_ss_days,
1628: sum(nvl(mss.target_safety_stock, 0)) AS target_ss_qty,
1629: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,
1630: sum(nvl(mss.target_days_of_supply, 0)) AS target_ss_days,
1631: sum(nvl(mss.user_defined_safety_stocks, 0)) AS userdef_ss_qty,
1632: sum(nvl(mss.user_defined_safety_stocks * msi.standard_cost, 0)) AS userdef_ss_dollars,
1633: sum(nvl(mss.user_defined_dos, 0)) AS userdef_ss_days,

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

1628: sum(nvl(mss.target_safety_stock, 0)) AS target_ss_qty,
1629: sum(nvl(mss.target_safety_stock * msi.standard_cost, 0)) AS target_ss_dollars,
1630: sum(nvl(mss.target_days_of_supply, 0)) AS target_ss_days,
1631: sum(nvl(mss.user_defined_safety_stocks, 0)) AS userdef_ss_qty,
1632: sum(nvl(mss.user_defined_safety_stocks * msi.standard_cost, 0)) AS userdef_ss_dollars,
1633: sum(nvl(mss.user_defined_dos, 0)) AS userdef_ss_days,
1634: 0 AS nr_ss_records,
1635: NULL AS inv_value_dollars,
1636: NULL AS period_type,

Line 1772: mss.safety_stock_quantity*msi.standard_cost

1768: NULL AS week_next_date,
1769: NULL AS period_start_date,
1770: 'N' AS last_week_of_period,
1771: mss.safety_stock_quantity AS achieved_ss_qty,
1772: mss.safety_stock_quantity*msi.standard_cost
1773: AS achieved_ss_dollars,
1774: mss.achieved_days_of_supply AS achieved_ss_days,
1775: mss.target_safety_stock AS target_ss_qty,
1776: mss.target_safety_stock * msi.standard_cost

Line 1776: mss.target_safety_stock * msi.standard_cost

1772: mss.safety_stock_quantity*msi.standard_cost
1773: AS achieved_ss_dollars,
1774: mss.achieved_days_of_supply AS achieved_ss_days,
1775: mss.target_safety_stock AS target_ss_qty,
1776: mss.target_safety_stock * msi.standard_cost
1777: AS target_ss_dollars,
1778: mss.target_days_of_supply AS target_ss_days,
1779: mss.user_defined_safety_stocks AS userdef_ss_qty,
1780: mss.user_defined_safety_stocks * msi.standard_cost

Line 1780: mss.user_defined_safety_stocks * msi.standard_cost

1776: mss.target_safety_stock * msi.standard_cost
1777: AS target_ss_dollars,
1778: mss.target_days_of_supply AS target_ss_days,
1779: mss.user_defined_safety_stocks AS userdef_ss_qty,
1780: mss.user_defined_safety_stocks * msi.standard_cost
1781: AS userdef_ss_dollars,
1782: mss.user_defined_dos AS userdef_ss_days,
1783: 0 AS nr_ss_records,
1784: NULL AS inv_value_dollars,