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 567: MSC_CAL_WEEK_START_DATES cal

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

Line 1831: from msc_cal_week_start_dates cal,

1827: p_daily_start_date := p_plan_start_date;
1828:
1829: select min(cal.week_start_date)
1830: into p_weekly_start_date
1831: from msc_cal_week_start_dates cal,
1832: msc_trading_partners tp
1833: where cal.exception_set_id = tp.calendar_exception_set_id
1834: and cal.calendar_code = tp.calendar_code
1835: and cal.week_start_date >= trunc(v_daily_cutoff_date)