View: FA_DEPRN_WEB_V

Product:	OFA - Assets
Description:	Depreciation information for an asset in a given depreciation book
Implementation/DBA Data:	APPS.FA_DEPRN_WEB_V

View Text

SELECT AD.ASSET_ID ASSET_ID
, AD.ASSET_NUMBER
, AD.DESCRIPTION
, 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
, CAT.CONCATENATED_SEGMENTS CATEGORY
, GLCC.CONCATENATED_SEGMENTS ACCOUNTING_CONCATENATED
FROM FA_ADDITIONS AD
, FA_CATEGORIES_B_KFV CAT
, FA_DEPRN_PERIODS DP
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, FA_DISTRIBUTION_HISTORY DH
, GL_CODE_COMBINATIONS_KFV GLCC
, FA_DEPRN_DETAIL DD
WHERE AD.ASSET_ID = DD.ASSET_ID
AND AD.ASSET_CATEGORY_ID = CAT.CATEGORY_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 GLCC.CODE_COMBINATION_ID = (DH.CODE_COMBINATION_ID + 0)
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
, CAT.CONCATENATED_SEGMENTS
, GLCC.CONCATENATED_SEGMENTS UNION SELECT AD.ASSET_ID ASSET_ID
, AD.ASSET_NUMBER
, AD.DESCRIPTION
, 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
, CAT.CONCATENATED_SEGMENTS
, GLCC.CONCATENATED_SEGMENTS
FROM FA_ADDITIONS AD
, FA_CATEGORIES_B_KFV CAT
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, GL_CODE_COMBINATIONS_KFV GLCC
, 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 AD.ASSET_CATEGORY_ID = CAT.CATEGORY_ID
AND ADJ.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID GROUP BY AD.ASSET_ID
, PERIOD_COUNTER
, AD.ASSET_NUMBER
, AD.DESCRIPTION
, DP.BOOK_TYPE_CODE
, DP.PERIOD_NAME
, CAT.CONCATENATED_SEGMENTS
, GLCC.CONCATENATED_SEGMENTS

Columns