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

TABLE: EAM.EAM_FAILURE_SETS

Object Details
Object Name: EAM_FAILURE_SETS
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_FAILURE_SETS
Subobject Name:
Status: VALID


This table stores failure set definition. Failure Sets are like a library of Failure, Cause and Resolution codes. Once the failure sets are defined, they need to be associated to Asset Groups for capuring the failure information at the work order level.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_FAILURE_SETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_ID
EAM_FAILURE_SETS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_NAME
Columns
Name Datatype Length Mandatory Comments
SET_ID NUMBER
Yes Unique identifier for failure set
SET_NAME VARCHAR2 (80) Yes Failure set name
DESCRIPTION VARCHAR2 (240)
Failure set description
EFFECTIVE_END_DATE DATE

End date beyond which the failure set is inactive
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 SET_ID
,      SET_NAME
,      DESCRIPTION
,      EFFECTIVE_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_FAILURE_SETS;

Dependencies

[top of page]

EAM.EAM_FAILURE_SETS does not reference any database object

EAM.EAM_FAILURE_SETS is referenced by following:

SchemaAPPS
SynonymEAM_FAILURE_SETS