Oracle apps technical tutorial

SQL Query to get Payment Method for Supplier and Supplier Site in Oracle apps

SQL Query to get Payment Method for Supplier and Supplier Site in Oracle apps

Query to get Payment Method for Supplier and supplier sites
This information is IBY_EXT_PARTY_PMT_MTHDS table which joins to IBY_EXTERNAL_PAYEES_ALL.

Below query will give you data of default payment method at site level.

SELECT 
  APS.VENDOR_NAME
 ,APS.VENDOR_TYPE_LOOKUP_CODE
 ,APSSA.VENDOR_SITE_CODE
 ,APSSA.ORG_ID
 ,IEPPM.PAYMENT_METHOD_CODE "PAYMENT METHOD"

 FROM 
  AP_SUPPLIERS APS
 ,AP_SUPPLIER_SITES_ALL APSSA
 ,IBY_EXTERNAL_PAYEES_ALL IEPA
 ,IBY_EXT_PARTY_PMT_MTHDS IEPPM
 
 WHERE 1 = 1
 AND APS.VENDOR_ID = APSSA.VENDOR_ID
 AND APS.PARTY_ID = IEPA.PAYEE_PARTY_ID
 AND IEPA.EXT_PAYEE_ID = IEPPM.EXT_PMT_PARTY_ID
 AND IEPA.SUPPLIER_SITE_ID = APSSA.VENDOR_SITE_ID
 AND IEPPM.PRIMARY_FLAG = 'Y'
 AND APS.VENDOR_NAME = :Vendor_NAME

I hope the query will be useful for you, if any suggestion please write in comment box.

https://techpursue.com/sql-query-to-get-invoice-approval-status-and-posting-status/

Leave a Reply