VIEW: APPS.FA_FIN_INQRY_DEPRN_WEB_V

Source

View Text - Preformatted

SELECT AD.ASSET_ID ASSET_ID , AD.ASSET_NUMBER||' - '||AD.DESCRIPTION ASSET_NUMBER , DP.BOOK_TYPE_CODE BOOK_TYPE_CODE , DP.PERIOD_COUNTER PERIOD_COUNTER , DP.PERIOD_NAME PERIOD_ENTERED , TO_CHAR(SUM(DD.DEPRN_AMOUNT), FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE),30)) DEPRN_AMOUNT , TO_CHAR(SUM(DD.REVAL_AMORTIZATION), FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE),30)) REVAL_AMORTIZATION , DH.CODE_COMBINATION_ID , CC.SEGMENT1 , CC.SEGMENT2 , CC.SEGMENT3 , CC.SEGMENT4 , CC.SEGMENT5 , CC.SEGMENT6 , CC.SEGMENT7 , CC.SEGMENT8 , CC.SEGMENT9 , CC.SEGMENT10 , CC.SEGMENT11 , CC.SEGMENT12 , CC.SEGMENT13 , CC.SEGMENT14 , CC.SEGMENT15 , CC.SEGMENT16 , CC.SEGMENT17 , CC.SEGMENT18 , CC.SEGMENT19 , CC.SEGMENT20 , CC.SEGMENT21 , CC.SEGMENT22 , CC.SEGMENT23 , CC.SEGMENT24 , CC.SEGMENT25 , CC.SEGMENT26 , CC.SEGMENT27 , CC.SEGMENT28 , CC.SEGMENT29 , CC.SEGMENT30 , CC.CONCATENATED_SEGMENTS ACCT_CONC_SEGMENTS FROM FA_ADDITIONS AD, FA_DEPRN_PERIODS DP, FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB, GL_CODE_COMBINATIONS_KFV CC, FA_DISTRIBUTION_HISTORY DH, FA_DEPRN_DETAIL DD WHERE AD.ASSET_ID = DD.ASSET_ID AND DD.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER AND DD.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE AND DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND CC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID AND DD.DEPRN_SOURCE_CODE = 'D' GROUP BY AD.ASSET_ID, DP.PERIOD_COUNTER, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION, DP.BOOK_TYPE_CODE, DP.PERIOD_NAME, DH.CODE_COMBINATION_ID, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, CC.CONCATENATED_SEGMENTS UNION SELECT AD.ASSET_ID ASSET_ID, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION ASSET_NUMBER, DP.BOOK_TYPE_CODE BOOK_TYPE_CODE, DP.PERIOD_COUNTER PERIOD_COUNTER, DP.PERIOD_NAME PERIOD_ENTERED, TO_CHAR(NVL(SUM(DECODE(ADJ.ADJUSTMENT_TYPE, 'EXPENSE', DECODE(ADJ.DEBIT_CREDIT_FLAG, 'DR', ADJ.ADJUSTMENT_AMOUNT, 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT))),0), FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE),30)) DEPRN_AMOUNT, TO_CHAR(0, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE),30)) REVAL_AMORTIZATION, ADJ.CODE_COMBINATION_ID, CC.SEGMENT1, CC.SEGMENT2, CC.SEGMENT3, CC.SEGMENT4, CC.SEGMENT5, CC.SEGMENT6, CC.SEGMENT7, CC.SEGMENT8, CC.SEGMENT9, CC.SEGMENT10, CC.SEGMENT11, CC.SEGMENT12, CC.SEGMENT13, CC.SEGMENT14, CC.SEGMENT15, CC.SEGMENT16, CC.SEGMENT17, CC.SEGMENT18, CC.SEGMENT19, CC.SEGMENT20, CC.SEGMENT21, CC.SEGMENT22, CC.SEGMENT23, CC.SEGMENT24, CC.SEGMENT25, CC.SEGMENT26, CC.SEGMENT27, CC.SEGMENT28, CC.SEGMENT29, CC.SEGMENT30, CC.CONCATENATED_SEGMENTS ACCT_CONC_SEGMENTS FROM FA_ADDITIONS AD, GL_CODE_COMBINATIONS_KFV CC, FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB, FA_DEPRN_PERIODS DP, FA_ADJUSTMENTS ADJ WHERE ADJ.SOURCE_TYPE_CODE='DEPRECIATION' AND ADJ.ADJUSTMENT_TYPE='EXPENSE' AND ADJ.BOOK_TYPE_CODE=DP.BOOK_TYPE_CODE AND ADJ.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID AND ADJ.PERIOD_COUNTER_CREATED = DP.PERIOD_COUNTER AND DP.PERIOD_CLOSE_DATE IS NULL AND ADJ.ASSET_ID=AD.ASSET_ID AND ADJ.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID GROUP BY AD.ASSET_ID, PERIOD_COUNTER, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION, DP.BOOK_TYPE_CODE, DP.PERIOD_NAME, ADJ.CODE_COMBINATION_ID, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20, SEGMENT21, SEGMENT22, SEGMENT23, SEGMENT24, SEGMENT25, SEGMENT26, SEGMENT27, SEGMENT28, SEGMENT29, SEGMENT30, CC.CONCATENATED_SEGMENTS

