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

TABLE: INV.MTL_EAM_ASSET_ACTIVITIES

Object Details
Object Name: MTL_EAM_ASSET_ACTIVITIES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_EAM_ASSET_ACTIVITIES
Subobject Name:
Status: VALID


This table stores association between Assets and Asset Activities. It also stores the attributes of the association e.g. effective start and end date of the association, activity priority, etc.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_EAM_ASSET_ACTIVITIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVITY_ASSOCIATION_ID
MTL_EAM_ASSET_ACTIVITIES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_ACTIVITY_ID
ColumnMAINTENANCE_OBJECT_TYPE
ColumnMAINTENANCE_OBJECT_ID
MTL_EAM_ASSET_ACTIVITIES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAINTENANCE_OBJECT_ID
ColumnMAINTENANCE_OBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

This column is no longer used. As per Release 12 design, this has been moved to eam_org_maint_defaults table.
ASSET_ACTIVITY_ID NUMBER
Yes Asset Activity identifier
START_DATE_ACTIVE DATE

Effective start date of the association
END_DATE_ACTIVE DATE

Effective end date of the association
PRIORITY_CODE VARCHAR2 (30)
An activity can associate with different asset items
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
OWNING_DEPARTMENT_ID NUMBER

Asset owning department identification
ACTIVITY_CAUSE_CODE VARCHAR2 (30)
Cause code for asset activity
ACTIVITY_TYPE_CODE VARCHAR2 (30)
Type of asset activity
INVENTORY_ITEM_ID NUMBER

This column is no longer used. Maintenance Object Type and Maintenance Object Id should be used instead.
SERIAL_NUMBER VARCHAR2 (30)
This column is no longer used. Maintenance Object Type and Maintenance Object Id should be used instead.
ACTIVITY_ASSOCIATION_ID NUMBER
Yes Primary Key, sequence
TAGGING_REQUIRED_FLAG VARCHAR2 (1)
Attribute for the asset activity
SHUTDOWN_TYPE_CODE VARCHAR2 (30)
Asset shutdown type for asset activity
CLASS_CODE VARCHAR2 (10)
Accounting class code for asset activity association
MAINTENANCE_OBJECT_TYPE NUMBER

Object Type
MAINTENANCE_OBJECT_ID NUMBER

Object ID
CREATION_ORGANIZATION_ID NUMBER

As per Release 12 designs, this column is no longer used.
TMPL_FLAG VARCHAR2 (1)
Flag indicating whether it is a activity association template or not
SOURCE_TMPL_ID NUMBER

Template that creates the activity association instance
ACTIVITY_SOURCE_CODE VARCHAR2 (30)
Activity Source
LAST_SERVICE_START_DATE DATE

The start date when the activity was last performed
LAST_SERVICE_END_DATE DATE

The end date when the activity was last performed
PREV_SERVICE_START_DATE DATE

Start date when last activity was performed
PREV_SERVICE_END_DATE DATE

End date when last activity was performed
LAST_SCHEDULED_START_DATE DATE

Start Date When Last Work Order Was Scheduled
LAST_SCHEDULED_END_DATE DATE

End Date When Last Work Order Was Scheduled
PREV_SCHEDULED_START_DATE DATE

Start Date When Previous Work Order Was Scheduled
PREV_SCHEDULED_END_DATE DATE

End Date When Previous Work Order Was Scheduled
WIP_ENTITY_ID NUMBER

Work Order Identifier
LAST_PM_SUGGESTED_START_DATE DATE

PM suggested Start Date When Last Work Order Was Scheduled
LAST_PM_SUGGESTED_END_DATE DATE

PM suggested End Date When Last Work Order Was Scheduled
PREV_PM_SUGGESTED_START_DATE DATE

PM suggested Start Date When Previous Work Order Was Scheduled
PREV_PM_SUGGESTED_END_DATE DATE

PM suggested End Date When Previous Work Order Was Scheduled
Query Text

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


SELECT ORGANIZATION_ID
,      ASSET_ACTIVITY_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PRIORITY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OWNING_DEPARTMENT_ID
,      ACTIVITY_CAUSE_CODE
,      ACTIVITY_TYPE_CODE
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      ACTIVITY_ASSOCIATION_ID
,      TAGGING_REQUIRED_FLAG
,      SHUTDOWN_TYPE_CODE
,      CLASS_CODE
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_ID
,      CREATION_ORGANIZATION_ID
,      TMPL_FLAG
,      SOURCE_TMPL_ID
,      ACTIVITY_SOURCE_CODE
,      LAST_SERVICE_START_DATE
,      LAST_SERVICE_END_DATE
,      PREV_SERVICE_START_DATE
,      PREV_SERVICE_END_DATE
,      LAST_SCHEDULED_START_DATE
,      LAST_SCHEDULED_END_DATE
,      PREV_SCHEDULED_START_DATE
,      PREV_SCHEDULED_END_DATE
,      WIP_ENTITY_ID
,      LAST_PM_SUGGESTED_START_DATE
,      LAST_PM_SUGGESTED_END_DATE
,      PREV_PM_SUGGESTED_START_DATE
,      PREV_PM_SUGGESTED_END_DATE
FROM INV.MTL_EAM_ASSET_ACTIVITIES;

Dependencies

[top of page]

INV.MTL_EAM_ASSET_ACTIVITIES does not reference any database object

INV.MTL_EAM_ASSET_ACTIVITIES is referenced by following:

SchemaINV
ViewMTL_EAM_ASSET_ACTIVITIES#