To find Bill of Lading info of the delivery

select

wnd.delivery_id delivery_id,

wdi.sequence_number bol_number,

wdi.bol_notify_party,

wdi.port_of_loading,

wdi.port_of_discharge,

wnd.WAYBILL waybill,

wnd.GROSS_WEIGHT gross_weight,

wnd.WEIGHT_UOM_CODE uom,

wnd.status_code

from wsh_new_deliveries wnd,

wsh_delivery_legs wdl,

wsh_document_instances wdi

where wnd.delivery_id =12784

and wnd.delivery_id = wdl.delivery_id (+)

and wdi.entity_id (+) = wdl.delivery_leg_id

AND wdi.entity_name (+) = 'WSH_DELIVERY_LEGS'

AND wdi.document_type (+) = 'BOL'

AND wdi.status (+) <> 'CANCELLED'