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.

[Home] [Help]

View: MTL_EAM_ASSET_ATTR_GROUPS_V

Product:	INV - Inventory
Description:	View for Asset Attribute Groups
Implementation/DBA Data:	APPS.MTL_EAM_ASSET_ATTR_GROUPS_V

View Text

SELECT MEAAG.ROWID ROW_ID
, MEAAG.ASSOCIATION_ID
, MEAAG.APPLICATION_ID
, MEAAG.DESCRIPTIVE_FLEXFIELD_NAME
, MEAAG.DESCRIPTIVE_FLEX_CONTEXT_CODE
, FDFCV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, FDFCV.DESCRIPTION
, MEAAG.ORGANIZATION_ID
, MEAAG.INVENTORY_ITEM_ID
, MEAAG.LAST_UPDATE_DATE
, MEAAG.LAST_UPDATED_BY
, MEAAG.CREATION_DATE
, MEAAG.CREATED_BY
, MEAAG.LAST_UPDATE_LOGIN
, MEAAG.ENABLED_FLAG
FROM MTL_EAM_ASSET_ATTR_GROUPS MEAAG
, FND_DESCR_FLEX_CONTEXTS_VL FDFCV
WHERE MEAAG.APPLICATION_ID = FDFCV.APPLICATION_ID
AND MEAAG.DESCRIPTIVE_FLEXFIELD_NAME = FDFCV.DESCRIPTIVE_FLEXFIELD_NAME
AND MEAAG.DESCRIPTIVE_FLEX_CONTEXT_CODE = FDFCV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FDFCV.ENABLED_FLAG = 'Y'
AND FDFCV.GLOBAL_FLAG = 'N'

Columns

Name
ROW_ID
ASSOCIATION_ID
APPLICATION_ID
DESCRIPTIVE_FLEXFIELD_NAME
DESCRIPTIVE_FLEX_CONTEXT_CODE
DESCRIPTIVE_FLEX_CONTEXT_NAME
DESCRIPTION
ORGANIZATION_ID
INVENTORY_ITEM_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ENABLED_FLAG