View: EAM_OP_COMPLETION_TXNS_V

Product:	EAM - Enterprise Asset Management
Description:	This view shows the details of all the completed operations of a work order.The view has being derived from the eam_op_completion_txns table . This view contains the most recent operation completion transactions of work order.
Implementation/DBA Data:	APPS.EAM_OP_COMPLETION_TXNS_V

View Text

SELECT EOCT.TRANSACTION_ID
, EOCT.TRANSACTION_DATE
, EOCT.TRANSACTION_TYPE
, EOCT.WIP_ENTITY_ID
, EOCT.ORGANIZATION_ID
, EOCT.OPERATION_SEQ_NUM
, EOCT.DEPARTMENT_ID
, EOCT.ASSET_GROUP_ID
, EOCT.ASSET_NUMBER
, EOCT.ASSET_ACTIVITY_ID
, EOCT.ACTUAL_START_DATE
, EOCT.ACTUAL_END_DATE
, EOCT.LAST_UPDATE_DATE
FROM EAM_OP_COMPLETION_TXNS EOCT
WHERE EOCT.TRANSACTION_ID = (SELECT MAX(TRANSACTION_ID)
FROM EAM_OP_COMPLETION_TXNS EOCT2
WHERE EOCT2.WIP_ENTITY_ID = EOCT.WIP_ENTITY_ID
AND EOCT2.OPERATION_SEQ_NUM = EOCT.OPERATION_SEQ_NUM)
AND EOCT.TRANSACTION_TYPE=1

Columns