eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: EAM.EAM_ASSET_FAILURE_CODES

Object Details

Object Name:	EAM_ASSET_FAILURE_CODES
Object Type:	TABLE
Owner:	EAM
FND Design Data:	EAM.EAM_ASSET_FAILURE_CODES
Subobject Name:
Status:	VALID

This table stores the detail information captured for a failure event i.e. failure code, cause code, resolution code and the comments entered by the user in the context of an Workorder (E.g. Work Order). This is a child table of its parent EAM_ASSET_FAILURES table.
As per the design, one failure reported for an Asset can have one failure code combinations(combination_id). Currently the Oracle Enterprise Asset Management application UIs restricts only one set of codes to be reported against an Asset.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_ASSET_FAILURE_CODES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FAILURE_ENTRY_ID
EAM_ASSET_FAILURE_CODES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	FAILURE_ID FAILURE_CODE CAUSE_CODE RESOLUTION_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
FAILURE_ID	NUMBER		Yes	Failure identifier
FAILURE_ENTRY_ID	NUMBER		Yes	Failure Entry Id
COMBINATION_ID	NUMBER			Identifier for failure combination.
FAILURE_CODE	VARCHAR2	(80)		Identifier for failure code
CAUSE_CODE	VARCHAR2	(80)		Identifier for cause code
RESOLUTION_CODE	VARCHAR2	(80)		Identifier for resolution code
COMMENTS	VARCHAR2	(2000)		Failure comment
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FAILURE_ID
,      FAILURE_ENTRY_ID
,      COMBINATION_ID
,      FAILURE_CODE
,      CAUSE_CODE
,      RESOLUTION_CODE
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_ASSET_FAILURE_CODES;

Dependencies

[top of page]

EAM.EAM_ASSET_FAILURE_CODES does not reference any database object

EAM.EAM_ASSET_FAILURE_CODES is referenced by following:

APPS: EAM_ASSET_FAILURE_CODES