DBA Data[Home] [Help]

APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_ANALYSIS_AGGREGATE

Line 960: FROM msc_analysis_aggregate lvl,

956: sum(lvl.TARGET_SERVICE_LEVEL) new_quantity,
957: 0 old_quantity,
958: 0 dos,
959: 0
960: FROM msc_analysis_aggregate lvl,
961: -- msc_form_query list
962: gmp_pdr_items_gtmp gpi
963: WHERE lvl.period_start_date <= last_date
964: AND lvl.period_start_date >= l_bckt_start_date -1

Line 1004: FROM msc_analysis_aggregate lvl,

1000: sum(lvl.ACHIEVED_SERVICE_LEVEL) new_quantity,
1001: 0 old_quantity,
1002: 0 dos,
1003: 0
1004: FROM msc_analysis_aggregate lvl,
1005: -- msc_form_query list
1006: gmp_pdr_items_gtmp gpi
1007: WHERE lvl.period_start_date <= last_date
1008: AND lvl.period_start_date >= l_bckt_start_date -1