VIEW: FA.FA_RETIRE_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, EMPLOYEE_NAME EMPLOYEE_NAME, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, COMPANY COMPANY, COST_CENTER COST_CENTER, EXPENSE_ACCT EXPENSE_ACCT, LOCATION LOCATION, CATEGORY CATEGORY, COST_ACCT COST_ACCT, RESERVE_ACCT RESERVE_ACCT, ASSET_NUMBER ASSET_NUMBER, DESCRIPTION DESCRIPTION, SERIAL_NUMBER SERIAL_NUMBER, TAG_NUMBER TAG_NUMBER, ASSET_KEY ASSET_KEY, DATE_RETIRED DATE_RETIRED, UNITS_RETIRED UNITS_RETIRED, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, COST_RETIRED COST_RETIRED, NBV_RETIRED NBV_RETIRED, PROCEEDS_OF_SALE PROCEEDS_OF_SALE, GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT, REMOVAL_COST REMOVAL_COST, ITC_CAPTURED ITC_CAPTURED, FLAG FLAG, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, 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, INVENTORIAL INVENTORIAL, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ORGANIZATION_NAME ORGANIZATION_NAME, BOOK_TYPE_CODE BOOK_TYPE_CODE, PERIOD_NAME PERIOD_NAME, PERIOD_NAME_TO PERIOD_NAME_TO, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, COST_CENTER_DESCRIPTION COST_CENTER_DESCRIPTION, DEPRN_RESERVE DEPRN_RESERVE, MAJOR_CATEGORY MAJOR_CATEGORY, MAJOR_CATEGORY_DESC MAJOR_CATEGORY_DESC, MINOR_CATEGORY MINOR_CATEGORY, MINOR_CATEGORY_DESC MINOR_CATEGORY_DESC, SPECIFIED_CATEGORY_SEG SPECIFIED_CATEGORY_SEG, SPECIFIED_CAT_SEG_DESC SPECIFIED_CAT_SEG_DESC, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER from "FA"."FA_RETIRE_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, EMPLOYEE_NAME EMPLOYEE_NAME
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, COMPANY COMPANY
, COST_CENTER COST_CENTER
, EXPENSE_ACCT EXPENSE_ACCT
, LOCATION LOCATION
, CATEGORY CATEGORY
, COST_ACCT COST_ACCT
, RESERVE_ACCT RESERVE_ACCT
, ASSET_NUMBER ASSET_NUMBER
, DESCRIPTION DESCRIPTION
, SERIAL_NUMBER SERIAL_NUMBER
, TAG_NUMBER TAG_NUMBER
, ASSET_KEY ASSET_KEY
, DATE_RETIRED DATE_RETIRED
, UNITS_RETIRED UNITS_RETIRED
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, COST_RETIRED COST_RETIRED
, NBV_RETIRED NBV_RETIRED
, PROCEEDS_OF_SALE PROCEEDS_OF_SALE
, GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT
, REMOVAL_COST REMOVAL_COST
, ITC_CAPTURED ITC_CAPTURED
, FLAG FLAG
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, 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
, INVENTORIAL INVENTORIAL
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME ORGANIZATION_NAME
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, PERIOD_NAME PERIOD_NAME
, PERIOD_NAME_TO PERIOD_NAME_TO
, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION
, COST_CENTER_DESCRIPTION COST_CENTER_DESCRIPTION
, DEPRN_RESERVE DEPRN_RESERVE
, MAJOR_CATEGORY MAJOR_CATEGORY
, MAJOR_CATEGORY_DESC MAJOR_CATEGORY_DESC
, MINOR_CATEGORY MINOR_CATEGORY
, MINOR_CATEGORY_DESC MINOR_CATEGORY_DESC
, SPECIFIED_CATEGORY_SEG SPECIFIED_CATEGORY_SEG
, SPECIFIED_CAT_SEG_DESC SPECIFIED_CAT_SEG_DESC
, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER
FROM "FA"."FA_RETIRE_REP_ITF"