AR Accounting Error checking SQL for Bank

SELECT distinct a.receipt_method_id, a.NAME receiptmethod, b.remit_bank_acct_use_id,
       c.bank_account_id, d.bank_account_name, d.bank_account_num, h.ENTITY_ID, h.EVENT_ID, h.AE_HEADER_ID, h.AE_LINE_NUM,  h.ENCODED_MSG
  FROM ar_receipt_methods a,
       ar_receipt_method_accounts_all b,
       ce_bank_acct_uses_all c,
       ce_bank_accounts d,
       ar_receipt_classes e,
       ar_cash_receipts_all f,
        ar_receivable_applications_all g,
        xla_accounting_errors h
 WHERE a.receipt_method_id = b.receipt_method_id
   AND b.remit_bank_acct_use_id = c.bank_acct_use_id
   AND c.bank_account_id = d.bank_account_id
   and a.RECEIPT_CLASS_ID=e.RECEIPT_CLASS_ID
   and a.RECEIPT_METHOD_ID=f.RECEIPT_METHOD_ID
   and f.CASH_RECEIPT_ID= g.CASH_RECEIPT_ID
   and g.EVENT_ID=h.EVENT_ID and h.request_id=:request_id