Connection Between receipts and statements..

HI,

   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 tried to link the ar_cash-receipt_history_all cash_receipt_history _id to reference_id of ce_statement_reconcils_all but no data was retrieved..

 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