Sunday, July 31, 2011

Supplier Site Payment Methods in R12

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

Best Blogger TipsGet Flower Effect