WSH_DELIVERY_DETAILS

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

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

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