View: FA_BOOKS_SUMMARY_MRC_V

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

View Text

SELECT FMCBS.ASSET_ID
, FMCBS.BOOK_TYPE_CODE
, FMCBS.PERIOD_COUNTER
, FMCBS.FISCAL_YEAR
, FMCBS.PERIOD_NUM
, FMCBS.CALENDAR_PERIOD_OPEN_DATE
, FMCBS.CALENDAR_PERIOD_CLOSE_DATE
, FMCBS.RESET_ADJUSTED_COST_FLAG
, FMCBS.CHANGE_IN_COST
, FMCBS.CHANGE_IN_ADDITIONS_COST
, FMCBS.CHANGE_IN_ADJUSTMENTS_COST
, FMCBS.CHANGE_IN_RETIREMENTS_COST
, FMCBS.CHANGE_IN_GROUP_REC_COST
, FMCBS.CHANGE_IN_CIP_COST
, FMCBS.COST
, FMCBS.CIP_COST
, FMCBS.SALVAGE_TYPE
, FMCBS.PERCENT_SALVAGE_VALUE
, FMCBS.SALVAGE_VALUE
, FMCBS.MEMBER_SALVAGE_VALUE
, FMCBS.RECOVERABLE_COST
, FMCBS.DEPRN_LIMIT_TYPE
, FMCBS.ALLOWED_DEPRN_LIMIT
, FMCBS.ALLOWED_DEPRN_LIMIT_AMOUNT
, FMCBS.MEMBER_DEPRN_LIMIT_AMOUNT
, FMCBS.ADJUSTED_RECOVERABLE_COST
, FMCBS.ADJUSTED_COST
, FMCBS.DEPRECIATE_FLAG
, FMCBS.DISABLED_FLAG
, FMCBS.DATE_PLACED_IN_SERVICE
, FMCBS.DEPRN_METHOD_CODE
, FMCBS.LIFE_IN_MONTHS
, FMCBS.RATE_ADJUSTMENT_FACTOR
, FMCBS.ADJUSTED_RATE
, FMCBS.BONUS_RULE
, FMCBS.ADJUSTED_CAPACITY
, FMCBS.PRODUCTION_CAPACITY
, FMCBS.UNIT_OF_MEASURE
, FMCBS.REMAINING_LIFE1
, FMCBS.REMAINING_LIFE2
, FMCBS.FORMULA_FACTOR
, FMCBS.UNREVALUED_COST
, FMCBS.REVAL_AMORTIZATION_BASIS
, FMCBS.REVAL_CEILING
, FMCBS.CEILING_NAME
, FMCBS.EOFY_ADJ_COST
, FMCBS.EOFY_FORMULA_FACTOR
, FMCBS.EOFY_RESERVE
, FMCBS.EOP_ADJ_COST
, FMCBS.EOP_FORMULA_FACTOR
, FMCBS.SHORT_FISCAL_YEAR_FLAG
, FMCBS.GROUP_ASSET_ID
, FMCBS.SUPER_GROUP_ID
, FMCBS.OVER_DEPRECIATE_OPTION
, FMCBS.FULLY_RSVD_REVALS_COUNTER
, FMCBS.CAPITALIZED_FLAG
, FMCBS.FULLY_RESERVED_FLAG
, FMCBS.FULLY_RETIRED_FLAG
, FMCBS.LIFE_COMPLETE_FLAG
, FMCBS.TERMINAL_GAIN_LOSS_AMOUNT
, FMCBS.TERMINAL_GAIN_LOSS_FLAG
, FMCBS.DEPRN_AMOUNT
, FMCBS.YTD_DEPRN
, FMCBS.DEPRN_RESERVE
, FMCBS.BONUS_DEPRN_AMOUNT
, FMCBS.BONUS_YTD_DEPRN
, FMCBS.BONUS_DEPRN_RESERVE
, FMCBS.BONUS_RATE
, FMCBS.LTD_PRODUCTION
, FMCBS.YTD_PRODUCTION
, FMCBS.PRODUCTION
, FMCBS.REVAL_AMORTIZATION
, FMCBS.REVAL_DEPRN_EXPENSE
, FMCBS.REVAL_RESERVE
, FMCBS.YTD_REVAL_DEPRN_EXPENSE
, FMCBS.DEPRN_OVERRIDE_FLAG
, FMCBS.SYSTEM_DEPRN_AMOUNT
, FMCBS.SYSTEM_BONUS_DEPRN_AMOUNT
, FMCBS.YTD_PROCEEDS_OF_SALE
, FMCBS.LTD_PROCEEDS_OF_SALE
, FMCBS.YTD_COST_OF_REMOVAL
, FMCBS.LTD_COST_OF_REMOVAL
, FMCBS.DEPRN_ADJUSTMENT_AMOUNT
, FMCBS.EXPENSE_ADJUSTMENT_AMOUNT
, FMCBS.UNPLANNED_AMOUNT
, FMCBS.RESERVE_ADJUSTMENT_AMOUNT
, FMCBS.CREATION_DATE
, FMCBS.CREATED_BY
, FMCBS.LAST_UPDATE_DATE
, FMCBS.LAST_UPDATED_BY
, FMCBS.LAST_UPDATE_LOGIN
, FMCBS.CHANGE_IN_EOFY_RESERVE
, FMCBS.SWITCH_CODE
, FMCBS.TRANSACTION_HEADER_ID_IN
, FMCBS.TRANSACTION_HEADER_ID_OUT
, FMCBS.POLISH_DEPRN_BASIS
, FMCBS.POLISH_ADJ_REC_COST
FROM FA_MC_BOOKS_SUMMARY FMCBS
WHERE FMCBS.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)

Columns