eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 -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 , 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' AND ((A.ASSET_TYPE = 'GROUP' AND EXISTS (select bk.transaction_header_id_in from fa_books bk where bk.ASSET_ID = DS.ASSET_ID and bk.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE and nvl(member_rollup_flag, 'N') = 'N' and bk.transaction_header_id_out is null)) OR A.ASSET_TYPE <> 'GROUP') 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' AND ((A.ASSET_TYPE = 'GROUP' AND EXISTS (select bk.transaction_header_id_in from fa_mc_books bk where bk.ASSET_ID = DS.ASSET_ID and bk.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE and nvl(member_rollup_flag, 'N') = 'N' and bk.transaction_header_id_out is null and bk.set_of_books_id = ds.set_of_books_id)) OR A.ASSET_TYPE <> 'GROUP') union all SELECT a.asset_id, a.asset_number, dp.period_counter, dp.period_name PERIOD_ENTERED, null deprn_run_date, dp.book_type_code, SUM(ds.deprn_amount - (nvl(ds.deprn_adjustment_amount,0) - nvl(ds.bonus_deprn_adjustment_amount,0)) - NVL(ds.bonus_deprn_amount,0) ) DEPRN_AMOUNT, SUM( nvl(ds.deprn_adjustment_amount,0) - nvl(ds.bonus_deprn_adjustment_amount,0) ) ADJUSTMENT_AMOUNT, SUM( nvl(ds.bonus_deprn_amount -nvl(ds.bonus_deprn_adjustment_amount,0),0) ) BONUS_DEPRN_AMOUNT, SUM(nvl(ds.bonus_deprn_adjustment_amount,0) ) BONUS_ADJUSTMENT_AMOUNT, SUM( nvl(ds.reval_amortization,0) ) REVAL_AMORTIZATION, SUM(nvl(ds.deprn_amount,0)) TOTAL_DEPRN_AMOUNT, dp.xla_conversion_status, null 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_ADDITIONS_B A, FA_BOOKS BKM, FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS ,fa_book_controls fb, gl_sets_of_books glsb WHERE DS.ASSET_ID = BKM.ASSET_ID AND BKM.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE AND BKM.TRANSACTION_HEADER_ID_OUT IS NULL AND BKM.GROUP_ASSET_ID = A.ASSET_ID AND nvl(BKM.member_rollup_flag, 'N') = 'Y' AND DS.PERIOD_COUNTER = DP.PERIOD_COUNTER AND DS.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE AND DS.DEPRN_SOURCE_CODE <> 'BOOKS' and fb.book_type_code = dp.book_type_code and fb.set_of_books_id = glsb.set_of_books_id and fb.date_ineffective is null AND (A.ASSET_TYPE = 'GROUP' AND EXISTS (select bk.transaction_header_id_in from fa_books bk where bk.ASSET_ID = A.ASSET_ID and bk.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE and nvl(member_rollup_flag, 'N') = 'Y' and bk.transaction_header_id_out is null)) group by a.asset_id, a.asset_number,dp.period_counter,dp.period_name, dp.book_type_code, dp.xla_conversion_status,fb.set_of_books_id union all SELECT a.asset_id, a.asset_number, dp.period_counter, dp.period_name PERIOD_ENTERED, null deprn_run_date, dp.book_type_code, SUM(ds.deprn_amount - (nvl(ds.deprn_adjustment_amount,0) - nvl(ds.bonus_deprn_adjustment_amount,0)) - NVL(ds.bonus_deprn_amount,0) ) DEPRN_AMOUNT, SUM( nvl(ds.deprn_adjustment_amount,0) - nvl(ds.bonus_deprn_adjustment_amount,0) ) ADJUSTMENT_AMOUNT, SUM( nvl(ds.bonus_deprn_amount -nvl(ds.bonus_deprn_adjustment_amount,0),0) ) BONUS_DEPRN_AMOUNT, SUM(nvl(ds.bonus_deprn_adjustment_amount,0) ) BONUS_ADJUSTMENT_AMOUNT, SUM( nvl(ds.reval_amortization,0) ) REVAL_AMORTIZATION, SUM(nvl(ds.deprn_amount,0)) TOTAL_DEPRN_AMOUNT, dp.xla_conversion_status, null 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_ADDITIONS_B A, FA_MC_BOOKS BKM, FA_DEPRN_PERIODS DP, FA_MC_DEPRN_SUMMARY DS ,fa_mc_book_controls fb, gl_sets_of_books glsb WHERE DS.ASSET_ID = BKM.ASSET_ID AND BKM.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE AND BKM.set_of_books_id = glsb.set_of_books_id AND BKM.TRANSACTION_HEADER_ID_OUT IS NULL AND BKM.GROUP_ASSET_ID = A.ASSET_ID AND nvl(BKM.member_rollup_flag, 'N') = 'Y' AND DS.PERIOD_COUNTER = DP.PERIOD_COUNTER AND DS.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE AND DS.DEPRN_SOURCE_CODE <> 'BOOKS' and fb.book_type_code = dp.book_type_code and fb.set_of_books_id = glsb.set_of_books_id AND ds.set_of_books_id = glsb.set_of_books_id AND (A.ASSET_TYPE = 'GROUP' AND EXISTS (select bk.transaction_header_id_in from fa_mc_books bk where bk.ASSET_ID = A.ASSET_ID and bk.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE and nvl(member_rollup_flag, 'N') = 'Y' and bk.transaction_header_id_out is null and bk.set_of_books_id = fb.set_of_books_id)) group by a.asset_id, a.asset_number,dp.period_counter,dp.period_name, dp.book_type_code, dp.xla_conversion_status,fb.set_of_books_id

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
, 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'
AND ((A.ASSET_TYPE = 'GROUP'
AND EXISTS (SELECT BK.TRANSACTION_HEADER_ID_IN
FROM FA_BOOKS BK
WHERE BK.ASSET_ID = DS.ASSET_ID
AND BK.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND NVL(MEMBER_ROLLUP_FLAG
, 'N') = 'N'
AND BK.TRANSACTION_HEADER_ID_OUT IS NULL)) OR A.ASSET_TYPE <> 'GROUP') 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'
AND ((A.ASSET_TYPE = 'GROUP'
AND EXISTS (SELECT BK.TRANSACTION_HEADER_ID_IN
FROM FA_MC_BOOKS BK
WHERE BK.ASSET_ID = DS.ASSET_ID
AND BK.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND NVL(MEMBER_ROLLUP_FLAG
, 'N') = 'N'
AND BK.TRANSACTION_HEADER_ID_OUT IS NULL
AND BK.SET_OF_BOOKS_ID = DS.SET_OF_BOOKS_ID)) OR A.ASSET_TYPE <> 'GROUP') UNION ALL SELECT A.ASSET_ID
, A.ASSET_NUMBER
, DP.PERIOD_COUNTER
, DP.PERIOD_NAME PERIOD_ENTERED
, NULL DEPRN_RUN_DATE
, DP.BOOK_TYPE_CODE
, SUM(DS.DEPRN_AMOUNT - (NVL(DS.DEPRN_ADJUSTMENT_AMOUNT
, 0) - NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0)) - NVL(DS.BONUS_DEPRN_AMOUNT
, 0) ) DEPRN_AMOUNT
, SUM( NVL(DS.DEPRN_ADJUSTMENT_AMOUNT
, 0) - NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0) ) ADJUSTMENT_AMOUNT
, SUM( NVL(DS.BONUS_DEPRN_AMOUNT -NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0)
, 0) ) BONUS_DEPRN_AMOUNT
, SUM(NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0) ) BONUS_ADJUSTMENT_AMOUNT
, SUM( NVL(DS.REVAL_AMORTIZATION
, 0) ) REVAL_AMORTIZATION
, SUM(NVL(DS.DEPRN_AMOUNT
, 0)) TOTAL_DEPRN_AMOUNT
, DP.XLA_CONVERSION_STATUS
, NULL 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_ADDITIONS_B A
, FA_BOOKS BKM
, FA_DEPRN_PERIODS DP
, FA_DEPRN_SUMMARY DS
, FA_BOOK_CONTROLS FB
, GL_SETS_OF_BOOKS GLSB
WHERE DS.ASSET_ID = BKM.ASSET_ID
AND BKM.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
AND BKM.TRANSACTION_HEADER_ID_OUT IS NULL
AND BKM.GROUP_ASSET_ID = A.ASSET_ID
AND NVL(BKM.MEMBER_ROLLUP_FLAG
, 'N') = 'Y'
AND DS.PERIOD_COUNTER = DP.PERIOD_COUNTER
AND DS.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND DS.DEPRN_SOURCE_CODE <> 'BOOKS'
AND FB.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND FB.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND FB.DATE_INEFFECTIVE IS NULL
AND (A.ASSET_TYPE = 'GROUP'
AND EXISTS (SELECT BK.TRANSACTION_HEADER_ID_IN
FROM FA_BOOKS BK
WHERE BK.ASSET_ID = A.ASSET_ID
AND BK.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND NVL(MEMBER_ROLLUP_FLAG
, 'N') = 'Y'
AND BK.TRANSACTION_HEADER_ID_OUT IS NULL)) GROUP BY A.ASSET_ID
, A.ASSET_NUMBER
, DP.PERIOD_COUNTER
, DP.PERIOD_NAME
, DP.BOOK_TYPE_CODE
, DP.XLA_CONVERSION_STATUS
, FB.SET_OF_BOOKS_ID UNION ALL SELECT A.ASSET_ID
, A.ASSET_NUMBER
, DP.PERIOD_COUNTER
, DP.PERIOD_NAME PERIOD_ENTERED
, NULL DEPRN_RUN_DATE
, DP.BOOK_TYPE_CODE
, SUM(DS.DEPRN_AMOUNT - (NVL(DS.DEPRN_ADJUSTMENT_AMOUNT
, 0) - NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0)) - NVL(DS.BONUS_DEPRN_AMOUNT
, 0) ) DEPRN_AMOUNT
, SUM( NVL(DS.DEPRN_ADJUSTMENT_AMOUNT
, 0) - NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0) ) ADJUSTMENT_AMOUNT
, SUM( NVL(DS.BONUS_DEPRN_AMOUNT -NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0)
, 0) ) BONUS_DEPRN_AMOUNT
, SUM(NVL(DS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, 0) ) BONUS_ADJUSTMENT_AMOUNT
, SUM( NVL(DS.REVAL_AMORTIZATION
, 0) ) REVAL_AMORTIZATION
, SUM(NVL(DS.DEPRN_AMOUNT
, 0)) TOTAL_DEPRN_AMOUNT
, DP.XLA_CONVERSION_STATUS
, NULL 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_ADDITIONS_B A
, FA_MC_BOOKS BKM
, FA_DEPRN_PERIODS DP
, FA_MC_DEPRN_SUMMARY DS
, FA_MC_BOOK_CONTROLS FB
, GL_SETS_OF_BOOKS GLSB
WHERE DS.ASSET_ID = BKM.ASSET_ID
AND BKM.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
AND BKM.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND BKM.TRANSACTION_HEADER_ID_OUT IS NULL
AND BKM.GROUP_ASSET_ID = A.ASSET_ID
AND NVL(BKM.MEMBER_ROLLUP_FLAG
, 'N') = 'Y'
AND DS.PERIOD_COUNTER = DP.PERIOD_COUNTER
AND DS.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND DS.DEPRN_SOURCE_CODE <> 'BOOKS'
AND FB.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND FB.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND DS.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND (A.ASSET_TYPE = 'GROUP'
AND EXISTS (SELECT BK.TRANSACTION_HEADER_ID_IN
FROM FA_MC_BOOKS BK
WHERE BK.ASSET_ID = A.ASSET_ID
AND BK.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND NVL(MEMBER_ROLLUP_FLAG
, 'N') = 'Y'
AND BK.TRANSACTION_HEADER_ID_OUT IS NULL
AND BK.SET_OF_BOOKS_ID = FB.SET_OF_BOOKS_ID)) GROUP BY A.ASSET_ID
, A.ASSET_NUMBER
, DP.PERIOD_COUNTER
, DP.PERIOD_NAME
, DP.BOOK_TYPE_CODE
, DP.XLA_CONVERSION_STATUS
, FB.SET_OF_BOOKS_ID