AR Module in Oracle Apps

LIST AR Tables

AR Tables
--------------------------------------
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUSTOMER_TRX_TYPE_ALL
RA_CUSTOMER_TRX_LINE_GL_DIST_ALL
RA_CUSTOMERS
RA_TERMS
RA_CUSTOMER_TRX_LINE_SALESREPS
AR_PAYMENT_SCHEDULES
AR_CUSTOMER_PROFILES
AR_CUSTOMER_PROFILE_CLASSES
AR_CASH_RECEIPTS
AR_MISC_CASH_DISTRIBUTIONS
AR_CASH_RECEIPT_HISTORY
AR_RECEIVABLE_APPLICATIONS
HZ_PARTIES
HZ_PARTY_SITES
HZ_CUST_ACCOUNTS
HZ_CUST_ACCOUNT_SITES_ALL
HZ_CUST_SITE_USES_ALL
HZ_LOCATIONS
HZ_CONTACT_POINTS
HZ_CUST_CONTACT_POINTS

-- Basic Query
-- Query Hot to find Customer Number , Site Number , Party Number From Invoice
-- Source : http://oracleappps.blogspot.com/search/label/AR

/* Formatted on 04/03/2019 19.13.39 (QP5 v5.256.13226.35510) */
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'