VIEW: WSH.WSH_DELIVERY_DETAILS#

Source

View Text - Preformatted

select DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, SOURCE_CODE SOURCE_CODE, SOURCE_HEADER_ID SOURCE_HEADER_ID, SOURCE_LINE_ID SOURCE_LINE_ID, SOURCE_HEADER_TYPE_ID SOURCE_HEADER_TYPE_ID, SOURCE_HEADER_TYPE_NAME SOURCE_HEADER_TYPE_NAME, CUST_PO_NUMBER CUST_PO_NUMBER, CUSTOMER_ID CUSTOMER_ID, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, SHIP_SET_ID SHIP_SET_ID, ARRIVAL_SET_ID ARRIVAL_SET_ID, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID, ATO_LINE_ID ATO_LINE_ID, HOLD_CODE HOLD_CODE, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG, HAZARD_CLASS_ID HAZARD_CLASS_ID, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN, CLASSIFICATION CLASSIFICATION, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID, ORGANIZATION_ID ORGANIZATION_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, INTMED_SHIP_TO_LOCATION_ID INTMED_SHIP_TO_LOCATION_ID, INTMED_SHIP_TO_CONTACT_ID INTMED_SHIP_TO_CONTACT_ID, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW, SRC_REQUESTED_QUANTITY SRC_REQUESTED_QUANTITY, SRC_REQUESTED_QUANTITY_UOM SRC_REQUESTED_QUANTITY_UOM, CANCELLED_QUANTITY CANCELLED_QUANTITY, REQUESTED_QUANTITY REQUESTED_QUANTITY, REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM, SHIPPED_QUANTITY SHIPPED_QUANTITY, DELIVERED_QUANTITY DELIVERED_QUANTITY, QUALITY_CONTROL_QUANTITY QUALITY_CONTROL_QUANTITY, CYCLE_COUNT_QUANTITY CYCLE_COUNT_QUANTITY, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID, SUBINVENTORY SUBINVENTORY, REVISION REVISION, LOT_NUMBER LOT_NUMBER, RELEASED_STATUS RELEASED_STATUS, CUSTOMER_REQUESTED_LOT_FLAG CUSTOMER_REQUESTED_LOT_FLAG, SERIAL_NUMBER SERIAL_NUMBER, LOCATOR_ID LOCATOR_ID, DATE_REQUESTED DATE_REQUESTED, DATE_SCHEDULED DATE_SCHEDULED, MASTER_CONTAINER_ITEM_ID MASTER_CONTAINER_ITEM_ID, DETAIL_CONTAINER_ITEM_ID DETAIL_CONTAINER_ITEM_ID, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER, SHIP_METHOD_CODE SHIP_METHOD_CODE, CARRIER_ID CARRIER_ID, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, FOB_CODE FOB_CODE, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG, CUSTOMER_PROD_SEQ CUSTOMER_PROD_SEQ, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE, NET_WEIGHT NET_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, VOLUME VOLUME, VOLUME_UOM_CODE VOLUME_UOM_CODE, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, ORG_ID ORG_ID, OE_INTERFACED_FLAG OE_INTERFACED_FLAG, MVT_STAT_STATUS MVT_STAT_STATUS, TRACKING_NUMBER TRACKING_NUMBER, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID, 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, 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, MOVEMENT_ID MOVEMENT_ID, SPLIT_FROM_DELIVERY_DETAIL_ID SPLIT_FROM_DELIVERY_DETAIL_ID, INV_INTERFACED_FLAG INV_INTERFACED_FLAG, SEAL_CODE SEAL_CODE, MINIMUM_FILL_PERCENT MINIMUM_FILL_PERCENT, MAXIMUM_VOLUME MAXIMUM_VOLUME, MAXIMUM_LOAD_WEIGHT MAXIMUM_LOAD_WEIGHT, MASTER_SERIAL_NUMBER MASTER_SERIAL_NUMBER, GROSS_WEIGHT GROSS_WEIGHT, FILL_PERCENT FILL_PERCENT, CONTAINER_NAME CONTAINER_NAME, CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE, CONTAINER_FLAG CONTAINER_FLAG, PREFERRED_GRADE PREFERRED_GRADE, SRC_REQUESTED_QUANTITY2 SRC_REQUESTED_QUANTITY2, SRC_REQUESTED_QUANTITY_UOM2 SRC_REQUESTED_QUANTITY_UOM2, REQUESTED_QUANTITY2 REQUESTED_QUANTITY2, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2, DELIVERED_QUANTITY2 DELIVERED_QUANTITY2, CANCELLED_QUANTITY2 CANCELLED_QUANTITY2, QUALITY_CONTROL_QUANTITY2 QUALITY_CONTROL_QUANTITY2, CYCLE_COUNT_QUANTITY2 CYCLE_COUNT_QUANTITY2, REQUESTED_QUANTITY_UOM2 REQUESTED_QUANTITY_UOM2, SUBLOT_NUMBER SUBLOT_NUMBER, UNIT_PRICE UNIT_PRICE, CURRENCY_CODE CURRENCY_CODE, UNIT_NUMBER UNIT_NUMBER, FREIGHT_CLASS_CAT_ID FREIGHT_CLASS_CAT_ID, COMMODITY_CODE_CAT_ID COMMODITY_CODE_CAT_ID, LPN_CONTENT_ID LPN_CONTENT_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, DELIVER_TO_SITE_USE_ID DELIVER_TO_SITE_USE_ID, LPN_ID LPN_ID, INSPECTION_FLAG INSPECTION_FLAG, ORIGINAL_SUBINVENTORY ORIGINAL_SUBINVENTORY, SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, SOURCE_LINE_NUMBER SOURCE_LINE_NUMBER, PICKABLE_FLAG PICKABLE_FLAG, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE, CUSTOMER_JOB CUSTOMER_JOB, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER, TO_SERIAL_NUMBER TO_SERIAL_NUMBER, PICKED_QUANTITY PICKED_QUANTITY, PICKED_QUANTITY2 PICKED_QUANTITY2, RECEIVED_QUANTITY RECEIVED_QUANTITY, RECEIVED_QUANTITY2 RECEIVED_QUANTITY2, SOURCE_LINE_SET_ID SOURCE_LINE_SET_ID, BATCH_ID BATCH_ID, TRANSACTION_ID TRANSACTION_ID, SERVICE_LEVEL SERVICE_LEVEL, MODE_OF_TRANSPORT MODE_OF_TRANSPORT, EARLIEST_PICKUP_DATE EARLIEST_PICKUP_DATE, LATEST_PICKUP_DATE LATEST_PICKUP_DATE, EARLIEST_DROPOFF_DATE EARLIEST_DROPOFF_DATE, LATEST_DROPOFF_DATE LATEST_DROPOFF_DATE, REQUEST_DATE_TYPE_CODE REQUEST_DATE_TYPE_CODE, TP_DELIVERY_DETAIL_ID TP_DELIVERY_DETAIL_ID, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID, VENDOR_ID VENDOR_ID, SHIP_FROM_SITE_ID SHIP_FROM_SITE_ID, IGNORE_FOR_PLANNING IGNORE_FOR_PLANNING, LINE_DIRECTION LINE_DIRECTION, PARTY_ID PARTY_ID, ROUTING_REQ_ID ROUTING_REQ_ID, SHIPPING_CONTROL SHIPPING_CONTROL, SOURCE_BLANKET_REFERENCE_ID SOURCE_BLANKET_REFERENCE_ID, SOURCE_BLANKET_REFERENCE_NUM SOURCE_BLANKET_REFERENCE_NUM, PO_SHIPMENT_LINE_ID PO_SHIPMENT_LINE_ID, PO_SHIPMENT_LINE_NUMBER PO_SHIPMENT_LINE_NUMBER, SCHEDULED_QUANTITY SCHEDULED_QUANTITY, RETURNED_QUANTITY RETURNED_QUANTITY, SCHEDULED_QUANTITY2 SCHEDULED_QUANTITY2, RETURNED_QUANTITY2 RETURNED_QUANTITY2, SOURCE_LINE_TYPE_CODE SOURCE_LINE_TYPE_CODE, RCV_SHIPMENT_LINE_ID RCV_SHIPMENT_LINE_ID, SUPPLIER_ITEM_NUMBER SUPPLIER_ITEM_NUMBER, FILLED_VOLUME FILLED_VOLUME, UNIT_WEIGHT UNIT_WEIGHT, UNIT_VOLUME UNIT_VOLUME, WV_FROZEN_FLAG WV_FROZEN_FLAG, PO_REVISION_NUMBER PO_REVISION_NUMBER, RELEASE_REVISION_NUMBER RELEASE_REVISION_NUMBER, REPLENISHMENT_STATUS REPLENISHMENT_STATUS, ORIGINAL_LOT_NUMBER ORIGINAL_LOT_NUMBER, ORIGINAL_REVISION ORIGINAL_REVISION, ORIGINAL_LOCATOR_ID ORIGINAL_LOCATOR_ID, REFERENCE_NUMBER REFERENCE_NUMBER, REFERENCE_LINE_NUMBER REFERENCE_LINE_NUMBER, REFERENCE_LINE_QUANTITY REFERENCE_LINE_QUANTITY, REFERENCE_LINE_QUANTITY_UOM REFERENCE_LINE_QUANTITY_UOM, CLIENT_ID CLIENT_ID, SHIPMENT_BATCH_ID SHIPMENT_BATCH_ID, SHIPMENT_LINE_NUMBER SHIPMENT_LINE_NUMBER, REFERENCE_LINE_ID REFERENCE_LINE_ID, CONSIGNEE_FLAG CONSIGNEE_FLAG from "WSH"."WSH_DELIVERY_DETAILS"

View Text - HTML Formatted

SELECT DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, SOURCE_CODE SOURCE_CODE
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, SOURCE_HEADER_TYPE_ID SOURCE_HEADER_TYPE_ID
, SOURCE_HEADER_TYPE_NAME SOURCE_HEADER_TYPE_NAME
, CUST_PO_NUMBER CUST_PO_NUMBER
, CUSTOMER_ID CUSTOMER_ID
, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, SHIP_SET_ID SHIP_SET_ID
, ARRIVAL_SET_ID ARRIVAL_SET_ID
, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, ATO_LINE_ID ATO_LINE_ID
, HOLD_CODE HOLD_CODE
, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, HAZARD_CLASS_ID HAZARD_CLASS_ID
, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, CLASSIFICATION CLASSIFICATION
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, INTMED_SHIP_TO_LOCATION_ID INTMED_SHIP_TO_LOCATION_ID
, INTMED_SHIP_TO_CONTACT_ID INTMED_SHIP_TO_CONTACT_ID
, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW
, SRC_REQUESTED_QUANTITY SRC_REQUESTED_QUANTITY
, SRC_REQUESTED_QUANTITY_UOM SRC_REQUESTED_QUANTITY_UOM
, CANCELLED_QUANTITY CANCELLED_QUANTITY
, REQUESTED_QUANTITY REQUESTED_QUANTITY
, REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, DELIVERED_QUANTITY DELIVERED_QUANTITY
, QUALITY_CONTROL_QUANTITY QUALITY_CONTROL_QUANTITY
, CYCLE_COUNT_QUANTITY CYCLE_COUNT_QUANTITY
, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, SUBINVENTORY SUBINVENTORY
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, RELEASED_STATUS RELEASED_STATUS
, CUSTOMER_REQUESTED_LOT_FLAG CUSTOMER_REQUESTED_LOT_FLAG
, SERIAL_NUMBER SERIAL_NUMBER
, LOCATOR_ID LOCATOR_ID
, DATE_REQUESTED DATE_REQUESTED
, DATE_SCHEDULED DATE_SCHEDULED
, MASTER_CONTAINER_ITEM_ID MASTER_CONTAINER_ITEM_ID
, DETAIL_CONTAINER_ITEM_ID DETAIL_CONTAINER_ITEM_ID
, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, CARRIER_ID CARRIER_ID
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, FOB_CODE FOB_CODE
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG
, CUSTOMER_PROD_SEQ CUSTOMER_PROD_SEQ
, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, NET_WEIGHT NET_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, VOLUME VOLUME
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, ORG_ID ORG_ID
, OE_INTERFACED_FLAG OE_INTERFACED_FLAG
, MVT_STAT_STATUS MVT_STAT_STATUS
, TRACKING_NUMBER TRACKING_NUMBER
, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID
, 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
, 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
, MOVEMENT_ID MOVEMENT_ID
, SPLIT_FROM_DELIVERY_DETAIL_ID SPLIT_FROM_DELIVERY_DETAIL_ID
, INV_INTERFACED_FLAG INV_INTERFACED_FLAG
, SEAL_CODE SEAL_CODE
, MINIMUM_FILL_PERCENT MINIMUM_FILL_PERCENT
, MAXIMUM_VOLUME MAXIMUM_VOLUME
, MAXIMUM_LOAD_WEIGHT MAXIMUM_LOAD_WEIGHT
, MASTER_SERIAL_NUMBER MASTER_SERIAL_NUMBER
, GROSS_WEIGHT GROSS_WEIGHT
, FILL_PERCENT FILL_PERCENT
, CONTAINER_NAME CONTAINER_NAME
, CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, CONTAINER_FLAG CONTAINER_FLAG
, PREFERRED_GRADE PREFERRED_GRADE
, SRC_REQUESTED_QUANTITY2 SRC_REQUESTED_QUANTITY2
, SRC_REQUESTED_QUANTITY_UOM2 SRC_REQUESTED_QUANTITY_UOM2
, REQUESTED_QUANTITY2 REQUESTED_QUANTITY2
, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2
, DELIVERED_QUANTITY2 DELIVERED_QUANTITY2
, CANCELLED_QUANTITY2 CANCELLED_QUANTITY2
, QUALITY_CONTROL_QUANTITY2 QUALITY_CONTROL_QUANTITY2
, CYCLE_COUNT_QUANTITY2 CYCLE_COUNT_QUANTITY2
, REQUESTED_QUANTITY_UOM2 REQUESTED_QUANTITY_UOM2
, SUBLOT_NUMBER SUBLOT_NUMBER
, UNIT_PRICE UNIT_PRICE
, CURRENCY_CODE CURRENCY_CODE
, UNIT_NUMBER UNIT_NUMBER
, FREIGHT_CLASS_CAT_ID FREIGHT_CLASS_CAT_ID
, COMMODITY_CODE_CAT_ID COMMODITY_CODE_CAT_ID
, LPN_CONTENT_ID LPN_CONTENT_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, DELIVER_TO_SITE_USE_ID DELIVER_TO_SITE_USE_ID
, LPN_ID LPN_ID
, INSPECTION_FLAG INSPECTION_FLAG
, ORIGINAL_SUBINVENTORY ORIGINAL_SUBINVENTORY
, SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER
, SOURCE_LINE_NUMBER SOURCE_LINE_NUMBER
, PICKABLE_FLAG PICKABLE_FLAG
, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE
, CUSTOMER_JOB CUSTOMER_JOB
, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER
, TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, PICKED_QUANTITY PICKED_QUANTITY
, PICKED_QUANTITY2 PICKED_QUANTITY2
, RECEIVED_QUANTITY RECEIVED_QUANTITY
, RECEIVED_QUANTITY2 RECEIVED_QUANTITY2
, SOURCE_LINE_SET_ID SOURCE_LINE_SET_ID
, BATCH_ID BATCH_ID
, TRANSACTION_ID TRANSACTION_ID
, SERVICE_LEVEL SERVICE_LEVEL
, MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, EARLIEST_PICKUP_DATE EARLIEST_PICKUP_DATE
, LATEST_PICKUP_DATE LATEST_PICKUP_DATE
, EARLIEST_DROPOFF_DATE EARLIEST_DROPOFF_DATE
, LATEST_DROPOFF_DATE LATEST_DROPOFF_DATE
, REQUEST_DATE_TYPE_CODE REQUEST_DATE_TYPE_CODE
, TP_DELIVERY_DETAIL_ID TP_DELIVERY_DETAIL_ID
, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID
, VENDOR_ID VENDOR_ID
, SHIP_FROM_SITE_ID SHIP_FROM_SITE_ID
, IGNORE_FOR_PLANNING IGNORE_FOR_PLANNING
, LINE_DIRECTION LINE_DIRECTION
, PARTY_ID PARTY_ID
, ROUTING_REQ_ID ROUTING_REQ_ID
, SHIPPING_CONTROL SHIPPING_CONTROL
, SOURCE_BLANKET_REFERENCE_ID SOURCE_BLANKET_REFERENCE_ID
, SOURCE_BLANKET_REFERENCE_NUM SOURCE_BLANKET_REFERENCE_NUM
, PO_SHIPMENT_LINE_ID PO_SHIPMENT_LINE_ID
, PO_SHIPMENT_LINE_NUMBER PO_SHIPMENT_LINE_NUMBER
, SCHEDULED_QUANTITY SCHEDULED_QUANTITY
, RETURNED_QUANTITY RETURNED_QUANTITY
, SCHEDULED_QUANTITY2 SCHEDULED_QUANTITY2
, RETURNED_QUANTITY2 RETURNED_QUANTITY2
, SOURCE_LINE_TYPE_CODE SOURCE_LINE_TYPE_CODE
, RCV_SHIPMENT_LINE_ID RCV_SHIPMENT_LINE_ID
, SUPPLIER_ITEM_NUMBER SUPPLIER_ITEM_NUMBER
, FILLED_VOLUME FILLED_VOLUME
, UNIT_WEIGHT UNIT_WEIGHT
, UNIT_VOLUME UNIT_VOLUME
, WV_FROZEN_FLAG WV_FROZEN_FLAG
, PO_REVISION_NUMBER PO_REVISION_NUMBER
, RELEASE_REVISION_NUMBER RELEASE_REVISION_NUMBER
, REPLENISHMENT_STATUS REPLENISHMENT_STATUS
, ORIGINAL_LOT_NUMBER ORIGINAL_LOT_NUMBER
, ORIGINAL_REVISION ORIGINAL_REVISION
, ORIGINAL_LOCATOR_ID ORIGINAL_LOCATOR_ID
, REFERENCE_NUMBER REFERENCE_NUMBER
, REFERENCE_LINE_NUMBER REFERENCE_LINE_NUMBER
, REFERENCE_LINE_QUANTITY REFERENCE_LINE_QUANTITY
, REFERENCE_LINE_QUANTITY_UOM REFERENCE_LINE_QUANTITY_UOM
, CLIENT_ID CLIENT_ID
, SHIPMENT_BATCH_ID SHIPMENT_BATCH_ID
, SHIPMENT_LINE_NUMBER SHIPMENT_LINE_NUMBER
, REFERENCE_LINE_ID REFERENCE_LINE_ID
, CONSIGNEE_FLAG CONSIGNEE_FLAG
FROM "WSH"."WSH_DELIVERY_DETAILS"