Product: | IBE - iStore |
---|---|
Description: | This view is used to get the Shipment line information in Post sales interaction with customer in iStore. This view is based on wsh_delivery_line_status_v. |
Implementation/DBA Data: | Not implemented in this database |
SELECT WSH.DELIVERY_DETAIL_ID
, WSH.SOURCE_CODE
, WSH.SOURCE_LINE_ID LINE_ID
, WSH.SOURCE_HEADER_ID HEADER_ID
, WSH.HEADER_NUMBER
, WSH.LINE_NUMBER
, WSH.SHIP_METHOD_CODE
, WSH.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, WSH.REQUESTED_QUANTITY
, WSH.SHIPPED_QUANTITY
, WSH.SHIPPED_QUANTITY_UOM
, WSH.REQUESTED_QUANTITY_UOM
, WSH.SHIP_SET_ID
, WSH.REVISION
, WSH.LOT_NUMBER
, WSH.SERIAL_NUMBER
, WSH.PICK_STATUS
, WSH.PICK_MEANING
, WSH.DELIVERY_ID
, WSH.DELIVERY_NAME
, WSH.CURRENCY_CODE
, WSH.DELIVERY_STATUS
, WSH.DELIVERY_STATUS_MEANING
, WSH.ORGANIZATION_ID
, WSH.INITIAL_PICKUP_LOCATION_ID
, WSH.INITIAL_PICKUP_LOCATION
, WSH.ULTIMATE_DROPOFF_LOCATION_ID
, WSH.ULTIMATE_DROPOFF_LOCATION
, WSH.WEIGHT
, WSH.WEIGHT_UOM_CODE
, WSH.DATE_SHIPPED
, WSH.DATE_RECEIVED
, WSH.TRACKING_NUMBER
, WSH.WAYBILL WAYBILL_NUMBER
FROM WSH_DELIVERY_LINE_STATUS_V WSH
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE WSH.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND WSH.ORGANIZATION_ID = MSI.ORGANIZATION_ID