VIEW: FA.FA_MASS_RECLASS_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, MASS_RECLASS_ID MASS_RECLASS_ID, ASSET_ID ASSET_ID, ASSET_NUMBER ASSET_NUMBER, DESCRIPTION DESCRIPTION, BOOK BOOK, OLD_CATEGORY OLD_CATEGORY, NEW_CATEGORY NEW_CATEGORY, CONVENTION CONVENTION, CEILING CEILING, METHOD METHOD, LIFE LIFE, BASIC_RATE BASIC_RATE, ADJUSTED_RATE ADJUSTED_RATE, BONUS_RULE BONUS_RULE, PRODUCTION_CAPACITY PRODUCTION_CAPACITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, DEPRECIATE_FLAG DEPRECIATE_FLAG, DEPRN_LIMIT_PERCENTAGE DEPRN_LIMIT_PERCENTAGE, DEPRN_LIMIT_AMOUNT DEPRN_LIMIT_AMOUNT, SALVAGE_VAL_PERCENTAGE SALVAGE_VAL_PERCENTAGE, COST_ACCT COST_ACCT, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT, 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_TYPE ASSET_TYPE from "FA"."FA_MASS_RECLASS_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, MASS_RECLASS_ID MASS_RECLASS_ID
, ASSET_ID ASSET_ID
, ASSET_NUMBER ASSET_NUMBER
, DESCRIPTION DESCRIPTION
, BOOK BOOK
, OLD_CATEGORY OLD_CATEGORY
, NEW_CATEGORY NEW_CATEGORY
, CONVENTION CONVENTION
, CEILING CEILING
, METHOD METHOD
, LIFE LIFE
, BASIC_RATE BASIC_RATE
, ADJUSTED_RATE ADJUSTED_RATE
, BONUS_RULE BONUS_RULE
, PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, DEPRECIATE_FLAG DEPRECIATE_FLAG
, DEPRN_LIMIT_PERCENTAGE DEPRN_LIMIT_PERCENTAGE
, DEPRN_LIMIT_AMOUNT DEPRN_LIMIT_AMOUNT
, SALVAGE_VAL_PERCENTAGE SALVAGE_VAL_PERCENTAGE
, COST_ACCT COST_ACCT
, DEPRN_RESERVE_ACCT DEPRN_RESERVE_ACCT
, 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_TYPE ASSET_TYPE
FROM "FA"."FA_MASS_RECLASS_ITF"