APPS.MRP_VALIDATE_FLOW_SCHEDULE dependencies on WIP_FLOW_SCHEDULES

Line 389: FROM wip_flow_schedules

385: INTO l_dummy
386: FROM dual
387: WHERE l_flow_schedule_rec.build_sequence NOT IN
388: (SELECT build_sequence
389: FROM wip_flow_schedules
390: WHERE NVL(schedule_group_id,-1) = NVL(l_schedule_group_id,-1)
391: AND line_id = l_flow_schedule_rec.line_id
392: AND scheduled_completion_date --fix bug#3170105
393: BETWEEN l_flow_schedule_rec.scheduled_completion_date