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 321: from msc_analysis_aggregate

317: ORDER BY cal.calendar_date;
318:
319: cursor c_first_date(p_st_date DATE) is
320: select period_start_date
321: from msc_analysis_aggregate
322: where plan_id = arg_plan_id
323: and record_type = 3
324: and period_type = 1
325: and period_start_date <= p_st_date

Line 1015: FROM msc_analysis_aggregate lvl,

1011: avg(lvl.TARGET_SERVICE_LEVEL) new_quantity,
1012: 0 old_quantity,
1013: 0 dos,
1014: 0
1015: FROM msc_analysis_aggregate lvl,
1016: msc_form_query list,
1017: msc_plan_buckets mpb
1018: WHERE lvl.record_type = 3
1019: AND lvl.period_type = 1

Line 1049: FROM msc_analysis_aggregate lvl,

1045: sum(lvl.ACHIEVED_SERVICE_LEVEL_QTY1)/sum(decode(lvl.ACHIEVED_SERVICE_LEVEL_QTY2, 0, 1, lvl.ACHIEVED_SERVICE_LEVEL_QTY2)) new_quantity,
1046: 0 old_quantity,
1047: 0 dos,
1048: 0
1049: FROM msc_analysis_aggregate lvl,
1050: msc_form_query list,
1051: msc_plan_buckets mpb
1052: WHERE lvl.record_type = 3
1053: AND lvl.period_type = 1