VIEW: APPS.FA_TRANSFER_INVOICES_V

Source

View Text - Preformatted

SELECT AD.ROWID ROW_ID , AD.ASSET_ID , AD.ASSET_NUMBER , AD.ASSET_TYPE , AD.ASSET_KEY_CCID , AD.TAG_NUMBER , ADT.DESCRIPTION , AD.CURRENT_UNITS , AD.MANUFACTURER_NAME , AD.SERIAL_NUMBER , AD.MODEL_NUMBER , AD.PROPERTY_TYPE_CODE , AD.IN_USE_FLAG , AD.ASSET_CATEGORY_ID , AD.ATTRIBUTE1 , AD.ATTRIBUTE2 , AD.ATTRIBUTE3 , AD.ATTRIBUTE4 , AD.ATTRIBUTE5 , AD.ATTRIBUTE6 , AD.ATTRIBUTE7 , AD.ATTRIBUTE8 , AD.ATTRIBUTE9 , AD.ATTRIBUTE10 , AD.ATTRIBUTE11 , AD.ATTRIBUTE12 , AD.ATTRIBUTE13 , AD.ATTRIBUTE14 , AD.ATTRIBUTE15 , AD.ATTRIBUTE16 , AD.ATTRIBUTE17 , AD.ATTRIBUTE18 , AD.ATTRIBUTE19 , AD.ATTRIBUTE20 , AD.ATTRIBUTE21 , AD.ATTRIBUTE22 , AD.ATTRIBUTE23 , AD.ATTRIBUTE24 , AD.ATTRIBUTE25 , AD.ATTRIBUTE26 , AD.ATTRIBUTE27 , AD.ATTRIBUTE28 , AD.ATTRIBUTE29 , AD.ATTRIBUTE30 , AD.ATTRIBUTE_CATEGORY_CODE , AD.CONTEXT , BK.BOOK_TYPE_CODE , BK.COST , BK.ORIGINAL_COST , BK.SALVAGE_VALUE , BK.RECOVERABLE_COST , BK.ADJUSTED_RATE , BK.CEILING_NAME , BK.BONUS_RULE , BK.DEPRN_METHOD_CODE , BK.LIFE_IN_MONTHS , BK.DATE_PLACED_IN_SERVICE , BK.PRORATE_DATE , BK.DEPRN_START_DATE , BK.DEPRECIATE_FLAG , BK.RATE_ADJUSTMENT_FACTOR , BK.REVAL_AMORTIZATION_BASIS , BK.PRODUCTION_CAPACITY , BK.ITC_BASIS , BK.ITC_AMOUNT_ID , BK.PERIOD_COUNTER_FULLY_RETIRED FROM FA_ADDITIONS_B AD, FA_ADDITIONS_TL ADT, FA_BOOK_CONTROLS BC, FA_BOOKS BK WHERE BC.BOOK_CLASS = 'CORPORATE' AND NVL(BC.DATE_INEFFECTIVE, SYSDATE+1) > SYSDATE AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BK.ASSET_ID = AD.ASSET_ID AND BK.DATE_INEFFECTIVE IS NULL AND ADT.ASSET_ID = AD.ASSET_ID AND ADT.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT AD.ROWID ROW_ID
, AD.ASSET_ID
, AD.ASSET_NUMBER
, AD.ASSET_TYPE
, AD.ASSET_KEY_CCID
, AD.TAG_NUMBER
, ADT.DESCRIPTION
, AD.CURRENT_UNITS
, AD.MANUFACTURER_NAME
, AD.SERIAL_NUMBER
, AD.MODEL_NUMBER
, AD.PROPERTY_TYPE_CODE
, AD.IN_USE_FLAG
, AD.ASSET_CATEGORY_ID
, AD.ATTRIBUTE1
, AD.ATTRIBUTE2
, AD.ATTRIBUTE3
, AD.ATTRIBUTE4
, AD.ATTRIBUTE5
, AD.ATTRIBUTE6
, AD.ATTRIBUTE7
, AD.ATTRIBUTE8
, AD.ATTRIBUTE9
, AD.ATTRIBUTE10
, AD.ATTRIBUTE11
, AD.ATTRIBUTE12
, AD.ATTRIBUTE13
, AD.ATTRIBUTE14
, AD.ATTRIBUTE15
, AD.ATTRIBUTE16
, AD.ATTRIBUTE17
, AD.ATTRIBUTE18
, AD.ATTRIBUTE19
, AD.ATTRIBUTE20
, AD.ATTRIBUTE21
, AD.ATTRIBUTE22
, AD.ATTRIBUTE23
, AD.ATTRIBUTE24
, AD.ATTRIBUTE25
, AD.ATTRIBUTE26
, AD.ATTRIBUTE27
, AD.ATTRIBUTE28
, AD.ATTRIBUTE29
, AD.ATTRIBUTE30
, AD.ATTRIBUTE_CATEGORY_CODE
, AD.CONTEXT
, BK.BOOK_TYPE_CODE
, BK.COST
, BK.ORIGINAL_COST
, BK.SALVAGE_VALUE
, BK.RECOVERABLE_COST
, BK.ADJUSTED_RATE
, BK.CEILING_NAME
, BK.BONUS_RULE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.DATE_PLACED_IN_SERVICE
, BK.PRORATE_DATE
, BK.DEPRN_START_DATE
, BK.DEPRECIATE_FLAG
, BK.RATE_ADJUSTMENT_FACTOR
, BK.REVAL_AMORTIZATION_BASIS
, BK.PRODUCTION_CAPACITY
, BK.ITC_BASIS
, BK.ITC_AMOUNT_ID
, BK.PERIOD_COUNTER_FULLY_RETIRED
FROM FA_ADDITIONS_B AD
, FA_ADDITIONS_TL ADT
, FA_BOOK_CONTROLS BC
, FA_BOOKS BK
WHERE BC.BOOK_CLASS = 'CORPORATE'
AND NVL(BC.DATE_INEFFECTIVE
, SYSDATE+1) > SYSDATE
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.ASSET_ID = AD.ASSET_ID
AND BK.DATE_INEFFECTIVE IS NULL
AND ADT.ASSET_ID = AD.ASSET_ID
AND ADT.LANGUAGE = USERENV('LANG')