View: FA_FIN_INQRY_DEPRN_WEB_V

Product:	OFA - Assets
Description:	Depreciation history information
Implementation/DBA Data:	APPS.FA_FIN_INQRY_DEPRN_WEB_V

View Text

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

Columns