View: FAFV_DEPRECIATIONS

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FAFV_DEPRECIATIONS

View Text

SELECT DD.DEPRN_RUN_DATE
, DD.DEPRN_AMOUNT
, DD.YTD_DEPRN
, DD.DEPRN_RESERVE
, DD.COST
, DD.DEPRN_ADJUSTMENT_AMOUNT
, DD.REVAL_DEPRN_EXPENSE
, DD.REVAL_RESERVE
, DD.YTD_REVAL_DEPRN_EXPENSE
, DD.ASSET_ID
, AD.ASSET_NUMBER
, DD.BOOK_TYPE_CODE
, DD.PERIOD_COUNTER
, DP.PERIOD_NAME
, DD.DISTRIBUTION_ID
, DH.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC' CODE_COMBINATION
FROM FA_DEPRN_DETAIL DD
, FA_BOOKS BK
, FA_DEPRN_PERIODS DP
, FA_DISTRIBUTION_HISTORY DH
, GL_CODE_COMBINATIONS GCC
, FA_ADDITIONS AD
WHERE DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
AND DD.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER
AND DD.ASSET_ID = AD.ASSET_ID
AND BK.TRANSACTION_HEADER_ID_OUT IS NULL
AND DH.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND BK.ASSET_ID = AD.ASSET_ID
AND BK.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE WITH READ ONLY

Columns