SELECT AISC.CHECKRUN_ID BATCH_ID
, AISC.CHECKRUN_NAME BATCH_NAME, AISC.ORG_ID
, AISC.CHECK_DATE
, AISC.CURRENCY_CODE
, HOU.NAME ORG_NAME
, HL.ADDRESS_LINE_1
, HL.TOWN_OR_CITY
, HL.COUNTRY
, HL.REGION_1
, HL.POSTAL_CODE
, HL.REGION_2
, ABA.BANK_ACCOUNT_NUM
, ABA.BANK_ACCOUNT_TYPE
, ABB.BANK_NUM
, ABB.BANK_NUMBER
, ABB.BANK_NAME
, ABB.BANK_BRANCH_ID
, ABB.BANK_BRANCH_NAME
, ABB.BANK_BRANCH_TYPE
, ABB.ADDRESS_LINE1 BANK_ADDRESS_LINE1
, ABB.CITY BANK_CITY
, ABB.COUNTRY BANK_COUNTRY
, ABB.ZIP BANK_ZIP
, ABB.STATE BANK_STATE
FROM HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS HL
, AP_INVOICE_SELECTION_CRITERIA AISC
, AP_BANK_ACCOUNTS ABA
, AP_BANK_BRANCHES ABB
WHERE HL.LOCATION_ID = HOU.LOCATION_ID
AND HOU.ORGANIZATION_ID = AISC.ORG_ID
AND AISC.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND ABA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID
