VIEW: APPS.WSH_DELIVERY_ASSIGNMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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