DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_UTIL dependencies on BOM_SHIFT_DATES

Line 396: bom_shift_dates bsd,

392: x_shift_end,
393: x_shift_day,
394: l_shift_description
395: from
396: bom_shift_dates bsd,
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

Line 503: bom_shift_dates bsd,

499: wip_ws_util.get_shift_info_for_display(
500: p_organization_id, bsd.seq_num, t.shift_num
501: ) as display
502: from
503: bom_shift_dates bsd,
504: (
505: select
506: bst.calendar_code,
507: bst.shift_num,