How do I join the AR_BATCHES_ALL table to the AR_CASH_RECEIPTS_ALL table?
I'm creating a custom report that requires me to show Receivables batches and receipt information. The ARTRM.pdf dated May 2000 states that these tables should join together using the BATCH_ID column (primary key column) from the AR_BATCHES_ALL table and the SELECTED_REMITTANCE_BATCH_ID column (foreign key column) from the AR_CASH_RECEIPTS_ALL table.
When I execute the following query:
select *
from ar_batches_all b,
ar_cash_receipts_all cr
where CR.SELECTED_REMITTANCE_BATCH_ID = b.batch_id
and CR.org_id = b.org_id
I get about 10 records returned, which all have an AR_BATCHES_ALL.STATUS column value of NULL. I've attempted to query these AR batches via the application in the 'Receipts Batches' screen (
When I execute the following query:
select *
from ar_batches_all b,
ar_cash_receipts_all cr
where CR.SELECTED_REMITTANCE_BATCH_ID = b.batch_id
and CR.org_id = b.org_id
I get about 10 records returned, which all have an AR_BATCHES_ALL.STATUS column value of NULL. I've attempted to query these AR batches via the application in the 'Receipts Batches' screen (
1