VIEW: FA.FA_BOOKS_SUMMARY_T#

Source

View Text - Preformatted

select ASSET_ID ASSET_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, PERIOD_COUNTER PERIOD_COUNTER, FISCAL_YEAR FISCAL_YEAR, PERIOD_NUM PERIOD_NUM, CALENDAR_PERIOD_OPEN_DATE CALENDAR_PERIOD_OPEN_DATE, CALENDAR_PERIOD_CLOSE_DATE CALENDAR_PERIOD_CLOSE_DATE, RESET_ADJUSTED_COST_FLAG RESET_ADJUSTED_COST_FLAG, CHANGE_IN_COST CHANGE_IN_COST, CHANGE_IN_ADDITIONS_COST CHANGE_IN_ADDITIONS_COST, CHANGE_IN_ADJUSTMENTS_COST CHANGE_IN_ADJUSTMENTS_COST, CHANGE_IN_RETIREMENTS_COST CHANGE_IN_RETIREMENTS_COST, CHANGE_IN_GROUP_REC_COST CHANGE_IN_GROUP_REC_COST, CHANGE_IN_CIP_COST CHANGE_IN_CIP_COST, COST COST, CIP_COST CIP_COST, SALVAGE_TYPE SALVAGE_TYPE, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, SALVAGE_VALUE SALVAGE_VALUE, MEMBER_SALVAGE_VALUE MEMBER_SALVAGE_VALUE, RECOVERABLE_COST RECOVERABLE_COST, DEPRN_LIMIT_TYPE DEPRN_LIMIT_TYPE, ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT, ALLOWED_DEPRN_LIMIT_AMOUNT ALLOWED_DEPRN_LIMIT_AMOUNT, MEMBER_DEPRN_LIMIT_AMOUNT MEMBER_DEPRN_LIMIT_AMOUNT, ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST, ADJUSTED_COST ADJUSTED_COST, DEPRECIATE_FLAG DEPRECIATE_FLAG, DISABLED_FLAG DISABLED_FLAG, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, DEPRN_METHOD_CODE DEPRN_METHOD_CODE, LIFE_IN_MONTHS LIFE_IN_MONTHS, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR, ADJUSTED_RATE ADJUSTED_RATE, BONUS_RULE BONUS_RULE, ADJUSTED_CAPACITY ADJUSTED_CAPACITY, PRODUCTION_CAPACITY PRODUCTION_CAPACITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, REMAINING_LIFE1 REMAINING_LIFE1, REMAINING_LIFE2 REMAINING_LIFE2, FORMULA_FACTOR FORMULA_FACTOR, UNREVALUED_COST UNREVALUED_COST, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS, REVAL_CEILING REVAL_CEILING, CEILING_NAME CEILING_NAME, EOFY_ADJ_COST EOFY_ADJ_COST, EOFY_FORMULA_FACTOR EOFY_FORMULA_FACTOR, EOFY_RESERVE EOFY_RESERVE, EOP_ADJ_COST EOP_ADJ_COST, EOP_FORMULA_FACTOR EOP_FORMULA_FACTOR, SHORT_FISCAL_YEAR_FLAG SHORT_FISCAL_YEAR_FLAG, GROUP_ASSET_ID GROUP_ASSET_ID, SUPER_GROUP_ID SUPER_GROUP_ID, OVER_DEPRECIATE_OPTION OVER_DEPRECIATE_OPTION, FULLY_RSVD_REVALS_COUNTER FULLY_RSVD_REVALS_COUNTER, CAPITALIZED_FLAG CAPITALIZED_FLAG, FULLY_RESERVED_FLAG FULLY_RESERVED_FLAG, FULLY_RETIRED_FLAG FULLY_RETIRED_FLAG, LIFE_COMPLETE_FLAG LIFE_COMPLETE_FLAG, TERMINAL_GAIN_LOSS_AMOUNT TERMINAL_GAIN_LOSS_AMOUNT, TERMINAL_GAIN_LOSS_FLAG TERMINAL_GAIN_LOSS_FLAG, DEPRN_AMOUNT DEPRN_AMOUNT, YTD_DEPRN YTD_DEPRN, DEPRN_RESERVE DEPRN_RESERVE, BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT, BONUS_YTD_DEPRN BONUS_YTD_DEPRN, BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE, BONUS_RATE BONUS_RATE, LTD_PRODUCTION LTD_PRODUCTION, YTD_PRODUCTION YTD_PRODUCTION, PRODUCTION PRODUCTION, REVAL_AMORTIZATION REVAL_AMORTIZATION, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE, REVAL_RESERVE REVAL_RESERVE, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE, DEPRN_OVERRIDE_FLAG DEPRN_OVERRIDE_FLAG, SYSTEM_DEPRN_AMOUNT SYSTEM_DEPRN_AMOUNT, SYSTEM_BONUS_DEPRN_AMOUNT SYSTEM_BONUS_DEPRN_AMOUNT, YTD_PROCEEDS_OF_SALE YTD_PROCEEDS_OF_SALE, LTD_PROCEEDS_OF_SALE LTD_PROCEEDS_OF_SALE, YTD_COST_OF_REMOVAL YTD_COST_OF_REMOVAL, LTD_COST_OF_REMOVAL LTD_COST_OF_REMOVAL, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT, EXPENSE_ADJUSTMENT_AMOUNT EXPENSE_ADJUSTMENT_AMOUNT, UNPLANNED_AMOUNT UNPLANNED_AMOUNT, RESERVE_ADJUSTMENT_AMOUNT RESERVE_ADJUSTMENT_AMOUNT, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CHANGE_IN_EOFY_RESERVE CHANGE_IN_EOFY_RESERVE, SWITCH_CODE SWITCH_CODE, POLISH_DEPRN_BASIS POLISH_DEPRN_BASIS, POLISH_ADJ_REC_COST POLISH_ADJ_REC_COST, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT, YTD_IMPAIRMENT YTD_IMPAIRMENT, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE, REQUEST_ID REQUEST_ID, IMPAIRMENT_ID IMPAIRMENT_ID from "FA"."FA_BOOKS_SUMMARY_T"

