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: INV.MTL_EAM_ASSET_ATTR_GROUPS

Object Details

Object Name:	MTL_EAM_ASSET_ATTR_GROUPS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_EAM_ASSET_ATTR_GROUPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSOCIATION_ID
MTL_EAM_ASSET_ATTR_GROUPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID INVENTORY_ITEM_ID DESCRIPTIVE_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:

INV: MTL_EAM_ASSET_ATTR_GROUPS#