APPS.WIP_WS_SHORTAGE dependencies on BOM_SHIFT_TIMES

Line 160: from bom_shift_times bst

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
160: from bom_shift_times bst
161: group by bst.calendar_code, bst.shift_num ) t
162: where mp.organization_id = p_org_id
163: and mp.calendar_code = bsd.calendar_code
164: and bsd.calendar_code = t.calendar_code