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_FAILURES

Object Details

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

This table stores failure events reported against an Asset in the context of a business flow. Eg. Failure can be reported against an Asset during the lifecycle of a Work Order. The failure table stores the denormalized information about an Asset, the source object in context of which the Failure was logged and other key information about an Asset at the time of the failure reporting.

For every failure on an asset an entry goes in to this table if the Failure Entry is required at the work order level. Also for this release restricted source_type to always 1 (Work Order) which means that the failure entry is at the Work Order level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_ASSET_FAILURES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FAILURE_ID
EAM_ASSET_FAILURES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_ID
EAM_ASSET_FAILURES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID

Columns

Name	Datatype	Mandatory	Comments
FAILURE_ID	NUMBER	Yes	Unique failure identifier
FAILURE_DATE	DATE		Failure date
SOURCE_TYPE	NUMBER	Yes	Source type of the failure record. Source Type value 1 corresponds to Work Order.
SOURCE_ID	NUMBER	Yes	Source identifier for the failure record. Source id maps to wip entity id for source type 1.
OBJECT_TYPE	NUMBER	Yes	Object type identifier indicates table where asset is stored. MSN for 11i10.
OBJECT_ID	NUMBER	Yes	Asset or rebuildable serial identifier. Gen object id from mtl_serial_numbers.
MAINT_ORGANIZATION_ID	NUMBER	Yes	Maintenance organization identifier
DEPARTMENT_ID	NUMBER		Department identifier at work order level or asset level.
AREA_ID	NUMBER		Area Identifier. Same as EAM_LOCATION_ID
CURRENT_ORGANIZATION_ID	NUMBER		Identifier of asset owning organization at the time of failure.
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_DATE
,      SOURCE_TYPE
,      SOURCE_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      MAINT_ORGANIZATION_ID
,      DEPARTMENT_ID
,      AREA_ID
,      CURRENT_ORGANIZATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_ASSET_FAILURES;

Dependencies

[top of page]

EAM.EAM_ASSET_FAILURES does not reference any database object

EAM.EAM_ASSET_FAILURES is referenced by following:

APPS: EAM_ASSET_FAILURES