Recently I had a call from a customer that had a requirement to mass update their supplier site payment method defaults in R12. They were updating the PAYMENT_METHOD_LOOKUP_CODE on the AP_SUPPLIER_SITES_ALL table and it was not reflecting the change in the applications.
In R12 the suppliers were merged into the Trading Community Architecture (TCA). The default payment method for supplier sites are now located in the IBY_EXT_PARTY_PMT_MTHDS table and not the AP_SUPPLIER_SITES_ALL table. Below is a query that will return a list of all suppliers, supplier sites and their payment methods. The default payment method is denoted with a primary flag = ‘Y’.
SELECT ieppm.ext_party_pmt_mthd_id,
sup.vendor_name,
assa.vendor_site_code,
ieppm.payment_method_code,
ieppm.primary_flag,
ieppm.inactive_date,
assa.org_id,
sup.vendor_id,
assa.vendor_site_id
FROM ap_supplier_sites_all assa,
ap_suppliers sup,
iby_external_payees_all iepa,
iby_ext_party_pmt_mthds ieppm
WHERE sup.vendor_id = assa.vendor_id
AND assa.pay_site_flag = 'Y'
AND assa.vendor_site_id = iepa.supplier_site_id
AND iepa.ext_payee_id = ieppm.ext_pmt_party_id
AND( (ieppm.inactive_date IS NULL)or (ieppm.inactive_date > sysdate))
ORDER BY sup.vendor_name, assa.vendor_site_code;
