Supplier Management

Get Involved. Join the Conversation.

Topic

    MerriH
    Supplier Site Report
    Topic posted September 2, 2019 by MerriHRed Ribbon: 250+ Points, tagged Audit, Financials, Fusion, How-To, Supplier Communication 
    44 Views, 3 Comments
    Title:
    Supplier Site Report
    Summary:
    Is there a report/query available for Supplier Sites
    Content:

    Customer has a number of suppliers sites with the communication method set to None.  They would like to report on supplier sites with communication method set to NONE so that they can update the method to email.  

    Is this available?

    Version:
    19B (11.13.19.04.0

    Comment

     

    • Karthikeyan Sukumar

      Hi Merri- 

      Below is the seeded report to extract Supplier sites

       

      Thanks!

      Karthik

    • Ramesh Bomma

      Hi Merri,
      All the Reports needs to be Created in BI
      There is a Suppliers - Supplier Real Time using this you can modify based on your requirements

      Below is the adhoc query i have for getting the details
      select b.vendor_name,a.vendor_site_code,a.supplier_notif_method,b.vendor_type_lookup_code from fusion.poz_supplier_sites_all_m a , fusion.poz_suppliers_v b
      where a.vendor_id=b.vendor_id;

      Thanks,
      Ramesh