AR Tables with joins

Joins  AR TRANSACTION AND RECEIPTS TO GL WITH JOINS STEP BY STEP IN SIMPLE WAY

                 
            AR TRANSACTONS TABLES

SELECT * FROM  RA_CUSTOMER_TRX_ALL
WHERE 1=1
AND TRX_NUMBER=10223 --and customer_trx_id=7943

SELECT * FROM  RA_CUSTOMER_TRX_LINES_ALL
WHERE CUSTOMER_TRX_ID=7943  --customer_trx_id=7943,CUSTOMER_TRX_LINE_ID 7964

SELECT * FROM RA_CUST_TRX_LINE_GL_DIST_ALL
WHERE CUSTOMER_TRX_LINE_ID =7964    --CUST_TRX_LINE_GL_DIST_ID=17399

                        AR RECEIPTS TABLES

SELECT * FROM  AR_RECEIVABLE_APPLICATIONS_ALL
WHERE APPLIED_CUSTOMER_TRX_ID =7943

SELECT * FROM  AR_CASH_RECEIPTS_ALL
WHERE CASH_RECEIPT_ID=139154   --PAY_FROM_CUSTOMER=10513


                        HZ PARTY TABLES IN AR

SELECT * FROM  HZ_CUST_ACCT_SITES_ALL
WHERE CUST_ACCOUNT_ID=10513  --party_site_id=448147

SELECT * FROM  HZ_PARTY_SITES
WHERE PARTY_SITE_ID=448147 --party_id=498171

SELECT * FROM  HZ_PARTIES
WHERE PARTY_ID=498171

                        XLA TABLES

SELECT * FROM   XLA.XLA_TRANSACTION_ENTITIES
WHERE SOURCE_ID_INT_1=7943  --entity_code=TRANSACTIONS,application_id=222

SELECT * FROM  XLA.XLA_AE_HEADERS
WHERE ENTITY_ID=1302589  --ae_header_id=1402447

SELECT * FROM  XLA.XLA_AE_LINES
WHERE AE_HEADER_ID=1402447    --gl_sl_link_id in(2729789,2729790)


                          GL TABLES                   

SELECT * FROM  GL_IMPORT_REFERENCES
WHERE GL_SL_LINK_ID IN(2729789,2729790)  --je_header_id=1759126, je_batch_id=1238537, je_header_id=1238537

SELECT * FROM  GL_JE_HEADERS
WHERE JE_HEADER_ID=1238537

SELECT * FROM  GL_JE_LINES
WHERE JE_HEADER_ID=1238537