WSH_DELIVERY_DETAILS_V
Details
-
Schema: FUSION
-
Object owner: WSH
-
Object type: VIEW
Columns
Name |
---|
DELIVERY_DETAIL_ID SOURCE_HEADER_ID SOURCE_LINE_ID SOURCE_HEADER_NUMBER CUST_PO_NUMBER SOLD_TO_CONTACT_ID INVENTORY_ITEM_ID ITEM_DESCRIPTION SHIP_FROM_LOCATION_ID ORGANIZATION_ID SHIP_TO_LOCATION_ID SHIP_TO_CONTACT_ID SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_BELOW SRC_REQUESTED_QUANTITY SRC_REQUESTED_QUANTITY_UOM CANCELLED_QUANTITY REQUESTED_QUANTITY REQUESTED_QUANTITY_UOM SHIPPED_QUANTITY DELIVERED_QUANTITY CYCLE_COUNT_QUANTITY MOVE_ORDER_LINE_ID SUBINVENTORY REVISION LOT_NUMBER RELEASED_STATUS SERIAL_NUMBER LOCATOR_ID DATE_REQUESTED DATE_SCHEDULED MASTER_CONTAINER_ITEM_ID DETAIL_CONTAINER_ITEM_ID LOAD_SEQ_NUMBER SHIP_METHOD_CODE CARRIER_ID FREIGHT_TERMS_CODE SHIPMENT_PRIORITY_CODE FOB_CODE CUSTOMER_ITEM_ID NET_WEIGHT WEIGHT_UOM_CODE VOLUME VOLUME_UOM_CODE SHIPPING_INSTRUCTIONS PACKING_INSTRUCTIONS PARENT_LPN_ID ORG_ID MVT_STAT_STATUS TRACKING_NUMBER TRANSACTION_TEMP_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE MOVEMENT_ID SPLIT_FROM_DELIVERY_DETAIL_ID INV_INTERFACED_FLAG SOURCE_LINE_NUMBER SEAL_CODE GROSS_WEIGHT PREFERRED_GRADE SRC_REQUESTED_QUANTITY2 SRC_REQUESTED_QUANTITY_UOM2 REQUESTED_QUANTITY2 SHIPPED_QUANTITY2 DELIVERED_QUANTITY2 CANCELLED_QUANTITY2 CYCLE_COUNT_QUANTITY2 REQUESTED_QUANTITY_UOM2 UNIT_PRICE CURRENCY_CODE LPN_CONTENT_ID INSPECTION_FLAG SHIP_TO_SITE_USE_ID ORIGINAL_SUBINVENTORY PICKABLE_FLAG PICKED_QUANTITY PICKED_QUANTITY2 BATCH_ID TRANSACTION_ID SERVICE_LEVEL MODE_OF_TRANSPORT EARLIEST_PICKUP_DATE LATEST_PICKUP_DATE EARLIEST_DROPOFF_DATE LATEST_DROPOFF_DATE REQUEST_DATE_TYPE_CODE SOURCE_DOCUMENT_TYPE_ID UNIT_WEIGHT UNIT_VOLUME WV_FROZEN_FLAG OBJECT_VERSION_NUMBER SHIP_TO_PARTY_ID SOLD_TO_PARTY_ID OUTSOURCER_PARTY_ID BILL_TO_PARTY_ID BILL_TO_LOCATION_ID BILL_TO_CONTACT_ID SHIP_SET_NAME ARRIVAL_SET_NAME SOURCE_LINE_UPDATE_DATE SELLING_PRICE SHIP_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID REQUISITION_HEADER_ID REQUISITION_LINE_ID CONVERTED_QUANTITY SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_NUMBER ROOT_SOURCE_SHIPMENT_ID WMS_SHIP_TOLERANCE_ABOVE WMS_SHIP_TOLERANCE_BELOW SOURCE_SYSTEM_ID SALES_ORDER_LINE_NUMBER SALES_ORDER_NUMBER SALES_ORDER_SHIPMENT_NUMBER CONVERSION_TYPE CONVERSION_DATE CONVERSION_RATE SP_PICKED_QUANTITY SPQ_UOM PARENT_INVENTORY_ITEM_ID PARENT_SOURCE_SHIPMENT_ID SHIPMENT_ADVICE_STATUS ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 CONVERTED_QUANTITY2 SRC_ATTRIBUTE_CATEGORY SRC_ATTRIBUTE1 SRC_ATTRIBUTE2 SRC_ATTRIBUTE3 SRC_ATTRIBUTE4 SRC_ATTRIBUTE5 SRC_ATTRIBUTE6 SRC_ATTRIBUTE7 SRC_ATTRIBUTE8 SRC_ATTRIBUTE9 SRC_ATTRIBUTE10 SRC_ATTRIBUTE11 SRC_ATTRIBUTE12 SRC_ATTRIBUTE13 SRC_ATTRIBUTE14 SRC_ATTRIBUTE15 SRC_ATTRIBUTE16 SRC_ATTRIBUTE17 SRC_ATTRIBUTE18 SRC_ATTRIBUTE19 SRC_ATTRIBUTE20 SRC_ATTRIBUTE_NUMBER1 SRC_ATTRIBUTE_NUMBER2 SRC_ATTRIBUTE_NUMBER3 SRC_ATTRIBUTE_NUMBER4 SRC_ATTRIBUTE_NUMBER5 SRC_ATTRIBUTE_NUMBER6 SRC_ATTRIBUTE_NUMBER7 SRC_ATTRIBUTE_NUMBER8 SRC_ATTRIBUTE_NUMBER9 SRC_ATTRIBUTE_NUMBER10 SRC_ATTRIBUTE_DATE1 SRC_ATTRIBUTE_DATE2 SRC_ATTRIBUTE_DATE3 SRC_ATTRIBUTE_DATE4 SRC_ATTRIBUTE_DATE5 SRC_ATTRIBUTE_TIMESTAMP1 SRC_ATTRIBUTE_TIMESTAMP2 SRC_ATTRIBUTE_TIMESTAMP3 SRC_ATTRIBUTE_TIMESTAMP4 SRC_ATTRIBUTE_TIMESTAMP5 CALC_WND_WDD_DATE SOURCE_LINE_TYPE DO_NOT_SHIP_BEFORE_DATE DO_NOT_SHIP_AFTER_DATE DEFAULT_TAXATION_COUNTRY FIRST_PTY_REG_ID THIRD_PTY_REG_ID FINAL_DISCHARGE_LOCATION_ID DOCUMENT_SUB_TYPE TRX_BUSINESS_CATEGORY USER_DEFINED_FISC_CLASS TAX_INVOICE_NUMBER TAX_INVOICE_DATE PRODUCT_CATEGORY INTENDED_USE_CLASSIF_ID PRODUCT_TYPE ASSESSABLE_VALUE TAX_CLASSIFICATION_CODE EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON_CODE SHIP_TO_LOCATION_TYPE CATEGORY_ID WMS_INTERFACED_FLAG BASE_ITEM_ID PICKED_FROM_SUBINVENTORY END_ASSEMBLY_ITEM_NUMBER TP_RECEIVED_DATE TP_SHIPMENT_NUMBER TP_SHIPMENT_LINE TRADE_COMPLIANCE_STATUS TRADE_COMPLIANCE_DATE TRADE_COMPLIANCE_REASON TP_STATUS_CODE TP_INITIAL_LEG_DEST_LOC_ID FISCAL_DOC_HEADER_ID FISCAL_DOC_LINE_ID QUICK_SHIP_STATUS PJC_PROJECT_ID PJC_TASK_ID ORIG_SOURCE_SHIPMENT_ID ORIG_SOURCE_SHIPMENT_NUMBER CANCEL_BACKORDERS ENFORCE_SINGLE_SHIPMENT |
Query
SQL_Statement |
---|
SELECT WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID, WSH_DELIVERY_DETAILS.SOURCE_HEADER_ID, WSH_DELIVERY_DETAILS.SOURCE_LINE_ID, WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER, WSH_DELIVERY_DETAILS.CUST_PO_NUMBER, WSH_DELIVERY_DETAILS.SOLD_TO_CONTACT_ID, WSH_DELIVERY_DETAILS.INVENTORY_ITEM_ID, WSH_DELIVERY_DETAILS.ITEM_DESCRIPTION, WSH_DELIVERY_DETAILS.SHIP_FROM_LOCATION_ID, WSH_DELIVERY_DETAILS.ORGANIZATION_ID, WSH_DELIVERY_DETAILS.SHIP_TO_LOCATION_ID, WSH_DELIVERY_DETAILS.SHIP_TO_CONTACT_ID, WSH_DELIVERY_DETAILS.SHIP_TOLERANCE_ABOVE, WSH_DELIVERY_DETAILS.SHIP_TOLERANCE_BELOW, WSH_DELIVERY_DETAILS.SRC_REQUESTED_QUANTITY, WSH_DELIVERY_DETAILS.SRC_REQUESTED_QUANTITY_UOM, WSH_DELIVERY_DETAILS.CANCELLED_QUANTITY, WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY, WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM, WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY, WSH_DELIVERY_DETAILS.DELIVERED_QUANTITY, WSH_DELIVERY_DETAILS.CYCLE_COUNT_QUANTITY, WSH_DELIVERY_DETAILS.MOVE_ORDER_LINE_ID, WSH_DELIVERY_DETAILS.SUBINVENTORY, WSH_DELIVERY_DETAILS.REVISION, WSH_DELIVERY_DETAILS.LOT_NUMBER, WSH_DELIVERY_DETAILS.RELEASED_STATUS, WSH_DELIVERY_DETAILS.SERIAL_NUMBER, WSH_DELIVERY_DETAILS.LOCATOR_ID, WSH_DELIVERY_DETAILS.DATE_REQUESTED, WSH_DELIVERY_DETAILS.DATE_SCHEDULED, WSH_DELIVERY_DETAILS.MASTER_CONTAINER_ITEM_ID, WSH_DELIVERY_DETAILS.DETAIL_CONTAINER_ITEM_ID, WSH_DELIVERY_DETAILS.LOAD_SEQ_NUMBER, WSH_DELIVERY_DETAILS.SHIP_METHOD_CODE, WSH_DELIVERY_DETAILS.CARRIER_ID, WSH_DELIVERY_DETAILS.FREIGHT_TERMS_CODE, WSH_DELIVERY_DETAILS.SHIPMENT_PRIORITY_CODE, WSH_DELIVERY_DETAILS.FOB_CODE, WSH_DELIVERY_DETAILS.CUSTOMER_ITEM_ID, WSH_DELIVERY_DETAILS.NET_WEIGHT, WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE, WSH_DELIVERY_DETAILS.VOLUME, WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE, WSH_DELIVERY_DETAILS.SHIPPING_INSTRUCTIONS, WSH_DELIVERY_DETAILS.PACKING_INSTRUCTIONS, WSH_DELIVERY_DETAILS.PARENT_LPN_ID, WSH_DELIVERY_DETAILS.ORG_ID, WSH_DELIVERY_DETAILS.MVT_STAT_STATUS, WSH_DELIVERY_DETAILS.TRACKING_NUMBER, WSH_DELIVERY_DETAILS.TRANSACTION_TEMP_ID, WSH_DELIVERY_DETAILS.ATTRIBUTE_CATEGORY, WSH_DELIVERY_DETAILS.ATTRIBUTE1, WSH_DELIVERY_DETAILS.ATTRIBUTE2, WSH_DELIVERY_DETAILS.ATTRIBUTE3, WSH_DELIVERY_DETAILS.ATTRIBUTE4, WSH_DELIVERY_DETAILS.ATTRIBUTE5, WSH_DELIVERY_DETAILS.ATTRIBUTE6, WSH_DELIVERY_DETAILS.ATTRIBUTE7, WSH_DELIVERY_DETAILS.ATTRIBUTE8, WSH_DELIVERY_DETAILS.ATTRIBUTE9, WSH_DELIVERY_DETAILS.ATTRIBUTE10, WSH_DELIVERY_DETAILS.ATTRIBUTE11, WSH_DELIVERY_DETAILS.ATTRIBUTE12, WSH_DELIVERY_DETAILS.ATTRIBUTE13, WSH_DELIVERY_DETAILS.ATTRIBUTE14, WSH_DELIVERY_DETAILS.ATTRIBUTE15, WSH_DELIVERY_DETAILS.CREATION_DATE, WSH_DELIVERY_DETAILS.CREATED_BY, WSH_DELIVERY_DETAILS.LAST_UPDATE_DATE, WSH_DELIVERY_DETAILS.LAST_UPDATED_BY, WSH_DELIVERY_DETAILS.LAST_UPDATE_LOGIN, WSH_DELIVERY_DETAILS.REQUEST_ID, WSH_DELIVERY_DETAILS.JOB_DEFINITION_NAME, WSH_DELIVERY_DETAILS.JOB_DEFINITION_PACKAGE, WSH_DELIVERY_DETAILS.MOVEMENT_ID, WSH_DELIVERY_DETAILS.SPLIT_FROM_DELIVERY_DETAIL_ID, WSH_DELIVERY_DETAILS.INV_INTERFACED_FLAG, WSH_DELIVERY_DETAILS.SOURCE_LINE_NUMBER, WSH_DELIVERY_DETAILS.SEAL_CODE, WSH_DELIVERY_DETAILS.GROSS_WEIGHT, WSH_DELIVERY_DETAILS.PREFERRED_GRADE, WSH_DELIVERY_DETAILS.SRC_REQUESTED_QUANTITY2, WSH_DELIVERY_DETAILS.SRC_REQUESTED_QUANTITY_UOM2, WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2, WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY2, WSH_DELIVERY_DETAILS.DELIVERED_QUANTITY2, WSH_DELIVERY_DETAILS.CANCELLED_QUANTITY2, WSH_DELIVERY_DETAILS.CYCLE_COUNT_QUANTITY2, WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY_UOM2, WSH_DELIVERY_DETAILS.UNIT_PRICE, WSH_DELIVERY_DETAILS.CURRENCY_CODE, WSH_DELIVERY_DETAILS.LPN_CONTENT_ID, WSH_DELIVERY_DETAILS.INSPECTION_FLAG, WSH_DELIVERY_DETAILS.SHIP_TO_SITE_USE_ID, WSH_DELIVERY_DETAILS.ORIGINAL_SUBINVENTORY, WSH_DELIVERY_DETAILS.PICKABLE_FLAG, WSH_DELIVERY_DETAILS.PICKED_QUANTITY, WSH_DELIVERY_DETAILS.PICKED_QUANTITY2, WSH_DELIVERY_DETAILS.BATCH_ID, WSH_DELIVERY_DETAILS.TRANSACTION_ID, WSH_DELIVERY_DETAILS.SERVICE_LEVEL, WSH_DELIVERY_DETAILS.MODE_OF_TRANSPORT, WSH_DELIVERY_DETAILS.EARLIEST_PICKUP_DATE, WSH_DELIVERY_DETAILS.LATEST_PICKUP_DATE, WSH_DELIVERY_DETAILS.EARLIEST_DROPOFF_DATE, WSH_DELIVERY_DETAILS.LATEST_DROPOFF_DATE, WSH_DELIVERY_DETAILS.REQUEST_DATE_TYPE_CODE, DECODE(WSH_DELIVERY_DETAILS.SOURCE_DOCUMENT_TYPE_ID, 10, 8, SOURCE_DOCUMENT_TYPE_ID) SOURCE_DOCUMENT_TYPE_ID, WSH_DELIVERY_DETAILS.UNIT_WEIGHT, WSH_DELIVERY_DETAILS.UNIT_VOLUME, WSH_DELIVERY_DETAILS.WV_FROZEN_FLAG, WSH_DELIVERY_DETAILS.OBJECT_VERSION_NUMBER, WSH_DELIVERY_DETAILS.SHIP_TO_PARTY_ID, WSH_DELIVERY_DETAILS.SOLD_TO_PARTY_ID, WSH_DELIVERY_DETAILS.OUTSOURCER_PARTY_ID, WSH_DELIVERY_DETAILS.BILL_TO_PARTY_ID, WSH_DELIVERY_DETAILS.BILL_TO_LOCATION_ID, WSH_DELIVERY_DETAILS.BILL_TO_CONTACT_ID, WSH_DELIVERY_DETAILS.SHIP_SET_NAME, WSH_DELIVERY_DETAILS.ARRIVAL_SET_NAME, WSH_DELIVERY_DETAILS.SOURCE_LINE_UPDATE_DATE, WSH_DELIVERY_DETAILS.SELLING_PRICE, WSH_DELIVERY_DETAILS.SHIP_TO_PARTY_SITE_ID, WSH_DELIVERY_DETAILS.BILL_TO_PARTY_SITE_ID, WSH_DELIVERY_DETAILS.REQUISITION_HEADER_ID, WSH_DELIVERY_DETAILS.REQUISITION_LINE_ID, WSH_DELIVERY_DETAILS.CONVERTED_QUANTITY, nvl(WSH_DELIVERY_DETAILS.NEW_SOURCE_SHIPMENT_ID,WSH_DELIVERY_DETAILS.SOURCE_SHIPMENT_ID) SOURCE_SHIPMENT_ID, nvl(WSH_DELIVERY_DETAILS.NEW_SOURCE_SHIPMENT_NUMBER,WSH_DELIVERY_DETAILS.SOURCE_SHIPMENT_NUMBER) SOURCE_SHIPMENT_NUMBER, WSH_DELIVERY_DETAILS.ROOT_SOURCE_SHIPMENT_ID, WSH_DELIVERY_DETAILS.WMS_SHIP_TOLERANCE_ABOVE, WSH_DELIVERY_DETAILS.WMS_SHIP_TOLERANCE_BELOW, WSH_DELIVERY_DETAILS.SOURCE_SYSTEM_ID, WSH_DELIVERY_DETAILS.SALES_ORDER_LINE_NUMBER, WSH_DELIVERY_DETAILS.SALES_ORDER_NUMBER, WSH_DELIVERY_DETAILS.SALES_ORDER_SHIPMENT_NUMBER, WSH_DELIVERY_DETAILS.CONVERSION_TYPE, WSH_DELIVERY_DETAILS.CONVERSION_DATE, WSH_DELIVERY_DETAILS.CONVERSION_RATE, WSH_DELIVERY_DETAILS.SP_PICKED_QUANTITY, WSH_DELIVERY_DETAILS.SPQ_UOM, WSH_DELIVERY_DETAILS.PARENT_INVENTORY_ITEM_ID, WSH_DELIVERY_DETAILS.PARENT_SOURCE_SHIPMENT_ID, WSH_DELIVERY_DETAILS.SHIPMENT_ADVICE_STATUS, WSH_DELIVERY_DETAILS.ATTRIBUTE16, WSH_DELIVERY_DETAILS.ATTRIBUTE17, WSH_DELIVERY_DETAILS.ATTRIBUTE18, WSH_DELIVERY_DETAILS.ATTRIBUTE19, WSH_DELIVERY_DETAILS.ATTRIBUTE20, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER1, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER2, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER3, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER4, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER5, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER6, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER7, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER8, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER9, WSH_DELIVERY_DETAILS.ATTRIBUTE_NUMBER10, WSH_DELIVERY_DETAILS.ATTRIBUTE_DATE1, WSH_DELIVERY_DETAILS.ATTRIBUTE_DATE2, WSH_DELIVERY_DETAILS.ATTRIBUTE_DATE3, WSH_DELIVERY_DETAILS.ATTRIBUTE_DATE4, WSH_DELIVERY_DETAILS.ATTRIBUTE_DATE5, WSH_DELIVERY_DETAILS.ATTRIBUTE_TIMESTAMP1, WSH_DELIVERY_DETAILS.ATTRIBUTE_TIMESTAMP2, WSH_DELIVERY_DETAILS.ATTRIBUTE_TIMESTAMP3, WSH_DELIVERY_DETAILS.ATTRIBUTE_TIMESTAMP4, WSH_DELIVERY_DETAILS.ATTRIBUTE_TIMESTAMP5, WSH_DELIVERY_DETAILS.CONVERTED_QUANTITY2, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_CATEGORY, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE1, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE2, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE3, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE4, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE5, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE6, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE7, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE8, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE9, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE10, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE11, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE12, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE13, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE14, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE15, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE16, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE17, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE18, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE19, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE20, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER1, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER2, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER3, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER4, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER5, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER6, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER7, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER8, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER9, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_NUMBER10, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_DATE1, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_DATE2, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_DATE3, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_DATE4, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_DATE5, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_TIMESTAMP1, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_TIMESTAMP2, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_TIMESTAMP3, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_TIMESTAMP4, WSH_DELIVERY_DETAILS.SRC_ATTRIBUTE_TIMESTAMP5, WSH_DELIVERY_DETAILS.CALC_WND_WDD_DATE, WSH_DELIVERY_DETAILS.SOURCE_LINE_TYPE, WSH_DELIVERY_DETAILS.DO_NOT_SHIP_BEFORE_DATE, WSH_DELIVERY_DETAILS.DO_NOT_SHIP_AFTER_DATE, WSH_DELIVERY_DETAILS.DEFAULT_TAXATION_COUNTRY, WSH_DELIVERY_DETAILS.FIRST_PTY_REG_ID, WSH_DELIVERY_DETAILS.THIRD_PTY_REG_ID, WSH_DELIVERY_DETAILS.FINAL_DISCHARGE_LOCATION_ID, WSH_DELIVERY_DETAILS.DOCUMENT_SUB_TYPE, WSH_DELIVERY_DETAILS.TRX_BUSINESS_CATEGORY, WSH_DELIVERY_DETAILS.USER_DEFINED_FISC_CLASS, WSH_DELIVERY_DETAILS.TAX_INVOICE_NUMBER, WSH_DELIVERY_DETAILS.TAX_INVOICE_DATE, WSH_DELIVERY_DETAILS.PRODUCT_CATEGORY, WSH_DELIVERY_DETAILS.INTENDED_USE_CLASSIF_ID, WSH_DELIVERY_DETAILS.PRODUCT_TYPE, WSH_DELIVERY_DETAILS.ASSESSABLE_VALUE, WSH_DELIVERY_DETAILS.TAX_CLASSIFICATION_CODE, WSH_DELIVERY_DETAILS.EXEMPT_CERTIFICATE_NUMBER, WSH_DELIVERY_DETAILS.EXEMPT_REASON_CODE, WSH_DELIVERY_DETAILS.SHIP_TO_LOCATION_TYPE, WSH_DELIVERY_DETAILS.CATEGORY_ID, WSH_DELIVERY_DETAILS.WMS_INTERFACED_FLAG, WSH_DELIVERY_DETAILS.BASE_ITEM_ID, WSH_DELIVERY_DETAILS.PICKED_FROM_SUBINVENTORY, WSH_DELIVERY_DETAILS.END_ASSEMBLY_ITEM_NUMBER, WSH_DELIVERY_DETAILS.TP_RECEIVED_DATE, WSH_DELIVERY_DETAILS.TP_SHIPMENT_NUMBER, WSH_DELIVERY_DETAILS.TP_SHIPMENT_LINE, WSH_DELIVERY_DETAILS.TRADE_COMPLIANCE_STATUS, WSH_DELIVERY_DETAILS.TRADE_COMPLIANCE_DATE, WSH_DELIVERY_DETAILS.TRADE_COMPLIANCE_REASON, WSH_DELIVERY_DETAILS.TP_STATUS_CODE, WSH_DELIVERY_DETAILS.TP_INITIAL_LEG_DEST_LOC_ID, WSH_DELIVERY_DETAILS.FISCAL_DOC_HEADER_ID, WSH_DELIVERY_DETAILS.FISCAL_DOC_LINE_ID, WSH_DELIVERY_DETAILS.QUICK_SHIP_STATUS , WSH_DELIVERY_DETAILS.PJC_PROJECT_ID, WSH_DELIVERY_DETAILS.PJC_TASK_ID, WSH_DELIVERY_DETAILS.SOURCE_SHIPMENT_ID ORIG_SOURCE_SHIPMENT_ID, WSH_DELIVERY_DETAILS.SOURCE_SHIPMENT_NUMBER ORIG_SOURCE_SHIPMENT_NUMBER, WSH_DELIVERY_DETAILS.CANCEL_BACKORDERS, WSH_DELIVERY_DETAILS.ENFORCE_SINGLE_SHIPMENT FROM WSH_DELIVERY_DETAILS |