VIEW: APPS.FA_ITF_IMPAIRMENTS_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)