Query to Join Delivery Details and MTL Material Table

SELECT   wdd.source_header_number,
         wdd.source_line_id,
         wdd.delivery_detail_id,
         wdd.released_status,
         oe_interfaced_flag,
         inv_interfaced_flag,
         wdd.creation_date,
         mtl.transaction_id,
         l.flow_status_code,
         l.open_flag,
         l.cancelled_flag
  FROM   wsh_delivery_details wdd,
         mtl_material_transactions mtl,
         oe_order_lines_all l
 WHERE       l.line_id = wdd.source_line_id
         AND wdd.delivery_Detail_id = mtl.picking_line_id
         AND wdd.source_code = 'OE'
         AND wdd.oe_interfaced_flag = 'Y'
         AND wdd.released_status = 'Y'