Query to get Supplier Payment method in Oracle apps

Query to get Supplier Payment method in Oracle apps

Hi friends, we are going to discuss about the Query to get Supplier Payment method in Oracle apps. We will share the detail sql query which helps to extract the complete oracle apps supplier details with supplier payment method details. Supplier payment method helps to process the oracle payments. Using supplier payment method, we do differentiate the oracle payments. It helps to mentioning the type of payment. Most common payment methods in oracle apps is EFT , Check. We will also share the oracle apps tables which helps to store the supplier payment method details in oracle apps. This is one of the important query about supplier information maintenance. In oracle apps , supplier method details stores in the IBY tables. Please find below the complete detail about Query to get Supplier Payment method in Oracle apps.

Query to get Supplier Payment method in Oracle apps

2 Important Table about Supplier Payment method in Oracle apps

1. IBY_EXT_PARTY_PMT_MTHDS

2. IBY_EXTERNAL_PAYEES_ALL

Detail SQL Query to get the Supplier Payment method in Oracle apps

Here below is the detail sql query which helps to extract the complete supplier details and the supplier payment method informations in oracle apps.

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

Query to get Supplier Payment method in Oracle apps