DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on BOM_SHIFT_DATES

Line 155: from mtl_parameters mp, bom_shift_dates bsd,

151: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) to_date,
152: t.shift_num,
153: bsd.seq_num,
154: wip_ws_util.get_shift_info_for_display(mp.organization_id, bsd.seq_num, t.shift_num) as display
155: from mtl_parameters mp, bom_shift_dates bsd,
156: (select bst.calendar_code,
157: bst.shift_num,
158: min(bst.from_time) from_time,
159: max(decode(sign(bst.to_time - bst.from_time), -1, 24*60*60, 0) + bst.to_time) to_time