VIEW: FA.FA_HR_RETIREMENT_HEADERS#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, EVENT_CODE EVENT_CODE, STATUS_CODE STATUS_CODE, ASSET_HIERARCHY_ID ASSET_HIERARCHY_ID, RETIREMENT_METHOD RETIREMENT_METHOD, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE, PRORATE_BY PRORATE_BY, RETIRE_BY RETIRE_BY, RETIREMENT_PERCENT RETIREMENT_PERCENT, RETIREMENT_AMOUNT RETIREMENT_AMOUNT, RETIRE_DATE RETIRE_DATE, RETIREMENT_CONVENTION_CODE RETIREMENT_CONVENTION_CODE, ALLOW_PARTIAL_RETIRE_FLAG ALLOW_PARTIAL_RETIRE_FLAG, RETIRE_UNITS_FLAG RETIRE_UNITS_FLAG, REJECTION_REASON_CODE REJECTION_REASON_CODE, TRANSACTION_NAME TRANSACTION_NAME, 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, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, 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, 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, COST_OF_REMOVAL COST_OF_REMOVAL, PROCEEDS_OF_SALE PROCEEDS_OF_SALE from "FA"."FA_HR_RETIREMENT_HEADERS"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, EVENT_CODE EVENT_CODE
, STATUS_CODE STATUS_CODE
, ASSET_HIERARCHY_ID ASSET_HIERARCHY_ID
, RETIREMENT_METHOD RETIREMENT_METHOD
, RETIREMENT_TYPE_CODE RETIREMENT_TYPE_CODE
, PRORATE_BY PRORATE_BY
, RETIRE_BY RETIRE_BY
, RETIREMENT_PERCENT RETIREMENT_PERCENT
, RETIREMENT_AMOUNT RETIREMENT_AMOUNT
, RETIRE_DATE RETIRE_DATE
, RETIREMENT_CONVENTION_CODE RETIREMENT_CONVENTION_CODE
, ALLOW_PARTIAL_RETIRE_FLAG ALLOW_PARTIAL_RETIRE_FLAG
, RETIRE_UNITS_FLAG RETIRE_UNITS_FLAG
, REJECTION_REASON_CODE REJECTION_REASON_CODE
, TRANSACTION_NAME TRANSACTION_NAME
, 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
, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, 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
, 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
, COST_OF_REMOVAL COST_OF_REMOVAL
, PROCEEDS_OF_SALE PROCEEDS_OF_SALE
FROM "FA"."FA_HR_RETIREMENT_HEADERS"