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_LOG

Object Details

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

This Table stores information of Assets for various events whose Operational
Logs are intented to be capture by enabling selective events at organization
level and at the Asset level. The events are classified as System Events such
as Create Work Requests, Work Order Events, Geneology Changes such as
Add/Remove Child or Parent Events, Activate or De-Activate Asset Events,
Meter Readings Entry, Collection Plan Entry during Work Order Completion and
Asset Operational events such as Check-In or Check-Out. This table also
captures inventory events like Location Transfer of Assets.
Other than System Events, Operational Events such as Resource Up, Down and
Acknowledge Down are supported part of OSFM events. User Defined Events are
supported.
This table holds details of the instance, event type and event id, reference
of the event date at which the event happened with the reference of the
transaction and the user who performed the event with user enterable comments
and the organization information. It also holds resource and resource
instance information and reason for the event and operational status of the
asset during the event optionally.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_ASSET_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_ID
EAM_ASSET_LOG_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID DEPARTMENT_ID EVENT_DATE EQUIPMENT_GEN_OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOG_ID	NUMBER		Yes	Entity identifier
EVENT_DATE	DATE		Yes	Event date
EVENT_TYPE	VARCHAR2	(30)		Event Type Code ('EAM_SYSTEM_EVENTS', 'EAM_USER_EVENTS','EAM_OPERATIONAL_EVENTS')
EVENT_ID	NUMBER			Event Identifier
ORGANIZATION_ID	NUMBER			Organization Identifier
INSTANCE_ID	NUMBER			Asset Number Identifier
REFERENCE	VARCHAR2	(80)		Additional information associated with the event
REF_ID	NUMBER			Depending on event_type, it will store primary key to identify the event.
OPERABLE	NUMBER			Operable Status Identifier (1- Operable2 - Non operable)
REASON_CODE	NUMBER			Reason Code
RESOURCE_ID	NUMBER			Resource Identifier
COMMENTS	VARCHAR2	(2000)		Comments regarding the event
DOWN_CODE	NUMBER			Down Code
RESOURCE_SERIAL_NUMBER	VARCHAR2	(30)		Asset Number of the instance
EXPECTED_UP_DATE	DATE			Expected operational date of the Resource
SOURCE_LOG_ID	NUMBER			Source Transaction Id (OSFM requirement)
EMPLOYEE_ID	NUMBER			Employee identifier who performed the transaction
DEPARTMENT_ID	NUMBER			Department identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure identifier
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
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
EQUIPMENT_GEN_OBJECT_ID	NUMBER			Genealogy object identifier

Query Text

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


SELECT LOG_ID
,      EVENT_DATE
,      EVENT_TYPE
,      EVENT_ID
,      ORGANIZATION_ID
,      INSTANCE_ID
,      REFERENCE
,      REF_ID
,      OPERABLE
,      REASON_CODE
,      RESOURCE_ID
,      COMMENTS
,      DOWN_CODE
,      RESOURCE_SERIAL_NUMBER
,      EXPECTED_UP_DATE
,      SOURCE_LOG_ID
,      EMPLOYEE_ID
,      DEPARTMENT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      EQUIPMENT_GEN_OBJECT_ID
FROM EAM.EAM_ASSET_LOG;

Dependencies

[top of page]

EAM.EAM_ASSET_LOG does not reference any database object

EAM.EAM_ASSET_LOG is referenced by following:

APPS: EAM_ASSET_LOG