VIEW: APPS.FA_FINANCIAL_INQUIRY_DEPRN_H_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 - nvl(ds.bonus_deprn_adjustment_amount,0),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 from fa_deprn_summary_h 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 - NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0)
, 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
FROM FA_DEPRN_SUMMARY_H 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'