VIEW: APPS.FA_BOOKS_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)