FA_ADDITIONS_VL

Details

• Schema: FUSION

• Object owner: FA

• Object type: VIEW

Columns

Name

ROW_ID ASSET_ID LEASE_ID ASSET_NUMBER ASSET_KEY_CCID CURRENT_UNITS ASSET_TYPE TAG_NUMBER DESCRIPTION ASSET_CATEGORY_ID PARENT_ASSET_ID MANUFACTURER_NAME SERIAL_NUMBER MODEL_NUMBER PROPERTY_TYPE_CODE PROPERTY_1245_1250_CODE IN_USE_FLAG OWNED_LEASED NEW_USED ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 OBJECT_VERSION_NUMBER ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_CATEGORY_CODE CONTEXT GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER6 GLOBAL_ATTRIBUTE_NUMBER7 GLOBAL_ATTRIBUTE_NUMBER8 GLOBAL_ATTRIBUTE_NUMBER9 GLOBAL_ATTRIBUTE_NUMBER10 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE6 GLOBAL_ATTRIBUTE_DATE7 GLOBAL_ATTRIBUTE_DATE8 GLOBAL_ATTRIBUTE_DATE9 GLOBAL_ATTRIBUTE_DATE10 GLOBAL_ATTRIBUTE_CATEGORY INVENTORIAL COMMITMENT INVESTMENT_LAW DISTRIBUTION_SOURCE_BOOK CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN INTANGIBLE_ASSET_FLAG

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.ASSET_ID, B.LEASE_ID, B.ASSET_NUMBER, B.ASSET_KEY_CCID, B.CURRENT_UNITS, B.ASSET_TYPE, B.TAG_NUMBER, T.DESCRIPTION, B.ASSET_CATEGORY_ID, B.PARENT_ASSET_ID, B.MANUFACTURER_NAME, B.SERIAL_NUMBER, B.MODEL_NUMBER, B.PROPERTY_TYPE_CODE, B.PROPERTY_1245_1250_CODE, B.IN_USE_FLAG, B.OWNED_LEASED, B.NEW_USED, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.OBJECT_VERSION_NUMBER, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.ATTRIBUTE16, B.ATTRIBUTE17, B.ATTRIBUTE18, B.ATTRIBUTE19, B.ATTRIBUTE20, B.ATTRIBUTE21, B.ATTRIBUTE22, B.ATTRIBUTE23, B.ATTRIBUTE24, B.ATTRIBUTE25, B.ATTRIBUTE26, B.ATTRIBUTE27, B.ATTRIBUTE28, B.ATTRIBUTE29, B.ATTRIBUTE30, B.ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5, B.ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5, B.ATTRIBUTE_CATEGORY_CODE, B.CONTEXT, B.GLOBAL_ATTRIBUTE1, B.GLOBAL_ATTRIBUTE2, B.GLOBAL_ATTRIBUTE3, B.GLOBAL_ATTRIBUTE4, B.GLOBAL_ATTRIBUTE5, B.GLOBAL_ATTRIBUTE6, B.GLOBAL_ATTRIBUTE7, B.GLOBAL_ATTRIBUTE8, B.GLOBAL_ATTRIBUTE9, B.GLOBAL_ATTRIBUTE10, B.GLOBAL_ATTRIBUTE11, B.GLOBAL_ATTRIBUTE12, B.GLOBAL_ATTRIBUTE13, B.GLOBAL_ATTRIBUTE14, B.GLOBAL_ATTRIBUTE15, B.GLOBAL_ATTRIBUTE16, B.GLOBAL_ATTRIBUTE17, B.GLOBAL_ATTRIBUTE18, B.GLOBAL_ATTRIBUTE19, B.GLOBAL_ATTRIBUTE20, B.GLOBAL_ATTRIBUTE_NUMBER1, B.GLOBAL_ATTRIBUTE_NUMBER2, B.GLOBAL_ATTRIBUTE_NUMBER3, B.GLOBAL_ATTRIBUTE_NUMBER4, B.GLOBAL_ATTRIBUTE_NUMBER5, B.GLOBAL_ATTRIBUTE_NUMBER6, B.GLOBAL_ATTRIBUTE_NUMBER7, B.GLOBAL_ATTRIBUTE_NUMBER8, B.GLOBAL_ATTRIBUTE_NUMBER9, B.GLOBAL_ATTRIBUTE_NUMBER10, B.GLOBAL_ATTRIBUTE_DATE1, B.GLOBAL_ATTRIBUTE_DATE2, B.GLOBAL_ATTRIBUTE_DATE3, B.GLOBAL_ATTRIBUTE_DATE4, B.GLOBAL_ATTRIBUTE_DATE5, B.GLOBAL_ATTRIBUTE_DATE6, B.GLOBAL_ATTRIBUTE_DATE7, B.GLOBAL_ATTRIBUTE_DATE8, B.GLOBAL_ATTRIBUTE_DATE9, B.GLOBAL_ATTRIBUTE_DATE10, B.GLOBAL_ATTRIBUTE_CATEGORY, B.INVENTORIAL, B.COMMITMENT, B.INVESTMENT_LAW, B.DISTRIBUTION_SOURCE_BOOK, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.INTANGIBLE_ASSET_FLAG FROM FA_ADDITIONS_B B, FA_ADDITIONS_TL T WHERE B.ASSET_ID = T.ASSET_ID AND T.LANGUAGE = USERENV('LANG')