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, 6) 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, 6))
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
, 6)
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
, 6))
|
|
|