VIEW: WSH.WSH_DEL_DETAILS_INTERFACE#

Source

View Text - Preformatted

select DELIVERY_DETAIL_INTERFACE_ID DELIVERY_DETAIL_INTERFACE_ID, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, SOURCE_CODE SOURCE_CODE, SOURCE_HEADER_ID SOURCE_HEADER_ID, SOURCE_LINE_ID SOURCE_LINE_ID, CUSTOMER_ID CUSTOMER_ID, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_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, REQUESTED_QUANTITY REQUESTED_QUANTITY, CANCELLED_QUANTITY CANCELLED_QUANTITY, SHIPPED_QUANTITY SHIPPED_QUANTITY, DELIVERED_QUANTITY DELIVERED_QUANTITY, REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM, SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM, SUBINVENTORY SUBINVENTORY, REVISION REVISION, LOT_NUMBER LOT_NUMBER, CUSTOMER_REQUESTED_LOT_FLAG CUSTOMER_REQUESTED_LOT_FLAG, SERIAL_NUMBER SERIAL_NUMBER, 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, GROSS_WEIGHT GROSS_WEIGHT, NET_WEIGHT NET_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, VOLUME VOLUME, VOLUME_UOM_CODE VOLUME_UOM_CODE, 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_UPDATE_BY LAST_UPDATE_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, 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, SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, SOURCE_HEADER_TYPE_ID SOURCE_HEADER_TYPE_ID, SOURCE_HEADER_TYPE_NAME SOURCE_HEADER_TYPE_NAME, CUST_PO_NUMBER CUST_PO_NUMBER, 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_TYPE_FLAG HOLD_TYPE_FLAG, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG, HAZARD_CLASS_ID HAZARD_CLASS_ID, CLASSIFICATION CLASSIFICATION, ORGANIZATION_ID ORGANIZATION_ID, SRC_REQUESTED_QUANTITY SRC_REQUESTED_QUANTITY, SRC_REQUESTED_QUANTITY_UOM SRC_REQUESTED_QUANTITY_UOM, QUALITY_CONTROL_QUANTITY QUALITY_CONTROL_QUANTITY, CYCLE_COUNT_QUANTITY CYCLE_COUNT_QUANTITY, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID, SHIP_CONFIRM_ACTION_FLAG SHIP_CONFIRM_ACTION_FLAG, LOCATOR_ID LOCATOR_ID, MVT_STAT_STATUS MVT_STAT_STATUS, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID, 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, LAST_UPDATED_BY LAST_UPDATED_BY, COMMODITY_CODE_CAT_ID COMMODITY_CODE_CAT_ID, CONTAINER_FLAG CONTAINER_FLAG, CONTAINER_NAME CONTAINER_NAME, CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE, CURRENCY_CODE CURRENCY_CODE, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER, CUSTOMER_JOB CUSTOMER_JOB, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE, DELIVER_TO_SITE_USE_ID DELIVER_TO_SITE_USE_ID, FILL_PERCENT FILL_PERCENT, FREIGHT_CLASS_CAT_ID FREIGHT_CLASS_CAT_ID, INSPECTION_FLAG INSPECTION_FLAG, LPN_CONTENT_ID LPN_CONTENT_ID, LPN_ID LPN_ID, MASTER_SERIAL_NUMBER MASTER_SERIAL_NUMBER, MAXIMUM_LOAD_WEIGHT MAXIMUM_LOAD_WEIGHT, MAXIMUM_VOLUME MAXIMUM_VOLUME, MINIMUM_FILL_PERCENT MINIMUM_FILL_PERCENT, MOVEMENT_ID MOVEMENT_ID, ORG_ID ORG_ID, ORIGINAL_SUBINVENTORY ORIGINAL_SUBINVENTORY, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, PICKED_QUANTITY PICKED_QUANTITY, PICKED_QUANTITY2 PICKED_QUANTITY2, PROJECT_ID PROJECT_ID, SEAL_CODE SEAL_CODE, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, SOURCE_LINE_NUMBER SOURCE_LINE_NUMBER, SPLIT_FROM_DELIVERY_DETAIL_ID SPLIT_FROM_DELIVERY_DETAIL_ID, TASK_ID TASK_ID, TO_SERIAL_NUMBER TO_SERIAL_NUMBER, TRACKING_NUMBER TRACKING_NUMBER, UNIT_NUMBER UNIT_NUMBER, UNIT_PRICE UNIT_PRICE, CARRIER_CODE CARRIER_CODE, COMMODITY_CODE_CAT_CODE COMMODITY_CODE_CAT_CODE, CUSTOMER_NUMBER CUSTOMER_NUMBER, CUSTOMER_ITEM_NUMBER CUSTOMER_ITEM_NUMBER, DELIVER_TO_LOCATION_CODE DELIVER_TO_LOCATION_CODE, DETAIL_CONTAINER_ITEM_CODE DETAIL_CONTAINER_ITEM_CODE, FREIGHT_CLASS_CAT_CODE FREIGHT_CLASS_CAT_CODE, HAZARD_CLASS_CODE HAZARD_CLASS_CODE, INTMED_SHIP_TO_LOCATION_CODE INTMED_SHIP_TO_LOCATION_CODE, ITEM_NUMBER ITEM_NUMBER, LOCATOR_CODE LOCATOR_CODE, MASTER_CONTAINER_ITEM_NUMBER MASTER_CONTAINER_ITEM_NUMBER, ORGANIZATION_CODE ORGANIZATION_CODE, SHIP_FROM_LOCATION_CODE SHIP_FROM_LOCATION_CODE, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE, CUSTOMER_NAME CUSTOMER_NAME, 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, SOURCE_LINE_SET_ID SOURCE_LINE_SET_ID, FILLED_VOLUME FILLED_VOLUME, WV_FROZEN_FLAG WV_FROZEN_FLAG, LINE_NUMBER LINE_NUMBER, UNIT_SELLING_PRICE UNIT_SELLING_PRICE, SHIP_SET_NAME SHIP_SET_NAME from "WSH"."WSH_DEL_DETAILS_INTERFACE"

