Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Need help with a query to extract data for supplier — Cloud Customer Connect
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

Received Response
15
Views
5
Comments
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!