View: EAM_FAILURE_CODES_V

Product:	EAM - Enterprise Asset Management
Description:	This view provides all Failure/Cause/Resolution Codes with their Code Types.
Implementation/DBA Data:	APPS.EAM_FAILURE_CODES_V

View Text

SELECT FC.FAILURE_CODE
, FC.DESCRIPTION
, FC.EFFECTIVE_END_DATE
, ML.MEANING FAILURE_CODE_TYPE_DISP
, 10 FAILURE_CODE_TYPE
, FC.CREATED_BY
, FC.CREATION_DATE
, FC.LAST_UPDATE_DATE
, FC.LAST_UPDATED_BY
, FC.LAST_UPDATE_LOGIN
, FC.FAILURE_CODE||'10'
FROM EAM_FAILURE_CODES FC
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE='EAM_FAILURE_CODE_TYPE'
AND ML.LOOKUP_CODE=10 UNION ALL SELECT CC.CAUSE_CODE
, CC.DESCRIPTION
, CC.EFFECTIVE_END_DATE
, ML.MEANING FAILURE_CODE_TYPE_DISP
, 20 FAILURE_CODE_TYPE
, CC.CREATED_BY
, CC.CREATION_DATE
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATED_BY
, CC.LAST_UPDATE_LOGIN
, CC.CAUSE_CODE||'20'
FROM EAM_CAUSE_CODES CC
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE='EAM_FAILURE_CODE_TYPE'
AND ML.LOOKUP_CODE=20 UNION ALL SELECT RC.RESOLUTION_CODE
, RC.DESCRIPTION
, RC.EFFECTIVE_END_DATE
, ML.MEANING FAILURE_CODE_TYPE_DISP
, 30 FAILURE_CODE_TYPE
, RC.CREATED_BY
, RC.CREATION_DATE
, RC.LAST_UPDATE_DATE
, RC.LAST_UPDATED_BY
, RC.LAST_UPDATE_LOGIN
, RC.RESOLUTION_CODE||'30'
FROM EAM_RESOLUTION_CODES RC
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE='EAM_FAILURE_CODE_TYPE'
AND ML.LOOKUP_CODE=30

Columns