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’.
FROM ap_supplier_sites_all assa,
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;