how to get a customer name based on order number

select ra.CUSTOMER_NAME,
          ra.CUSTOMER_ID,
          rcta.CT_REFERENCE,
          ooha.order_number
from ra_customer_trx_all rcta,
         ra_customers ra,
         oe_order_headers_all ooha
where rcta.CT_REFERENCE=to_char(ooha.ORDER_NUMBER)
          and ra.CUSTOMER_ID=rcta.SHIP_TO_CUSTOMER_ID
          and order_number='66415'

(or)

select hp.PARTY_NAME,
          hp.PARTY_ID,
          rcta.CT_REFERENCE,
          ooha.order_number
from ra_customer_trx_all rcta,
         hz_parties hp,
         oe_order_headers_all ooha
where rcta.CT_REFERENCE=to_char(ooha.ORDER_NUMBER)
          andhp.PARTY_ID=rcta.SHIP_TO_CUSTOMER_ID
          and order_number='66415'