SQL Query to get Ship_To Site Details for an AR Transaction in Oracle Fusion Account Receivables

SELECT DISTINCT rcta.trx_number,
                hca.account_number,
                hps.party_site_number
FROM   hz_cust_accounts hca
       JOIN hz_cust_acct_sites_all hcsa
         ON hca.cust_account_id = hcsa.cust_account_id
       JOIN hz_cust_site_uses_all hcsu
         ON hcsa.cust_acct_site_id = hcsu.cust_acct_site_id
       JOIN hz_party_sites hps
         ON hcsa.party_site_id = hps.party_site_id
       JOIN ra_customer_trx_all rcta
         ON hca.party_id = rcta.ship_to_party_id
WHERE  hcsu.site_use_code = 'SHIP_TO'
       AND rcta.trx_number = :trx_number