Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_DEPRN_DETAIL_MRC_V |
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.DEPRN_EXPENSE_JE_LINE_NUM
, FMCDD.DEPRN_RESERVE_JE_LINE_NUM
, FMCDD.REVAL_AMORT_JE_LINE_NUM
, FMCDD.REVAL_RESERVE_JE_LINE_NUM
, FMCDD.JE_HEADER_ID
, 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.BONUS_DEPRN_EXP_JE_LINE_NUM
, FMCDD.BONUS_DEPRN_RSV_JE_LINE_NUM
, 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.IMPAIRMENT_AMOUNT
, FMCDD.YTD_IMPAIRMENT
, FMCDD.IMPAIRMENT_RESERVE
FROM FA_MC_DEPRN_DETAIL FMCDD
WHERE FMCDD.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)