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.

APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_SAFETY_STOCKS

Line 733: FROM msc_safety_stocks safety,

729: sum(safety.safety_stock_quantity) new_quantity,
730: safety.organization_id old_quantity,
731: sum(safety.achieved_days_of_supply) dos,
732: sum(safety.safety_stock_quantity * item.standard_cost) cost
733: FROM msc_safety_stocks safety,
734: msc_form_query list ,
735: msc_system_items item
736: WHERE safety.period_start_date <= last_date
737: AND safety.organization_id = list.number2

Line 771: FROM msc_safety_stocks safety,

767: sum(safety.TARGET_SAFETY_STOCK) new_quantity,
768: sum(safety.TOTAL_UNPOOLED_SAFETY_STOCK) old_quantity,
769: sum(safety.target_days_of_supply) dos,
770: sum(safety.TARGET_SAFETY_STOCK * item.standard_cost) cost
771: FROM msc_safety_stocks safety,
772: msc_form_query list ,
773: msc_system_items item
774: WHERE safety.period_start_date <= last_date
775: AND safety.organization_id = list.number2

Line 808: FROM msc_safety_stocks safety,

804: sum(safety.USER_DEFINED_SAFETY_STOCKS) new_quantity,
805: sum(0) old_quantity,
806: sum(safety.user_defined_dos) dos,
807: sum(safety.USER_DEFINED_SAFETY_STOCKS * item.standard_cost) cost
808: FROM msc_safety_stocks safety,
809: msc_form_query list,
810: msc_system_items item
811: WHERE safety.period_start_date <= last_date
812: AND safety.organization_id = list.number2

Line 845: FROM msc_safety_stocks safety,

841: sum(safety.MFG_LTVAR_SS_PERCENT) new_quantity,
842: sum(safety.SUP_LTVAR_SS_PERCENT) old_quantity,
843: sum(safety.TRANSIT_LTVAR_SS_PERCENT) dos,
844: sum(safety.DEMAND_VAR_SS_PERCENT) cost
845: FROM msc_safety_stocks safety,
846: msc_form_query list,
847: msc_system_items item
848: WHERE safety.period_start_date <= last_date
849: AND safety.organization_id = list.number2

Line 3638: update msc_safety_stocks

3634: p_new_qty number ) return number is
3635: PRAGMA AUTONOMOUS_TRANSACTION;
3636: BEGIN
3637:
3638: update msc_safety_stocks
3639: set SAFETY_STOCK_QUANTITY = p_new_qty
3640: where
3641: plan_id = p_plan_id
3642: and sr_instance_id = p_sr_instance_id