View: EAM_PRIOR_OPERATIONS_V

Product:	EAM - Enterprise Asset Management
Description:	View provides a list of Prior operations for a specific operation in a work order depends upon the Dependency Definition defined in WIP_OPERATION_NETWORKS
Implementation/DBA Data:	APPS.EAM_PRIOR_OPERATIONS_V

View Text

SELECT WO.OPERATION_SEQ_NUM
, WO.DESCRIPTION
, BD.DEPARTMENT_CODE
, LKP.MEANING
, WO.FIRST_UNIT_START_DATE
, WO.LAST_UNIT_COMPLETION_DATE
, ROUND((WO.LAST_UNIT_COMPLETION_DATE-WO.FIRST_UNIT_START_DATE)*24)
, DECODE(UPPER(WO.OPERATION_COMPLETED)
, 'Y'
, EOCT.ACTUAL_START_DATE
, NULL)
, DECODE(UPPER(WO.OPERATION_COMPLETED)
, 'Y'
, EOCT.ACTUAL_END_DATE
, NULL)
, WON.WIP_ENTITY_ID
, WON.NEXT_OPERATION
FROM WIP_OPERATIONS WO
, EAM_OP_COMPLETION_TXNS EOCT
, WIP_OPERATION_NETWORKS WON
, BOM_DEPARTMENTS BD
, FND_LOOKUP_VALUES LKP
WHERE (WO.WIP_ENTITY_ID=WON.WIP_ENTITY_ID
AND WON.WIP_ENTITY_ID=EOCT.WIP_ENTITY_ID(+))
AND (WO.OPERATION_SEQ_NUM=WON.PRIOR_OPERATION
AND WON.PRIOR_OPERATION=EOCT.OPERATION_SEQ_NUM(+))
AND BD.DEPARTMENT_ID=WO.DEPARTMENT_ID
AND NVL(EOCT.TRANSACTION_ID
, 0)=(SELECT NVL(MAX(TRANSACTION_ID)
, 0)
FROM EAM_OP_COMPLETION_TXNS
WHERE WIP_ENTITY_ID=WON.WIP_ENTITY_ID
AND OPERATION_SEQ_NUM=WON.PRIOR_OPERATION)
AND LKP.LANGUAGE=USERENV('LANG')
AND LKP.LOOKUP_TYPE='EAM_YES_NO'
AND LKP.LOOKUP_CODE=NVL(WO.OPERATION_COMPLETED
, 'N')

Columns