VIEW: WSH.WSH_TRIPS#

Source

View Text - Preformatted

select TRIP_ID TRIP_ID, NAME NAME, PLANNED_FLAG PLANNED_FLAG, ARRIVE_AFTER_TRIP_ID ARRIVE_AFTER_TRIP_ID, STATUS_CODE STATUS_CODE, VEHICLE_ITEM_ID VEHICLE_ITEM_ID, VEHICLE_NUMBER VEHICLE_NUMBER, CARRIER_ID CARRIER_ID, SHIP_METHOD_CODE SHIP_METHOD_CODE, ROUTE_ID ROUTE_ID, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, VEHICLE_ORGANIZATION_ID VEHICLE_ORGANIZATION_ID, VEHICLE_NUM_PREFIX VEHICLE_NUM_PREFIX, SERVICE_LEVEL SERVICE_LEVEL, MODE_OF_TRANSPORT MODE_OF_TRANSPORT, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, CONSOLIDATION_ALLOWED CONSOLIDATION_ALLOWED, LOAD_TENDER_STATUS LOAD_TENDER_STATUS, ROUTE_LANE_ID ROUTE_LANE_ID, LANE_ID LANE_ID, SCHEDULE_ID SCHEDULE_ID, BOOKING_NUMBER BOOKING_NUMBER, LOAD_TENDER_NUMBER LOAD_TENDER_NUMBER, VESSEL VESSEL, VOYAGE_NUMBER VOYAGE_NUMBER, PORT_OF_LOADING PORT_OF_LOADING, PORT_OF_DISCHARGE PORT_OF_DISCHARGE, WF_NAME WF_NAME, WF_PROCESS_NAME WF_PROCESS_NAME, WF_ITEM_KEY WF_ITEM_KEY, CARRIER_CONTACT_ID CARRIER_CONTACT_ID, SHIPPER_WAIT_TIME SHIPPER_WAIT_TIME, WAIT_TIME_UOM WAIT_TIME_UOM, LOAD_TENDERED_TIME LOAD_TENDERED_TIME, CARRIER_RESPONSE CARRIER_RESPONSE, SEAL_CODE SEAL_CODE, IGNORE_FOR_PLANNING IGNORE_FOR_PLANNING, TP_PLAN_NAME TP_PLAN_NAME, TP_TRIP_NUMBER TP_TRIP_NUMBER, SHIPMENTS_TYPE_FLAG SHIPMENTS_TYPE_FLAG, OPERATOR OPERATOR, TRIP_WF_PROCESS TRIP_WF_PROCESS, CARRIER_REFERENCE_NUMBER CARRIER_REFERENCE_NUMBER, RANK_ID RANK_ID, CONSIGNEE_CARRIER_AC_NO CONSIGNEE_CARRIER_AC_NO, ROUTING_RULE_ID ROUTING_RULE_ID, APPEND_FLAG APPEND_FLAG from "WSH"."WSH_TRIPS"

View Text - HTML Formatted

SELECT TRIP_ID TRIP_ID
, NAME NAME
, PLANNED_FLAG PLANNED_FLAG
, ARRIVE_AFTER_TRIP_ID ARRIVE_AFTER_TRIP_ID
, STATUS_CODE STATUS_CODE
, VEHICLE_ITEM_ID VEHICLE_ITEM_ID
, VEHICLE_NUMBER VEHICLE_NUMBER
, CARRIER_ID CARRIER_ID
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, ROUTE_ID ROUTE_ID
, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, VEHICLE_ORGANIZATION_ID VEHICLE_ORGANIZATION_ID
, VEHICLE_NUM_PREFIX VEHICLE_NUM_PREFIX
, SERVICE_LEVEL SERVICE_LEVEL
, MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, CONSOLIDATION_ALLOWED CONSOLIDATION_ALLOWED
, LOAD_TENDER_STATUS LOAD_TENDER_STATUS
, ROUTE_LANE_ID ROUTE_LANE_ID
, LANE_ID LANE_ID
, SCHEDULE_ID SCHEDULE_ID
, BOOKING_NUMBER BOOKING_NUMBER
, LOAD_TENDER_NUMBER LOAD_TENDER_NUMBER
, VESSEL VESSEL
, VOYAGE_NUMBER VOYAGE_NUMBER
, PORT_OF_LOADING PORT_OF_LOADING
, PORT_OF_DISCHARGE PORT_OF_DISCHARGE
, WF_NAME WF_NAME
, WF_PROCESS_NAME WF_PROCESS_NAME
, WF_ITEM_KEY WF_ITEM_KEY
, CARRIER_CONTACT_ID CARRIER_CONTACT_ID
, SHIPPER_WAIT_TIME SHIPPER_WAIT_TIME
, WAIT_TIME_UOM WAIT_TIME_UOM
, LOAD_TENDERED_TIME LOAD_TENDERED_TIME
, CARRIER_RESPONSE CARRIER_RESPONSE
, SEAL_CODE SEAL_CODE
, IGNORE_FOR_PLANNING IGNORE_FOR_PLANNING
, TP_PLAN_NAME TP_PLAN_NAME
, TP_TRIP_NUMBER TP_TRIP_NUMBER
, SHIPMENTS_TYPE_FLAG SHIPMENTS_TYPE_FLAG
, OPERATOR OPERATOR
, TRIP_WF_PROCESS TRIP_WF_PROCESS
, CARRIER_REFERENCE_NUMBER CARRIER_REFERENCE_NUMBER
, RANK_ID RANK_ID
, CONSIGNEE_CARRIER_AC_NO CONSIGNEE_CARRIER_AC_NO
, ROUTING_RULE_ID ROUTING_RULE_ID
, APPEND_FLAG APPEND_FLAG
FROM "WSH"."WSH_TRIPS"