Join condition between WSH_DELIVERY_DETAILS and DOO_FULFILL_LINES_ALL

Query with Join condition between WSH_DELIVERY_DETAILS and DOO_FULFILL_LINES_ALL

 SELECT a.delivery_detail_id,
       d.order_number,
       d.ordered_date,
       c.line_number,
       c.ordered_qty,
       c.inventory_item_id,
       c.inventory_organization_id,
       e.item_number
  FROM wsh_delivery_details   a,
       doo_fulfill_lines_all  b,
       DOO_LINES_ALL          c,
       doo_headers_all        d,
       egp_system_items_b     e
 WHERE     a.source_shipment_id = b.fulfill_line_id
       AND b.line_id = c.line_id
       AND c.inventory_item_id = e.inventory_item_id
       AND c.inventory_organization_id = e.organization_id
       AND c.header_id = d.header_id
       AND b.line_id = <OrderLineId>
       AND d.header_id = <OrderHeaderId>;
                
Additional Queries.

select delivery_id from WSH_DELIVERY_ASSIGNMENTS where delivery_detail_id = 3;
          
select * from WSH_NEW_DELIVERIES where delivery_id = 1001;