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_TRADING_PARTNERS

Line 97: FROM msc_trading_partners tp,

93:
94: CURSOR day_bucket IS
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

Line 115: FROM msc_trading_partners tp,

111: order by mpsd.calendar_date;
112:
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

Line 133: FROM msc_trading_partners tp,

129: order by mpsd.week_start_date;
130:
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