View: MTL_EAM_ASSET_ATTR_VALUES_V

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

View Text

SELECT MEAAV.ROWID ROW_ID
, MEAAV.ASSOCIATION_ID
, MEAAG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTRIBUTE_CATEGORY
, MEAAG.DESCRIPTIVE_FLEX_CONTEXT_NAME ATTRIBUTE_GROUP
, MEAAV.APPLICATION_ID
, MEAAV.DESCRIPTIVE_FLEXFIELD_NAME
, CII.INVENTORY_ITEM_ID
, CII.SERIAL_NUMBER
, CII.INSTANCE_NUMBER
, MEAAV.ORGANIZATION_ID
, MEAAV.C_ATTRIBUTE1
, MEAAV.C_ATTRIBUTE2
, MEAAV.C_ATTRIBUTE3
, MEAAV.C_ATTRIBUTE4
, MEAAV.C_ATTRIBUTE5
, MEAAV.C_ATTRIBUTE6
, MEAAV.C_ATTRIBUTE7
, MEAAV.C_ATTRIBUTE8
, MEAAV.C_ATTRIBUTE9
, MEAAV.C_ATTRIBUTE10
, MEAAV.C_ATTRIBUTE11
, MEAAV.C_ATTRIBUTE12
, MEAAV.C_ATTRIBUTE13
, MEAAV.C_ATTRIBUTE14
, MEAAV.C_ATTRIBUTE15
, MEAAV.C_ATTRIBUTE16
, MEAAV.C_ATTRIBUTE17
, MEAAV.C_ATTRIBUTE18
, MEAAV.C_ATTRIBUTE19
, MEAAV.C_ATTRIBUTE20
, MEAAV.D_ATTRIBUTE1
, MEAAV.D_ATTRIBUTE2
, MEAAV.D_ATTRIBUTE3
, MEAAV.D_ATTRIBUTE4
, MEAAV.D_ATTRIBUTE5
, MEAAV.D_ATTRIBUTE6
, MEAAV.D_ATTRIBUTE7
, MEAAV.D_ATTRIBUTE8
, MEAAV.D_ATTRIBUTE9
, MEAAV.D_ATTRIBUTE10
, MEAAV.N_ATTRIBUTE1
, MEAAV.N_ATTRIBUTE2
, MEAAV.N_ATTRIBUTE3
, MEAAV.N_ATTRIBUTE4
, MEAAV.N_ATTRIBUTE5
, MEAAV.N_ATTRIBUTE6
, MEAAV.N_ATTRIBUTE7
, MEAAV.N_ATTRIBUTE8
, MEAAV.N_ATTRIBUTE9
, MEAAV.N_ATTRIBUTE10
, MEAAV.LAST_UPDATE_DATE
, MEAAV.LAST_UPDATED_BY
, MEAAV.CREATION_DATE
, MEAAV.CREATED_BY
, MEAAV.LAST_UPDATE_LOGIN
, MEAAV.REQUEST_ID
, MEAAV.PROGRAM_APPLICATION_ID
, MEAAV.PROGRAM_ID
, MEAAV.PROGRAM_UPDATE_DATE
, MEAAV.MAINTENANCE_OBJECT_ID
, MEAAV.MAINTENANCE_OBJECT_TYPE
FROM MTL_EAM_ASSET_ATTR_VALUES MEAAV
, MTL_EAM_ASSET_ATTR_GROUPS_V MEAAG
, CSI_ITEM_INSTANCES CII
WHERE MEAAG.DESCRIPTIVE_FLEX_CONTEXT_CODE = MEAAV.ATTRIBUTE_CATEGORY
AND MEAAG.ASSOCIATION_ID = MEAAV.ASSOCIATION_ID
AND CII.INSTANCE_ID = MEAAV.MAINTENANCE_OBJECT_ID
AND MEAAV.MAINTENANCE_OBJECT_TYPE = 3

Columns