View: FA_IMPAIRMENTS_MRC_V

Product:	OFA - Assets
Description:	FA_IMPAIRMENTS_MRC_V is the MRC view on top of FA_MC_IMPAIRMENTS.
Implementation/DBA Data:	APPS.FA_IMPAIRMENTS_MRC_V

View Text

SELECT FMCIP.IMPAIRMENT_ID
, FMCIP.IMPAIRMENT_NAME
, FMCIP.DESCRIPTION
, FMCIP.SET_OF_BOOKS_ID
, FMCIP.REQUEST_ID
, FMCIP.STATUS
, FMCIP.BOOK_TYPE_CODE
, FMCIP.CASH_GENERATING_UNIT_ID
, FMCIP.ASSET_ID
, FMCIP.NET_BOOK_VALUE
, FMCIP.NET_SELLING_PRICE
, FMCIP.VALUE_IN_USE
, FMCIP.GOODWILL_ASSET_ID
, FMCIP.GOODWILL_AMOUNT
, FMCIP.USER_DATE
, FMCIP.IMPAIRMENT_DATE
, FMCIP.PERIOD_COUNTER_IMPAIRED
, FMCIP.IMPAIRMENT_AMOUNT
, FMCIP.DATE_INEFFECTIVE
, FMCIP.CREATION_DATE
, FMCIP.CREATED_BY
, FMCIP.LAST_UPDATE_DATE
, FMCIP.LAST_UPDATED_BY
, FMCIP.LAST_UPDATE_LOGIN
FROM FA_MC_IMPAIRMENTS FMCIP
WHERE FMCIP.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)

Columns