Query for default payment method code

Query for default payment method code:


SELECT apssa.vendor_site_id,

apssa.vendor_site_code,

ibeppm.payment_method_code

FROM

ap_suppliers aps,

iby_external_payees_all ibepa,

iby_ext_party_pmt_mthds ibeppm,



ap_supplier_sites_all apssa

WHERE aps.party_id=ibepa.payee_party_id AND

ibeppm.ext_pmt_party_id = ibepa.ext_payee_id AND

apssa.vendor_id = aps.vendor_id AND

ibepa.supplier_site_id is not null AND

ibeppm.primary_flag = 'Y' AND

aps.segment1= '<Vendor Number>'

and ibepa.party_site_id = apssa.party_site_id

and vendor_site_code = <Vendor Site code>