View Text - HTML Formatted

SELECT DELIVERY_DETAIL_INTERFACE_ID DELIVERY_DETAIL_INTERFACE_ID
, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, SOURCE_CODE SOURCE_CODE
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, CUSTOMER_ID CUSTOMER_ID
, SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_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
, REQUESTED_QUANTITY REQUESTED_QUANTITY
, CANCELLED_QUANTITY CANCELLED_QUANTITY
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, DELIVERED_QUANTITY DELIVERED_QUANTITY
, REQUESTED_QUANTITY_UOM REQUESTED_QUANTITY_UOM
, SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM
, SUBINVENTORY SUBINVENTORY
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, CUSTOMER_REQUESTED_LOT_FLAG CUSTOMER_REQUESTED_LOT_FLAG
, SERIAL_NUMBER SERIAL_NUMBER
, 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
, GROSS_WEIGHT GROSS_WEIGHT
, NET_WEIGHT NET_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, VOLUME VOLUME
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, 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_UPDATE_BY LAST_UPDATE_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
, 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
, SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER
, SOURCE_HEADER_TYPE_ID SOURCE_HEADER_TYPE_ID
, SOURCE_HEADER_TYPE_NAME SOURCE_HEADER_TYPE_NAME
, CUST_PO_NUMBER CUST_PO_NUMBER
, 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_TYPE_FLAG HOLD_TYPE_FLAG
, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, HAZARD_CLASS_ID HAZARD_CLASS_ID
, CLASSIFICATION CLASSIFICATION
, ORGANIZATION_ID ORGANIZATION_ID
, SRC_REQUESTED_QUANTITY SRC_REQUESTED_QUANTITY
, SRC_REQUESTED_QUANTITY_UOM SRC_REQUESTED_QUANTITY_UOM
, QUALITY_CONTROL_QUANTITY QUALITY_CONTROL_QUANTITY
, CYCLE_COUNT_QUANTITY CYCLE_COUNT_QUANTITY
, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, SHIP_CONFIRM_ACTION_FLAG SHIP_CONFIRM_ACTION_FLAG
, LOCATOR_ID LOCATOR_ID
, MVT_STAT_STATUS MVT_STAT_STATUS
, TRANSACTION_TEMP_ID TRANSACTION_TEMP_ID
, 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
, LAST_UPDATED_BY LAST_UPDATED_BY
, COMMODITY_CODE_CAT_ID COMMODITY_CODE_CAT_ID
, CONTAINER_FLAG CONTAINER_FLAG
, CONTAINER_NAME CONTAINER_NAME
, CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, CURRENCY_CODE CURRENCY_CODE
, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER
, CUSTOMER_JOB CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE
, DELIVER_TO_SITE_USE_ID DELIVER_TO_SITE_USE_ID
, FILL_PERCENT FILL_PERCENT
, FREIGHT_CLASS_CAT_ID FREIGHT_CLASS_CAT_ID
, INSPECTION_FLAG INSPECTION_FLAG
, LPN_CONTENT_ID LPN_CONTENT_ID
, LPN_ID LPN_ID
, MASTER_SERIAL_NUMBER MASTER_SERIAL_NUMBER
, MAXIMUM_LOAD_WEIGHT MAXIMUM_LOAD_WEIGHT
, MAXIMUM_VOLUME MAXIMUM_VOLUME
, MINIMUM_FILL_PERCENT MINIMUM_FILL_PERCENT
, MOVEMENT_ID MOVEMENT_ID
, ORG_ID ORG_ID
, ORIGINAL_SUBINVENTORY ORIGINAL_SUBINVENTORY
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, PICKED_QUANTITY PICKED_QUANTITY
, PICKED_QUANTITY2 PICKED_QUANTITY2
, PROJECT_ID PROJECT_ID
, SEAL_CODE SEAL_CODE
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, SOURCE_LINE_NUMBER SOURCE_LINE_NUMBER
, SPLIT_FROM_DELIVERY_DETAIL_ID SPLIT_FROM_DELIVERY_DETAIL_ID
, TASK_ID TASK_ID
, TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, TRACKING_NUMBER TRACKING_NUMBER
, UNIT_NUMBER UNIT_NUMBER
, UNIT_PRICE UNIT_PRICE
, CARRIER_CODE CARRIER_CODE
, COMMODITY_CODE_CAT_CODE COMMODITY_CODE_CAT_CODE
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, CUSTOMER_ITEM_NUMBER CUSTOMER_ITEM_NUMBER
, DELIVER_TO_LOCATION_CODE DELIVER_TO_LOCATION_CODE
, DETAIL_CONTAINER_ITEM_CODE DETAIL_CONTAINER_ITEM_CODE
, FREIGHT_CLASS_CAT_CODE FREIGHT_CLASS_CAT_CODE
, HAZARD_CLASS_CODE HAZARD_CLASS_CODE
, INTMED_SHIP_TO_LOCATION_CODE INTMED_SHIP_TO_LOCATION_CODE
, ITEM_NUMBER ITEM_NUMBER
, LOCATOR_CODE LOCATOR_CODE
, MASTER_CONTAINER_ITEM_NUMBER MASTER_CONTAINER_ITEM_NUMBER
, ORGANIZATION_CODE ORGANIZATION_CODE
, SHIP_FROM_LOCATION_CODE SHIP_FROM_LOCATION_CODE
, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE
, CUSTOMER_NAME CUSTOMER_NAME
, 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
, SOURCE_LINE_SET_ID SOURCE_LINE_SET_ID
, FILLED_VOLUME FILLED_VOLUME
, WV_FROZEN_FLAG WV_FROZEN_FLAG
, LINE_NUMBER LINE_NUMBER
, UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, SHIP_SET_NAME SHIP_SET_NAME
FROM "WSH"."WSH_DEL_DETAILS_INTERFACE"