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_CAL_WEEK_START_DATES

Line 357: from msc_cal_week_start_dates cal,

353: IF l_weekly_buckets > 0 THEN
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

Line 374: from msc_cal_week_start_dates cal,

370: and tp.partner_type = 3 ;
371: ELSE
372: select min(cal.week_start_date)
373: into l_curr_start_date
374: from msc_cal_week_start_dates cal,
375: msc_calendar_dates mc
376: where cal.exception_set_id = mc.exception_set_id
377: and cal.calendar_code = mc.calendar_code
378: and cal.sr_instance_id = mc.sr_instance_id

Line 565: MSC_CAL_WEEK_START_DATES cal

561: l_msc_plan_buckets.bkt_end_date,
562: l_msc_plan_buckets.bucket_type,
563: l_msc_plan_buckets.days_in_bkt
564: FROM
565: MSC_CAL_WEEK_START_DATES cal
566: WHERE cal.sr_instance_id = m_sr_instance_id
567: AND cal.calendar_code = m_calendar_code
568: AND cal.exception_set_id = m_cal_exception_set_id
569: and trunc(cal.week_start_date) <= trunc(l_weekly_cutoff_date)

Line 1805: from msc_cal_week_start_dates cal,

1801: p_daily_start_date := p_plan_start_date;
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)