How to get banking information for AP suppliers by SQL?

Hello there,

I always get confused with query for banking information for our suppliers. Here is the script I normally use:

select *

FROM apps.ap_suppliers aps, apps.ap_supplier_sites_all apss, apps.iby_ext_bank_accounts ieba, apps.iby_account_owners iao,

    apps.iby_ext_banks_v ieb, apps.iby_ext_bank_branches_v iebb, apps.ap_terms apt, apps.ap_terms apt1, iby.iby_external_payees_all iepa 

    WHERE aps.vendor_id = apss.vendor_id

    AND aps.terms_id = apt.term_id           -- For Supplier Banking Information

    AND apss.terms_id = apt1.term_id(+)

    and iao.account_owner_party_id = aps.party_id