[Home] [Help]
807: sum(safety.safety_stock_quantity) new_quantity,
808: safety.organization_id old_quantity,
809: sum(safety.achieved_days_of_supply) dos,
810: sum(safety.safety_stock_quantity * item.standard_cost) cost
811: FROM msc_safety_stocks safety,
812: msc_form_query list ,
813: msc_system_items item
814: WHERE safety.period_start_date <= last_date
815: AND safety.organization_id = list.number2
845: sum(safety.TARGET_SAFETY_STOCK) new_quantity,
846: sum(safety.TOTAL_UNPOOLED_SAFETY_STOCK) old_quantity,
847: sum(safety.target_days_of_supply) dos,
848: sum(safety.TARGET_SAFETY_STOCK * item.standard_cost) cost
849: FROM msc_safety_stocks safety,
850: msc_form_query list ,
851: msc_system_items item
852: WHERE safety.period_start_date <= last_date
853: AND safety.organization_id = list.number2
882: sum(safety.USER_DEFINED_SAFETY_STOCKS) new_quantity,
883: sum(0) old_quantity,
884: sum(safety.user_defined_dos) dos,
885: sum(safety.USER_DEFINED_SAFETY_STOCKS * item.standard_cost) cost
886: FROM msc_safety_stocks safety,
887: msc_form_query list,
888: msc_system_items item
889: WHERE safety.period_start_date <= last_date
890: AND safety.organization_id = list.number2
919: sum(safety.MFG_LTVAR_SS_PERCENT) new_quantity,
920: sum(safety.SUP_LTVAR_SS_PERCENT) old_quantity,
921: sum(safety.TRANSIT_LTVAR_SS_PERCENT) dos,
922: sum(safety.DEMAND_VAR_SS_PERCENT) cost
923: FROM msc_safety_stocks safety,
924: msc_form_query list,
925: msc_system_items item
926: WHERE safety.period_start_date <= last_date
927: AND safety.organization_id = list.number2
3895: p_new_qty number ) return number is
3896: PRAGMA AUTONOMOUS_TRANSACTION;
3897: BEGIN
3898:
3899: update msc_safety_stocks
3900: set SAFETY_STOCK_QUANTITY = p_new_qty
3901: where
3902: plan_id = p_plan_id
3903: and sr_instance_id = p_sr_instance_id