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.WSH_CALENDAR_ACTIONS dependencies on BOM_SHIFT_TIMES

Line 44: FROM BOM_CALENDAR_SHIFTS BCA, BOM_SHIFT_TIMES BSH,

40: -- that calendar.
41:
42: CURSOR get_shift_end_time_today(p_location_id in number, p_date in date) IS
43: SELECT BSH.from_time, BSH.to_time
44: FROM BOM_CALENDAR_SHIFTS BCA, BOM_SHIFT_TIMES BSH,
45: BOM_SHIFT_DATES BDT, WSH_CALENDAR_ASSIGNMENTS WCA
46: WHERE WCA.LOCATION_ID = p_location_id and
47: BCA.CALENDAR_CODE=WCA.CALENDAR_CODE and
48: BSH.CALENDAR_CODE=WCA.CALENDAR_CODE and

Line 65: FROM BOM_CALENDAR_SHIFTS BCA, BOM_SHIFT_TIMES BSH,

61: -- that calendar. This will be used when a shift may begin today, but
62: -- end tomorrow.
63: CURSOR get_shift_end_time_tomorrow(p_location_id in number, p_date in date) IS
64: SELECT BSH.from_time, BSH.to_time
65: FROM BOM_CALENDAR_SHIFTS BCA, BOM_SHIFT_TIMES BSH,
66: BOM_SHIFT_DATES BDT, WSH_CALENDAR_ASSIGNMENTS WCA
67: WHERE WCA.LOCATION_ID = p_location_id and
68: BCA.CALENDAR_CODE=WCA.CALENDAR_CODE and
69: BSH.CALENDAR_CODE=WCA.CALENDAR_CODE and