We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

R13-SQL Supplier information

Accepted answer
16
Views
3
Comments
edited May 26, 2021 11:37PM in Payables, Payments & Cash Management 3 comments

Summary

R13-SQL Supplier information

Content

Hello :

I was wondering if you can share with me any SQL to get the Supplier information. I have the following one but it is for Oracle EBS R12.

Best Regards

SELECT
asp.vendor_id ,
asp.segment1 "Supplier Num" ,
asp.vendor_name "Supplier Name" ,
****.vendor_site_code "site name" ,
hou.name "Operating Unit Name" ,
****.address_line1 ,
****.city ,
****.state ,
****.zip ,
****.country ,
****.phone ,
person.person_first_name ,
person.person_last_name ,
pty_rel.primary_phone_number ,
pty_rel.email_address
FROM
ap_suppliers asp ,
ap_supplier_sites_all **** ,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!