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_BOOKS_GROUPS#

Source

View Text - Preformatted


select GROUP_ASSET_ID GROUP_ASSET_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, COST COST, ORIGINAL_COST ORIGINAL_COST, SALVAGE_VALUE SALVAGE_VALUE, ADJUSTED_COST ADJUSTED_COST, ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST, RECOVERABLE_COST RECOVERABLE_COST, COST_CHANGE_FLAG COST_CHANGE_FLAG, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT, PERIOD_COUNTER_LIFE_COMPLETE PERIOD_COUNTER_LIFE_COMPLETE, PERIOD_COUNTER PERIOD_COUNTER, BEGINNING_BALANCE_FLAG BEGINNING_BALANCE_FLAG, DATE_INEFFECTIVE DATE_INEFFECTIVE, DATE_EFFECTIVE DATE_EFFECTIVE, IDLED_FLAG IDLED_FLAG, ITC_AMOUNT ITC_AMOUNT, ITC_AMOUNT_ID ITC_AMOUNT_ID, ITC_BASIS ITC_BASIS, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, PERIOD_COUNTER_CAPITALIZED PERIOD_COUNTER_CAPITALIZED, PERIOD_COUNTER_FULLY_RESERVED PERIOD_COUNTER_FULLY_RESERVED, PERIOD_COUNTER_FULLY_RETIRED PERIOD_COUNTER_FULLY_RETIRED, RETIREMENT_ID RETIREMENT_ID, RETIREMENT_PENDING_FLAG RETIREMENT_PENDING_FLAG, TAX_REQUEST_ID TAX_REQUEST_ID, CAPITALIZE_FLAG CAPITALIZE_FLAG, YTD_PROCEEDS YTD_PROCEEDS, LTD_PROCEEDS LTD_PROCEEDS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, 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 from "FA"."FA_BOOKS_GROUPS"

View Text - HTML Formatted

SELECT GROUP_ASSET_ID GROUP_ASSET_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, COST COST
, ORIGINAL_COST ORIGINAL_COST
, SALVAGE_VALUE SALVAGE_VALUE
, ADJUSTED_COST ADJUSTED_COST
, ADJUSTED_RECOVERABLE_COST ADJUSTED_RECOVERABLE_COST
, RECOVERABLE_COST RECOVERABLE_COST
, COST_CHANGE_FLAG COST_CHANGE_FLAG
, TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, PERIOD_COUNTER_LIFE_COMPLETE PERIOD_COUNTER_LIFE_COMPLETE
, PERIOD_COUNTER PERIOD_COUNTER
, BEGINNING_BALANCE_FLAG BEGINNING_BALANCE_FLAG
, DATE_INEFFECTIVE DATE_INEFFECTIVE
, DATE_EFFECTIVE DATE_EFFECTIVE
, IDLED_FLAG IDLED_FLAG
, ITC_AMOUNT ITC_AMOUNT
, ITC_AMOUNT_ID ITC_AMOUNT_ID
, ITC_BASIS ITC_BASIS
, PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, PERIOD_COUNTER_CAPITALIZED PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED PERIOD_COUNTER_FULLY_RETIRED
, RETIREMENT_ID RETIREMENT_ID
, RETIREMENT_PENDING_FLAG RETIREMENT_PENDING_FLAG
, TAX_REQUEST_ID TAX_REQUEST_ID
, CAPITALIZE_FLAG CAPITALIZE_FLAG
, YTD_PROCEEDS YTD_PROCEEDS
, LTD_PROCEEDS LTD_PROCEEDS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 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
FROM "FA"."FA_BOOKS_GROUPS"