View Text - HTML Formatted

SELECT AD.ASSET_ID ASSET_ID
, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION ASSET_NUMBER
, DP.BOOK_TYPE_CODE BOOK_TYPE_CODE
, DP.PERIOD_COUNTER PERIOD_COUNTER
, DP.PERIOD_NAME PERIOD_ENTERED
, TO_CHAR(SUM(DD.DEPRN_AMOUNT)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE)
, 30)) DEPRN_AMOUNT
, TO_CHAR(SUM(DD.REVAL_AMORTIZATION)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE)
, 30)) REVAL_AMORTIZATION
, DH.CODE_COMBINATION_ID
, CC.SEGMENT1
, CC.SEGMENT2
, CC.SEGMENT3
, CC.SEGMENT4
, CC.SEGMENT5
, CC.SEGMENT6
, CC.SEGMENT7
, CC.SEGMENT8
, CC.SEGMENT9
, CC.SEGMENT10
, CC.SEGMENT11
, CC.SEGMENT12
, CC.SEGMENT13
, CC.SEGMENT14
, CC.SEGMENT15
, CC.SEGMENT16
, CC.SEGMENT17
, CC.SEGMENT18
, CC.SEGMENT19
, CC.SEGMENT20
, CC.SEGMENT21
, CC.SEGMENT22
, CC.SEGMENT23
, CC.SEGMENT24
, CC.SEGMENT25
, CC.SEGMENT26
, CC.SEGMENT27
, CC.SEGMENT28
, CC.SEGMENT29
, CC.SEGMENT30
, CC.CONCATENATED_SEGMENTS ACCT_CONC_SEGMENTS
FROM FA_ADDITIONS AD
, FA_DEPRN_PERIODS DP
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, GL_CODE_COMBINATIONS_KFV CC
, FA_DISTRIBUTION_HISTORY DH
, FA_DEPRN_DETAIL DD
WHERE AD.ASSET_ID = DD.ASSET_ID
AND DD.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER
AND DD.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
AND CC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID
AND DD.DEPRN_SOURCE_CODE = 'D' GROUP BY AD.ASSET_ID
, DP.PERIOD_COUNTER
, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION
, DP.BOOK_TYPE_CODE
, DP.PERIOD_NAME
, DH.CODE_COMBINATION_ID
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, CC.CONCATENATED_SEGMENTS UNION SELECT AD.ASSET_ID ASSET_ID
, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION ASSET_NUMBER
, DP.BOOK_TYPE_CODE BOOK_TYPE_CODE
, DP.PERIOD_COUNTER PERIOD_COUNTER
, DP.PERIOD_NAME PERIOD_ENTERED
, TO_CHAR(NVL(SUM(DECODE(ADJ.ADJUSTMENT_TYPE
, 'EXPENSE'
, DECODE(ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, ADJ.ADJUSTMENT_AMOUNT
, 'CR'
, -1 * ADJ.ADJUSTMENT_AMOUNT)))
, 0)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE)
, 30)) DEPRN_AMOUNT
, TO_CHAR(0
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(MAX(GLSB.CURRENCY_CODE)
, 30)) REVAL_AMORTIZATION
, ADJ.CODE_COMBINATION_ID
, CC.SEGMENT1
, CC.SEGMENT2
, CC.SEGMENT3
, CC.SEGMENT4
, CC.SEGMENT5
, CC.SEGMENT6
, CC.SEGMENT7
, CC.SEGMENT8
, CC.SEGMENT9
, CC.SEGMENT10
, CC.SEGMENT11
, CC.SEGMENT12
, CC.SEGMENT13
, CC.SEGMENT14
, CC.SEGMENT15
, CC.SEGMENT16
, CC.SEGMENT17
, CC.SEGMENT18
, CC.SEGMENT19
, CC.SEGMENT20
, CC.SEGMENT21
, CC.SEGMENT22
, CC.SEGMENT23
, CC.SEGMENT24
, CC.SEGMENT25
, CC.SEGMENT26
, CC.SEGMENT27
, CC.SEGMENT28
, CC.SEGMENT29
, CC.SEGMENT30
, CC.CONCATENATED_SEGMENTS ACCT_CONC_SEGMENTS
FROM FA_ADDITIONS AD
, GL_CODE_COMBINATIONS_KFV CC
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, FA_DEPRN_PERIODS DP
, FA_ADJUSTMENTS ADJ
WHERE ADJ.SOURCE_TYPE_CODE='DEPRECIATION'
AND ADJ.ADJUSTMENT_TYPE='EXPENSE'
AND ADJ.BOOK_TYPE_CODE=DP.BOOK_TYPE_CODE
AND ADJ.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND ADJ.PERIOD_COUNTER_CREATED = DP.PERIOD_COUNTER
AND DP.PERIOD_CLOSE_DATE IS NULL
AND ADJ.ASSET_ID=AD.ASSET_ID
AND ADJ.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID GROUP BY AD.ASSET_ID
, PERIOD_COUNTER
, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION
, DP.BOOK_TYPE_CODE
, DP.PERIOD_NAME
, ADJ.CODE_COMBINATION_ID
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, CC.CONCATENATED_SEGMENTS