FND Design Data [Home] [Help]

View: IBE_SHIPMENT_LINES_V

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
View Text

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

Columns

DELIVERY_DETAIL_ID
SOURCE_CODE
LINE_ID
HEADER_ID
HEADER_NUMBER
LINE_NUMBER
SHIP_METHOD_CODE
INVENTORY_ITEM_ID
ITEM_DESCRIPTION
REQUESTED_QUANTITY
SHIPPED_QUANTITY
SHIPPED_QUANTITY_UOM
REQUESTED_QUANTITY_UOM
SHIP_SET_ID
REVISION
LOT_NUMBER
SERIAL_NUMBER
PICK_STATUS
PICK_MEANING
DELIVERY_ID
DELIVERY_NAME
CURRENCY_CODE
DELIVERY_STATUS
DELIVERY_STATUS_MEANING
ORGANIZATION_ID
INITIAL_PICKUP_LOCATION_ID
INITIAL_PICKUP_LOCATION
ULTIMATE_DROPOFF_LOCATION_ID
ULTIMATE_DROPOFF_LOCATION
WEIGHT
WEIGHT_UOM_CODE
DATE_SHIPPED
DATE_RECEIVED
TRACKING_NUMBER
WAYBILL_NUMBER
Name