VIEW: WSH.WSH_NEW_DELIVERIES#

Source

View Text - Preformatted

select DELIVERY_ID DELIVERY_ID, NAME NAME, PLANNED_FLAG PLANNED_FLAG, STATUS_CODE STATUS_CODE, INITIAL_PICKUP_DATE INITIAL_PICKUP_DATE, INITIAL_PICKUP_LOCATION_ID INITIAL_PICKUP_LOCATION_ID, ULTIMATE_DROPOFF_LOCATION_ID ULTIMATE_DROPOFF_LOCATION_ID, ULTIMATE_DROPOFF_DATE ULTIMATE_DROPOFF_DATE, CUSTOMER_ID CUSTOMER_ID, INTMED_SHIP_TO_LOCATION_ID INTMED_SHIP_TO_LOCATION_ID, POOLED_SHIP_TO_LOCATION_ID POOLED_SHIP_TO_LOCATION_ID, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FOB_CODE FOB_CODE, FOB_LOCATION_ID FOB_LOCATION_ID, WAYBILL WAYBILL, ACCEPTANCE_FLAG ACCEPTANCE_FLAG, ACCEPTED_BY ACCEPTED_BY, ACCEPTED_DATE ACCEPTED_DATE, ACKNOWLEDGED_BY ACKNOWLEDGED_BY, CONFIRMED_BY CONFIRMED_BY, ASN_DATE_SENT ASN_DATE_SENT, ASN_STATUS_CODE ASN_STATUS_CODE, ASN_SEQ_NUMBER ASN_SEQ_NUMBER, REASON_OF_TRANSPORT REASON_OF_TRANSPORT, DESCRIPTION DESCRIPTION, GROSS_WEIGHT GROSS_WEIGHT, NET_WEIGHT NET_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, VOLUME VOLUME, VOLUME_UOM_CODE VOLUME_UOM_CODE, ADDITIONAL_SHIPMENT_INFO ADDITIONAL_SHIPMENT_INFO, PORT_OF_DISCHARGE PORT_OF_DISCHARGE, BOOKING_NUMBER BOOKING_NUMBER, COD_AMOUNT COD_AMOUNT, COD_CURRENCY_CODE COD_CURRENCY_CODE, SERVICE_CONTRACT SERVICE_CONTRACT, COD_REMIT_TO COD_REMIT_TO, COD_CHARGE_PAID_BY COD_CHARGE_PAID_BY, PROBLEM_CONTACT_REFERENCE PROBLEM_CONTACT_REFERENCE, BILL_FREIGHT_TO BILL_FREIGHT_TO, CARRIED_BY CARRIED_BY, PORT_OF_LOADING PORT_OF_LOADING, 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, TP_ATTRIBUTE_CATEGORY TP_ATTRIBUTE_CATEGORY, TP_ATTRIBUTE1 TP_ATTRIBUTE1, TP_ATTRIBUTE2 TP_ATTRIBUTE2, TP_ATTRIBUTE3 TP_ATTRIBUTE3, TP_ATTRIBUTE4 TP_ATTRIBUTE4, TP_ATTRIBUTE5 TP_ATTRIBUTE5, TP_ATTRIBUTE6 TP_ATTRIBUTE6, TP_ATTRIBUTE7 TP_ATTRIBUTE7, TP_ATTRIBUTE8 TP_ATTRIBUTE8, TP_ATTRIBUTE9 TP_ATTRIBUTE9, TP_ATTRIBUTE10 TP_ATTRIBUTE10, TP_ATTRIBUTE11 TP_ATTRIBUTE11, TP_ATTRIBUTE12 TP_ATTRIBUTE12, TP_ATTRIBUTE13 TP_ATTRIBUTE13, TP_ATTRIBUTE14 TP_ATTRIBUTE14, TP_ATTRIBUTE15 TP_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, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, CONFIRM_DATE CONFIRM_DATE, SHIP_METHOD_CODE SHIP_METHOD_CODE, DOCK_CODE DOCK_CODE, DELIVERY_TYPE DELIVERY_TYPE, CARRIER_ID CARRIER_ID, CURRENCY_CODE CURRENCY_CODE, ORGANIZATION_ID ORGANIZATION_ID, LOADING_SEQUENCE LOADING_SEQUENCE, LOADING_ORDER_FLAG LOADING_ORDER_FLAG, NUMBER_OF_LPN NUMBER_OF_LPN, BATCH_ID BATCH_ID, SOURCE_HEADER_ID SOURCE_HEADER_ID, HASH_VALUE HASH_VALUE, FTZ_NUMBER FTZ_NUMBER, ROUTED_EXPORT_TXN ROUTED_EXPORT_TXN, ENTRY_NUMBER ENTRY_NUMBER, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS, IN_BOND_CODE IN_BOND_CODE, SHIPPING_MARKS SHIPPING_MARKS, SERVICE_LEVEL SERVICE_LEVEL, MODE_OF_TRANSPORT MODE_OF_TRANSPORT, ASSIGNED_TO_FTE_TRIPS ASSIGNED_TO_FTE_TRIPS, AUTO_SC_EXCLUDE_FLAG AUTO_SC_EXCLUDE_FLAG, AUTO_AP_EXCLUDE_FLAG AUTO_AP_EXCLUDE_FLAG, AP_BATCH_ID AP_BATCH_ID, TP_DELIVERY_NUMBER TP_DELIVERY_NUMBER, TP_PLAN_NAME TP_PLAN_NAME, VENDOR_ID VENDOR_ID, EARLIEST_PICKUP_DATE EARLIEST_PICKUP_DATE, LATEST_PICKUP_DATE LATEST_PICKUP_DATE, EARLIEST_DROPOFF_DATE EARLIEST_DROPOFF_DATE, LATEST_DROPOFF_DATE LATEST_DROPOFF_DATE, IGNORE_FOR_PLANNING IGNORE_FOR_PLANNING, PARTY_ID PARTY_ID, ROUTING_RESPONSE_ID ROUTING_RESPONSE_ID, RCV_SHIPMENT_HEADER_ID RCV_SHIPMENT_HEADER_ID, ASN_SHIPMENT_HEADER_ID ASN_SHIPMENT_HEADER_ID, SHIPMENT_DIRECTION SHIPMENT_DIRECTION, SHIPPING_CONTROL SHIPPING_CONTROL, WV_FROZEN_FLAG WV_FROZEN_FLAG, HASH_STRING HASH_STRING, ITINERARY_COMPLETE ITINERARY_COMPLETE, DELIVERED_DATE DELIVERED_DATE, DELIVERY_WF_PROCESS DELIVERY_WF_PROCESS, DEL_WF_INTRANSIT_ATTR DEL_WF_INTRANSIT_ATTR, DEL_WF_INTERFACE_ATTR DEL_WF_INTERFACE_ATTR, DEL_WF_CLOSE_ATTR DEL_WF_CLOSE_ATTR, DELIVERY_SCPOD_WF_PROCESS DELIVERY_SCPOD_WF_PROCESS, TMS_VERSION_NUMBER TMS_VERSION_NUMBER, TMS_INTERFACE_FLAG TMS_INTERFACE_FLAG, PENDING_ADVICE_FLAG PENDING_ADVICE_FLAG, CLIENT_ID CLIENT_ID, CONSIGNEE_FLAG CONSIGNEE_FLAG from "WSH"."WSH_NEW_DELIVERIES"

