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_VERTICAL_PLAN_SC dependencies on MSC_PLANS

Line 99: msc_plans mp

95: SELECT to_char(mpsd.calendar_date,'DD-MM-RR'),
96: mpsd.calendar_date
97: FROM msc_trading_partners tp,
98: msc_calendar_dates mpsd,
99: msc_plans mp
100: WHERE mpsd.calendar_code = tp.calendar_code
101: and mpsd.sr_instance_id = tp.sr_instance_id
102: and mpsd.exception_set_id = tp.calendar_exception_set_id
103: and mpsd.seq_num is not null

Line 117: msc_plans mp

113: CURSOR week_bucket IS
114: SELECT to_char(mpsd.week_start_date,'DD-MM-RR'), mpsd.week_start_date
115: FROM msc_trading_partners tp,
116: msc_cal_week_start_dates mpsd,
117: msc_plans mp
118: WHERE mpsd.calendar_code = tp.calendar_code
119: and mpsd.sr_instance_id = tp.sr_instance_id
120: and mpsd.exception_set_id = tp.calendar_exception_set_id
121: and tp.sr_instance_id = nvl(arg_instance_id, tp.sr_instance_id)

Line 135: msc_plans mp

131: CURSOR period_bucket IS
132: SELECT mpsd.period_name, mpsd.period_start_date
133: FROM msc_trading_partners tp,
134: msc_period_start_dates mpsd,
135: msc_plans mp
136: WHERE mpsd.calendar_code = tp.calendar_code
137: and mpsd.sr_instance_id = tp.sr_instance_id
138: and mpsd.exception_set_id = tp.calendar_exception_set_id
139: and tp.sr_instance_id = nvl(arg_instance_id, tp.sr_instance_id)