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.

VIEW: FTE.FTE_MESSAGE_ADDRESS#

Source

View Text - Preformatted


select ID ID, ADDR_LINE1 ADDR_LINE1, ADDR_LINE2 ADDR_LINE2, ADDR_LINE3 ADDR_LINE3, ADDR_LINE4 ADDR_LINE4, ADDR_LINE5 ADDR_LINE5, ADDR_LINE6 ADDR_LINE6, ADDR_LINE7 ADDR_LINE7, ADDR_LINE8 ADDR_LINE8, ADDR_LINE9 ADDR_LINE9, ADDR_TYPE ADDR_TYPE, ADDR_CITY ADDR_CITY, ADDR_COUNTY ADDR_COUNTY, ADDR_COUNTRY ADDR_COUNTRY, ADDR_DESCRIPTION ADDR_DESCRIPTION, ADDR_POSTAL_CODE ADDR_POSTAL_CODE, ADDR_REGION ADDR_REGION, ADDR_STATE ADDR_STATE, ADDR_TAX_JURISDICTION ADDR_TAX_JURISDICTION, ADDR_URL ADDR_URL, FAX1 FAX1, FAX2 FAX2, FAX3 FAX3, FAX4 FAX4, FAX5 FAX5, FAX6 FAX6, FAX7 FAX7, FAX8 FAX8, FAX9 FAX9, TELEPHONE1 TELEPHONE1, TELEPHONE2 TELEPHONE2, TELEPHONE3 TELEPHONE3, TELEPHONE4 TELEPHONE4, TELEPHONE5 TELEPHONE5, TELEPHONE6 TELEPHONE6, TELEPHONE7 TELEPHONE7, TELEPHONE8 TELEPHONE8, TELEPHONE9 TELEPHONE9, 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, TRANSACTION_ID TRANSACTION_ID, ADDRESS_TO_TABLE ADDRESS_TO_TABLE, ADDRESS_TO_ID ADDRESS_TO_ID from "FTE"."FTE_MESSAGE_ADDRESS"

View Text - HTML Formatted

SELECT ID ID
, ADDR_LINE1 ADDR_LINE1
, ADDR_LINE2 ADDR_LINE2
, ADDR_LINE3 ADDR_LINE3
, ADDR_LINE4 ADDR_LINE4
, ADDR_LINE5 ADDR_LINE5
, ADDR_LINE6 ADDR_LINE6
, ADDR_LINE7 ADDR_LINE7
, ADDR_LINE8 ADDR_LINE8
, ADDR_LINE9 ADDR_LINE9
, ADDR_TYPE ADDR_TYPE
, ADDR_CITY ADDR_CITY
, ADDR_COUNTY ADDR_COUNTY
, ADDR_COUNTRY ADDR_COUNTRY
, ADDR_DESCRIPTION ADDR_DESCRIPTION
, ADDR_POSTAL_CODE ADDR_POSTAL_CODE
, ADDR_REGION ADDR_REGION
, ADDR_STATE ADDR_STATE
, ADDR_TAX_JURISDICTION ADDR_TAX_JURISDICTION
, ADDR_URL ADDR_URL
, FAX1 FAX1
, FAX2 FAX2
, FAX3 FAX3
, FAX4 FAX4
, FAX5 FAX5
, FAX6 FAX6
, FAX7 FAX7
, FAX8 FAX8
, FAX9 FAX9
, TELEPHONE1 TELEPHONE1
, TELEPHONE2 TELEPHONE2
, TELEPHONE3 TELEPHONE3
, TELEPHONE4 TELEPHONE4
, TELEPHONE5 TELEPHONE5
, TELEPHONE6 TELEPHONE6
, TELEPHONE7 TELEPHONE7
, TELEPHONE8 TELEPHONE8
, TELEPHONE9 TELEPHONE9
, 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
, TRANSACTION_ID TRANSACTION_ID
, ADDRESS_TO_TABLE ADDRESS_TO_TABLE
, ADDRESS_TO_ID ADDRESS_TO_ID
FROM "FTE"."FTE_MESSAGE_ADDRESS"