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 101: FROM msc_trading_partners tp,

97:
98: CURSOR day_bucket IS
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

Line 119: FROM msc_trading_partners tp,

115: order by mpsd.calendar_date;
116:
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

Line 137: FROM msc_trading_partners tp,

133: order by mpsd.week_start_date;
134:
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