query to get Shipment number based on Order number

 SELECT DISTINCT

    wnd.delivery_name,

    wnd.actual_ship_date,

    wdd.sales_order_number

FROM

    wsh_new_deliveries       wnd,

    wsh_delivery_assignments wda,

    wsh_delivery_details     wdd

WHERE

        wnd.delivery_id = wda.delivery_id

    AND wda.delivery_detail_id = wdd.delivery_detail_id

    AND wdd.sales_order_number IS NOT NULL --='422213'

    AND wnd.actual_ship_date IS NOT NULL

ORDER BY

    wdd.sales_order_number