VIEW: FA.FA_MASS_RETIREMENTS#

Source

View Text - Preformatted

select MASS_RETIREMENT_ID MASS_RETIREMENT_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, RETIRE_SUBCOMPONENTS_FLAG RETIRE_SUBCOMPONENTS_FLAG, STATUS STATUS, RETIRE_REQUEST_ID RETIRE_REQUEST_ID, REINSTATE_REQUEST_ID REINSTATE_REQUEST_ID, RETIREMENT_DATE RETIREMENT_DATE, PROCEEDS_OF_SALE PROCEEDS_OF_SALE, COST_OF_REMOVAL COST_OF_REMOVAL, FROM_COST FROM_COST, INCLUDE_FULLY_RSVD_FLAG INCLUDE_FULLY_RSVD_FLAG, TO_COST TO_COST, DESCRIPTION DESCRIPTION, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE, ASSET_TYPE ASSET_TYPE, LOCATION_ID LOCATION_ID, EMPLOYEE_ID EMPLOYEE_ID, CATEGORY_ID CATEGORY_ID, ASSET_KEY_ID ASSET_KEY_ID, FROM_ASSET_NUMBER FROM_ASSET_NUMBER, TO_ASSET_NUMBER TO_ASSET_NUMBER, FROM_DATE_PLACED_IN_SERVICE FROM_DATE_PLACED_IN_SERVICE, TO_DATE_PLACED_IN_SERVICE TO_DATE_PLACED_IN_SERVICE, 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, SEGMENT1_LOW SEGMENT1_LOW, SEGMENT2_LOW SEGMENT2_LOW, SEGMENT3_LOW SEGMENT3_LOW, SEGMENT4_LOW SEGMENT4_LOW, SEGMENT5_LOW SEGMENT5_LOW, SEGMENT6_LOW SEGMENT6_LOW, SEGMENT7_LOW SEGMENT7_LOW, SEGMENT8_LOW SEGMENT8_LOW, SEGMENT9_LOW SEGMENT9_LOW, SEGMENT10_LOW SEGMENT10_LOW, SEGMENT11_LOW SEGMENT11_LOW, SEGMENT12_LOW SEGMENT12_LOW, SEGMENT13_LOW SEGMENT13_LOW, SEGMENT14_LOW SEGMENT14_LOW, SEGMENT15_LOW SEGMENT15_LOW, SEGMENT16_LOW SEGMENT16_LOW, SEGMENT17_LOW SEGMENT17_LOW, SEGMENT18_LOW SEGMENT18_LOW, SEGMENT19_LOW SEGMENT19_LOW, SEGMENT20_LOW SEGMENT20_LOW, SEGMENT21_LOW SEGMENT21_LOW, SEGMENT22_LOW SEGMENT22_LOW, SEGMENT23_LOW SEGMENT23_LOW, SEGMENT24_LOW SEGMENT24_LOW, SEGMENT25_LOW SEGMENT25_LOW, SEGMENT26_LOW SEGMENT26_LOW, SEGMENT27_LOW SEGMENT27_LOW, SEGMENT28_LOW SEGMENT28_LOW, SEGMENT29_LOW SEGMENT29_LOW, SEGMENT30_LOW SEGMENT30_LOW, SEGMENT1_HIGH SEGMENT1_HIGH, SEGMENT2_HIGH SEGMENT2_HIGH, SEGMENT3_HIGH SEGMENT3_HIGH, SEGMENT4_HIGH SEGMENT4_HIGH, SEGMENT5_HIGH SEGMENT5_HIGH, SEGMENT6_HIGH SEGMENT6_HIGH, SEGMENT7_HIGH SEGMENT7_HIGH, SEGMENT8_HIGH SEGMENT8_HIGH, SEGMENT9_HIGH SEGMENT9_HIGH, SEGMENT10_HIGH SEGMENT10_HIGH, SEGMENT11_HIGH SEGMENT11_HIGH, SEGMENT12_HIGH SEGMENT12_HIGH, SEGMENT13_HIGH SEGMENT13_HIGH, SEGMENT14_HIGH SEGMENT14_HIGH, SEGMENT15_HIGH SEGMENT15_HIGH, SEGMENT16_HIGH SEGMENT16_HIGH, SEGMENT17_HIGH SEGMENT17_HIGH, SEGMENT18_HIGH SEGMENT18_HIGH, SEGMENT19_HIGH SEGMENT19_HIGH, SEGMENT20_HIGH SEGMENT20_HIGH, SEGMENT21_HIGH SEGMENT21_HIGH, SEGMENT22_HIGH SEGMENT22_HIGH, SEGMENT23_HIGH SEGMENT23_HIGH, SEGMENT24_HIGH SEGMENT24_HIGH, SEGMENT25_HIGH SEGMENT25_HIGH, SEGMENT26_HIGH SEGMENT26_HIGH, SEGMENT27_HIGH SEGMENT27_HIGH, SEGMENT28_HIGH SEGMENT28_HIGH, SEGMENT29_HIGH SEGMENT29_HIGH, SEGMENT30_HIGH SEGMENT30_HIGH, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, GROUP_ASSET_ID GROUP_ASSET_ID, FROM_THRESHOLD_AMOUNT FROM_THRESHOLD_AMOUNT, TO_THRESHOLD_AMOUNT TO_THRESHOLD_AMOUNT, CREATE_REQUEST_ID CREATE_REQUEST_ID, GROUP_ASSOCIATION GROUP_ASSOCIATION, SERIAL_NUMBER SERIAL_NUMBER, MANUFACTURER_NAME MANUFACTURER_NAME, MODEL_NUMBER MODEL_NUMBER, TAG_NUMBER TAG_NUMBER, UNITS_TO_RETIRE UNITS_TO_RETIRE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID from "FA"."FA_MASS_RETIREMENTS"

