[Home] [Help]
View: WSH_DLVY_SHIP_FROM_TO_V
View Text
SELECT DELIVERY_ID
, NAME DELIVERY_NAME
, TO_CHAR(NULL) CONTAINER_FLAG
, TO_NUMBER(NULL) DELIVERY_DETAIL_ID
, TO_CHAR(NULL) CONTAINER_NAME
, TO_NUMBER(NULL) ORGANIZATION_ID
, TO_NUMBER(NULL) INVENTORY_ITEM_ID
, INITIAL_PICKUP_LOCATION_ID SHIP_FROM_LOCATION_ID
, ULTIMATE_DROPOFF_LOCATION_ID SHIP_TO_LOCATION_ID
FROM WSH_NEW_DELIVERIES
WHERE NVL(SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')
Columns
Name |
DELIVERY_ID |
DELIVERY_NAME |
CONTAINER_FLAG |
DELIVERY_DETAIL_ID |
CONTAINER_NAME |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
SHIP_FROM_LOCATION_ID |
SHIP_TO_LOCATION_ID |