BI Publisher connecting bank account to receipt

Summary

Need advice on creating a data model for a BI Publisher report on AR receipts

Content

I need to create a new BI Publisher data model which returns the bank account associated with receipt in AR. 

I tried connecting ar_cash_receipts_all.customer_bank_account_id to iby_ext_bank_accounts.ext_bank_account_id but it seems that ar_cash_receipts_all.customer_bank_account_id is NULL for these receipt created using automatic receipting.

Does anyone have any advice on how to get the bank account name associated with AR receipts?

 

Code Snippet

FROM
hz_cust_accounts account
JOIN ar_cash_receipts_all receipt
ON account.cust_account_id = receipt.pay_from_customer
JOIN iby_ext_bank_accounts bank
ON receipt.customer_bank_account_id = bank.ext_bank_account_id