Need to create sql join between the ar_receipt_method_accounts_all table and ce_bank_accounts

Need to create sql script for cash receipts and pull the bank account name and bank account number. I have joined the two tables using bank_accout_id for the ce_bank_accounts table and

remit_bank_acct_use_id for the ar_receipt_method_accounts_all table. The problem is that for any bank account created after we upgraded to Release 12 the bank_account_id and  remit_bank_acct_use_id

are not the same. For all bank accounts created prior to release 12  bank_account_id and remit_bank_acct_use_id  are the same and the join is sucessfully pulling the correct cash receipts.