Query
SELECT IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM,
IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME,HZ_PARTIES.PARTY_NAME BANK,
HZ_PARTIES1.PARTY_NUMBER BANK_NUMBER,
s.vendor_name,
s.segment1 vendor_num
FROM IBY.IBY_EXT_BANK_ACCOUNTS IBY_EXT_BANK_ACCOUNTS,
AR.HZ_PARTIES HZ_PARTIES,
AR.HZ_PARTIES HZ_PARTIES1,
ap_suppliers s,
iby_external_payees_all ep,
iby_pmt_instr_uses_all piu
WHERE HZ_PARTIES.PARTY_ID = IBY_EXT_BANK_ACCOUNTS.BANK_ID
AND HZ_PARTIES1.PARTY_ID = IBY_EXT_BANK_ACCOUNTS.BRANCH_ID
AND IBY_EXT_BANK_ACCOUNTS.ACCOUNT_CLASSIFICATION = 'EXTERNAL'
AND IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id = piu.instrument_id
AND ep.ext_payee_id = piu.ext_pmt_party_id
AND ep.payee_party_id = s.party_id
