- AR_TRX_INFO_V
SELECT trx.customer_trx_id CUSTOMER_TRX_ID,
pty.party_name CUSTOMER_NAME,
ca.account_number CUSTOMER_NUMBER,
trx.trx_number TRX_NUMBER,
trx.doc_sequence_value TRX_DOCUMENT_NUMBER,
trx.trx_date TRX_DATE,
tty.name TRX_TYPE,
bs.name TRX_BATCH_SOURCE,
bu.bu_name BU_NAME
FROM ra_customer_trx_all trx ,
hz_cust_accounts ca ,
hz_parties pty ,
ra_cust_trx_types_all tty,
ra_batch_sources_all bs,
fun_all_business_units_v bu
WHERE DECODE(trx.drawee_id, NULL, trx.bill_to_customer_id, trx.drawee_id) = ca.cust_account_id
AND ca.party_id = pty.party_id
AND trx.cust_trx_type_seq_id = tty.cust_trx_type_seq_id
AND trx.batch_source_seq_id = bs.batch_source_seq_id
AND trx.org_id = bu.bu_id
- AR_CR_INFO_V
SELECT cr.cash_receipt_id ,
pty.party_name ,
ca.account_number ,
cr.receipt_number ,
cr.doc_sequence_value,
cr.receipt_date ,
arm.NAME ,
bu.bu_name
FROM ar_cash_receipts_all cr,
hz_cust_accounts ca ,
hz_parties pty ,
ar_receipt_methods arm ,
fun_all_business_units_v bu
WHERE cr.pay_from_customer = ca.cust_account_id(+)
AND ca.party_id = pty.party_id(+)
AND cr.receipt_method_id = arm.receipt_method_id
AND cr.org_id = bu.bu_id
- AR_ADJ_INFO_V
SELECT adj.adjustment_id ,
pty.party_name ,
ca.account_number ,
adj.adjustment_number,
adj.doc_sequence_value,
adj.creation_date,
adj.type,
bu.bu_name
FROM ar_adjustments_all adj,
ra_customer_trx_all trx,
hz_cust_accounts ca ,
hz_parties pty,
fun_all_business_units_v bu
WHERE adj.customer_trx_id = trx.customer_trx_id
AND trx.bill_to_customer_id = ca.cust_account_id
AND ca.party_id = pty.party_id
AND adj.org_id = bu.bu_id
For more information
https://docs.oracle.com/en/cloud/saas/financials/18c/oedmf/AR-tables.html