View: FA_ADDITIONS_NON_SEC_VL

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_ADDITIONS_NON_SEC_VL

View Text

SELECT B.ROWID ROW_ID
, B.ASSET_ID ASSET_ID
, B.ASSET_NUMBER ASSET_NUMBER
, B.ASSET_KEY_CCID ASSET_KEY_CCID
, B.CURRENT_UNITS CURRENT_UNITS
, B.ASSET_TYPE ASSET_TYPE
, B.TAG_NUMBER TAG_NUMBER
, T.DESCRIPTION DESCRIPTION
, B.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, B.PARENT_ASSET_ID PARENT_ASSET_ID
, B.MANUFACTURER_NAME MANUFACTURER_NAME
, B.SERIAL_NUMBER SERIAL_NUMBER
, B.MODEL_NUMBER MODEL_NUMBER
, B.PROPERTY_TYPE_CODE PROPERTY_TYPE_CODE
, B.PROPERTY_1245_1250_CODE PROPERTY_1245_1250_CODE
, B.IN_USE_FLAG IN_USE_FLAG
, B.OWNED_LEASED OWNED_LEASED
, B.NEW_USED NEW_USED
, B.UNIT_ADJUSTMENT_FLAG UNIT_ADJUSTMENT_FLAG
, B.ADD_COST_JE_FLAG ADD_COST_JE_FLAG
, B.ATTRIBUTE1 ATTRIBUTE1
, B.ATTRIBUTE2 ATTRIBUTE2
, B.ATTRIBUTE3 ATTRIBUTE3
, B.ATTRIBUTE4 ATTRIBUTE4
, B.ATTRIBUTE5 ATTRIBUTE5
, B.ATTRIBUTE6 ATTRIBUTE6
, B.ATTRIBUTE7 ATTRIBUTE7
, B.ATTRIBUTE8 ATTRIBUTE8
, B.ATTRIBUTE9 ATTRIBUTE9
, B.ATTRIBUTE10 ATTRIBUTE10
, B.ATTRIBUTE11 ATTRIBUTE11
, B.ATTRIBUTE12 ATTRIBUTE12
, B.ATTRIBUTE13 ATTRIBUTE13
, B.ATTRIBUTE14 ATTRIBUTE14
, B.ATTRIBUTE15 ATTRIBUTE15
, B.ATTRIBUTE16 ATTRIBUTE16
, B.ATTRIBUTE17 ATTRIBUTE17
, B.ATTRIBUTE18 ATTRIBUTE18
, B.ATTRIBUTE19 ATTRIBUTE19
, B.ATTRIBUTE20 ATTRIBUTE20
, B.ATTRIBUTE21 ATTRIBUTE21
, B.ATTRIBUTE22 ATTRIBUTE22
, B.ATTRIBUTE23 ATTRIBUTE23
, B.ATTRIBUTE24 ATTRIBUTE24
, B.ATTRIBUTE25 ATTRIBUTE25
, B.ATTRIBUTE26 ATTRIBUTE26
, B.ATTRIBUTE27 ATTRIBUTE27
, B.ATTRIBUTE28 ATTRIBUTE28
, B.ATTRIBUTE29 ATTRIBUTE29
, B.ATTRIBUTE30 ATTRIBUTE30
, B.ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE
, B.CONTEXT CONTEXT
, B.LEASE_ID LEASE_ID
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, B.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, B.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, B.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, B.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, B.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, B.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, B.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, B.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, B.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, B.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, B.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, B.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, B.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, B.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, B.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, B.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, B.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, B.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, B.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, B.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, B.INVENTORIAL INVENTORIAL
, B.COMMITMENT
, B.INVESTMENT_LAW
FROM FA_ADDITIONS_B B
, FA_ADDITIONS_TL T
WHERE B.ASSET_ID = T.ASSET_ID
AND T.LANGUAGE = USERENV('LANG')

Columns