Query to check whether a Supplier-Site-Bank can make an International Payment

SELECT
   hp.party_name AS supplier_name,
   ps.segment1 AS supplier_number,
   pssam.vendor_site_code as site,
   ieba.bank_account_num as bank_acc_no,
   decode(LOWER(ieba.foreign_payment_use_flag), 'y', 'Allow International Payments', 'n', 'Don''t allow International Payments') AS international_payments,
   CASE
      WHEN
         ipiua.end_date LIKE '4712-12-31%'
      THEN
         'Active'
      ELSE
         'Inactive'
   END AS stat,
   decode(LOWER(ipiua.primary_flag), 'y', 'Primary Bank Account', 'Non-Primary Bank Account') AS bank_type,
   ieba.last_updated_by,
   ieba.last_update_date || '  ' || 'UTC' AS last_update_date
FROM
   poz_suppliers ps,
   hz_parties hp,
   poz_supplier_sites_all_m pssam,
   iby_external_payees_all iepa,
   iby_pmt_instr_uses_all ipiua,
   iby_ext_bank_accounts ieba
WHERE
   1 = 1
   AND hp.party_id = ps.party_id
   AND ps.vendor_id = pssam.vendor_id
   AND iepa.supplier_site_id = pssam.vendor_site_id
   AND ipiua.ext_pmt_party_id = iepa.ext_payee_id
   AND ipiua.instrument_id = ieba.ext_bank_account_id
ORDER BY
   hp.party_name, pssam.vendor_site_code, ieba.bank_account_num