SELECT HOU.NAME
, AISC.CHECKRUN_ID, AISC.CHECKRUN_NAME
, AISC.CHECK_DATE
, HL.TOWN_OR_CITY
, HL.REGION_1
, HL.REGION_2
, HL.COUNTRY
, HL.POSTAL_CODE
, HL.TELEPHONE_NUMBER_1
, HL.DESCRIPTION
, DECODE(AISC.PAYMENT_METHOD_LOOKUP_CODE
, 'EFT'
, 'ACH'
, AISC.PAYMENT_METHOD_LOOKUP_CODE)
, AISC.ORG_ID
, HL.ADDRESS_LINE_1||'
, '||HL.ADDRESS_LINE_2
, ABA.EFT_USER_NUMBER
FROM HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS HL
, AP_INVOICE_SELECTION_CRITERIA AISC
, AP_BANK_ACCOUNTS ABA
WHERE HL.LOCATION_ID = HOU.LOCATION_ID
AND HOU.ORGANIZATION_ID = AISC.ORG_ID
AND AISC.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND AISC.STATUS <> 'QUICKCHECK' UNION ALL SELECT HOU.NAME
, AISC.CHECKRUN_ID
, AISC.CHECKRUN_NAME
, AISC.CHECK_DATE
, HL.TOWN_OR_CITY
, HL.REGION_1
, HL.REGION_2
, HL.COUNTRY
, HL.POSTAL_CODE
, HL.TELEPHONE_NUMBER_1
, HL.DESCRIPTION
, DECODE(APC.PAYMENT_METHOD_LOOKUP_CODE
, 'EFT'
, 'ACH'
, APC.PAYMENT_METHOD_LOOKUP_CODE)
, AISC.ORG_ID
, HL.ADDRESS_LINE_1||'
, '||HL.ADDRESS_LINE_2
, ABA.EFT_USER_NUMBER
FROM HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS HL
, AP_INVOICE_SELECTION_CRITERIA AISC
, AP_BANK_ACCOUNTS ABA
, AP_CHECKS APC
WHERE HL.LOCATION_ID = HOU.LOCATION_ID
AND HOU.ORGANIZATION_ID = AISC.ORG_ID
AND AISC.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND AISC.STATUS = 'QUICKCHECK'
AND AISC.CHECKRUN_NAME = APC.CHECKRUN_NAME
