DBA Data[Home] [Help]

APPS.WMS_DATECHECK_PVT dependencies on BOM_SHIFT_TIMES

Line 73: FROM BOM_SHIFT_TIMES

69: WHERE calendar_code = cal_code AND
70: exception_set_id = nvl(except_set, -1) AND
71: shift_date = cur_date AND
72: shift_num NOT IN (SELECT shift_num
73: FROM BOM_SHIFT_TIMES
74: WHERE calendar_code = cal_code AND
75: cur_seconds not between FROM_TIME and TO_TIME) AND
76: seq_num IS NOT NULL;
77: