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: CSF.CSF_LF_POIS_AU#

Source

View Text - Preformatted


select POI_ID POI_ID, FEATURE_CODE FEATURE_CODE, POI_ADDRESS POI_ADDRESS, TELEPHONE_NUMBER TELEPHONE_NUMBER, CHAIN_NAME CHAIN_NAME, FOOD_TYPE FOOD_TYPE, IMPORTANCE IMPORTANCE, POPULATION POPULATION, ROADSEGMENT_ID ROADSEGMENT_ID, PLACE_ID PLACE_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, POI_POINT POI_POINT from "CSF"."CSF_LF_POIS_AU"

View Text - HTML Formatted

SELECT POI_ID POI_ID
, FEATURE_CODE FEATURE_CODE
, POI_ADDRESS POI_ADDRESS
, TELEPHONE_NUMBER TELEPHONE_NUMBER
, CHAIN_NAME CHAIN_NAME
, FOOD_TYPE FOOD_TYPE
, IMPORTANCE IMPORTANCE
, POPULATION POPULATION
, ROADSEGMENT_ID ROADSEGMENT_ID
, PLACE_ID PLACE_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, POI_POINT POI_POINT
FROM "CSF"."CSF_LF_POIS_AU"