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

TABLE: EAM.EAM_FAILURE_SET_ASSOCIATIONS

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


This table stores association of failure set with asset groups. Failure entry required flag set at the association level would default at the work order level. Whenever a failure is reported against an Asset, a Failure Set library can be used to report the Failure, Cause and Resolution codes.
The associations to Asset Groups established and stored in this table restrict the failure set libraries that can be used for failure reporting.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_FAILURESET_ASSOCIATION_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_ID
ColumnINVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
SET_ID NUMBER
Yes Identifier for failure set
INVENTORY_ITEM_ID NUMBER
Yes Asset Group or Rebuildable Identifier
FAILURE_CODE_REQUIRED VARCHAR2 (1)
Flag to signify mandatory failure capture
EFFECTIVE_END_DATE DATE

Effective End date indicates deletion of association.
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 SET_ID
,      INVENTORY_ITEM_ID
,      FAILURE_CODE_REQUIRED
,      EFFECTIVE_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM EAM.EAM_FAILURE_SET_ASSOCIATIONS;

Dependencies

[top of page]

EAM.EAM_FAILURE_SET_ASSOCIATIONS does not reference any database object

EAM.EAM_FAILURE_SET_ASSOCIATIONS is referenced by following:

SchemaAPPS
SynonymEAM_FAILURE_SET_ASSOCIATIONS