eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: FA.FA_IMPAIRMENTS#

Source

View Text - Preformatted


select IMPAIRMENT_ID IMPAIRMENT_ID, IMPAIRMENT_NAME IMPAIRMENT_NAME, DESCRIPTION DESCRIPTION, REQUEST_ID REQUEST_ID, STATUS STATUS, BOOK_TYPE_CODE BOOK_TYPE_CODE, CASH_GENERATING_UNIT_ID CASH_GENERATING_UNIT_ID, ASSET_ID ASSET_ID, NET_BOOK_VALUE NET_BOOK_VALUE, NET_SELLING_PRICE NET_SELLING_PRICE, VALUE_IN_USE VALUE_IN_USE, GOODWILL_ASSET_ID GOODWILL_ASSET_ID, GOODWILL_AMOUNT GOODWILL_AMOUNT, USER_DATE USER_DATE, IMPAIRMENT_DATE IMPAIRMENT_DATE, PERIOD_COUNTER_IMPAIRED PERIOD_COUNTER_IMPAIRED, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT, DATE_INEFFECTIVE DATE_INEFFECTIVE, 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, 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_PERCENT SPLIT1_PERCENT, SPLIT1_LOSS_ACCT SPLIT1_LOSS_ACCT, SPLIT2_IMPAIR_CLASS SPLIT2_IMPAIR_CLASS, SPLIT2_REASON SPLIT2_REASON, SPLIT2_PERCENT SPLIT2_PERCENT, SPLIT2_LOSS_ACCT SPLIT2_LOSS_ACCT, SPLIT3_IMPAIR_CLASS SPLIT3_IMPAIR_CLASS, SPLIT3_REASON SPLIT3_REASON, SPLIT3_PERCENT SPLIT3_PERCENT, SPLIT3_LOSS_ACCT SPLIT3_LOSS_ACCT from "FA"."FA_IMPAIRMENTS"

View Text - HTML Formatted

SELECT IMPAIRMENT_ID IMPAIRMENT_ID
, IMPAIRMENT_NAME IMPAIRMENT_NAME
, DESCRIPTION DESCRIPTION
, REQUEST_ID REQUEST_ID
, STATUS STATUS
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, CASH_GENERATING_UNIT_ID CASH_GENERATING_UNIT_ID
, ASSET_ID ASSET_ID
, NET_BOOK_VALUE NET_BOOK_VALUE
, NET_SELLING_PRICE NET_SELLING_PRICE
, VALUE_IN_USE VALUE_IN_USE
, GOODWILL_ASSET_ID GOODWILL_ASSET_ID
, GOODWILL_AMOUNT GOODWILL_AMOUNT
, USER_DATE USER_DATE
, IMPAIRMENT_DATE IMPAIRMENT_DATE
, PERIOD_COUNTER_IMPAIRED PERIOD_COUNTER_IMPAIRED
, IMPAIRMENT_AMOUNT IMPAIRMENT_AMOUNT
, DATE_INEFFECTIVE DATE_INEFFECTIVE
, 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
, 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_PERCENT SPLIT1_PERCENT
, SPLIT1_LOSS_ACCT SPLIT1_LOSS_ACCT
, SPLIT2_IMPAIR_CLASS SPLIT2_IMPAIR_CLASS
, SPLIT2_REASON SPLIT2_REASON
, SPLIT2_PERCENT SPLIT2_PERCENT
, SPLIT2_LOSS_ACCT SPLIT2_LOSS_ACCT
, SPLIT3_IMPAIR_CLASS SPLIT3_IMPAIR_CLASS
, SPLIT3_REASON SPLIT3_REASON
, SPLIT3_PERCENT SPLIT3_PERCENT
, SPLIT3_LOSS_ACCT SPLIT3_LOSS_ACCT
FROM "FA"."FA_IMPAIRMENTS"