VIEW: INV.MTL_EAM_ASSET_ATTR_VALUES#

Source

View Text - Preformatted

select ASSOCIATION_ID ASSOCIATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SERIAL_NUMBER SERIAL_NUMBER, ORGANIZATION_ID ORGANIZATION_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, C_ATTRIBUTE1 C_ATTRIBUTE1, C_ATTRIBUTE2 C_ATTRIBUTE2, C_ATTRIBUTE3 C_ATTRIBUTE3, C_ATTRIBUTE4 C_ATTRIBUTE4, C_ATTRIBUTE5 C_ATTRIBUTE5, C_ATTRIBUTE6 C_ATTRIBUTE6, C_ATTRIBUTE7 C_ATTRIBUTE7, C_ATTRIBUTE8 C_ATTRIBUTE8, C_ATTRIBUTE9 C_ATTRIBUTE9, C_ATTRIBUTE10 C_ATTRIBUTE10, C_ATTRIBUTE11 C_ATTRIBUTE11, C_ATTRIBUTE12 C_ATTRIBUTE12, C_ATTRIBUTE13 C_ATTRIBUTE13, C_ATTRIBUTE14 C_ATTRIBUTE14, C_ATTRIBUTE15 C_ATTRIBUTE15, C_ATTRIBUTE16 C_ATTRIBUTE16, C_ATTRIBUTE17 C_ATTRIBUTE17, C_ATTRIBUTE18 C_ATTRIBUTE18, C_ATTRIBUTE19 C_ATTRIBUTE19, C_ATTRIBUTE20 C_ATTRIBUTE20, D_ATTRIBUTE1 D_ATTRIBUTE1, D_ATTRIBUTE2 D_ATTRIBUTE2, D_ATTRIBUTE3 D_ATTRIBUTE3, D_ATTRIBUTE4 D_ATTRIBUTE4, D_ATTRIBUTE5 D_ATTRIBUTE5, D_ATTRIBUTE6 D_ATTRIBUTE6, D_ATTRIBUTE7 D_ATTRIBUTE7, D_ATTRIBUTE8 D_ATTRIBUTE8, D_ATTRIBUTE9 D_ATTRIBUTE9, D_ATTRIBUTE10 D_ATTRIBUTE10, N_ATTRIBUTE1 N_ATTRIBUTE1, N_ATTRIBUTE2 N_ATTRIBUTE2, N_ATTRIBUTE3 N_ATTRIBUTE3, N_ATTRIBUTE4 N_ATTRIBUTE4, N_ATTRIBUTE5 N_ATTRIBUTE5, N_ATTRIBUTE6 N_ATTRIBUTE6, N_ATTRIBUTE7 N_ATTRIBUTE7, N_ATTRIBUTE8 N_ATTRIBUTE8, N_ATTRIBUTE10 N_ATTRIBUTE10, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, N_ATTRIBUTE9 N_ATTRIBUTE9, APPLICATION_ID APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEXFIELD_NAME, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID, CREATION_ORGANIZATION_ID CREATION_ORGANIZATION_ID from "INV"."MTL_EAM_ASSET_ATTR_VALUES"

View Text - HTML Formatted

SELECT ASSOCIATION_ID ASSOCIATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SERIAL_NUMBER SERIAL_NUMBER
, ORGANIZATION_ID ORGANIZATION_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, C_ATTRIBUTE1 C_ATTRIBUTE1
, C_ATTRIBUTE2 C_ATTRIBUTE2
, C_ATTRIBUTE3 C_ATTRIBUTE3
, C_ATTRIBUTE4 C_ATTRIBUTE4
, C_ATTRIBUTE5 C_ATTRIBUTE5
, C_ATTRIBUTE6 C_ATTRIBUTE6
, C_ATTRIBUTE7 C_ATTRIBUTE7
, C_ATTRIBUTE8 C_ATTRIBUTE8
, C_ATTRIBUTE9 C_ATTRIBUTE9
, C_ATTRIBUTE10 C_ATTRIBUTE10
, C_ATTRIBUTE11 C_ATTRIBUTE11
, C_ATTRIBUTE12 C_ATTRIBUTE12
, C_ATTRIBUTE13 C_ATTRIBUTE13
, C_ATTRIBUTE14 C_ATTRIBUTE14
, C_ATTRIBUTE15 C_ATTRIBUTE15
, C_ATTRIBUTE16 C_ATTRIBUTE16
, C_ATTRIBUTE17 C_ATTRIBUTE17
, C_ATTRIBUTE18 C_ATTRIBUTE18
, C_ATTRIBUTE19 C_ATTRIBUTE19
, C_ATTRIBUTE20 C_ATTRIBUTE20
, D_ATTRIBUTE1 D_ATTRIBUTE1
, D_ATTRIBUTE2 D_ATTRIBUTE2
, D_ATTRIBUTE3 D_ATTRIBUTE3
, D_ATTRIBUTE4 D_ATTRIBUTE4
, D_ATTRIBUTE5 D_ATTRIBUTE5
, D_ATTRIBUTE6 D_ATTRIBUTE6
, D_ATTRIBUTE7 D_ATTRIBUTE7
, D_ATTRIBUTE8 D_ATTRIBUTE8
, D_ATTRIBUTE9 D_ATTRIBUTE9
, D_ATTRIBUTE10 D_ATTRIBUTE10
, N_ATTRIBUTE1 N_ATTRIBUTE1
, N_ATTRIBUTE2 N_ATTRIBUTE2
, N_ATTRIBUTE3 N_ATTRIBUTE3
, N_ATTRIBUTE4 N_ATTRIBUTE4
, N_ATTRIBUTE5 N_ATTRIBUTE5
, N_ATTRIBUTE6 N_ATTRIBUTE6
, N_ATTRIBUTE7 N_ATTRIBUTE7
, N_ATTRIBUTE8 N_ATTRIBUTE8
, N_ATTRIBUTE10 N_ATTRIBUTE10
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, N_ATTRIBUTE9 N_ATTRIBUTE9
, APPLICATION_ID APPLICATION_ID
, DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEXFIELD_NAME
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE
, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID
, CREATION_ORGANIZATION_ID CREATION_ORGANIZATION_ID
FROM "INV"."MTL_EAM_ASSET_ATTR_VALUES"