Connection between two tables
Just a simple question.. What is the link between ce_statement_lines and ar_cash_receipts_all except from bank_trx_number of statement line and receipt number of cash receipt.
I need to get data which is already reconciled but still has a status of remitted.
HERE IS THE SCRIPT
select csl.line_number
,cra.org_id
,crh.status
,crh.current_record_flag
,crh.factor_flag
,csr.auto_reconciled_flag
,csr.current_record_flag
,csh.statement_number
,csl.bank_trx_number
,aba.bank_account_num
from ce_statement_headers_all csh
,ce_statement_lines csl
,ap_bank_accounts_all aba