View Text - HTML Formatted

SELECT DELIVERY_ID DELIVERY_ID
, NAME NAME
, PLANNED_FLAG PLANNED_FLAG
, STATUS_CODE STATUS_CODE
, INITIAL_PICKUP_DATE INITIAL_PICKUP_DATE
, INITIAL_PICKUP_LOCATION_ID INITIAL_PICKUP_LOCATION_ID
, ULTIMATE_DROPOFF_LOCATION_ID ULTIMATE_DROPOFF_LOCATION_ID
, ULTIMATE_DROPOFF_DATE ULTIMATE_DROPOFF_DATE
, CUSTOMER_ID CUSTOMER_ID
, INTMED_SHIP_TO_LOCATION_ID INTMED_SHIP_TO_LOCATION_ID
, POOLED_SHIP_TO_LOCATION_ID POOLED_SHIP_TO_LOCATION_ID
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FOB_CODE FOB_CODE
, FOB_LOCATION_ID FOB_LOCATION_ID
, WAYBILL WAYBILL
, ACCEPTANCE_FLAG ACCEPTANCE_FLAG
, ACCEPTED_BY ACCEPTED_BY
, ACCEPTED_DATE ACCEPTED_DATE
, ACKNOWLEDGED_BY ACKNOWLEDGED_BY
, CONFIRMED_BY CONFIRMED_BY
, ASN_DATE_SENT ASN_DATE_SENT
, ASN_STATUS_CODE ASN_STATUS_CODE
, ASN_SEQ_NUMBER ASN_SEQ_NUMBER
, REASON_OF_TRANSPORT REASON_OF_TRANSPORT
, DESCRIPTION DESCRIPTION
, GROSS_WEIGHT GROSS_WEIGHT
, NET_WEIGHT NET_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, VOLUME VOLUME
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, ADDITIONAL_SHIPMENT_INFO ADDITIONAL_SHIPMENT_INFO
, PORT_OF_DISCHARGE PORT_OF_DISCHARGE
, BOOKING_NUMBER BOOKING_NUMBER
, COD_AMOUNT COD_AMOUNT
, COD_CURRENCY_CODE COD_CURRENCY_CODE
, SERVICE_CONTRACT SERVICE_CONTRACT
, COD_REMIT_TO COD_REMIT_TO
, COD_CHARGE_PAID_BY COD_CHARGE_PAID_BY
, PROBLEM_CONTACT_REFERENCE PROBLEM_CONTACT_REFERENCE
, BILL_FREIGHT_TO BILL_FREIGHT_TO
, CARRIED_BY CARRIED_BY
, PORT_OF_LOADING PORT_OF_LOADING
, 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
, TP_ATTRIBUTE_CATEGORY TP_ATTRIBUTE_CATEGORY
, TP_ATTRIBUTE1 TP_ATTRIBUTE1
, TP_ATTRIBUTE2 TP_ATTRIBUTE2
, TP_ATTRIBUTE3 TP_ATTRIBUTE3
, TP_ATTRIBUTE4 TP_ATTRIBUTE4
, TP_ATTRIBUTE5 TP_ATTRIBUTE5
, TP_ATTRIBUTE6 TP_ATTRIBUTE6
, TP_ATTRIBUTE7 TP_ATTRIBUTE7
, TP_ATTRIBUTE8 TP_ATTRIBUTE8
, TP_ATTRIBUTE9 TP_ATTRIBUTE9
, TP_ATTRIBUTE10 TP_ATTRIBUTE10
, TP_ATTRIBUTE11 TP_ATTRIBUTE11
, TP_ATTRIBUTE12 TP_ATTRIBUTE12
, TP_ATTRIBUTE13 TP_ATTRIBUTE13
, TP_ATTRIBUTE14 TP_ATTRIBUTE14
, TP_ATTRIBUTE15 TP_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
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, CONFIRM_DATE CONFIRM_DATE
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, DOCK_CODE DOCK_CODE
, DELIVERY_TYPE DELIVERY_TYPE
, CARRIER_ID CARRIER_ID
, CURRENCY_CODE CURRENCY_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, LOADING_SEQUENCE LOADING_SEQUENCE
, LOADING_ORDER_FLAG LOADING_ORDER_FLAG
, NUMBER_OF_LPN NUMBER_OF_LPN
, BATCH_ID BATCH_ID
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, HASH_VALUE HASH_VALUE
, FTZ_NUMBER FTZ_NUMBER
, ROUTED_EXPORT_TXN ROUTED_EXPORT_TXN
, ENTRY_NUMBER ENTRY_NUMBER
, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS
, IN_BOND_CODE IN_BOND_CODE
, SHIPPING_MARKS SHIPPING_MARKS
, SERVICE_LEVEL SERVICE_LEVEL
, MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, ASSIGNED_TO_FTE_TRIPS ASSIGNED_TO_FTE_TRIPS
, AUTO_SC_EXCLUDE_FLAG AUTO_SC_EXCLUDE_FLAG
, AUTO_AP_EXCLUDE_FLAG AUTO_AP_EXCLUDE_FLAG
, AP_BATCH_ID AP_BATCH_ID
, TP_DELIVERY_NUMBER TP_DELIVERY_NUMBER
, TP_PLAN_NAME TP_PLAN_NAME
, VENDOR_ID VENDOR_ID
, EARLIEST_PICKUP_DATE EARLIEST_PICKUP_DATE
, LATEST_PICKUP_DATE LATEST_PICKUP_DATE
, EARLIEST_DROPOFF_DATE EARLIEST_DROPOFF_DATE
, LATEST_DROPOFF_DATE LATEST_DROPOFF_DATE
, IGNORE_FOR_PLANNING IGNORE_FOR_PLANNING
, PARTY_ID PARTY_ID
, ROUTING_RESPONSE_ID ROUTING_RESPONSE_ID
, RCV_SHIPMENT_HEADER_ID RCV_SHIPMENT_HEADER_ID
, ASN_SHIPMENT_HEADER_ID ASN_SHIPMENT_HEADER_ID
, SHIPMENT_DIRECTION SHIPMENT_DIRECTION
, SHIPPING_CONTROL SHIPPING_CONTROL
, WV_FROZEN_FLAG WV_FROZEN_FLAG
, HASH_STRING HASH_STRING
, ITINERARY_COMPLETE ITINERARY_COMPLETE
, DELIVERED_DATE DELIVERED_DATE
, DELIVERY_WF_PROCESS DELIVERY_WF_PROCESS
, DEL_WF_INTRANSIT_ATTR DEL_WF_INTRANSIT_ATTR
, DEL_WF_INTERFACE_ATTR DEL_WF_INTERFACE_ATTR
, DEL_WF_CLOSE_ATTR DEL_WF_CLOSE_ATTR
, DELIVERY_SCPOD_WF_PROCESS DELIVERY_SCPOD_WF_PROCESS
, TMS_VERSION_NUMBER TMS_VERSION_NUMBER
, TMS_INTERFACE_FLAG TMS_INTERFACE_FLAG
, PENDING_ADVICE_FLAG PENDING_ADVICE_FLAG
, CLIENT_ID CLIENT_ID
, CONSIGNEE_FLAG CONSIGNEE_FLAG
FROM "WSH"."WSH_NEW_DELIVERIES"