VIEW: APPS.FA_FINANCIAL_INQUIRY_DEPRN_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'