APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_SAFETY_STOCKS

Line 678: FROM msc_safety_stocks safety,

674: sum(safety.safety_stock_quantity) new_quantity,
675: safety.organization_id old_quantity,
676: sum(safety.achieved_days_of_supply) dos,
677: sum(safety.safety_stock_quantity * gpi.standard_cost) cost
678: FROM msc_safety_stocks safety,
679: -- msc_form_query list ,
680: -- msc_system_items item
681: gmp_pdr_items_gtmp gpi
682: WHERE safety.period_start_date <= last_date

Line 728: FROM msc_safety_stocks safety,

724: sum(safety.TARGET_SAFETY_STOCK) new_quantity,
725: sum(safety.TOTAL_UNPOOLED_SAFETY_STOCK) old_quantity,
726: sum(safety.target_days_of_supply) dos,
727: sum(safety.TARGET_SAFETY_STOCK * gpi.standard_cost) cost
728: FROM msc_safety_stocks safety,
729: -- msc_form_query list ,
730: -- msc_system_items item
731: gmp_pdr_items_gtmp gpi
732: WHERE safety.period_start_date <= last_date

Line 777: FROM msc_safety_stocks safety,

773: sum(safety.USER_DEFINED_SAFETY_STOCKS) new_quantity,
774: sum(0) old_quantity,
775: sum(safety.user_defined_dos) dos,
776: sum(safety.USER_DEFINED_SAFETY_STOCKS * gpi.standard_cost) cost
777: FROM msc_safety_stocks safety,
778: -- msc_form_query list,
779: -- msc_system_items item
780: gmp_pdr_items_gtmp gpi
781: WHERE safety.period_start_date <= last_date

Line 828: FROM msc_safety_stocks safety,

824: sum(safety.MFG_LTVAR_SS_PERCENT) new_quantity,
825: sum(safety.SUP_LTVAR_SS_PERCENT) old_quantity,
826: sum(safety.TRANSIT_LTVAR_SS_PERCENT) dos,
827: sum(safety.DEMAND_VAR_SS_PERCENT) cost
828: FROM msc_safety_stocks safety,
829: -- msc_form_query list,
830: -- msc_system_items item
831: gmp_pdr_items_gtmp gpi
832: WHERE safety.period_start_date <= last_date