View: FA_FINANCIAL_INQUIRY_DEPRN_V

Product:	OFA - Assets
Description:	Depreciation history information
Implementation/DBA Data:	APPS.FA_FINANCIAL_INQUIRY_DEPRN_V

View Text

SELECT A.ASSET_ID
, A.ASSET_NUMBER
, DS.PERIOD_COUNTER
, DP.PERIOD_NAME PERIOD_ENTERED
, DS.DEPRN_RUN_DATE
, DS.BOOK_TYPE_CODE
, DS.DEPRN_AMOUNT - (NVL(DS.DEPRN_ADJUSTMENT_AMOUNT
, 0) - NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0)) - NVL(DS.BONUS_DEPRN_AMOUNT
, 0) DEPRN_AMOUNT
, NVL(DS.DEPRN_ADJUSTMENT_AMOUNT
, 0) - NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0) ADJUSTMENT_AMOUNT
, NVL(DS.BONUS_DEPRN_AMOUNT - DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0) BONUS_DEPRN_AMOUNT
, NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0) BONUS_ADJUSTMENT_AMOUNT
, NVL(DS.REVAL_AMORTIZATION
, 0) REVAL_AMORTIZATION
, DS.DEPRN_AMOUNT TOTAL_DEPRN_AMOUNT
, DP.XLA_CONVERSION_STATUS
, DS.DEPRN_RUN_ID
FROM FA_DEPRN_SUMMARY DS
, FA_ADDITIONS_B A
, FA_DEPRN_PERIODS DP
, FA_BOOK_CONTROLS FB
, GL_SETS_OF_BOOKS GLSB
WHERE FB.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
AND FB.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND DS.ASSET_ID = A.ASSET_ID
AND DS.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND DS.PERIOD_COUNTER = DP.PERIOD_COUNTER
AND DS.DEPRN_SOURCE_CODE <> 'BOOKS'

Columns