VIEW: FA.FA_MC_BOOKS#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ASSET_ID ASSET_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT, ADJUSTED_COST ADJUSTED_COST, COST COST, SOURCE_COST SOURCE_COST, ORIGINAL_COST ORIGINAL_COST, SOURCE_ORIGINAL_COST SOURCE_ORIGINAL_COST, SALVAGE_VALUE SALVAGE_VALUE, ADJUSTMENT_REQUIRED_STATUS ADJUSTMENT_REQUIRED_STATUS, RETIREMENT_PENDING_FLAG RETIREMENT_PENDING_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, ITC_AMOUNT ITC_AMOUNT, ITC_BASIS ITC_BASIS, RECOVERABLE_COST RECOVERABLE_COST, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REVAL_CEILING REVAL_CEILING, PERIOD_COUNTER_FULLY_RESERVED PERIOD_COUNTER_FULLY_RESERVED, UNREVALUED_COST UNREVALUED_COST, ALLOWED_DEPRN_LIMIT_AMOUNT ALLOWED_DEPRN_LIMIT_AMOUNT, PERIOD_COUNTER_LIFE_COMPLETE PERIOD_COUNTER_LIFE_COMPLETE, ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST, CONVERTED_FLAG CONVERTED_FLAG, ANNUAL_DEPRN_ROUNDING_FLAG ANNUAL_DEPRN_ROUNDING_FLAG, EOFY_ADJ_COST EOFY_ADJ_COST, OLD_ADJUSTED_COST OLD_ADJUSTED_COST, EOFY_FORMULA_FACTOR EOFY_FORMULA_FACTOR, FORMULA_FACTOR FORMULA_FACTOR, REMAINING_LIFE1 REMAINING_LIFE1, REMAINING_LIFE2 REMAINING_LIFE2, SHORT_FISCAL_YEAR_FLAG SHORT_FISCAL_YEAR_FLAG, GROUP_ASSET_ID GROUP_ASSET_ID, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS, ITC_AMOUNT_ID ITC_AMOUNT_ID, RETIREMENT_ID RETIREMENT_ID, TAX_REQUEST_ID TAX_REQUEST_ID, BASIC_RATE BASIC_RATE, ADJUSTED_RATE ADJUSTED_RATE, BONUS_RULE BONUS_RULE, CEILING_NAME CEILING_NAME, ADJUSTED_CAPACITY ADJUSTED_CAPACITY, FULLY_RSVD_REVALS_COUNTER FULLY_RSVD_REVALS_COUNTER, IDLED_FLAG IDLED_FLAG, PERIOD_COUNTER_CAPITALIZED PERIOD_COUNTER_CAPITALIZED, PERIOD_COUNTER_FULLY_RETIRED PERIOD_COUNTER_FULLY_RETIRED, PRODUCTION_CAPACITY PRODUCTION_CAPACITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT, ANNUAL_ROUNDING_FLAG ANNUAL_ROUNDING_FLAG, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, DATE_EFFECTIVE DATE_EFFECTIVE, DEPRN_START_DATE DEPRN_START_DATE, DEPRN_METHOD_CODE DEPRN_METHOD_CODE, LIFE_IN_MONTHS LIFE_IN_MONTHS, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE, PRORATE_DATE PRORATE_DATE, COST_CHANGE_FLAG COST_CHANGE_FLAG, CAPITALIZE_FLAG CAPITALIZE_FLAG, DEPRECIATE_FLAG DEPRECIATE_FLAG, DATE_INEFFECTIVE DATE_INEFFECTIVE, CONVERSION_DATE CONVERSION_DATE, ORIGINAL_DEPRN_START_DATE ORIGINAL_DEPRN_START_DATE, SALVAGE_TYPE SALVAGE_TYPE, DEPRN_LIMIT_TYPE DEPRN_LIMIT_TYPE, REDUCTION_RATE REDUCTION_RATE, REDUCE_ADDITION_FLAG REDUCE_ADDITION_FLAG, REDUCE_ADJUSTMENT_FLAG REDUCE_ADJUSTMENT_FLAG, REDUCE_RETIREMENT_FLAG REDUCE_RETIREMENT_FLAG, RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS, RECAPTURE_RESERVE_FLAG RECAPTURE_RESERVE_FLAG, LIMIT_PROCEEDS_FLAG LIMIT_PROCEEDS_FLAG, TERMINAL_GAIN_LOSS TERMINAL_GAIN_LOSS, TRACKING_METHOD TRACKING_METHOD, EXCLUDE_FULLY_RSV_FLAG EXCLUDE_FULLY_RSV_FLAG, EXCESS_ALLOCATION_OPTION EXCESS_ALLOCATION_OPTION, DEPRECIATION_OPTION DEPRECIATION_OPTION, MEMBER_ROLLUP_FLAG MEMBER_ROLLUP_FLAG, ALLOCATE_TO_FULLY_RSV_FLAG ALLOCATE_TO_FULLY_RSV_FLAG, ALLOCATE_TO_FULLY_RET_FLAG ALLOCATE_TO_FULLY_RET_FLAG, TERMINAL_GAIN_LOSS_AMOUNT TERMINAL_GAIN_LOSS_AMOUNT, CIP_COST CIP_COST, YTD_PROCEEDS YTD_PROCEEDS, LTD_PROCEEDS LTD_PROCEEDS, LTD_COST_OF_REMOVAL LTD_COST_OF_REMOVAL, EOFY_RESERVE EOFY_RESERVE, PRIOR_EOFY_RESERVE PRIOR_EOFY_RESERVE, EOP_ADJ_COST EOP_ADJ_COST, EOP_FORMULA_FACTOR EOP_FORMULA_FACTOR, EXCLUDE_PROCEEDS_FROM_BASIS EXCLUDE_PROCEEDS_FROM_BASIS, RETIREMENT_DEPRN_OPTION RETIREMENT_DEPRN_OPTION, TERMINAL_GAIN_LOSS_FLAG TERMINAL_GAIN_LOSS_FLAG, SUPER_GROUP_ID SUPER_GROUP_ID, OVER_DEPRECIATE_OPTION OVER_DEPRECIATE_OPTION, DISABLED_FLAG DISABLED_FLAG, OLD_ADJUSTED_CAPACITY OLD_ADJUSTED_CAPACITY, DRY_HOLE_FLAG DRY_HOLE_FLAG, CASH_GENERATING_UNIT_ID CASH_GENERATING_UNIT_ID, CONTRACT_ID CONTRACT_ID, RATE_IN_USE RATE_IN_USE from "FA"."FA_MC_BOOKS"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ASSET_ID ASSET_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, ADJUSTED_COST ADJUSTED_COST
, COST COST
, SOURCE_COST SOURCE_COST
, ORIGINAL_COST ORIGINAL_COST
, SOURCE_ORIGINAL_COST SOURCE_ORIGINAL_COST
, SALVAGE_VALUE SALVAGE_VALUE
, ADJUSTMENT_REQUIRED_STATUS ADJUSTMENT_REQUIRED_STATUS
, RETIREMENT_PENDING_FLAG RETIREMENT_PENDING_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, ITC_AMOUNT ITC_AMOUNT
, ITC_BASIS ITC_BASIS
, RECOVERABLE_COST RECOVERABLE_COST
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REVAL_CEILING REVAL_CEILING
, PERIOD_COUNTER_FULLY_RESERVED PERIOD_COUNTER_FULLY_RESERVED
, UNREVALUED_COST UNREVALUED_COST
, ALLOWED_DEPRN_LIMIT_AMOUNT ALLOWED_DEPRN_LIMIT_AMOUNT
, PERIOD_COUNTER_LIFE_COMPLETE PERIOD_COUNTER_LIFE_COMPLETE
, ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST
, CONVERTED_FLAG CONVERTED_FLAG
, ANNUAL_DEPRN_ROUNDING_FLAG ANNUAL_DEPRN_ROUNDING_FLAG
, EOFY_ADJ_COST EOFY_ADJ_COST
, OLD_ADJUSTED_COST OLD_ADJUSTED_COST
, EOFY_FORMULA_FACTOR EOFY_FORMULA_FACTOR
, FORMULA_FACTOR FORMULA_FACTOR
, REMAINING_LIFE1 REMAINING_LIFE1
, REMAINING_LIFE2 REMAINING_LIFE2
, SHORT_FISCAL_YEAR_FLAG SHORT_FISCAL_YEAR_FLAG
, GROUP_ASSET_ID GROUP_ASSET_ID
, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS
, ITC_AMOUNT_ID ITC_AMOUNT_ID
, RETIREMENT_ID RETIREMENT_ID
, TAX_REQUEST_ID TAX_REQUEST_ID
, BASIC_RATE BASIC_RATE
, ADJUSTED_RATE ADJUSTED_RATE
, BONUS_RULE BONUS_RULE
, CEILING_NAME CEILING_NAME
, ADJUSTED_CAPACITY ADJUSTED_CAPACITY
, FULLY_RSVD_REVALS_COUNTER FULLY_RSVD_REVALS_COUNTER
, IDLED_FLAG IDLED_FLAG
, PERIOD_COUNTER_CAPITALIZED PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RETIRED PERIOD_COUNTER_FULLY_RETIRED
, PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT
, ANNUAL_ROUNDING_FLAG ANNUAL_ROUNDING_FLAG
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, DATE_EFFECTIVE DATE_EFFECTIVE
, DEPRN_START_DATE DEPRN_START_DATE
, DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
, PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE
, PRORATE_DATE PRORATE_DATE
, COST_CHANGE_FLAG COST_CHANGE_FLAG
, CAPITALIZE_FLAG CAPITALIZE_FLAG
, DEPRECIATE_FLAG DEPRECIATE_FLAG
, DATE_INEFFECTIVE DATE_INEFFECTIVE
, CONVERSION_DATE CONVERSION_DATE
, ORIGINAL_DEPRN_START_DATE ORIGINAL_DEPRN_START_DATE
, SALVAGE_TYPE SALVAGE_TYPE
, DEPRN_LIMIT_TYPE DEPRN_LIMIT_TYPE
, REDUCTION_RATE REDUCTION_RATE
, REDUCE_ADDITION_FLAG REDUCE_ADDITION_FLAG
, REDUCE_ADJUSTMENT_FLAG REDUCE_ADJUSTMENT_FLAG
, REDUCE_RETIREMENT_FLAG REDUCE_RETIREMENT_FLAG
, RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS
, RECAPTURE_RESERVE_FLAG RECAPTURE_RESERVE_FLAG
, LIMIT_PROCEEDS_FLAG LIMIT_PROCEEDS_FLAG
, TERMINAL_GAIN_LOSS TERMINAL_GAIN_LOSS
, TRACKING_METHOD TRACKING_METHOD
, EXCLUDE_FULLY_RSV_FLAG EXCLUDE_FULLY_RSV_FLAG
, EXCESS_ALLOCATION_OPTION EXCESS_ALLOCATION_OPTION
, DEPRECIATION_OPTION DEPRECIATION_OPTION
, MEMBER_ROLLUP_FLAG MEMBER_ROLLUP_FLAG
, ALLOCATE_TO_FULLY_RSV_FLAG ALLOCATE_TO_FULLY_RSV_FLAG
, ALLOCATE_TO_FULLY_RET_FLAG ALLOCATE_TO_FULLY_RET_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT TERMINAL_GAIN_LOSS_AMOUNT
, CIP_COST CIP_COST
, YTD_PROCEEDS YTD_PROCEEDS
, LTD_PROCEEDS LTD_PROCEEDS
, LTD_COST_OF_REMOVAL LTD_COST_OF_REMOVAL
, EOFY_RESERVE EOFY_RESERVE
, PRIOR_EOFY_RESERVE PRIOR_EOFY_RESERVE
, EOP_ADJ_COST EOP_ADJ_COST
, EOP_FORMULA_FACTOR EOP_FORMULA_FACTOR
, EXCLUDE_PROCEEDS_FROM_BASIS EXCLUDE_PROCEEDS_FROM_BASIS
, RETIREMENT_DEPRN_OPTION RETIREMENT_DEPRN_OPTION
, TERMINAL_GAIN_LOSS_FLAG TERMINAL_GAIN_LOSS_FLAG
, SUPER_GROUP_ID SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION OVER_DEPRECIATE_OPTION
, DISABLED_FLAG DISABLED_FLAG
, OLD_ADJUSTED_CAPACITY OLD_ADJUSTED_CAPACITY
, DRY_HOLE_FLAG DRY_HOLE_FLAG
, CASH_GENERATING_UNIT_ID CASH_GENERATING_UNIT_ID
, CONTRACT_ID CONTRACT_ID
, RATE_IN_USE RATE_IN_USE
FROM "FA"."FA_MC_BOOKS"