ORACLE MASTERMINDS

Query to get Supplier Details, payment term and payment methods in R12

Introduction

This Post is about to get the details of External party payees, payment term and payment method in oracle EBS R12

SELECT

 AP_SUP.SEGMENT1 SUPPLIER_NUMBER

,AP_SUP.VENDOR_NAME SUPPLIER_NAME

,SUP_SITES.VENDOR_SITE_CODE  SUPPLIER_SITE

,(select APT.NAME from apps.AP_TERMS_TL APT where apt.term_id=SUP_SITES.TERMS_ID and language='US') payment_term

,PAY_METHOD.payment_method_code

,PAY_METHOD.last_update_date

,IBY_PAYEES.REMIT_ADVICE_EMAIL

from apps.ap_suppliers AP_SUP

,apps.ap_supplier_sites_all SUP_SITES

--,apps.AP_TERMS_TL APT

,apps.iby_external_payees_all IBY_PAYEES

,apps.IBY_EXT_PARTY_PMT_MTHDS PAY_METHOD

where AP_SUP.VENDOR_ID=SUP_SITES.VENDOR_ID

AND AP_SUP.PARTY_ID=IBY_PAYEES.PAYEE_PARTY_ID

and SUP_SITES.VENDOR_SITE_ID=IBY_PAYEES.SUPPLIER_SITE_ID

AND IBY_PAYEES.EXT_PAYEE_ID=PAY_METHOD.EXT_PMT_PARTY_ID  

AND PAY_METHOD.payment_method_code like 'CHECK'

AND SUP_SITES.org_id=:P_ORG_ID

AND IBY_PAYEES.org_id=SUP_SITES.org_id

ORDER BY 1

Summary

This Post described the script to of External party payees, payment term and payment method Oracle EBS R12.

Got any queries?

Do drop a note by writing us at contact@doyensys.com or use the comment section below to ask your questions.

By Dileep Singh