View: WSHBV_DELIVERY_ASSIGNMENTS

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSHBV_DELIVERY_ASSIGNMENTS

View Text

SELECT WDA.DELIVERY_ASSIGNMENT_ID
, WDA.DELIVERY_ID
, WDA.DELIVERY_DETAIL_ID
, WDA.PARENT_DELIVERY_DETAIL_ID
, WDA.CREATION_DATE
, WDA.CREATED_BY
, WDA.LAST_UPDATE_DATE
, WDA.LAST_UPDATED_BY
, '_LA:WDA.ACTIVE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
FROM WSH_DELIVERY_ASSIGNMENTS WDA
, WSH_DELIVERY_DETAILS WDD
WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY

Columns