Product: | OFA - Assets |
---|---|
Description: | FA_ITF_IMPAIRMENTS_MRC_V is the MRC view on top of FA_MC_ITF_IMPAIRMENTS. |
Implementation/DBA Data: | APPS.FA_ITF_IMPAIRMENTS_MRC_V |
SELECT FMCIP.REQUEST_ID
, FMCIP.IMPAIRMENT_ID
, FMCIP.BOOK_TYPE_CODE
, FMCIP.SET_OF_BOOKS_ID
, FMCIP.ASSET_ID
, FMCIP.CASH_GENERATING_UNIT_ID
, FMCIP.NET_BOOK_VALUE
, FMCIP.NET_SELLING_PRICE
, FMCIP.VALUE_IN_USE
, FMCIP.IMPAIRMENT_AMOUNT
, FMCIP.YTD_IMPAIRMENT
, FMCIP.IMPAIRMENT_RESERVE
, FMCIP.GOODWILL_ASSET_FLAG
, FMCIP.DEPRN_RUN_DATE
, FMCIP.DEPRN_AMOUNT
, FMCIP.YTD_DEPRN
, FMCIP.DEPRN_RESERVE
, FMCIP.ADJUSTED_COST
, FMCIP.BONUS_RATE
, FMCIP.LTD_PRODUCTION
, FMCIP.PERIOD_COUNTER
, FMCIP.PRODUCTION
, FMCIP.REVAL_AMORTIZATION
, FMCIP.REVAL_AMORTIZATION_BASIS
, FMCIP.REVAL_DEPRN_EXPENSE
, FMCIP.REVAL_RESERVE
, FMCIP.YTD_PRODUCTION
, FMCIP.YTD_REVAL_DEPRN_EXPENSE
, FMCIP.PRIOR_FY_EXPENSE
, FMCIP.BONUS_DEPRN_AMOUNT
, FMCIP.BONUS_YTD_DEPRN
, FMCIP.BONUS_DEPRN_RESERVE
, FMCIP.PRIOR_FY_BONUS_EXPENSE
, FMCIP.DEPRN_OVERRIDE_FLAG
, FMCIP.SYSTEM_DEPRN_AMOUNT
, FMCIP.SYSTEM_BONUS_DEPRN_AMOUNT
, FMCIP.DEPRN_ADJUSTMENT_AMOUNT
, FMCIP.BONUS_DEPRN_ADJUSTMENT_AMOUNT
, FMCIP.COST
, FMCIP.PERIOD_OF_ADDITION_FLAG
, FMCIP.CURRENT_UNITS
, FMCIP.CATEGORY_ID
, FMCIP.IMPAIRMENT_DATE
, FMCIP.REVAL_RESERVE_ADJ_AMOUNT
, FMCIP.WORKER_ID
, FMCIP.PROCESS_ORDER
, FMCIP.RATE_ADJUSTMENT_FACTOR
, FMCIP.FORMULA_FACTOR
, FMCIP.EOFY_RESERVE
, FMCIP.CREATION_DATE
, FMCIP.CREATED_BY
, FMCIP.LAST_UPDATE_DATE
, FMCIP.LAST_UPDATED_BY
, FMCIP.LAST_UPDATE_LOGIN
FROM FA_MC_ITF_IMPAIRMENTS FMCIP
WHERE FMCIP.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)