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_DL_UTIL dependencies on BOM_SHIFT_TIMES

Line 98: from bom_shift_times bst

94: from bom_shift_dates bsd,
95: ( select bst.shift_num,
96: min(bst.from_time) from_time,
97: max (bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0) ) to_time
98: from bom_shift_times bst
99: where bst.calendar_code = p_cal_code
100: group by bst.shift_num
101: ) st
102: where bsd.calendar_code = p_cal_code and

Line 195: from bom_shift_times bst

191: from bom_shift_dates bsd,
192: ( select bst.shift_num,
193: min(bst.from_time) from_time,
194: max (bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0) ) to_time
195: from bom_shift_times bst
196: where bst.calendar_code = p_cal_code
197: group by bst.shift_num
198: ) st ,
199: bom_resource_shifts brs

Line 1619: from bom_shift_times bst

1615: into l_total_time
1616: from
1617: ( select GREATEST(l_date, l_shift_date + from_time/(24*60*60)) from_date,
1618: l_shift_date + to_time/(24*60*60) + decode(sign(to_time - from_time), -1, 1, 0) to_date
1619: from bom_shift_times bst
1620: where bst.calendar_code = l_cal_code and
1621: bst.shift_num = p_shift_num
1622: ) sd
1623: where sd.from_date <= sd.to_date;