SELECT AISC.CHECKRUN_NAME
, AISC.CHECKRUN_ID, ABA.BANK_ACCOUNT_NUM
, ABA.BANK_ACCOUNT_TYPE
, ABA.CHECK_DIGITS
, ABA.CURRENCY_CODE
, ABA.BANK_ACCOUNT_NAME
, ABB.BANK_BRANCH_TYPE
, ABB.BANK_NUMBER
, ABB.BANK_NAME
, ABB.BANK_BRANCH_NAME
, ABB.BANK_NUM
, ABB.CONTACT_TITLE
, ABB.PHONE
, ABB.CITY
, ABB.STATE
, ABB.ZIP
, ABB.COUNTRY
, ABA.EFT_USER_NUMBER
, ABB.EFT_SWIFT_CODE
, ABB.CONTACT_FIRST_NAME||' '||ABB.CONTACT_LAST_NAME
, ABB.ADDRESS_LINE1||'
, '||ABB.ADDRESS_LINE2
FROM AP_INVOICE_SELECTION_CRITERIA AISC
, AP_BANK_ACCOUNTS ABA
, AP_BANK_BRANCHES ABB
WHERE AISC.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND ABA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID
