External Bank Account Assigned to Suppliers

  SELECT APS.vendor_name,
         APS.segment1 vendor_num,
         APSS.vendor_site_code vendor_Site,
         HZP.party_name Bank_Name,
         IEBA.bank_Account_name,
         IEBA.bank_account_num,
         IEBA.IBAN,
       IPUA.ORDER_OF_PREFERENCE Priority,
       IPUA.START_DATE,
       IPUA.END_DATE,
         BranchOrgProfile.bank_or_branch_number Sort_Code
    FROM apps.IBY_EXT_BANK_ACCOUNTS IEBA,
         apps.IBY_PMT_INSTR_USES_ALL IPUA,
         apps.IBY_EXTERNAL_PAYEES_ALL IEPA,
         apps.AP_SUPPLIERS APS,
         apps.AP_SUPPLIER_SITES_ALL APSS,
         apps.HZ_PARTIES HZP,
         apps.HZ_ORGANIZATION_PROFILES BranchOrgProfile
   --CE_BANK_BRANCHES_V
   WHERE     1 = 1
         AND IEBA.ext_bank_account_id = IPUA.instrument_id
         AND IPUA.instrument_type = 'BANKACCOUNT'
         AND IPUA.ext_pmt_party_id = IEPA.ext_payee_id
         AND IEPA.payee_party_id = APS.party_id
         AND IEPA.party_site_id = APSS.party_site_id(+)
         AND IEPA.payment_function = 'PAYABLES_DISB'
         AND IEPA.supplier_site_id = APSS.vendor_site_id(+)
         --Bank as Party
         AND IEBA.bank_id = HZP.party_id(+)
         --         AND  IEBA.bank_id = HZ_ORGANIZATION_PROFILES.party_id(+)
         --         AND  IEBA.branch_id = CE_BANK_BRANCHES_V.branch_party_id(+)
--         AND IEBA.BANK_ACCOUNT_NUM = '02249990'
         --              AND APS.segment1 = '95921'
         AND apss.org_id = 84
         AND payment_flow = 'DISBURSEMENTS'
         AND IEBA.branch_id = BranchOrgProfile.PARTY_ID(+)
ORDER BY aps.segment1, apss.vendor_site_Code, ipua.order_of_preference