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: WSH.WSH_CARRIER_SITES#

Source

View Text - Preformatted


select CARRIER_ID CARRIER_ID, CARRIER_SITE_ID CARRIER_SITE_ID, EMAIL_ADDRESS EMAIL_ADDRESS, AUTO_ACCEPT_LOAD_TENDER AUTO_ACCEPT_LOAD_TENDER, TENDER_WAIT_TIME TENDER_WAIT_TIME, WAIT_TIME_UOM WAIT_TIME_UOM, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WEIGHT_THRESHOLD_UPPER WEIGHT_THRESHOLD_UPPER, WEIGHT_THRESHOLD_LOWER WEIGHT_THRESHOLD_LOWER, VOLUME_THRESHOLD_UPPER VOLUME_THRESHOLD_UPPER, VOLUME_THRESHOLD_LOWER VOLUME_THRESHOLD_LOWER, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, ENABLE_AUTO_TENDER ENABLE_AUTO_TENDER, TENDER_TRANSMISSION_METHOD TENDER_TRANSMISSION_METHOD from "WSH"."WSH_CARRIER_SITES"

View Text - HTML Formatted

SELECT CARRIER_ID CARRIER_ID
, CARRIER_SITE_ID CARRIER_SITE_ID
, EMAIL_ADDRESS EMAIL_ADDRESS
, AUTO_ACCEPT_LOAD_TENDER AUTO_ACCEPT_LOAD_TENDER
, TENDER_WAIT_TIME TENDER_WAIT_TIME
, WAIT_TIME_UOM WAIT_TIME_UOM
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WEIGHT_THRESHOLD_UPPER WEIGHT_THRESHOLD_UPPER
, WEIGHT_THRESHOLD_LOWER WEIGHT_THRESHOLD_LOWER
, VOLUME_THRESHOLD_UPPER VOLUME_THRESHOLD_UPPER
, VOLUME_THRESHOLD_LOWER VOLUME_THRESHOLD_LOWER
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, ENABLE_AUTO_TENDER ENABLE_AUTO_TENDER
, TENDER_TRANSMISSION_METHOD TENDER_TRANSMISSION_METHOD
FROM "WSH"."WSH_CARRIER_SITES"