View: WIP_FIRST_TXN_SCHEDULE_V

Product:	WIP - Work in Process
Description:	Earliest transactable repetitive schedule on a line for a repetitive assembly
Implementation/DBA Data:	APPS.WIP_FIRST_TXN_SCHEDULE_V

View Text

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

Columns