VIEW: FA.FA_MASS_EXT_RETIREMENTS#

Source

View Text - Preformatted

select BATCH_NAME BATCH_NAME, MASS_EXTERNAL_RETIRE_ID MASS_EXTERNAL_RETIRE_ID, RETIREMENT_ID RETIREMENT_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, REVIEW_STATUS REVIEW_STATUS, ASSET_ID ASSET_ID, TRANSACTION_NAME TRANSACTION_NAME, DATE_RETIRED DATE_RETIRED, DATE_EFFECTIVE DATE_EFFECTIVE, COST_RETIRED COST_RETIRED, RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION, UNITS UNITS, PERCENTAGE PERCENTAGE, COST_OF_REMOVAL COST_OF_REMOVAL, PROCEEDS_OF_SALE PROCEEDS_OF_SALE, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE, REFERENCE_NUM REFERENCE_NUM, SOLD_TO SOLD_TO, TRADE_IN_ASSET_ID TRADE_IN_ASSET_ID, CALC_GAIN_LOSS_FLAG CALC_GAIN_LOSS_FLAG, STL_METHOD_CODE STL_METHOD_CODE, STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS, STL_DEPRN_AMOUNT STL_DEPRN_AMOUNT, 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, TH_ATTRIBUTE_CATEGORY TH_ATTRIBUTE_CATEGORY, TH_ATTRIBUTE1 TH_ATTRIBUTE1, TH_ATTRIBUTE2 TH_ATTRIBUTE2, TH_ATTRIBUTE3 TH_ATTRIBUTE3, TH_ATTRIBUTE4 TH_ATTRIBUTE4, TH_ATTRIBUTE5 TH_ATTRIBUTE5, TH_ATTRIBUTE6 TH_ATTRIBUTE6, TH_ATTRIBUTE7 TH_ATTRIBUTE7, TH_ATTRIBUTE8 TH_ATTRIBUTE8, TH_ATTRIBUTE9 TH_ATTRIBUTE9, TH_ATTRIBUTE10 TH_ATTRIBUTE10, TH_ATTRIBUTE11 TH_ATTRIBUTE11, TH_ATTRIBUTE12 TH_ATTRIBUTE12, TH_ATTRIBUTE13 TH_ATTRIBUTE13, TH_ATTRIBUTE14 TH_ATTRIBUTE14, TH_ATTRIBUTE15 TH_ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, 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, DISTRIBUTION_ID DISTRIBUTION_ID, RETURN_TO_INVENTORY RETURN_TO_INVENTORY, CODE_COMBINATION_ID CODE_COMBINATION_ID, LOCATION_ID LOCATION_ID, ASSIGNED_TO ASSIGNED_TO, REQUEST_ID REQUEST_ID, WORKER_ID WORKER_ID, RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS from "FA"."FA_MASS_EXT_RETIREMENTS"

View Text - HTML Formatted

SELECT BATCH_NAME BATCH_NAME
, MASS_EXTERNAL_RETIRE_ID MASS_EXTERNAL_RETIRE_ID
, RETIREMENT_ID RETIREMENT_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, REVIEW_STATUS REVIEW_STATUS
, ASSET_ID ASSET_ID
, TRANSACTION_NAME TRANSACTION_NAME
, DATE_RETIRED DATE_RETIRED
, DATE_EFFECTIVE DATE_EFFECTIVE
, COST_RETIRED COST_RETIRED
, RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION
, UNITS UNITS
, PERCENTAGE PERCENTAGE
, COST_OF_REMOVAL COST_OF_REMOVAL
, PROCEEDS_OF_SALE PROCEEDS_OF_SALE
, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE
, REFERENCE_NUM REFERENCE_NUM
, SOLD_TO SOLD_TO
, TRADE_IN_ASSET_ID TRADE_IN_ASSET_ID
, CALC_GAIN_LOSS_FLAG CALC_GAIN_LOSS_FLAG
, STL_METHOD_CODE STL_METHOD_CODE
, STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS
, STL_DEPRN_AMOUNT STL_DEPRN_AMOUNT
, 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
, TH_ATTRIBUTE_CATEGORY TH_ATTRIBUTE_CATEGORY
, TH_ATTRIBUTE1 TH_ATTRIBUTE1
, TH_ATTRIBUTE2 TH_ATTRIBUTE2
, TH_ATTRIBUTE3 TH_ATTRIBUTE3
, TH_ATTRIBUTE4 TH_ATTRIBUTE4
, TH_ATTRIBUTE5 TH_ATTRIBUTE5
, TH_ATTRIBUTE6 TH_ATTRIBUTE6
, TH_ATTRIBUTE7 TH_ATTRIBUTE7
, TH_ATTRIBUTE8 TH_ATTRIBUTE8
, TH_ATTRIBUTE9 TH_ATTRIBUTE9
, TH_ATTRIBUTE10 TH_ATTRIBUTE10
, TH_ATTRIBUTE11 TH_ATTRIBUTE11
, TH_ATTRIBUTE12 TH_ATTRIBUTE12
, TH_ATTRIBUTE13 TH_ATTRIBUTE13
, TH_ATTRIBUTE14 TH_ATTRIBUTE14
, TH_ATTRIBUTE15 TH_ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, 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
, DISTRIBUTION_ID DISTRIBUTION_ID
, RETURN_TO_INVENTORY RETURN_TO_INVENTORY
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, LOCATION_ID LOCATION_ID
, ASSIGNED_TO ASSIGNED_TO
, REQUEST_ID REQUEST_ID
, WORKER_ID WORKER_ID
, RECOGNIZE_GAIN_LOSS RECOGNIZE_GAIN_LOSS
FROM "FA"."FA_MASS_EXT_RETIREMENTS"