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_LOCATION#

Source

View Text - Preformatted


select ID ID, DESCRIPTION DESCRIPTION, GEOCOORDINATES GEOCOORDINATES, GEOCOORDINATES_TYPE GEOCOORDINATES_TYPE, LOCATION_ID LOCATION_ID, LOCATION_ID_TYPE LOCATION_ID_TYPE, SITELEVEL1 SITELEVEL1, SITELEVEL2 SITELEVEL2, SITELEVEL3 SITELEVEL3, SITELEVEL4 SITELEVEL4, SITELEVEL5 SITELEVEL5, SITELEVEL6 SITELEVEL6, SITELEVEL7 SITELEVEL7, SITELEVEL8 SITELEVEL8, SITELEVEL9 SITELEVEL9, ADDRESS_ID ADDRESS_ID, 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, LOCATION_TO_TABLE LOCATION_TO_TABLE, LOCATION_TO_ID LOCATION_TO_ID from "FTE"."FTE_MESSAGE_LOCATION"

View Text - HTML Formatted

SELECT ID ID
, DESCRIPTION DESCRIPTION
, GEOCOORDINATES GEOCOORDINATES
, GEOCOORDINATES_TYPE GEOCOORDINATES_TYPE
, LOCATION_ID LOCATION_ID
, LOCATION_ID_TYPE LOCATION_ID_TYPE
, SITELEVEL1 SITELEVEL1
, SITELEVEL2 SITELEVEL2
, SITELEVEL3 SITELEVEL3
, SITELEVEL4 SITELEVEL4
, SITELEVEL5 SITELEVEL5
, SITELEVEL6 SITELEVEL6
, SITELEVEL7 SITELEVEL7
, SITELEVEL8 SITELEVEL8
, SITELEVEL9 SITELEVEL9
, ADDRESS_ID ADDRESS_ID
, 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
, LOCATION_TO_TABLE LOCATION_TO_TABLE
, LOCATION_TO_ID LOCATION_TO_ID
FROM "FTE"."FTE_MESSAGE_LOCATION"