Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Need help with a query to extract data for supplier

edited Jan 15, 2020 4:00PM in Supplier Management 5 comments

Summary

Need help with a query to extract data for supplier, though query is generating output but few rows has missing data for sites and few sites are duplicating

Content

Need help with a query to extract data for supplier, though query is generating output but few rows has missing data for sites and few sites are duplicating.Can you please suggest what I am doing incorrect.

Select SV.VENDOR_NAME

,SV.VENDOR_ID

,SV.SEGMENT1

,SV.VENDOR_NAME_ALT

,SV.BUSINESS_RELATIONSHIP

,SV.ORGANIZATION_TYPE_LOOKUP_CODE

,SV.CREATION_DATE

,SV.LAST_UPDATE_DATE

,SV.LAST_UPDATED_BY

,SV.VENDOR_TYPE_LOOKUP_CODE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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