View: OKX_AST_DPRTNS_V

Product:	OKX - Contracts Integration
Description:	This view contains Information regarding all the depreciation runs for an asset.
Implementation/DBA Data:	APPS.OKX_AST_DPRTNS_V

View Text

SELECT FADEP.ASSET_ID ID1
, FADEP.BOOK_TYPE_CODE||'
, '||TO_CHAR(FADEP.PERIOD_COUNTER) ID2
, FA.ASSET_NUMBER NAME
, FA.ASSET_NUMBER||'
, '||FADEP.BOOK_TYPE_CODE||'
, '||TO_CHAR(FADEP.PERIOD_COUNTER) DESCRIPTION
, FADEP.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FADEP.ASSET_ID ASSET_ID
, FADEP.DEPRN_RUN_DATE DEPRN_RUN_DATE
, FADEP.DEPRN_AMOUNT DEPRN_AMOUNT
, FADEP.YTD_DEPRN YTD_DEPRN
, FADEP.DEPRN_RESERVE DEPRN_RESERVE
, FADEP.DEPRN_SOURCE_CODE DEPRN_SOURCE_CODE
, FADEP.ADJUSTED_COST ADJUSTED_COST
, FADEP.BONUS_RATE BONUS_RATE
, FADEP.LTD_PRODUCTION LTD_PRODUCTION
, FADEP.PERIOD_COUNTER PERIOD_COUNTER
, FADEP.PRODUCTION PRODUCTION
, FADEP.REVAL_AMORTIZATION REVAL_AMORTIZATION
, FADEP.REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS
, FADEP.REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE
, FADEP.REVAL_RESERVE REVAL_RESERVE
, FADEP.YTD_PRODUCTION YTD_PRODUCTION
, FADEP.YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE
, FADEP.PRIOR_FY_EXPENSE PRIOR_FY_EXPENSE
, FADEP.BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT
, FADEP.BONUS_YTD_DEPRN BONUS_YTD_DEPRN
, FADEP.BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE
, FADEP.PRIOR_FY_BONUS_EXPENSE PRIOR_FY_BONUS_EXPENSE
, SYSDATE START_DATE_ACTIVE
, SYSDATE+1 END_DATE_ACTIVE
, 'A' STATUS
, NULL PRIMARY_UOM_CODE
FROM FA_DEPRN_SUMMARY FADEP
, FA_ADDITIONS_B FA
WHERE FADEP.ASSET_ID = FA.ASSET_ID

Columns