SELECT WRS.WIP_ENTITY_ID , WRS.LINE_ID , WRS.ORGANIZATION_ID , WRS.REPETITIVE_SCHEDULE_ID FROM WIP_REPETITIVE_SCHEDULES WRS WHERE WRS.STATUS_TYPE IN (3, 4) AND WRS.FIRST_UNIT_START_DATE = (SELECT MIN(FIRST_UNIT_START_DATE) FROM WIP_REPETITIVE_SCHEDULES WHERE WIP_ENTITY_ID = WRS.WIP_ENTITY_ID AND LINE_ID = WRS.LINE_ID AND ORGANIZATION_ID = WRS.ORGANIZATION_ID AND STATUS_TYPE IN (3, 4))
SELECT WRS.WIP_ENTITY_ID
, WRS.LINE_ID
, WRS.ORGANIZATION_ID
, WRS.REPETITIVE_SCHEDULE_ID
FROM WIP_REPETITIVE_SCHEDULES WRS
WHERE WRS.STATUS_TYPE IN (3
, 4)
AND WRS.FIRST_UNIT_START_DATE = (SELECT MIN(FIRST_UNIT_START_DATE)
FROM WIP_REPETITIVE_SCHEDULES
WHERE WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
AND LINE_ID = WRS.LINE_ID
AND ORGANIZATION_ID = WRS.ORGANIZATION_ID
AND STATUS_TYPE IN (3
, 4))
|
|
|