View: WSH_DELIVERY_ASSIGNMENTS_V

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

View Text

SELECT WDA.DELIVERY_ASSIGNMENT_ID
, WDA.DELIVERY_ID
, WDA.PARENT_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
, WDA.LAST_UPDATE_LOGIN
, WDA.PROGRAM_APPLICATION_ID
, WDA.PROGRAM_ID
, WDA.PROGRAM_UPDATE_DATE
, WDA.REQUEST_ID
, WDA.ACTIVE_FLAG
, NVL(WDA.TYPE
, 'S')
FROM WSH_DELIVERY_ASSIGNMENTS WDA
WHERE WDA.TYPE IN ('S'
, 'O') OR WDA.TYPE IS NULL

Columns