VIEW: APPS.MTL_EAM_ASSET_ATTR_VALUES_V

Source

View Text - Preformatted

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, cii.last_vld_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

View Text - HTML Formatted

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
, CII.LAST_VLD_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