VIEW: WSH.WSH_DEL_LEGS_INTERFACE#

Source

View Text - Preformatted

select DELIVERY_LEG_INTERFACE_ID DELIVERY_LEG_INTERFACE_ID, DELIVERY_LEG_ID DELIVERY_LEG_ID, DELIVERY_ID DELIVERY_ID, DELIVERY_INTERFACE_ID DELIVERY_INTERFACE_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SEQUENCE_NUMBER SEQUENCE_NUMBER, LOADING_ORDER_FLAG LOADING_ORDER_FLAG, PICK_UP_STOP_ID PICK_UP_STOP_ID, PICK_UP_STOP_INTERFACE_ID PICK_UP_STOP_INTERFACE_ID, DROP_OFF_STOP_ID DROP_OFF_STOP_ID, DROP_OFF_STOP_INTERFACE_ID DROP_OFF_STOP_INTERFACE_ID, GROSS_WEIGHT GROSS_WEIGHT, NET_WEIGHT NET_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, VOLUME VOLUME, VOLUME_UOM_CODE VOLUME_UOM_CODE, 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, INTERFACE_ACTION_CODE INTERFACE_ACTION_CODE, LOCK_FLAG LOCK_FLAG, PROCESS_FLAG PROCESS_FLAG, PROCESS_MODE PROCESS_MODE, DELETE_FLAG DELETE_FLAG, PROCESS_STATUS_FLAG PROCESS_STATUS_FLAG, AETC_NUMBER AETC_NUMBER, BILL_FREIGHT_TO BILL_FREIGHT_TO, BOOKING_NUMBER BOOKING_NUMBER, BOOKING_OFFICE BOOKING_OFFICE, CARRIER_DATE CARRIER_DATE, CARRIER_EXPORT_REF CARRIER_EXPORT_REF, CARRIER_HM_BY CARRIER_HM_BY, CARRIER_HM_DATE CARRIER_HM_DATE, CARRIER_SIGNED_BY CARRIER_SIGNED_BY, DOC_DATE_ISSUED DOC_DATE_ISSUED, DOC_ISSUE_OFFICE DOC_ISSUE_OFFICE, DOC_ISSUED_BY DOC_ISSUED_BY, DOC_NOTIFY_PARTY DOC_NOTIFY_PARTY, EXPECTED_POD_DATE EXPECTED_POD_DATE, POD_BY POD_BY, POD_DATE POD_DATE, POD_FLAG POD_FLAG, PORT_OF_DISCHARGE PORT_OF_DISCHARGE, PORT_OF_LOADING PORT_OF_LOADING, REQUEST_ID REQUEST_ID, SERVICE_CONTRACT SERVICE_CONTRACT, SHIPPER_DATE SHIPPER_DATE, SHIPPER_EXPORT_REF SHIPPER_EXPORT_REF, SHIPPER_HM_BY SHIPPER_HM_BY, SHIPPER_HM_DATE SHIPPER_HM_DATE, SHIPPER_PHONE SHIPPER_PHONE, SHIPPER_SIGNED_BY SHIPPER_SIGNED_BY, SHIPPER_TITLE SHIPPER_TITLE from "WSH"."WSH_DEL_LEGS_INTERFACE"

View Text - HTML Formatted

SELECT DELIVERY_LEG_INTERFACE_ID DELIVERY_LEG_INTERFACE_ID
, DELIVERY_LEG_ID DELIVERY_LEG_ID
, DELIVERY_ID DELIVERY_ID
, DELIVERY_INTERFACE_ID DELIVERY_INTERFACE_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, LOADING_ORDER_FLAG LOADING_ORDER_FLAG
, PICK_UP_STOP_ID PICK_UP_STOP_ID
, PICK_UP_STOP_INTERFACE_ID PICK_UP_STOP_INTERFACE_ID
, DROP_OFF_STOP_ID DROP_OFF_STOP_ID
, DROP_OFF_STOP_INTERFACE_ID DROP_OFF_STOP_INTERFACE_ID
, GROSS_WEIGHT GROSS_WEIGHT
, NET_WEIGHT NET_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, VOLUME VOLUME
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, 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
, INTERFACE_ACTION_CODE INTERFACE_ACTION_CODE
, LOCK_FLAG LOCK_FLAG
, PROCESS_FLAG PROCESS_FLAG
, PROCESS_MODE PROCESS_MODE
, DELETE_FLAG DELETE_FLAG
, PROCESS_STATUS_FLAG PROCESS_STATUS_FLAG
, AETC_NUMBER AETC_NUMBER
, BILL_FREIGHT_TO BILL_FREIGHT_TO
, BOOKING_NUMBER BOOKING_NUMBER
, BOOKING_OFFICE BOOKING_OFFICE
, CARRIER_DATE CARRIER_DATE
, CARRIER_EXPORT_REF CARRIER_EXPORT_REF
, CARRIER_HM_BY CARRIER_HM_BY
, CARRIER_HM_DATE CARRIER_HM_DATE
, CARRIER_SIGNED_BY CARRIER_SIGNED_BY
, DOC_DATE_ISSUED DOC_DATE_ISSUED
, DOC_ISSUE_OFFICE DOC_ISSUE_OFFICE
, DOC_ISSUED_BY DOC_ISSUED_BY
, DOC_NOTIFY_PARTY DOC_NOTIFY_PARTY
, EXPECTED_POD_DATE EXPECTED_POD_DATE
, POD_BY POD_BY
, POD_DATE POD_DATE
, POD_FLAG POD_FLAG
, PORT_OF_DISCHARGE PORT_OF_DISCHARGE
, PORT_OF_LOADING PORT_OF_LOADING
, REQUEST_ID REQUEST_ID
, SERVICE_CONTRACT SERVICE_CONTRACT
, SHIPPER_DATE SHIPPER_DATE
, SHIPPER_EXPORT_REF SHIPPER_EXPORT_REF
, SHIPPER_HM_BY SHIPPER_HM_BY
, SHIPPER_HM_DATE SHIPPER_HM_DATE
, SHIPPER_PHONE SHIPPER_PHONE
, SHIPPER_SIGNED_BY SHIPPER_SIGNED_BY
, SHIPPER_TITLE SHIPPER_TITLE
FROM "WSH"."WSH_DEL_LEGS_INTERFACE"