Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_BOOKS_MRC_V |
SELECT FMCB.SET_OF_BOOKS_ID
, FMCB.BOOK_TYPE_CODE
, FMCB.ASSET_ID
, FMCB.DATE_PLACED_IN_SERVICE
, FMCB.DATE_EFFECTIVE
, FMCB.DEPRN_START_DATE
, FMCB.DEPRN_METHOD_CODE
, FMCB.LIFE_IN_MONTHS
, FMCB.RATE_ADJUSTMENT_FACTOR
, FMCB.ADJUSTED_COST
, FMCB.COST
, FMCB.ORIGINAL_COST
, FMCB.SALVAGE_VALUE
, FMCB.PRORATE_CONVENTION_CODE
, FMCB.PRORATE_DATE
, FMCB.COST_CHANGE_FLAG
, FMCB.ADJUSTMENT_REQUIRED_STATUS
, FMCB.CAPITALIZE_FLAG
, FMCB.RETIREMENT_PENDING_FLAG
, FMCB.DEPRECIATE_FLAG
, FMCB.LAST_UPDATE_DATE
, FMCB.LAST_UPDATED_BY
, FMCB.DATE_INEFFECTIVE
, FMCB.TRANSACTION_HEADER_ID_IN
, FMCB.TRANSACTION_HEADER_ID_OUT
, FMCB.ITC_AMOUNT_ID
, FMCB.ITC_AMOUNT
, FMCB.RETIREMENT_ID
, FMCB.TAX_REQUEST_ID
, FMCB.ITC_BASIS
, FMCB.BASIC_RATE
, FMCB.ADJUSTED_RATE
, FMCB.BONUS_RULE
, FMCB.CEILING_NAME
, FMCB.RECOVERABLE_COST
, FMCB.LAST_UPDATE_LOGIN
, FMCB.ADJUSTED_CAPACITY
, FMCB.FULLY_RSVD_REVALS_COUNTER
, FMCB.IDLED_FLAG
, FMCB.PERIOD_COUNTER_CAPITALIZED
, FMCB.PERIOD_COUNTER_FULLY_RESERVED
, FMCB.PERIOD_COUNTER_FULLY_RETIRED
, FMCB.PRODUCTION_CAPACITY
, FMCB.REVAL_AMORTIZATION_BASIS
, FMCB.REVAL_CEILING
, FMCB.UNIT_OF_MEASURE
, FMCB.UNREVALUED_COST
, FMCB.ANNUAL_DEPRN_ROUNDING_FLAG
, FMCB.PERCENT_SALVAGE_VALUE
, FMCB.ALLOWED_DEPRN_LIMIT
, FMCB.ALLOWED_DEPRN_LIMIT_AMOUNT
, FMCB.PERIOD_COUNTER_LIFE_COMPLETE
, FMCB.ADJUSTED_RECOVERABLE_COST
, FMCB.ANNUAL_ROUNDING_FLAG
, FMCB.GLOBAL_ATTRIBUTE1
, FMCB.GLOBAL_ATTRIBUTE2
, FMCB.GLOBAL_ATTRIBUTE3
, FMCB.GLOBAL_ATTRIBUTE4
, FMCB.GLOBAL_ATTRIBUTE5
, FMCB.GLOBAL_ATTRIBUTE6
, FMCB.GLOBAL_ATTRIBUTE7
, FMCB.GLOBAL_ATTRIBUTE8
, FMCB.GLOBAL_ATTRIBUTE9
, FMCB.GLOBAL_ATTRIBUTE10
, FMCB.GLOBAL_ATTRIBUTE11
, FMCB.GLOBAL_ATTRIBUTE12
, FMCB.GLOBAL_ATTRIBUTE13
, FMCB.GLOBAL_ATTRIBUTE14
, FMCB.GLOBAL_ATTRIBUTE15
, FMCB.GLOBAL_ATTRIBUTE16
, FMCB.GLOBAL_ATTRIBUTE17
, FMCB.GLOBAL_ATTRIBUTE18
, FMCB.GLOBAL_ATTRIBUTE19
, FMCB.GLOBAL_ATTRIBUTE20
, FMCB.GLOBAL_ATTRIBUTE_CATEGORY
, FMCB.SHORT_FISCAL_YEAR_FLAG
, FMCB.CONVERSION_DATE
, FMCB.ORIGINAL_DEPRN_START_DATE
, FMCB.FORMULA_FACTOR
, FMCB.REMAINING_LIFE1
, FMCB.REMAINING_LIFE2
, FMCB.OLD_ADJUSTED_COST
, FMCB.EOFY_ADJ_COST
, FMCB.EOFY_FORMULA_FACTOR
, FMCB.GROUP_ASSET_ID
, FMCB.REDUCTION_RATE
, FMCB.REDUCE_ADDITION_FLAG
, FMCB.REDUCE_ADJUSTMENT_FLAG
, FMCB.REDUCE_RETIREMENT_FLAG
, FMCB.RECOGNIZE_GAIN_LOSS
, FMCB.RECAPTURE_RESERVE_FLAG
, FMCB.LIMIT_PROCEEDS_FLAG
, FMCB.TERMINAL_GAIN_LOSS
, FMCB.SALVAGE_TYPE
, FMCB.DEPRN_LIMIT_TYPE
, FMCB.TRACKING_METHOD
, FMCB.ALLOCATE_TO_FULLY_RSV_FLAG
, FMCB.ALLOCATE_TO_FULLY_RET_FLAG
, FMCB.EXCESS_ALLOCATION_OPTION
, FMCB.DEPRECIATION_OPTION
, FMCB.MEMBER_ROLLUP_FLAG
, FMCB.YTD_PROCEEDS
, FMCB.LTD_PROCEEDS
, FMCB.EXCLUDE_FULLY_RSV_FLAG
, FMCB.EOFY_RESERVE
, FMCB.CIP_COST
, FMCB.TERMINAL_GAIN_LOSS_AMOUNT
, FMCB.LTD_COST_OF_REMOVAL
, FMCB.PRIOR_EOFY_RESERVE
, FMCB.EOP_ADJ_COST
, FMCB.EOP_FORMULA_FACTOR
, FMCB.EXCLUDE_PROCEEDS_FROM_BASIS
, FMCB.RETIREMENT_DEPRN_OPTION
, FMCB.TERMINAL_GAIN_LOSS_FLAG
, FMCB.SUPER_GROUP_ID
, FMCB.OVER_DEPRECIATE_OPTION
, FMCB.DISABLED_FLAG
, FMCB.OLD_ADJUSTED_CAPACITY
, FMCB.DRY_HOLE_FLAG
, FMCB.CASH_GENERATING_UNIT_ID
, FMCB.CONTRACT_ID
, FMCB.RATE_IN_USE
FROM FA_MC_BOOKS FMCB
WHERE FMCB.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)