To Get the Suppliers Payment Method

Define Payment methods are available in the following tables:

select * from IBY_APPLICABLE_PMT_MTHDS

where payment_method_code in

(select payment_method_code

 from iby_payment_methods_vl

 where payment_method_name = 'Payment Method Name'

);

To get the payment methods assigned to a certain supplier:

SELECT *

FROM fusion.iby_ext_party_pmt_mthds ieppm

WHERE ieppm.ext_pmt_party_id IN

    (SELECT iep.ext_payee_id

     FROM fusion.iby_external_payees_all iep

     WHERE 1 = 1

     and ieppm.Primary_flag = 'Y'

     AND iep.supplier_site_id IN

                    (SELECT pssa.vendor_site_id

                     FROM fusion.poz_supplier_sites_all_m pssa, fusion.poz_suppliers ps

                     WHERE ps.vendor_id = pssa.vendor_id

                     AND ps.party_id in (select party_id

                                         from hz_parties

                                         where party_name = 'xxxxx'

                                        )

                    )

    )