Sales Order Details After Pick Release

SELECT   ooh.order_number,
         ool.line_number,
         wnd.delivery_id,
         mtrh.request_number
  FROM   oe_order_headers ooh,
         oe_order_lines_all ool,
         wsh_delivery_details wdd,
         wsh_new_deliveries wnd,
         wsh_delivery_assignments wda,
         mtl_txn_request_lines mtrl,
         mtl_txn_reuest_headers mtrh
 WHERE       ooh.order_number = 123            
         AND ool.header_id = ooh.header_id
         AND ool.line_id = wdd.source_line_id
         AND wdd.delivery_detail_id = wda.delivery_detail_id
         AND wnd.delivery_id = wda.delivery_id
         AND wdd.move_order_line_id = mtrl.line_id
         AND mtrl.header_id = mtrh.header_id