RMA Number From Inv Material transaction

select dha.ORDER_NUMBER,imt.transaction_id, (select receipt_num from rcv_shipment_headers rsh1, rcv_transactions rc where rsh1.SHIPMENT_HEADER_ID=rc.SHIPMENT_HEADER_ID and rc.TRANSACTION_ID=imt.RCV_TRANSACTION_ID)receipt_num from inv_material_txns imt, rcv_shipment_headers rsh, doo_headers_All dha where imt.transaction_id=448369 and imt.TRANSACTION_SOURCE_ID=rsh.SHIPMENT_HEADER_ID and rsh.RECEIPT_ADVICE_NUMBER=dha.HEADER_ID