View: EAM_FAILURE_SET_ASSOCIATIONS_V

Product:	EAM - Enterprise Asset Management
Description:	This view queries all active Failure Set - Item associations.
Implementation/DBA Data:	APPS.EAM_FAILURE_SET_ASSOCIATIONS_V

View Text

SELECT SET_ID
, INVENTORY_ITEM_ID
, FAILURE_CODE_REQUIRED
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, EFFECTIVE_END_DATE
FROM EAM_FAILURE_SET_ASSOCIATIONS
WHERE TRUNC(NVL(EFFECTIVE_END_DATE
, SYSDATE+1)) > TRUNC(SYSDATE)

Columns