Query to find Supplier details in R12

Tables Involved:

AP_SUPPLIERS

AP_SUPPLIER_SITES_ALL

AP_SUPPLIER_CONTACTS

HZ_PARTIES

HR_OPERATING_UNITS

Query:

SELECT abc.vendor_id,

abc.segment1 "Supplier No.",

abc.vendor_name "Supplier Name",

xyz.vendor_site_code "Site",

hou.name "Operating Unit",

xyz.address_line1,

xyz.city,

xyz.state,

xyz.zip,

xyz.country,

xyz.phone,

person.person_first_name,

person.person_last_name,

pty_rel.primary_phone_number,

pty_rel.email_address

FROM ap_suppliers abc,

ap_supplier_sites_all xyz,

ap_supplier_contacts fd,

hz_parties person,

hz_parties pty_rel,

hr_operating_units hou

WHERE xyz.vendor_id = abc.vendor_id

AND fd.per_party_id = person.party_id

AND fd.rel_party_id = pty_rel.party_id

AND xyz.org_id = hou.organization_id

AND fd.org_party_site_id = xyz.party_site_id

AND abc.vendor_name = '&supplier_name';

Note:

The query will yield information only about the suppliers which don’t have special characters in their name.

---X---