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

Line 278: from bom_shift_times bst

274: from bom_shift_dates bsd,
275: ( select bst.shift_num,
276: min(bst.from_time) from_time,
277: max (bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0) ) to_time
278: from bom_shift_times bst
279: where bst.calendar_code = l_cal_code
280: group by bst.shift_num
281: ) st ,
282: bom_resource_shifts brs

Line 491: from bom_shift_times bst

487: (select
488: bst.shift_num,
489: min(bst.from_time) from_time,
490: max (bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0) ) to_time
491: from bom_shift_times bst
492: where bst.calendar_code = l_calendar_code
493: and bst.shift_num = l_shift_num
494: group by bst.shift_num
495: ) st,

Line 600: from bom_shift_times bst

596: bst.calendar_code,
597: bst.shift_num,
598: min(bst.from_time) from_time,
599: max(decode(sign(bst.to_time - bst.from_time), -1, 24*60*60, 0) + bst.to_time) to_time
600: from bom_shift_times bst
601: where bst.calendar_code = p_calendar_code
602: group by bst.calendar_code, bst.shift_num
603: ) t
604: where bsd.calendar_code = p_calendar_code