eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: FA.FA_TRANSFER_REP_ITF#

Source

View Text - Preformatted


select REQUEST_ID REQUEST_ID, ASSET_NUMBER ASSET_NUMBER, DESCRIPTION DESCRIPTION, SERIAL_NUMBER SERIAL_NUMBER, TAG_NUMBER TAG_NUMBER, ASSET_KEY ASSET_KEY, TO_COMPANY TO_COMPANY, TO_COST_CENTER TO_COST_CENTER, TO_EXPENSE_ACCT TO_EXPENSE_ACCT, FROM_COMPANY FROM_COMPANY, FROM_COST_CENTER FROM_COST_CENTER, FROM_EXPENSE_ACCT FROM_EXPENSE_ACCT, COST_ACCT COST_ACCT, RESERVE_ACCT RESERVE_ACCT, YTD_DEPRN YTD_DEPRN, RESERVE RESERVE, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, MASS_TRANSFER_ID MASS_TRANSFER_ID, TO_LOCATION TO_LOCATION, TO_EMPLOYEE_NAME TO_EMPLOYEE_NAME, TO_EMPLOYEE_NUMBER TO_EMPLOYEE_NUMBER, FROM_LOCATION FROM_LOCATION, FROM_EMPLOYEE_NAME FROM_EMPLOYEE_NAME, FROM_EMPLOYEE_NUMBER FROM_EMPLOYEE_NUMBER, TRANSACTION_DATE TRANSACTION_DATE, COST_TRANSFERRED COST_TRANSFERRED, RESERVE_TRANSFERRED RESERVE_TRANSFERRED, UNITS_TRANSFERRED UNITS_TRANSFERRED, 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, ASSET_TYPE ASSET_TYPE from "FA"."FA_TRANSFER_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, ASSET_NUMBER ASSET_NUMBER
, DESCRIPTION DESCRIPTION
, SERIAL_NUMBER SERIAL_NUMBER
, TAG_NUMBER TAG_NUMBER
, ASSET_KEY ASSET_KEY
, TO_COMPANY TO_COMPANY
, TO_COST_CENTER TO_COST_CENTER
, TO_EXPENSE_ACCT TO_EXPENSE_ACCT
, FROM_COMPANY FROM_COMPANY
, FROM_COST_CENTER FROM_COST_CENTER
, FROM_EXPENSE_ACCT FROM_EXPENSE_ACCT
, COST_ACCT COST_ACCT
, RESERVE_ACCT RESERVE_ACCT
, YTD_DEPRN YTD_DEPRN
, RESERVE RESERVE
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, MASS_TRANSFER_ID MASS_TRANSFER_ID
, TO_LOCATION TO_LOCATION
, TO_EMPLOYEE_NAME TO_EMPLOYEE_NAME
, TO_EMPLOYEE_NUMBER TO_EMPLOYEE_NUMBER
, FROM_LOCATION FROM_LOCATION
, FROM_EMPLOYEE_NAME FROM_EMPLOYEE_NAME
, FROM_EMPLOYEE_NUMBER FROM_EMPLOYEE_NUMBER
, TRANSACTION_DATE TRANSACTION_DATE
, COST_TRANSFERRED COST_TRANSFERRED
, RESERVE_TRANSFERRED RESERVE_TRANSFERRED
, UNITS_TRANSFERRED UNITS_TRANSFERRED
, 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
, ASSET_TYPE ASSET_TYPE
FROM "FA"."FA_TRANSFER_REP_ITF"