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_FAILURE_COMBINATIONS

Object Details

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

This table stores unique combinations of failure code, cause code and resolution code in the context of a failure set. This table is the library of Failure, Cause and Resolution codes put together in a logical combination by a user who manages failure sets to be further used for failure reporting against Assets of a specific type.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_FAILURE_COMBINATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMBINATION_ID
EAM_FAILURE_COMBINATIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_ID FAILURE_CODE CAUSE_CODE RESOLUTION_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
COMBINATION_ID	NUMBER		Yes	Sequence generated unique identifier for failure combination.
SET_ID	NUMBER		Yes	Identifier for failure set
FAILURE_CODE	VARCHAR2	(80)	Yes	Identifier for failure code
CAUSE_CODE	VARCHAR2	(80)	Yes	Identifier for cause code
RESOLUTION_CODE	VARCHAR2	(80)	Yes	Identifier for resolution code
EFFECTIVE_END_DATE	DATE			End date beyond which combination is inactive
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		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 COMBINATION_ID
,      SET_ID
,      FAILURE_CODE
,      CAUSE_CODE
,      RESOLUTION_CODE
,      EFFECTIVE_END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_FAILURE_COMBINATIONS;

Dependencies

[top of page]

EAM.EAM_FAILURE_COMBINATIONS does not reference any database object

EAM.EAM_FAILURE_COMBINATIONS is referenced by following:

APPS: EAM_FAILURE_COMBINATIONS