View: FA_GROUP_DEPRN_SUMMARY_MRC_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_GROUP_DEPRN_SUMMARY_MRC_V

View Text

SELECT IMGDS.SET_OF_BOOKS_ID
, IMGDS.BOOK_TYPE_CODE
, IMGDS.GROUP_ASSET_ID
, IMGDS.DEPRN_RUN_DATE
, IMGDS.DEPRN_AMOUNT
, IMGDS.YTD_DEPRN
, IMGDS.DEPRN_RESERVE
, IMGDS.DEPRN_SOURCE_CODE
, IMGDS.ADJUSTED_COST
, IMGDS.BONUS_RATE
, IMGDS.LTD_PRODUCTION
, IMGDS.PERIOD_COUNTER
, IMGDS.PRODUCTION
, IMGDS.REVAL_AMORTIZATION
, IMGDS.REVAL_AMORTIZATION_BASIS
, IMGDS.REVAL_DEPRN_EXPENSE
, IMGDS.REVAL_RESERVE
, IMGDS.YTD_PRODUCTION
, IMGDS.YTD_REVAL_DEPRN_EXPENSE
, IMGDS.PRIOR_FY_EXPENSE
, IMGDS.CONVERTED_FLAG
, IMGDS.DEPRN_RATE
FROM FA_MC_GROUP_DEPRN_SUMMARY IMGDS
WHERE IMGDS.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)

Columns