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


TABLE: INV.MTL_EAM_ASSET_ATTR_GROUPS

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


This table stores available asset attribute groups for each asset group. It also stores extra attributes for the asset attribute groups such as context code, enabled flag, etc.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_EAM_ASSET_ATTR_GROUPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSOCIATION_ID
MTL_EAM_ASSET_ATTR_GROUPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnDESCRIPTIVE_FLEX_CONTEXT_CODE
Columns
Name Datatype Length Mandatory Comments
ASSOCIATION_ID NUMBER
Yes Primary key column for the table, asset group and attribute group association ID
APPLICATION_ID NUMBER
Yes Application Identifier of the flexfield for the attribute group
DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2 (40) Yes Name of flexfield for the attribute group
DESCRIPTIVE_FLEX_CONTEXT_CODE VARCHAR2 (30) Yes Context code of the flexfield for the attribute group
ORGANIZATION_ID NUMBER

Organization identifier of the asset group
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier of the asset group
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
Yes Standard who column
ENABLED_FLAG VARCHAR2 (1) Yes Once the associations have been defined, it cannot be deleted, user can only disable it by using this flag
CREATION_ORGANIZATION_ID NUMBER

Creation Organization Identifier
Query Text

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


SELECT ASSOCIATION_ID
,      APPLICATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      DESCRIPTIVE_FLEX_CONTEXT_CODE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ENABLED_FLAG
,      CREATION_ORGANIZATION_ID
FROM INV.MTL_EAM_ASSET_ATTR_GROUPS;

Dependencies

[top of page]

INV.MTL_EAM_ASSET_ATTR_GROUPS does not reference any database object

INV.MTL_EAM_ASSET_ATTR_GROUPS is referenced by following:

SchemaINV
ViewMTL_EAM_ASSET_ATTR_GROUPS#