Monday, 7 July 2014

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’.

/* Formatted on 7/7/2014 4:52:17 PM (QP5 v5.115.810.9015) */
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