VIEW: APPS.FA_DEPRN_DETAIL_H_MRC_V

Source

View Text - Preformatted

SELECT FMCDD.SET_OF_BOOKS_ID , FMCDD.BOOK_TYPE_CODE , FMCDD.ASSET_ID , FMCDD.PERIOD_COUNTER , FMCDD.DISTRIBUTION_ID , FMCDD.DEPRN_SOURCE_CODE , FMCDD.DEPRN_RUN_DATE , FMCDD.DEPRN_AMOUNT , FMCDD.YTD_DEPRN , FMCDD.DEPRN_RESERVE , FMCDD.ADDITION_COST_TO_CLEAR , FMCDD.COST , FMCDD.DEPRN_ADJUSTMENT_AMOUNT , FMCDD.REVAL_AMORTIZATION , FMCDD.REVAL_DEPRN_EXPENSE , FMCDD.REVAL_RESERVE , FMCDD.YTD_REVAL_DEPRN_EXPENSE , FMCDD.BONUS_DEPRN_AMOUNT , FMCDD.BONUS_YTD_DEPRN , FMCDD.BONUS_DEPRN_RESERVE , FMCDD.BONUS_DEPRN_ADJUSTMENT_AMOUNT , FMCDD.DEPRN_EXPENSE_CCID , FMCDD.DEPRN_RESERVE_CCID , FMCDD.BONUS_DEPRN_EXPENSE_CCID , FMCDD.BONUS_DEPRN_RESERVE_CCID , FMCDD.REVAL_AMORT_CCID , FMCDD.REVAL_RESERVE_CCID, FMCDD.EVENT_ID , FMCDD.DEPRN_RUN_ID , FMCDD.REVERSAL_EVENT_ID, FMCDD.REVERSAL_DATE FROM FA_MC_DEPRN_DETAIL_H FMCDD WHERE FMCDD.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),45,10)),-1)

View Text - HTML Formatted

SELECT FMCDD.SET_OF_BOOKS_ID
, FMCDD.BOOK_TYPE_CODE
, FMCDD.ASSET_ID
, FMCDD.PERIOD_COUNTER
, FMCDD.DISTRIBUTION_ID
, FMCDD.DEPRN_SOURCE_CODE
, FMCDD.DEPRN_RUN_DATE
, FMCDD.DEPRN_AMOUNT
, FMCDD.YTD_DEPRN
, FMCDD.DEPRN_RESERVE
, FMCDD.ADDITION_COST_TO_CLEAR
, FMCDD.COST
, FMCDD.DEPRN_ADJUSTMENT_AMOUNT
, FMCDD.REVAL_AMORTIZATION
, FMCDD.REVAL_DEPRN_EXPENSE
, FMCDD.REVAL_RESERVE
, FMCDD.YTD_REVAL_DEPRN_EXPENSE
, FMCDD.BONUS_DEPRN_AMOUNT
, FMCDD.BONUS_YTD_DEPRN
, FMCDD.BONUS_DEPRN_RESERVE
, FMCDD.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, FMCDD.DEPRN_EXPENSE_CCID
, FMCDD.DEPRN_RESERVE_CCID
, FMCDD.BONUS_DEPRN_EXPENSE_CCID
, FMCDD.BONUS_DEPRN_RESERVE_CCID
, FMCDD.REVAL_AMORT_CCID
, FMCDD.REVAL_RESERVE_CCID
, FMCDD.EVENT_ID
, FMCDD.DEPRN_RUN_ID
, FMCDD.REVERSAL_EVENT_ID
, FMCDD.REVERSAL_DATE
FROM FA_MC_DEPRN_DETAIL_H FMCDD
WHERE FMCDD.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)