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_SNAPSHOT_PK dependencies on MSC_TRADING_PARTNERS

Line 291: msc_trading_partners mtp,

287: mpl.sr_instance_id,
288: TRUNC(sysdate),
289: mpl.cutoff_date
290: FROM
291: msc_trading_partners mtp,
292: msc_plans mpl
293: WHERE
294: mpl.plan_id = p_plan_id
295: and mpl.organization_id = mtp.sr_tp_id

Line 358: msc_trading_partners tp,

354: IF (lv_bkt_ref_calendar is null) then
355: select min(cal.week_start_date)
356: into l_curr_start_date
357: from msc_cal_week_start_dates cal,
358: msc_trading_partners tp,
359: msc_calendar_dates mc
360: where cal.exception_set_id = tp.calendar_exception_set_id
361: and mc.exception_set_id = tp.calendar_exception_set_id
362: and cal.calendar_code = tp.calendar_code

Line 388: msc_trading_partners tp

384: IF (lv_bkt_ref_calendar is null) then
385: select min(cal.period_start_date)
386: into l_curr_start_date
387: from msc_period_start_dates cal,
388: msc_trading_partners tp
389: where cal.exception_set_id = tp.calendar_exception_set_id
390: and cal.calendar_code = tp.calendar_code
391: and cal.period_start_date >= trunc(sysdate)
392: and cal.sr_instance_id = tp.sr_instance_id

Line 485: msc_trading_partners tp,

481: tp.calendar_exception_set_id ,
482: decode(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), NULL, tp.sr_instance_id, mcd.sr_instance_id)
483: into m_calendar_code , m_cal_exception_set_id , m_sr_instance_id
484: from msc_plans mp,
485: msc_trading_partners tp,
486: msc_calendar_dates mcd
487: where mp.plan_id = p_plan_id
488: and tp.partner_type = 3
489: and tp.sr_instance_id = mp.sr_instance_id

Line 1806: msc_trading_partners tp

1802:
1803: select min(cal.week_start_date)
1804: into p_weekly_start_date
1805: from msc_cal_week_start_dates cal,
1806: msc_trading_partners tp
1807: where cal.exception_set_id = tp.calendar_exception_set_id
1808: and cal.calendar_code = tp.calendar_code
1809: and cal.week_start_date >= trunc(v_daily_cutoff_date)
1810: and cal.sr_instance_id = tp.sr_instance_id

Line 1821: msc_trading_partners tp

1817:
1818: select min(cal.period_start_date)
1819: into p_period_start_date
1820: from msc_period_start_dates cal,
1821: msc_trading_partners tp
1822: where cal.exception_set_id = tp.calendar_exception_set_id
1823: and cal.calendar_code = tp.calendar_code
1824: and cal.period_start_date >= nvl(trunc(v_weekly_cutoff_date),
1825: trunc(v_daily_cutoff_date))