R13-SQL Supplier information

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 **** ,