View: WIP_EAM_NEXT_OPERATIONS_V

Product:	WIP - Work in Process
Description:	EAM Operation Dependency - Next Ops
Implementation/DBA Data:	APPS.WIP_EAM_NEXT_OPERATIONS_V

View Text

SELECT WON.WIP_ENTITY_ID
, WON.ORGANIZATION_ID
, WON.NEXT_OPERATION
, WO.DESCRIPTION NEXT_OP_DESC
, WO.FIRST_UNIT_START_DATE NEXT_OP_START_DATE
, WO.LAST_UNIT_COMPLETION_DATE NEXT_OP_COMPLETION_DATE
, WO.DEPARTMENT_ID NEXT_OP_DEPARTMENT_ID
, BD.DEPARTMENT_CODE NEXT_OP_DEPT_CODE
, WON.PRIOR_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.NEXT_OPERATION = WO.OPERATION_SEQ_NUM
AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
AND BD.ORGANIZATION_ID = WO.ORGANIZATION_ID

Columns