How to find customer number, site number, party number from invoice

select rcta.trx_number,
cust_acct.account_number customer_number,
party_site.party_site_number site_number,
hp.party_number
FROM ra_customer_trx_all rcta,
hz_cust_accounts cust_acct,
hz_party_sites party_site,
hz_cust_acct_sites_all acct_site,
hz_cust_site_uses_all site_uses,
hz_parties hp
where  rcta.bill_to_customer_id = cust_acct.cust_account_id
AND rcta.bill_to_customer_id = acct_site.cust_account_id
AND rcta.bill_to_site_use_id = site_uses.site_use_id
AND cust_acct.cust_account_id = acct_site.cust_account_id
AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
AND site_uses.site_use_code = 'BILL_TO'
AND party_site.party_site_id = acct_site.party_site_id
AND hp.party_id = cust_acct.party_id
AND hp.party_id = party_site.party_id
and rcta.trx_number='11111111'