View: WIP_OPERATION_RESOURCE_USAGE_V

Product:	WIP - Work in Process
Description:	Resolves foreign key data for WIP_OPERATION_RESOURCE_USAGE
Implementation/DBA Data:	APPS.WIP_OPERATION_RESOURCE_USAGE_V

View Text

SELECT WOR.WIP_ENTITY_ID WIP_ENTITY_ID
, WOR.REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, WOR.ORGANIZATION_ID ORGANIZATION_ID
, WOR.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, WOR.RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, WOR.RESOURCE_ID
, BR.RESOURCE_CODE
, BDR.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, BDR.SHARE_FROM_DEPT_ID
, DECODE(WORU.START_DATE
, NULL
, WOR.START_DATE
, WORU.START_DATE) START_DATE
, DECODE(WORU.COMPLETION_DATE
, NULL
, WOR.COMPLETION_DATE
, WORU.COMPLETION_DATE) COMPLETION_DATE
, DECODE(WORU.ASSIGNED_UNITS
, NULL
, WOR.ASSIGNED_UNITS
, WORU.ASSIGNED_UNITS) ASSIGNED_UNITS
, WOR.SCHEDULED_FLAG
, WORU.INSTANCE_ID
, WORU.SERIAL_NUMBER
, DECODE(WOR.PARENT_RESOURCE_SEQ
, NULL
, 0
, 1) SETUP
, WORU.CUMULATIVE_PROCESSING_TIME
FROM BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENT_RESOURCES BDR
, WIP_OPERATIONS WO
, WIP_OPERATION_RESOURCE_USAGE WORU
, WIP_OPERATION_RESOURCES WOR
WHERE WORU.WIP_ENTITY_ID(+) = WOR.WIP_ENTITY_ID
AND WORU.OPERATION_SEQ_NUM(+) = WOR.OPERATION_SEQ_NUM
AND WORU.RESOURCE_SEQ_NUM(+) = WOR.RESOURCE_SEQ_NUM
AND WORU.ORGANIZATION_ID(+) = WOR.ORGANIZATION_ID
AND NVL(WORU.REPETITIVE_SCHEDULE_ID(+)
, -1) = NVL(WOR.REPETITIVE_SCHEDULE_ID
, -1)
AND WOR.SCHEDULED_FLAG IN (1
, 3
, 4)
AND BD.DEPARTMENT_ID = BDR.DEPARTMENT_ID
AND BDR.DEPARTMENT_ID = WO.DEPARTMENT_ID
AND BR.RESOURCE_ID = BDR.RESOURCE_ID
AND BDR.RESOURCE_ID = WOR.RESOURCE_ID
AND WO.ORGANIZATION_ID = WOR.ORGANIZATION_ID
AND WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
AND WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM
AND NVL(WO.REPETITIVE_SCHEDULE_ID
, -1) = NVL(WOR.REPETITIVE_SCHEDULE_ID
, -1)

Columns