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 103: msc_plans mp

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

Line 121: msc_plans mp

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

Line 139: msc_plans mp

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