APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_SAFETY_STOCKS

Line 665: FROM msc_safety_stocks safety,

661: sum(safety.safety_stock_quantity) new_quantity,
662: safety.organization_id old_quantity,
663: sum(safety.achieved_days_of_supply) dos,
664: sum(safety.safety_stock_quantity * gpi.standard_cost) cost
665: FROM msc_safety_stocks safety,
666: -- msc_form_query list ,
667: -- msc_system_items item
668: gmp_pdr_items_gtmp gpi
669: WHERE safety.period_start_date <= last_date

Line 715: FROM msc_safety_stocks safety,

711: sum(safety.TARGET_SAFETY_STOCK) new_quantity,
712: sum(safety.TOTAL_UNPOOLED_SAFETY_STOCK) old_quantity,
713: sum(safety.target_days_of_supply) dos,
714: sum(safety.TARGET_SAFETY_STOCK * gpi.standard_cost) cost
715: FROM msc_safety_stocks safety,
716: -- msc_form_query list ,
717: -- msc_system_items item
718: gmp_pdr_items_gtmp gpi
719: WHERE safety.period_start_date <= last_date

Line 764: FROM msc_safety_stocks safety,

760: sum(safety.USER_DEFINED_SAFETY_STOCKS) new_quantity,
761: sum(0) old_quantity,
762: sum(safety.user_defined_dos) dos,
763: sum(safety.USER_DEFINED_SAFETY_STOCKS * gpi.standard_cost) cost
764: FROM msc_safety_stocks safety,
765: -- msc_form_query list,
766: -- msc_system_items item
767: gmp_pdr_items_gtmp gpi
768: WHERE safety.period_start_date <= last_date

Line 815: FROM msc_safety_stocks safety,

811: sum(safety.MFG_LTVAR_SS_PERCENT) new_quantity,
812: sum(safety.SUP_LTVAR_SS_PERCENT) old_quantity,
813: sum(safety.TRANSIT_LTVAR_SS_PERCENT) dos,
814: sum(safety.DEMAND_VAR_SS_PERCENT) cost
815: FROM msc_safety_stocks safety,
816: -- msc_form_query list,
817: -- msc_system_items item
818: gmp_pdr_items_gtmp gpi
819: WHERE safety.period_start_date <= last_date