Sales Order Return Invoice No Query in Oracle apps

Sales Order Return Invoice No Query in Oracle apps

SELECToeh.order_number, oel.return_attribute1, rat.customer_trx_id,
rat.trx_number , inv.trx_number parent_inv_no, oel.line_id
FROM ra_customer_trx_all rat,

     oe_order_headers_all oe,
oe_order_lines_all oel ,

ra_customer_trx_all inv

WHERE rat.trx_number = '13901123'

AND rat.interface_header_attribute1 = oeh.order_number

AND oeh.header_id = oel.header_id

AND TO_NUMBER (oel.return_attribute1) = inv.customer_trx_id