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.

VIEW: APPS.MTL_EAM_ASSET_ATTR_GROUPS_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'