Supplier Payment Method

In Oracle on the supplier/supplier site a payment method can be maintained. e.g.  CHECK or EFT.
When the Supplier is created the payment method information is populated in the table :
IBY_EXTERNAL_PAYEES_ALL and IBY_EXT_PARTY_PMT_MTHDS

Post creation when the payment method details are updated oracle will insert a new record in the table : IBY_EXT_PARTY_PMT_MTHDS , thus this table maitains the complete history of payment method details of the supplier/supplier site.

The current record is identified by PRIMARY_FLAG = 'Y' .

select

aps.vendor_name,aps.segment1 ,asl.vendor_site_code,pmt.PAYMENT_METHOD_CODE

from apps.ap_suppliers aps,
apps.ap_supplier_sites_all asl,
apps.IBY_EXTERNAL_PAYEES_ALL iep,
APPS.IBY_EXT_PARTY_PMT_MTHDS pmt
where aps.vendor_id = asl.vendor_id
and asl.vendor_site_id = iep.supplier_site_id
and asl.org_id = iep.org_id
and iep.ext_payee_id = pmt.ext_pmt_party_id
and pmt.primary_flag = 'Y'