Supplier Sites Payment information in R12

            Supplier Site payment information in R12 will not be there in the AP supplier base table AP_SUPPLIER_SITES_ALL. In R12 Payments/Payment methods are overtaken by IBY (Payments). Payment method code in R12 is stored in IBY_PAYMENT_METHODS.PAYMENT_METHOD_CODE The default payment method for supplier sites are now located in the IBY_EXT_PARTY_PMT_MTHDS table. Below is a query that will return a list of all suppliers, supplier sites and their payment methods.

SELECT         ieppm.ext_party_pmt_mthd_id,

     s.vendor_name,

     ss.vendor_site_code,

     ieppm.payment_method_code,

     eppm.primary_flag,

     ieppm.inactive_date,

     ss.org_id,

     s.vendor_id,

     ss.vendor_site_id

FROM ap_supplier_sites_all ss,

            ap_suppliers s,

            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))