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

Line 62: from bom_shift_times bst

58: bom_shift_dates bsd,
59: (select bst.shift_num,
60: min(bst.from_time) from_time,
61: max(decode(sign(bst.to_time - bst.from_time), -1, 24*60*60, 0) + bst.to_time) to_time
62: from bom_shift_times bst
63: where bst.calendar_code = p_calendar_code
64: group by bst.shift_num) st
65: where bsd.calendar_code = p_calendar_code
66: and bsd.shift_num = st.shift_num

Line 84: from bom_shift_times bst

80: from
81: bom_shift_dates bsd,
82: (select bst.shift_num,
83: max(decode(sign(bst.to_time - bst.from_time), -1, 24*60*60, 0) + bst.to_time) to_time
84: from bom_shift_times bst
85: where bst.calendar_code = p_calendar_code
86: group by bst.shift_num) st
87: where bsd.calendar_code = p_calendar_code
88: and bsd.shift_num = st.shift_num

Line 316: from bom_shift_times bst

312: from bom_shift_dates bsd,
313: (select bst.shift_num,
314: min(bst.from_time) from_time,
315: max(bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0)) to_time
316: from bom_shift_times bst
317: where bst.calendar_code = p_calendar_code
318: group by bst.shift_num) st,
319: bom_calendar_shifts bcs,
320: bom_resource_shifts brs