View: WIP_OPEN_SCHEDULES_VAL_V

Product:	WIP - Work in Process
Description:	Open repetitive schedules
Implementation/DBA Data:	APPS.WIP_OPEN_SCHEDULES_VAL_V

View Text

SELECT WRS.ORGANIZATION_ID
, WRS.REPETITIVE_SCHEDULE_ID
, WRS.WIP_ENTITY_ID
, WRI.PRIMARY_ITEM_ID
, WRS.LINE_ID
, WRS.FIRST_UNIT_START_DATE
, WRS.FIRST_UNIT_COMPLETION_DATE
, WRS.LAST_UNIT_START_DATE
, WRS.LAST_UNIT_COMPLETION_DATE
, WRS.DAILY_PRODUCTION_RATE * WRS.PROCESSING_WORK_DAYS TOTAL_QUANTITY
, WRS.BOM_REVISION
, WRS.STATUS_TYPE
, WRS.PROCESSING_WORK_DAYS
, WRS.DAILY_PRODUCTION_RATE
FROM WIP_REPETITIVE_ITEMS WRI
, WIP_REPETITIVE_SCHEDULES WRS
WHERE WRI.ORGANIZATION_ID = WRS.ORGANIZATION_ID
AND WRI.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
AND WRI.LINE_ID = WRS.LINE_ID
AND WRS.STATUS_TYPE IN (1
, 3
, 4
, 6)

Columns