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
