VIEW: FA.FA_ITF_IMPAIRMENTS#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, IMPAIRMENT_ID IMPAIRMENT_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, CASH_GENERATING_UNIT_ID CASH_GENERATING_UNIT_ID, NET_BOOK_VALUE NET_BOOK_VALUE, NET_SELLING_PRICE NET_SELLING_PRICE, VALUE_IN_USE VALUE_IN_USE, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT, YTD_IMPAIRMENT YTD_IMPAIRMENT, LTD_IMPAIRMENT LTD_IMPAIRMENT, GOODWILL_ASSET_FLAG GOODWILL_ASSET_FLAG, DEPRN_RUN_DATE DEPRN_RUN_DATE, DEPRN_AMOUNT DEPRN_AMOUNT, YTD_DEPRN YTD_DEPRN, DEPRN_RESERVE DEPRN_RESERVE, ADJUSTED_COST ADJUSTED_COST, BONUS_RATE BONUS_RATE, LTD_PRODUCTION LTD_PRODUCTION, PERIOD_COUNTER PERIOD_COUNTER, PRODUCTION PRODUCTION, REVAL_AMORTIZATION REVAL_AMORTIZATION, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE, REVAL_RESERVE REVAL_RESERVE, YTD_PRODUCTION YTD_PRODUCTION, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE, PRIOR_FY_EXPENSE PRIOR_FY_EXPENSE, BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT, BONUS_YTD_DEPRN BONUS_YTD_DEPRN, BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE, PRIOR_FY_BONUS_EXPENSE PRIOR_FY_BONUS_EXPENSE, DEPRN_OVERRIDE_FLAG DEPRN_OVERRIDE_FLAG, SYSTEM_DEPRN_AMOUNT SYSTEM_DEPRN_AMOUNT, SYSTEM_BONUS_DEPRN_AMOUNT SYSTEM_BONUS_DEPRN_AMOUNT, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT, BONUS_DEPRN_ADJUSTMENT_AMOUNT BONUS_DEPRN_ADJUSTMENT_AMOUNT, REVAL_RESERVE_ADJ_AMOUNT REVAL_RESERVE_ADJ_AMOUNT, COST COST, PERIOD_OF_ADDITION_FLAG PERIOD_OF_ADDITION_FLAG, CURRENT_UNITS CURRENT_UNITS, CATEGORY_ID CATEGORY_ID, IMPAIRMENT_DATE IMPAIRMENT_DATE, WORKER_ID WORKER_ID, PROCESS_ORDER PROCESS_ORDER, 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, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR, FORMULA_FACTOR FORMULA_FACTOR, EOFY_RESERVE EOFY_RESERVE, IMPAIR_CLASS IMPAIR_CLASS, REASON REASON, IMPAIR_LOSS_ACCT IMPAIR_LOSS_ACCT, SPLIT_IMPAIR_FLAG SPLIT_IMPAIR_FLAG, SPLIT1_IMPAIR_CLASS SPLIT1_IMPAIR_CLASS, SPLIT1_REASON SPLIT1_REASON, SPLIT1_LOSS_AMOUNT SPLIT1_LOSS_AMOUNT, SPLIT1_REVAL_RESERVE SPLIT1_REVAL_RESERVE, SPLIT1_PERCENT SPLIT1_PERCENT, SPLIT1_LOSS_ACCT SPLIT1_LOSS_ACCT, SPLIT1_PROCESS_ORDER SPLIT1_PROCESS_ORDER, SPLIT2_IMPAIR_CLASS SPLIT2_IMPAIR_CLASS, SPLIT2_REASON SPLIT2_REASON, SPLIT2_LOSS_AMOUNT SPLIT2_LOSS_AMOUNT, SPLIT2_REVAL_RESERVE SPLIT2_REVAL_RESERVE, SPLIT2_PERCENT SPLIT2_PERCENT, SPLIT2_LOSS_ACCT SPLIT2_LOSS_ACCT, SPLIT2_PROCESS_ORDER SPLIT2_PROCESS_ORDER, SPLIT3_IMPAIR_CLASS SPLIT3_IMPAIR_CLASS, SPLIT3_REASON SPLIT3_REASON, SPLIT3_LOSS_AMOUNT SPLIT3_LOSS_AMOUNT, SPLIT3_REVAL_RESERVE SPLIT3_REVAL_RESERVE, SPLIT3_PERCENT SPLIT3_PERCENT, SPLIT3_LOSS_ACCT SPLIT3_LOSS_ACCT, SPLIT3_PROCESS_ORDER SPLIT3_PROCESS_ORDER, CAPITAL_ADJUSTMENT CAPITAL_ADJUSTMENT, GENERAL_FUND GENERAL_FUND, REVERSED_IMP_AMT REVERSED_IMP_AMT, REVERSED_IMP_AMT_S1 REVERSED_IMP_AMT_S1, REVERSED_IMP_AMT_S2 REVERSED_IMP_AMT_S2, REVERSED_IMP_AMT_S3 REVERSED_IMP_AMT_S3, REVERSED_DEPRN_IMPACT REVERSED_DEPRN_IMPACT, REVERSED_DEPRN_IMPACT_S1 REVERSED_DEPRN_IMPACT_S1, REVERSED_DEPRN_IMPACT_S2 REVERSED_DEPRN_IMPACT_S2, REVERSED_DEPRN_IMPACT_S3 REVERSED_DEPRN_IMPACT_S3, REVERSED_REVAL_AMT REVERSED_REVAL_AMT, REVERSED_REVAL_AMT_S1 REVERSED_REVAL_AMT_S1, REVERSED_REVAL_AMT_S2 REVERSED_REVAL_AMT_S2, REVERSED_REVAL_AMT_S3 REVERSED_REVAL_AMT_S3, REVERSED_REVAL_IMPACT REVERSED_REVAL_IMPACT, REVERSED_REVAL_IMPACT_S1 REVERSED_REVAL_IMPACT_S1, REVERSED_REVAL_IMPACT_S2 REVERSED_REVAL_IMPACT_S2, REVERSED_REVAL_IMPACT_S3 REVERSED_REVAL_IMPACT_S3, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE, ALLOWED_DEPRN_LIMIT_AMOUNT ALLOWED_DEPRN_LIMIT_AMOUNT, REVAL_LOSS_BALANCE REVAL_LOSS_BALANCE from "FA"."FA_ITF_IMPAIRMENTS"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, IMPAIRMENT_ID IMPAIRMENT_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, CASH_GENERATING_UNIT_ID CASH_GENERATING_UNIT_ID
, NET_BOOK_VALUE NET_BOOK_VALUE
, NET_SELLING_PRICE NET_SELLING_PRICE
, VALUE_IN_USE VALUE_IN_USE
, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT
, YTD_IMPAIRMENT YTD_IMPAIRMENT
, LTD_IMPAIRMENT LTD_IMPAIRMENT
, GOODWILL_ASSET_FLAG GOODWILL_ASSET_FLAG
, DEPRN_RUN_DATE DEPRN_RUN_DATE
, DEPRN_AMOUNT DEPRN_AMOUNT
, YTD_DEPRN YTD_DEPRN
, DEPRN_RESERVE DEPRN_RESERVE
, ADJUSTED_COST ADJUSTED_COST
, BONUS_RATE BONUS_RATE
, LTD_PRODUCTION LTD_PRODUCTION
, PERIOD_COUNTER PERIOD_COUNTER
, PRODUCTION PRODUCTION
, REVAL_AMORTIZATION REVAL_AMORTIZATION
, REVAL_AMORTIZATION_BASIS REVAL_AMORTIZATION_BASIS
, REVAL_DEPRN_EXPENSE REVAL_DEPRN_EXPENSE
, REVAL_RESERVE REVAL_RESERVE
, YTD_PRODUCTION YTD_PRODUCTION
, YTD_REVAL_DEPRN_EXPENSE YTD_REVAL_DEPRN_EXPENSE
, PRIOR_FY_EXPENSE PRIOR_FY_EXPENSE
, BONUS_DEPRN_AMOUNT BONUS_DEPRN_AMOUNT
, BONUS_YTD_DEPRN BONUS_YTD_DEPRN
, BONUS_DEPRN_RESERVE BONUS_DEPRN_RESERVE
, PRIOR_FY_BONUS_EXPENSE PRIOR_FY_BONUS_EXPENSE
, DEPRN_OVERRIDE_FLAG DEPRN_OVERRIDE_FLAG
, SYSTEM_DEPRN_AMOUNT SYSTEM_DEPRN_AMOUNT
, SYSTEM_BONUS_DEPRN_AMOUNT SYSTEM_BONUS_DEPRN_AMOUNT
, DEPRN_ADJUSTMENT_AMOUNT DEPRN_ADJUSTMENT_AMOUNT
, BONUS_DEPRN_ADJUSTMENT_AMOUNT BONUS_DEPRN_ADJUSTMENT_AMOUNT
, REVAL_RESERVE_ADJ_AMOUNT REVAL_RESERVE_ADJ_AMOUNT
, COST COST
, PERIOD_OF_ADDITION_FLAG PERIOD_OF_ADDITION_FLAG
, CURRENT_UNITS CURRENT_UNITS
, CATEGORY_ID CATEGORY_ID
, IMPAIRMENT_DATE IMPAIRMENT_DATE
, WORKER_ID WORKER_ID
, PROCESS_ORDER PROCESS_ORDER
, 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
, RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
, FORMULA_FACTOR FORMULA_FACTOR
, EOFY_RESERVE EOFY_RESERVE
, IMPAIR_CLASS IMPAIR_CLASS
, REASON REASON
, IMPAIR_LOSS_ACCT IMPAIR_LOSS_ACCT
, SPLIT_IMPAIR_FLAG SPLIT_IMPAIR_FLAG
, SPLIT1_IMPAIR_CLASS SPLIT1_IMPAIR_CLASS
, SPLIT1_REASON SPLIT1_REASON
, SPLIT1_LOSS_AMOUNT SPLIT1_LOSS_AMOUNT
, SPLIT1_REVAL_RESERVE SPLIT1_REVAL_RESERVE
, SPLIT1_PERCENT SPLIT1_PERCENT
, SPLIT1_LOSS_ACCT SPLIT1_LOSS_ACCT
, SPLIT1_PROCESS_ORDER SPLIT1_PROCESS_ORDER
, SPLIT2_IMPAIR_CLASS SPLIT2_IMPAIR_CLASS
, SPLIT2_REASON SPLIT2_REASON
, SPLIT2_LOSS_AMOUNT SPLIT2_LOSS_AMOUNT
, SPLIT2_REVAL_RESERVE SPLIT2_REVAL_RESERVE
, SPLIT2_PERCENT SPLIT2_PERCENT
, SPLIT2_LOSS_ACCT SPLIT2_LOSS_ACCT
, SPLIT2_PROCESS_ORDER SPLIT2_PROCESS_ORDER
, SPLIT3_IMPAIR_CLASS SPLIT3_IMPAIR_CLASS
, SPLIT3_REASON SPLIT3_REASON
, SPLIT3_LOSS_AMOUNT SPLIT3_LOSS_AMOUNT
, SPLIT3_REVAL_RESERVE SPLIT3_REVAL_RESERVE
, SPLIT3_PERCENT SPLIT3_PERCENT
, SPLIT3_LOSS_ACCT SPLIT3_LOSS_ACCT
, SPLIT3_PROCESS_ORDER SPLIT3_PROCESS_ORDER
, CAPITAL_ADJUSTMENT CAPITAL_ADJUSTMENT
, GENERAL_FUND GENERAL_FUND
, REVERSED_IMP_AMT REVERSED_IMP_AMT
, REVERSED_IMP_AMT_S1 REVERSED_IMP_AMT_S1
, REVERSED_IMP_AMT_S2 REVERSED_IMP_AMT_S2
, REVERSED_IMP_AMT_S3 REVERSED_IMP_AMT_S3
, REVERSED_DEPRN_IMPACT REVERSED_DEPRN_IMPACT
, REVERSED_DEPRN_IMPACT_S1 REVERSED_DEPRN_IMPACT_S1
, REVERSED_DEPRN_IMPACT_S2 REVERSED_DEPRN_IMPACT_S2
, REVERSED_DEPRN_IMPACT_S3 REVERSED_DEPRN_IMPACT_S3
, REVERSED_REVAL_AMT REVERSED_REVAL_AMT
, REVERSED_REVAL_AMT_S1 REVERSED_REVAL_AMT_S1
, REVERSED_REVAL_AMT_S2 REVERSED_REVAL_AMT_S2
, REVERSED_REVAL_AMT_S3 REVERSED_REVAL_AMT_S3
, REVERSED_REVAL_IMPACT REVERSED_REVAL_IMPACT
, REVERSED_REVAL_IMPACT_S1 REVERSED_REVAL_IMPACT_S1
, REVERSED_REVAL_IMPACT_S2 REVERSED_REVAL_IMPACT_S2
, REVERSED_REVAL_IMPACT_S3 REVERSED_REVAL_IMPACT_S3
, IMPAIRMENT_RESERVE IMPAIRMENT_RESERVE
, ALLOWED_DEPRN_LIMIT_AMOUNT ALLOWED_DEPRN_LIMIT_AMOUNT
, REVAL_LOSS_BALANCE REVAL_LOSS_BALANCE
FROM "FA"."FA_ITF_IMPAIRMENTS"