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
, NULL CODE_COMBINATION_ID
, NULL SEGMENT1
, NULL SEGMENT2
, NULL SEGMENT3
, NULL SEGMENT4
, NULL SEGMENT5
, NULL SEGMENT6
, NULL SEGMENT7
, NULL SEGMENT8
, NULL SEGMENT9
, NULL SEGMENT10
, NULL SEGMENT11
, NULL SEGMENT12
, NULL SEGMENT13
, NULL SEGMENT14
, NULL SEGMENT15
, NULL SEGMENT16
, NULL SEGMENT17
, NULL SEGMENT18
, NULL SEGMENT19
, NULL SEGMENT20
, NULL SEGMENT21
, NULL SEGMENT22
, NULL SEGMENT23
, NULL SEGMENT24
, NULL SEGMENT25
, NULL SEGMENT26
, NULL SEGMENT27
, NULL SEGMENT28
, NULL SEGMENT29
, NULL SEGMENT30
, FB.SET_OF_BOOKS_ID SOB_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' UNION ALL 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
, NULL CODE_COMBINATION_ID
, NULL SEGMENT1
, NULL SEGMENT2
, NULL SEGMENT3
, NULL SEGMENT4
, NULL SEGMENT5
, NULL SEGMENT6
, NULL SEGMENT7
, NULL SEGMENT8
, NULL SEGMENT9
, NULL SEGMENT10
, NULL SEGMENT11
, NULL SEGMENT12
, NULL SEGMENT13
, NULL SEGMENT14
, NULL SEGMENT15
, NULL SEGMENT16
, NULL SEGMENT17
, NULL SEGMENT18
, NULL SEGMENT19
, NULL SEGMENT20
, NULL SEGMENT21
, NULL SEGMENT22
, NULL SEGMENT23
, NULL SEGMENT24
, NULL SEGMENT25
, NULL SEGMENT26
, NULL SEGMENT27
, NULL SEGMENT28
, NULL SEGMENT29
, NULL SEGMENT30
, DS.SET_OF_BOOKS_ID SOB_ID
FROM FA_MC_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 DS.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