VIEW: APPS.FAFV_DEPRECIATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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