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_ANALYSIS_AGGREGATE

Line 292: from msc_analysis_aggregate

288: ORDER BY cal.calendar_date;
289:
290: cursor c_first_date(p_st_date DATE) is
291: select period_start_date
292: from msc_analysis_aggregate
293: where plan_id = arg_plan_id
294: and record_type = 3
295: and period_type = 1
296: and period_start_date <= p_st_date

Line 937: FROM msc_analysis_aggregate lvl,

933: avg(lvl.TARGET_SERVICE_LEVEL) new_quantity,
934: 0 old_quantity,
935: 0 dos,
936: 0
937: FROM msc_analysis_aggregate lvl,
938: msc_form_query list,
939: msc_plan_buckets mpb
940: WHERE lvl.record_type = 3
941: AND lvl.period_type = 1

Line 971: FROM msc_analysis_aggregate lvl,

967: sum(lvl.ACHIEVED_SERVICE_LEVEL_QTY1)/sum(decode(lvl.ACHIEVED_SERVICE_LEVEL_QTY2, 0, 1, lvl.ACHIEVED_SERVICE_LEVEL_QTY2)) new_quantity,
968: 0 old_quantity,
969: 0 dos,
970: 0
971: FROM msc_analysis_aggregate lvl,
972: msc_form_query list,
973: msc_plan_buckets mpb
974: WHERE lvl.record_type = 3
975: AND lvl.period_type = 1