DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_UTIL dependencies on BOM_SHIFT_TIMES

Line 401: from bom_shift_times bst

397: (select
398: bst.shift_num,
399: min(bst.from_time) from_time,
400: max (bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0) ) to_time
401: from bom_shift_times bst
402: where bst.calendar_code = l_calendar_code
403: and bst.shift_num = l_shift_num
404: group by bst.shift_num
405: ) st,

Line 510: from bom_shift_times bst

506: bst.calendar_code,
507: bst.shift_num,
508: min(bst.from_time) from_time,
509: max(decode(sign(bst.to_time - bst.from_time), -1, 24*60*60, 0) + bst.to_time) to_time
510: from bom_shift_times bst
511: where bst.calendar_code = p_calendar_code
512: group by bst.calendar_code, bst.shift_num
513: ) t
514: where bsd.calendar_code = p_calendar_code