View: EAM_FAILURE_COMBINATIONS_V

Product:	EAM - Enterprise Asset Management
Description:	This view displays all Failure/Cause/Resolution Code Combinations along with their description.
Implementation/DBA Data:	APPS.EAM_FAILURE_COMBINATIONS_V

View Text

SELECT FCC.SET_ID
, FCC.FAILURE_CODE
, FCC.CAUSE_CODE
, FCC.RESOLUTION_CODE
, FCC.EFFECTIVE_END_DATE
, FCC.CREATED_BY
, FCC.CREATION_DATE
, FCC.LAST_UPDATE_DATE
, FCC.LAST_UPDATED_BY
, FCC.LAST_UPDATE_LOGIN
, FCC.COMBINATION_ID
, FC.DESCRIPTION
, CC.DESCRIPTION
, RC.DESCRIPTION
FROM EAM_FAILURE_COMBINATIONS FCC
, EAM_FAILURE_CODES FC
, EAM_CAUSE_CODES CC
, EAM_RESOLUTION_CODES RC
WHERE FCC.FAILURE_CODE=FC.FAILURE_CODE
AND FCC.CAUSE_CODE =CC.CAUSE_CODE
AND FCC.RESOLUTION_CODE=RC.RESOLUTION_CODE

Columns