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 138: from bom_shift_times bst

134: select shift_date + at.from_time /(24*60*60)
135: into l_eff_date
136: from bom_shift_dates,
137: (select min(bst.from_time) from_time
138: from bom_shift_times bst
139: where bst.calendar_code = l_calendar_code
140: and bst.shift_num = p_shift_num
141: ) at
142: where calendar_code = l_calendar_code

Line 322: from bom_shift_times bst

318: from bom_shift_dates bsd,
319: (select bst.shift_num,
320: min(bst.from_time) from_time,
321: max(bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0)) to_time
322: from bom_shift_times bst
323: where bst.calendar_code = p_calendar_code
324: group by bst.shift_num) st,
325: bom_calendar_shifts bcs,
326: bom_resource_shifts brs