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.

VIEW: FA.FA_CATEGORY_BOOKS#

Source

View Text - Preformatted


select CATEGORY_ID CATEGORY_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ASSET_CLEARING_ACCT ASSET_CLEARING_ACCT, ASSET_COST_ACCT ASSET_COST_ACCT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE, CIP_CLEARING_ACCT CIP_CLEARING_ACCT, CIP_COST_ACCT CIP_COST_ACCT, DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT, REVAL_AMORTIZATION_ACCT REVAL_AMORTIZATION_ACCT, REVAL_RESERVE_ACCT REVAL_RESERVE_ACCT, ASSET_COST_ACCOUNT_CCID ASSET_COST_ACCOUNT_CCID, ASSET_CLEARING_ACCOUNT_CCID ASSET_CLEARING_ACCOUNT_CCID, WIP_COST_ACCOUNT_CCID WIP_COST_ACCOUNT_CCID, WIP_CLEARING_ACCOUNT_CCID WIP_CLEARING_ACCOUNT_CCID, RESERVE_ACCOUNT_CCID RESERVE_ACCOUNT_CCID, REVAL_AMORT_ACCOUNT_CCID REVAL_AMORT_ACCOUNT_CCID, REVAL_RESERVE_ACCOUNT_CCID REVAL_RESERVE_ACCOUNT_CCID, LIFE_EXTENSION_CEILING LIFE_EXTENSION_CEILING, LIFE_EXTENSION_FACTOR LIFE_EXTENSION_FACTOR, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, 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, DEFAULT_GROUP_ASSET_ID DEFAULT_GROUP_ASSET_ID, BONUS_DEPRN_EXPENSE_ACCT BONUS_DEPRN_EXPENSE_ACCT, BONUS_DEPRN_RESERVE_ACCT BONUS_DEPRN_RESERVE_ACCT, BONUS_RESERVE_ACCT_CCID BONUS_RESERVE_ACCT_CCID, UNPLAN_EXPENSE_ACCOUNT_CCID UNPLAN_EXPENSE_ACCOUNT_CCID, UNPLAN_EXPENSE_ACCT UNPLAN_EXPENSE_ACCT, DEPRN_EXPENSE_ACCOUNT_CCID DEPRN_EXPENSE_ACCOUNT_CCID, BONUS_EXPENSE_ACCOUNT_CCID BONUS_EXPENSE_ACCOUNT_CCID, ALT_COST_ACCOUNT_CCID ALT_COST_ACCOUNT_CCID, ALT_COST_ACCT ALT_COST_ACCT, WRITE_OFF_ACCOUNT_CCID WRITE_OFF_ACCOUNT_CCID, WRITE_OFF_ACCT WRITE_OFF_ACCT, IMPAIR_EXPENSE_ACCOUNT_CCID IMPAIR_EXPENSE_ACCOUNT_CCID, IMPAIR_EXPENSE_ACCT IMPAIR_EXPENSE_ACCT, IMPAIR_RESERVE_ACCOUNT_CCID IMPAIR_RESERVE_ACCOUNT_CCID, IMPAIR_RESERVE_ACCT IMPAIR_RESERVE_ACCT, CAPITAL_ADJ_ACCT CAPITAL_ADJ_ACCT, CAPITAL_ADJ_ACCOUNT_CCID CAPITAL_ADJ_ACCOUNT_CCID, GENERAL_FUND_ACCT GENERAL_FUND_ACCT, GENERAL_FUND_ACCOUNT_CCID GENERAL_FUND_ACCOUNT_CCID, REVAL_LOSS_ACCT REVAL_LOSS_ACCT, REVAL_LOSS_ACCOUNT_CCID REVAL_LOSS_ACCOUNT_CCID from "FA"."FA_CATEGORY_BOOKS"

View Text - HTML Formatted

SELECT CATEGORY_ID CATEGORY_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ASSET_CLEARING_ACCT ASSET_CLEARING_ACCT
, ASSET_COST_ACCT ASSET_COST_ACCT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE
, CIP_CLEARING_ACCT CIP_CLEARING_ACCT
, CIP_COST_ACCT CIP_COST_ACCT
, DEPRN_EXPENSE_ACCT DEPRN_EXPENSE_ACCT
, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT
, REVAL_AMORTIZATION_ACCT REVAL_AMORTIZATION_ACCT
, REVAL_RESERVE_ACCT REVAL_RESERVE_ACCT
, ASSET_COST_ACCOUNT_CCID ASSET_COST_ACCOUNT_CCID
, ASSET_CLEARING_ACCOUNT_CCID ASSET_CLEARING_ACCOUNT_CCID
, WIP_COST_ACCOUNT_CCID WIP_COST_ACCOUNT_CCID
, WIP_CLEARING_ACCOUNT_CCID WIP_CLEARING_ACCOUNT_CCID
, RESERVE_ACCOUNT_CCID RESERVE_ACCOUNT_CCID
, REVAL_AMORT_ACCOUNT_CCID REVAL_AMORT_ACCOUNT_CCID
, REVAL_RESERVE_ACCOUNT_CCID REVAL_RESERVE_ACCOUNT_CCID
, LIFE_EXTENSION_CEILING LIFE_EXTENSION_CEILING
, LIFE_EXTENSION_FACTOR LIFE_EXTENSION_FACTOR
, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, 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
, DEFAULT_GROUP_ASSET_ID DEFAULT_GROUP_ASSET_ID
, BONUS_DEPRN_EXPENSE_ACCT BONUS_DEPRN_EXPENSE_ACCT
, BONUS_DEPRN_RESERVE_ACCT BONUS_DEPRN_RESERVE_ACCT
, BONUS_RESERVE_ACCT_CCID BONUS_RESERVE_ACCT_CCID
, UNPLAN_EXPENSE_ACCOUNT_CCID UNPLAN_EXPENSE_ACCOUNT_CCID
, UNPLAN_EXPENSE_ACCT UNPLAN_EXPENSE_ACCT
, DEPRN_EXPENSE_ACCOUNT_CCID DEPRN_EXPENSE_ACCOUNT_CCID
, BONUS_EXPENSE_ACCOUNT_CCID BONUS_EXPENSE_ACCOUNT_CCID
, ALT_COST_ACCOUNT_CCID ALT_COST_ACCOUNT_CCID
, ALT_COST_ACCT ALT_COST_ACCT
, WRITE_OFF_ACCOUNT_CCID WRITE_OFF_ACCOUNT_CCID
, WRITE_OFF_ACCT WRITE_OFF_ACCT
, IMPAIR_EXPENSE_ACCOUNT_CCID IMPAIR_EXPENSE_ACCOUNT_CCID
, IMPAIR_EXPENSE_ACCT IMPAIR_EXPENSE_ACCT
, IMPAIR_RESERVE_ACCOUNT_CCID IMPAIR_RESERVE_ACCOUNT_CCID
, IMPAIR_RESERVE_ACCT IMPAIR_RESERVE_ACCT
, CAPITAL_ADJ_ACCT CAPITAL_ADJ_ACCT
, CAPITAL_ADJ_ACCOUNT_CCID CAPITAL_ADJ_ACCOUNT_CCID
, GENERAL_FUND_ACCT GENERAL_FUND_ACCT
, GENERAL_FUND_ACCOUNT_CCID GENERAL_FUND_ACCOUNT_CCID
, REVAL_LOSS_ACCT REVAL_LOSS_ACCT
, REVAL_LOSS_ACCOUNT_CCID REVAL_LOSS_ACCOUNT_CCID
FROM "FA"."FA_CATEGORY_BOOKS"