VIEW: APPS.FA_DEPRN_SUMMARY_H_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)