[Home] [Help]
View: WIP_EAM_PRIOR_OPERATIONS_V
View Text
SELECT WON.WIP_ENTITY_ID
, WON.ORGANIZATION_ID
, WON.PRIOR_OPERATION
, WO.DESCRIPTION PRIOR_OP_DESC
, WO.FIRST_UNIT_START_DATE PRIOR_OP_START_DATE
, WO.LAST_UNIT_COMPLETION_DATE PRIOR_OP_COMPLETION_DATE
, WO.DEPARTMENT_ID PRIOR_OP_DEPT_ID
, BD.DEPARTMENT_CODE PRIOR_OP_DEPT_CODE
, WON.NEXT_OPERATION
, NVL(WO.OPERATION_COMPLETED
, 'N') OP_COMPLETED
FROM WIP_OPERATION_NETWORKS WON
, WIP_OPERATIONS WO
, BOM_DEPARTMENTS BD
WHERE WON.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
AND WON.ORGANIZATION_ID = WO.ORGANIZATION_ID
AND WON.PRIOR_OPERATION = WO.OPERATION_SEQ_NUM
AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
AND BD.ORGANIZATION_ID = WO.ORGANIZATION_ID
Columns
Name |
WIP_ENTITY_ID |
ORGANIZATION_ID |
PRIOR_OPERATION |
PRIOR_OP_DESC |
PRIOR_OP_START_DATE |
PRIOR_OP_COMPLETION_DATE |
PRIOR_OP_DEPT_ID |
PRIOR_OP_DEPT_CODE |
NEXT_OPERATION |
OP_COMPLETED |