Order Receivable Invoice Query

SELECT   ooh.order_number,
         --    ool.line_id,
         ool.ordered_quantity,
         ool.shipped_quantity,
         ool.invoiced_quantity,
         wdd.delivery_detail_id,
         wnd.delivery_id,
         TO_CHAR (wdd.CREATION_DATE, 'DD-MON-YY') delivery_cre_date,
         (SELECT   trx_number
            FROM   ra_customer_trx_all rct, ra_customer_trx_lines_all rctl
           WHERE   rctl.interface_line_attribute1 =
                      TO_CHAR (ooh.order_number)
                   AND rctl.interface_line_attribute6 = TO_CHAR (ool.line_id)
                   AND rctl.interface_line_attribute3 =
                         TO_CHAR (wnd.delivery_id)
                   AND rctl.customer_trx_id = rct.customer_trx_id
                   AND rct.interface_header_context = 'ORDER ENTRY')
            trx_number
  FROM   oe_order_headers_all ooh,
         oe_order_lines_all ool,
         wsh_delivery_details wdd,
         wsh_new_deliveries wnd,
         wsh_delivery_assignments wda
 WHERE       ooh.header_Id = ool.header_id
         AND ooh.org_id = ool.org_id
         AND wdd.source_header_id = ooh.header_id
         AND wdd.SOURCE_LINE_ID = ool.line_id
         AND wdd.delivery_detail_Id = wda.delivery_detail_id
         AND wda.delivery_id = wnd.delivery_id
         -- AND rctl.interface_line_attribute1 = TO_CHAR (ooh.order_number)
         -- AND rctl.interface_line_attribute6 = TO_CHAR (ool.line_id)
         -- AND rctl.interface_line_attribute3 = TO_CHAR (wnd.delivery_id)
         -- AND rctl.customer_trx_id = rct.customer_trx_id
         -- AND rct.interface_header_context = 'ORDER ENTRY'
         AND wdd.CREATION_DATE BETWEEN '01-MAY-15' AND '30-MAY-15'
--and wda.delivery_id = 2555078
--  and ooh.order_number = 1531311781
-- AND rct.org_id = 613