Introduction:
This report will showing all Oracle US and Canada suppliers with payment type of XXX
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 ‘:Payment_Method_code%’
AND SUP_SITES.org_id=:ORG_ID
AND IBY_PAYEES.org_id=SUP_SITES.org_id
ORDER BY 1
Summary:
This report will showing all Oracle US and Canada suppliers with payment type of XXX
Know more about post.
Doyen.ebiz@gmail.com
