AR Tables

select * from HZ_CUST_ACCOUNTS where cust_account_id = 123

select * from hz_parties where party_id in (1234,110011)

select * from  HZ_CUST_ACCOUNT_ROLES where cust_account_id = 1243 and cust_account_role_id = 1100

select * from RA_SALESREPS_ALL

select * from RA_CUST_TRX_TYPES_ALL

select * from SO_AGREEMENTS_B

select * from RA_TERRITORIES

select * from AR_BATCHES_ALL

select * from RA_ADDRESSES_ALL

select * from RA_TERMS_B

select * from AR_CASH_RECEIPTS_ALL

select * from AR_CASH_RECEIPT_HISTORY_ALL

select * from AR_RECEIVABLE_APPLICATIONS_ALL

select * from AR_PAYMENT_SCHEDULES_ALL

select * from AR_RECEIPT_CLASSES

select * from AR_RECEIPT_METHODS

select * from AR_RECEIPT_METHOD_ACCOUNTS