VIEW: APPS.FA_ADDITIONS_NON_SEC_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')