FND Design Data [Home] [Help]

View: WSH_DLVY_SHIP_FROM_TO_V

Product: WSH - Shipping Execution
Description:
Implementation/DBA Data: ViewAPPS.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