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.MRP_CRP_HORIZONTAL_PLAN dependencies on CRP_CAL_SHIFT_DELTA

Line 537: and not exists ( select 1 from CRP_CAL_SHIFT_DELTA delta1

533: AND cal.calendar_code = param.calendar_code
534: AND cal.exception_set_id = param.calendar_exception_set_id
535: AND trunc(cal.calendar_date) >= trunc(sysdate)
536: AND ((cal.seq_num is not null
537: and not exists ( select 1 from CRP_CAL_SHIFT_DELTA delta1
538: where delta1.calendar_code =
539: shifts.calendar_code
540: and delta1.exception_set_id =
541: param.calendar_exception_set_id

Line 547: and exists ( select 1 from CRP_CAL_SHIFT_DELTA delta1

543: and delta1.calendar_date = cal.calendar_date
544: and delta1.shift_num = shifts.shift_num))
545: OR
546: (cal.seq_num is null
547: and exists ( select 1 from CRP_CAL_SHIFT_DELTA delta1
548: where delta1.calendar_code =
549: shifts.calendar_code
550: and delta1.exception_set_id =
551: param.calendar_exception_set_id

Line 593: from CRP_CAL_SHIFT_DELTA delta1

589: AND (brc.action_type = ADD_WORK_DAY
590: OR dates.seq_num is not NULL
591: OR (dates.seq_num IS NULL
592: and exists ( select 1
593: from CRP_CAL_SHIFT_DELTA delta1
594: where delta1.calendar_code =
595: dates.calendar_code
596: and delta1.exception_set_id =
597: dates.exception_set_id