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

Query For getting Sourcing Rule Information

in Order Management 1 comment

Summary:

I am Trying to Get Customer Site and Customer Information Related to Sourcing rule.

On going through Documentation I have found MSC_CUSTOMER_SITES and MSC_CUSTOMERS  these two tables But I dont seem to find the joins with the  MSC_SOURCING_RULES. Kindly Help us out with Joins or leads to get Customer and Customer SITE information for the Sourcing rule

Content (please ensure you mask any confidential information):

I also Tried Using  ship_to_site_id from table MSC_SR_ASSIGNMENTS but data is mismatching.

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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