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

TABLE: EAM.EAM_FAILURE_CODES

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


This table stores failure code definition. Failure code is the first code reported by the user when any failure occurs. As an example for a printer jam failure, Failure Code could be PRNTRJAM and its description could be Printer Jam.
Practically, Failure Codes needs to be defined before we go ahead and make Failure Combinations to be used during capturing Failure Information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_FAILURE_CODES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFAILURE_CODE
Columns
Name Datatype Length Mandatory Comments
FAILURE_CODE VARCHAR2 (80) Yes Unique identifier for failure code
DESCRIPTION VARCHAR2 (2000)
Failure code description
EFFECTIVE_END_DATE DATE

End date beyond which failure code is inactive
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
Query Text

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


SELECT FAILURE_CODE
,      DESCRIPTION
,      EFFECTIVE_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM EAM.EAM_FAILURE_CODES;

Dependencies

[top of page]

EAM.EAM_FAILURE_CODES does not reference any database object

EAM.EAM_FAILURE_CODES is referenced by following:

SchemaEAM
ViewEAM_FAILURE_CODES#