Payment Method table in oracle apps r12

Payment Method table in oracle apps r12

In this post , We will discuss about Payment Method table in oracle apps r12. Payment Method in Oracle apps is used to make the payment for the supplier in oracle apps. Payment method is specifies , the payment for the supplier will be done through Check or through EFT. Here below I will share the Payment Method table in oracle apps r12 and the SQL query to extract the Payment Method of supplier in oracle apps.

 

 

2 Important Payment Method table in oracle apps r12

1.IBY_EXT_PARTY_PMT_MTHDS

 

 

 

SQL query to extract the Payment Method of supplier in oracle apps

SELECT
sup.vendor_name
     , sup.segment1 vendor_number
     , sup.party_id
     , epa.payee_party_id
     , epa.supplier_site_id
     , ss.vendor_site_code
     , ppm.payment_method_code
     , 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.vendor_id = ss.vendor_id
   AND ss.vendor_site_id = epa.supplier_site_id --epa.payee_party_id
   AND epa.ext_payee_id  = ppm.ext_pmt_party_id
   AND ss.inactive_date    IS NULL
   AND sup.end_date_active IS NULL
   AND ppm.inactive_date   IS NULL
   AND epa.inactive_date   IS NULL