View: WIP_OP_RES_INSTANCE_USAGE_V

Product:	WIP - Work in Process
Description:	Usage data for operation resources
Implementation/DBA Data:	APPS.WIP_OP_RES_INSTANCE_USAGE_V

View Text

SELECT WORI.WIP_ENTITY_ID WIP_ENTITY_ID
, TO_NUMBER(NULL)
, WORI.ORGANIZATION_ID ORGANIZATION_ID
, WORI.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
, WORI.START_DATE
, WORU.START_DATE) START_DATE
, DECODE(WORU.COMPLETION_DATE
, NULL
, WORI.COMPLETION_DATE
, WORU.COMPLETION_DATE) COMPLETION_DATE
, 1
, WOR.SCHEDULED_FLAG
, WORI.INSTANCE_ID INSTANCE_ID
, WORI.SERIAL_NUMBER SERIAL_NUMBER
FROM BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENT_RESOURCES BDR
, WIP_OPERATIONS WO
, WIP_OPERATION_RESOURCE_USAGE WORU
, WIP_OPERATION_RESOURCES WOR
, WIP_OP_RESOURCE_INSTANCES WORI
WHERE WORU.WIP_ENTITY_ID(+) = WORI.WIP_ENTITY_ID
AND WORU.OPERATION_SEQ_NUM(+) = WORI.OPERATION_SEQ_NUM
AND WORU.RESOURCE_SEQ_NUM(+) = WORI.RESOURCE_SEQ_NUM
AND WORU.ORGANIZATION_ID(+) = WORI.ORGANIZATION_ID
AND WOR.SCHEDULED_FLAG IN (1
, 3
, 4)
AND WORI.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
AND WORI.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM
AND WORI.RESOURCE_SEQ_NUM = WOR.RESOURCE_SEQ_NUM
AND WORU.INSTANCE_ID(+) = WORI.INSTANCE_ID
AND WORU.SERIAL_NUMBER(+) = WORI.SERIAL_NUMBER
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