Query to get Supplier Site Level Bank Account in Oracle APPS

SELECT bank_account_name

              ,bank_account_num

  FROM iby_ext_bank_accounts

 WHERE ext_bank_account_id IN ( SELECT ext_bank_account_id

                                  FROM iby_account_owners

                                 WHERE account_owner_party_id

                                    IN ( SELECT party_id

      FROM hz_party_sites

   WHERE party_site_name = 'SUPPLIER_SITE_NAME'

)

)