Query for Supplier Payment Method

SELECT pv.payment_method_name
FROM   iby_external_payees_all ip,
       iby_ext_party_pmt_mthds pm,
       iby_payment_methods_vl pv
WHERE  1 = 1
  AND  ip.supplier_site_id IS NULL
  AND  ip.payee_party_id = :Party_Id
  AND  ip.ext_payee_id = pm.ext_pmt_party_id
  AND  pm.payment_method_code = pv.payment_method_code
ORDER BY pm.primary_flag DESC, pm.last_update_date DESC;