Query to get the delivery Order ,order_status ,ordered quantity and shipped quantity details

SELECT

OOH.ORDER_NUMBER

,WDD.RELEASED_STATUS

,WDD.ITEM_DESCRIPTION

,OOL.ORDERED_QUANTITY

,wdd.shipped_quantity

from

OE_ORDER_LINES_ALL OOL,

oe_order_headers_all ooh,

WSH_DELIVERY_DETAILS WDD

WHERE 1=1

AND wdd.source_header_id = ool.header_id

and WDD.SOURCE_LINE_ID = OOL.LINE_ID

and OOH.HEADER_ID=OOL.HEADER_ID

and ORDER_NUMBER='5345';