How to join CE_STATEMENT_LINES, CE_RECON_HISTORY, CE_RECON_HISTORY_ITEMS, AP_CHECK_ALL

We are building a BI publisher report to list

Bank Statement Number, Bank Statement Line, Statement Line Amount, AP Payment Number

Using the tables

CE_STATEMENT_HEADERS CSH

CE_STATEMENT_LINES CSL

CE_RECON_HISTORY CRH

CE_RECON_HISTORY_ITEMS CRHI

AP_CHECK_ALL ACA

And Join conditions as below:1=1
AND CSH.STATEMENT_HEADER_ID = CSL.STATEMENT_HEADER_ID
AND CSL.EXTERNAL_TRANSACTION_ID IS NULL
AND CSL.RECON_HISTORY_ID = CRH.RECON_HISTORY_ID
AND CRH.RECON_HISTORY_ID = CRHI.RECON_HISTORY_ID
AND CRH.BANK_ACCOUNT_ID = CSH.BANK_ACCOUNT_ID
AND ACA.CLEARED_DATE = CRHI.CLEARED_DATE