Supplier Payment Method Query In Oracle Apps R12 - Orapoint

In this article we will discuss on query to Get Supplier Payment Method in Oracle Apps. We’ll show you how to use a detailed SQL query to extract all of the Oracle Apps provider information, including payment method information. Oracle payments are processed with the help of the supplier payment method.

Oracle payments are differentiated using the supplier payment method. Mentioning the type of payment is beneficial. EFT and Check are the most prevalent payment methods in Oracle apps. We’ll also show you how to use Oracle Apps tables to store supplier payment method information in Oracle Apps. This is a crucial question regarding the upkeep of supplier information.

Payment Terms in Oracle Apps R12

When you submit an invoice for approval, you can attach payment terms to it, which will automatically produce periodic payments. You can create several scheduled payment lines and numerous levels of discounts by defining payment terms. You can establish as many payment terms as you want.

Supplier Payment Method Table in Oracle Apps R12

1. IBY_EXT_PARTY_PMT_MTHDS
2. IBY_EXTERNAL_PAYEES_ALL

Supplier Payment Method SQL Query in Oracle Apps R12

The following is a detailed sql query that can be used in Oracle apps to extract entire supplier details and payment method information.

SELECT  sup.segment1 "Supplier Number",
        sup.vendor_name "Supplier Name",
        ss.vendor_site_code "Supplier Site",
        ppm.payment_method_code "Supplier Payment Method"
     ,  ppm.primary_flag
 FROM  ap_suppliers                sup
     , ap_supplier_sites_all       ss
     , iby.iby_external_payees_all epa
     , iby_ext_party_pmt_mthds     ppm
WHERE sup.end_date_active IS NULL
   AND ppm.inactive_date   IS NULL
   AND sup.vendor_id = ss.vendor_id
   AND ss.vendor_site_id = epa.supplier_site_id
   AND epa.inactive_date  IS NULL
   AND epa.ext_payee_id  = ppm.ext_pmt_party_id
   AND ss.inactive_date   IS NULL;