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;
No comments:
Post a Comment