View Text - HTML Formatted

SELECT ASSET_ID ASSET_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, PERIOD_COUNTER PERIOD_COUNTER
, FISCAL_YEAR FISCAL_YEAR
, PERIOD_NUM PERIOD_NUM
, CALENDAR_PERIOD_OPEN_DATE CALENDAR_PERIOD_OPEN_DATE
, CALENDAR_PERIOD_CLOSE_DATE CALENDAR_PERIOD_CLOSE_DATE
, RESET_ADJUSTED_COST_FLAG RESET_ADJUSTED_COST_FLAG
, CHANGE_IN_COST CHANGE_IN_COST
, CHANGE_IN_ADDITIONS_COST CHANGE_IN_ADDITIONS_COST
, CHANGE_IN_ADJUSTMENTS_COST CHANGE_IN_ADJUSTMENTS_COST
, CHANGE_IN_RETIREMENTS_COST CHANGE_IN_RETIREMENTS_COST
, CHANGE_IN_GROUP_REC_COST CHANGE_IN_GROUP_REC_COST
, CHANGE_IN_CIP_COST CHANGE_IN_CIP_COST
, COST COST
, CIP_COST CIP_COST
, SALVAGE_TYPE SALVAGE_TYPE
, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, SALVAGE_VALUE SALVAGE_VALUE
, MEMBER_SALVAGE_VALUE MEMBER_SALVAGE_VALUE
, RECOVERABLE_COST RECOVERABLE_COST
, DEPRN_LIMIT_TYPE DEPRN_LIMIT_TYPE
, ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT
, ALLOWED_DEPRN_LIMIT_AMOUNT ALLOWED_DEPRN_LIMIT_AMOUNT
, MEMBER_DEPRN_LIMIT_AMOUNT MEMBER_DEPRN_LIMIT_AMOUNT
, ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST
, ADJUSTED_COST ADJUSTED_COST
, DEPRECIATE_FLAG DEPRECIATE_FLAG
, DISABLED_FLAG DISABLED_FLAG
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
, ADJUSTED_RATE ADJUSTED_RATE
, BONUS_RULE BONUS_RULE
, ADJUSTED_CAPACITY ADJUSTED_CAPACITY
, PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, REMAINING_LIFE1 REMAINING_LIFE1
, REMAINING_LIFE2 REMAINING_LIFE2
, FORMULA_FACTOR FORMULA_FACTOR
, UNREVALUED_COST UNREVALUED_COST
, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS
, REVAL_CEILING REVAL_CEILING
, CEILING_NAME CEILING_NAME
, EOFY_ADJ_COST EOFY_ADJ_COST
, EOFY_FORMULA_FACTOR EOFY_FORMULA_FACTOR
, EOFY_RESERVE EOFY_RESERVE
, EOP_ADJ_COST EOP_ADJ_COST
, EOP_FORMULA_FACTOR EOP_FORMULA_FACTOR
, SHORT_FISCAL_YEAR_FLAG SHORT_FISCAL_YEAR_FLAG
, GROUP_ASSET_ID GROUP_ASSET_ID
, SUPER_GROUP_ID SUPER_GROUP_ID
, OVER_DEPRECIATE_OPTION OVER_DEPRECIATE_OPTION
, FULLY_RSVD_REVALS_COUNTER FULLY_RSVD_REVALS_COUNTER
, CAPITALIZED_FLAG CAPITALIZED_FLAG
, FULLY_RESERVED_FLAG FULLY_RESERVED_FLAG
, FULLY_RETIRED_FLAG FULLY_RETIRED_FLAG
, LIFE_COMPLETE_FLAG LIFE_COMPLETE_FLAG
, TERMINAL_GAIN_LOSS_AMOUNT TERMINAL_GAIN_LOSS_AMOUNT
, TERMINAL_GAIN_LOSS_FLAG TERMINAL_GAIN_LOSS_FLAG
, DEPRN_AMOUNT DEPRN_AMOUNT
, YTD_DEPRN YTD_DEPRN
, DEPRN_RESERVE DEPRN_RESERVE
, BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE
, BONUS_RATE BONUS_RATE
, LTD_PRODUCTION LTD_PRODUCTION
, YTD_PRODUCTION YTD_PRODUCTION
, PRODUCTION PRODUCTION
, REVAL_AMORTIZATION REVAL_AMORTIZATION
, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE
, REVAL_RESERVE REVAL_RESERVE
, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE
, DEPRN_OVERRIDE_FLAG DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT SYSTEM_BONUS_DEPRN_AMOUNT
, YTD_PROCEEDS_OF_SALE YTD_PROCEEDS_OF_SALE
, LTD_PROCEEDS_OF_SALE LTD_PROCEEDS_OF_SALE
, YTD_COST_OF_REMOVAL YTD_COST_OF_REMOVAL
, LTD_COST_OF_REMOVAL LTD_COST_OF_REMOVAL
, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT
, EXPENSE_ADJUSTMENT_AMOUNT EXPENSE_ADJUSTMENT_AMOUNT
, UNPLANNED_AMOUNT UNPLANNED_AMOUNT
, RESERVE_ADJUSTMENT_AMOUNT RESERVE_ADJUSTMENT_AMOUNT
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CHANGE_IN_EOFY_RESERVE CHANGE_IN_EOFY_RESERVE
, SWITCH_CODE SWITCH_CODE
, POLISH_DEPRN_BASIS POLISH_DEPRN_BASIS
, POLISH_ADJ_REC_COST POLISH_ADJ_REC_COST
, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT YTD_IMPAIRMENT
, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE
, REQUEST_ID REQUEST_ID
, IMPAIRMENT_ID IMPAIRMENT_ID
FROM "FA"."FA_BOOKS_SUMMARY_T"