Use this EBS R12 query for the following requirements:
– Find all supplier sites and contact details for for vendors.
– Extract all site details for fusion data migration purpose.
SELECT DISTINCT ven.vendor_id,
ven.vendor_name "Supplier Name",
st.vendor_site_code "Address Name",
st.vendor_site_code "Address New Name",
st.country "Country",
st.address_line1 "Address Line 1",
st.address_line2 "Address Line 2",
st.address_line3 "Address Line 3",
st.address_line4 "Address Line 4",
st.city "City",
st.state "State",
st.zip "Postal Code",
st.area_code "Phone Country Code",
st.area_code "Phone Area Code",
st.phone "Phone",
st.rfq_only_site_flag
FROM AP_SUPPLIER_SITES_ALL ST, AP_SUPPLIERS VEN
WHERE 1 = 1
and st.vendor_id = ven.vendor_id
and (VEN.vendor_type_lookup_code <> 'EMPLOYEE' or VEN.vendor_type_lookup_code is null)
AND VEN.end_date_active IS NULL
ORDER BY ven.vendor_name
Leave a Reply