View Text - HTML Formatted

SELECT MASS_RETIREMENT_ID MASS_RETIREMENT_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, RETIRE_SUBCOMPONENTS_FLAG RETIRE_SUBCOMPONENTS_FLAG
, STATUS STATUS
, RETIRE_REQUEST_ID RETIRE_REQUEST_ID
, REINSTATE_REQUEST_ID REINSTATE_REQUEST_ID
, RETIREMENT_DATE RETIREMENT_DATE
, PROCEEDS_OF_SALE PROCEEDS_OF_SALE
, COST_OF_REMOVAL COST_OF_REMOVAL
, FROM_COST FROM_COST
, INCLUDE_FULLY_RSVD_FLAG INCLUDE_FULLY_RSVD_FLAG
, TO_COST TO_COST
, DESCRIPTION DESCRIPTION
, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE
, ASSET_TYPE ASSET_TYPE
, LOCATION_ID LOCATION_ID
, EMPLOYEE_ID EMPLOYEE_ID
, CATEGORY_ID CATEGORY_ID
, ASSET_KEY_ID ASSET_KEY_ID
, FROM_ASSET_NUMBER FROM_ASSET_NUMBER
, TO_ASSET_NUMBER TO_ASSET_NUMBER
, FROM_DATE_PLACED_IN_SERVICE FROM_DATE_PLACED_IN_SERVICE
, TO_DATE_PLACED_IN_SERVICE TO_DATE_PLACED_IN_SERVICE
, 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
, SEGMENT1_LOW SEGMENT1_LOW
, SEGMENT2_LOW SEGMENT2_LOW
, SEGMENT3_LOW SEGMENT3_LOW
, SEGMENT4_LOW SEGMENT4_LOW
, SEGMENT5_LOW SEGMENT5_LOW
, SEGMENT6_LOW SEGMENT6_LOW
, SEGMENT7_LOW SEGMENT7_LOW
, SEGMENT8_LOW SEGMENT8_LOW
, SEGMENT9_LOW SEGMENT9_LOW
, SEGMENT10_LOW SEGMENT10_LOW
, SEGMENT11_LOW SEGMENT11_LOW
, SEGMENT12_LOW SEGMENT12_LOW
, SEGMENT13_LOW SEGMENT13_LOW
, SEGMENT14_LOW SEGMENT14_LOW
, SEGMENT15_LOW SEGMENT15_LOW
, SEGMENT16_LOW SEGMENT16_LOW
, SEGMENT17_LOW SEGMENT17_LOW
, SEGMENT18_LOW SEGMENT18_LOW
, SEGMENT19_LOW SEGMENT19_LOW
, SEGMENT20_LOW SEGMENT20_LOW
, SEGMENT21_LOW SEGMENT21_LOW
, SEGMENT22_LOW SEGMENT22_LOW
, SEGMENT23_LOW SEGMENT23_LOW
, SEGMENT24_LOW SEGMENT24_LOW
, SEGMENT25_LOW SEGMENT25_LOW
, SEGMENT26_LOW SEGMENT26_LOW
, SEGMENT27_LOW SEGMENT27_LOW
, SEGMENT28_LOW SEGMENT28_LOW
, SEGMENT29_LOW SEGMENT29_LOW
, SEGMENT30_LOW SEGMENT30_LOW
, SEGMENT1_HIGH SEGMENT1_HIGH
, SEGMENT2_HIGH SEGMENT2_HIGH
, SEGMENT3_HIGH SEGMENT3_HIGH
, SEGMENT4_HIGH SEGMENT4_HIGH
, SEGMENT5_HIGH SEGMENT5_HIGH
, SEGMENT6_HIGH SEGMENT6_HIGH
, SEGMENT7_HIGH SEGMENT7_HIGH
, SEGMENT8_HIGH SEGMENT8_HIGH
, SEGMENT9_HIGH SEGMENT9_HIGH
, SEGMENT10_HIGH SEGMENT10_HIGH
, SEGMENT11_HIGH SEGMENT11_HIGH
, SEGMENT12_HIGH SEGMENT12_HIGH
, SEGMENT13_HIGH SEGMENT13_HIGH
, SEGMENT14_HIGH SEGMENT14_HIGH
, SEGMENT15_HIGH SEGMENT15_HIGH
, SEGMENT16_HIGH SEGMENT16_HIGH
, SEGMENT17_HIGH SEGMENT17_HIGH
, SEGMENT18_HIGH SEGMENT18_HIGH
, SEGMENT19_HIGH SEGMENT19_HIGH
, SEGMENT20_HIGH SEGMENT20_HIGH
, SEGMENT21_HIGH SEGMENT21_HIGH
, SEGMENT22_HIGH SEGMENT22_HIGH
, SEGMENT23_HIGH SEGMENT23_HIGH
, SEGMENT24_HIGH SEGMENT24_HIGH
, SEGMENT25_HIGH SEGMENT25_HIGH
, SEGMENT26_HIGH SEGMENT26_HIGH
, SEGMENT27_HIGH SEGMENT27_HIGH
, SEGMENT28_HIGH SEGMENT28_HIGH
, SEGMENT29_HIGH SEGMENT29_HIGH
, SEGMENT30_HIGH SEGMENT30_HIGH
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GROUP_ASSET_ID GROUP_ASSET_ID
, FROM_THRESHOLD_AMOUNT FROM_THRESHOLD_AMOUNT
, TO_THRESHOLD_AMOUNT TO_THRESHOLD_AMOUNT
, CREATE_REQUEST_ID CREATE_REQUEST_ID
, GROUP_ASSOCIATION GROUP_ASSOCIATION
, SERIAL_NUMBER SERIAL_NUMBER
, MANUFACTURER_NAME MANUFACTURER_NAME
, MODEL_NUMBER MODEL_NUMBER
, TAG_NUMBER TAG_NUMBER
, UNITS_TO_RETIRE UNITS_TO_RETIRE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
FROM "FA"."FA_MASS_RETIREMENTS"