Query to get Sale Order and Move Order Info in Oracle apps R12 EBS

Below is the query to get Sale Order and Move Order Info

 SELECT
            mtrh.request_number                         AS move_order_number,
            mtrh.organization_id,
            mtrh.header_id,
            mtrl.line_id,
            mtrh.move_order_type,
            mtrl.quantity,
            mtrl.quantity_delivered,
            ( mtrl.quantity - mtrl.quantity_delivered ) unallocated_qty
        FROM
            xx_ont_sale_ord_ibi_t       ibi,
            oe_order_headers_all        ooha,
            oe_order_lines_all          oola,
            wsh_delivery_details        wdd,
            mtl_txn_request_headers     mtrh,
            mtl_txn_request_lines       mtrl
        WHERE 1=1
            AND ibi.order_number = ooha.order_number
            AND ibi.line_id = oola.line_id
            AND ooha.header_id = oola.header_id
            AND wdd.source_line_id = oola.line_id
            AND wdd.source_header_id = oola.header_id
            AND wdd.move_order_line_id = mtrl.line_id
            AND mtrl.header_id = mtrh.header_id
            AND ibi.order_number = p_order_no;