View: WIP_JOBS_AND_SCHEDULES_V

Product:	WIP - Work in Process
Description:	Summary data for jobs and schedules
Implementation/DBA Data:	APPS.WIP_JOBS_AND_SCHEDULES_V

View Text

SELECT WE.WIP_ENTITY_ID
, WE.ORGANIZATION_ID
, DECODE(WE.ENTITY_TYPE
, 2
, NULL
, WE.WIP_ENTITY_NAME) WIP_ENTITY_NAME
, WE.ENTITY_TYPE
, DECODE(WE.ENTITY_TYPE
, 2
, NULL
, WE.DESCRIPTION) DESCRIPTION
, WE.PRIMARY_ITEM_ID
, DECODE(WE.ENTITY_TYPE
, 1
, WDJ.STATUS_TYPE
, 2
, WRS.STATUS_TYPE
, 3
, WDJ.STATUS_TYPE
, NULL) STATUS_TYPE
, DECODE(WE.ENTITY_TYPE
, 1
, WDJ.START_QUANTITY
, 2
, WRS.DAILY_PRODUCTION_RATE * PROCESSING_WORK_DAYS
, 3
, WDJ.START_QUANTITY
, NULL) TOTAL_QUANTITY
, WRS.DAILY_PRODUCTION_RATE
, WRS.PROCESSING_WORK_DAYS
, WDJ.JOB_TYPE
, DECODE(WE.ENTITY_TYPE
, 1
, WDJ.SCHEDULED_START_DATE
, 2
, WRS.FIRST_UNIT_START_DATE
, 3
, WDJ.SCHEDULED_START_DATE
, NULL) SCHEDULED_START_DATE
, WRS.REPETITIVE_SCHEDULE_ID
, WL.LINE_ID
, WL.LINE_CODE
FROM WIP_LINES WL
, WIP_REPETITIVE_SCHEDULES WRS
, WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID (+)
AND WE.ORGANIZATION_ID = WDJ.ORGANIZATION_ID (+)
AND WE.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID (+)
AND WRS.LINE_ID = WL.LINE_ID (+)

Columns