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: WMS.WMS_DOCK_APPOINTMENTS_B#

Source

View Text - Preformatted


select DOCK_APPOINTMENT_ID DOCK_APPOINTMENT_ID, APPOINTMENT_TYPE APPOINTMENT_TYPE, DOCK_ID DOCK_ID, ORGANIZATION_ID ORGANIZATION_ID, START_TIME START_TIME, END_TIME END_TIME, CARRIER CARRIER, SOURCE_TYPE SOURCE_TYPE, SOURCE_HEADER_ID SOURCE_HEADER_ID, SOURCE_LINE_ID SOURCE_LINE_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, STAGING_LANE_ID STAGING_LANE_ID, TRIP_STOP TRIP_STOP, REP_START_DATE REP_START_DATE, REP_END_DATE REP_END_DATE, REP_ORIGIN REP_ORIGIN, REP_FREQUENCY REP_FREQUENCY, APPOINTMENT_STATUS APPOINTMENT_STATUS, CARRIER_CODE CARRIER_CODE from "WMS"."WMS_DOCK_APPOINTMENTS_B"

View Text - HTML Formatted

SELECT DOCK_APPOINTMENT_ID DOCK_APPOINTMENT_ID
, APPOINTMENT_TYPE APPOINTMENT_TYPE
, DOCK_ID DOCK_ID
, ORGANIZATION_ID ORGANIZATION_ID
, START_TIME START_TIME
, END_TIME END_TIME
, CARRIER CARRIER
, SOURCE_TYPE SOURCE_TYPE
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, SOURCE_LINE_ID SOURCE_LINE_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
, STAGING_LANE_ID STAGING_LANE_ID
, TRIP_STOP TRIP_STOP
, REP_START_DATE REP_START_DATE
, REP_END_DATE REP_END_DATE
, REP_ORIGIN REP_ORIGIN
, REP_FREQUENCY REP_FREQUENCY
, APPOINTMENT_STATUS APPOINTMENT_STATUS
, CARRIER_CODE CARRIER_CODE
FROM "WMS"."WMS_DOCK_APPOINTMENTS_B"