Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_DEPRN_SUMMARY_H_MRC_V |
SELECT FMCDS.SET_OF_BOOKS_ID
, FMCDS.BOOK_TYPE_CODE
, FMCDS.ASSET_ID
, FMCDS.DEPRN_RUN_DATE
, FMCDS.DEPRN_AMOUNT
, FMCDS.YTD_DEPRN
, FMCDS.DEPRN_RESERVE
, FMCDS.DEPRN_SOURCE_CODE
, FMCDS.ADJUSTED_COST
, FMCDS.BONUS_RATE
, FMCDS.LTD_PRODUCTION
, FMCDS.PERIOD_COUNTER
, FMCDS.PRODUCTION
, FMCDS.REVAL_AMORTIZATION
, FMCDS.REVAL_AMORTIZATION_BASIS
, FMCDS.REVAL_DEPRN_EXPENSE
, FMCDS.REVAL_RESERVE
, FMCDS.YTD_PRODUCTION
, FMCDS.YTD_REVAL_DEPRN_EXPENSE
, FMCDS.PRIOR_FY_EXPENSE
, FMCDS.BONUS_DEPRN_AMOUNT
, FMCDS.BONUS_YTD_DEPRN
, FMCDS.BONUS_DEPRN_RESERVE
, FMCDS.PRIOR_FY_BONUS_EXPENSE
, FMCDS.DEPRN_OVERRIDE_FLAG
, FMCDS.SYSTEM_DEPRN_AMOUNT
, FMCDS.SYSTEM_BONUS_DEPRN_AMOUNT
, FMCDS.EVENT_ID
, FMCDS.DEPRN_RUN_ID
, FMCDS.REVERSAL_EVENT_ID
, FMCDS.REVERSAL_DATE
, FMCDS.DEPRN_ADJUSTMENT_AMOUNT
, FMCDS.BONUS_DEPRN_ADJUSTMENT_AMOUNT
FROM FA_MC_DEPRN_SUMMARY_H FMCDS
WHERE FMCDS.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)