Data mismatch between ERP system sourcing rules data and data in back end table (msc_sr_assignments)

Summary:

Data mismatch between ERP system sourcing rules data and data in back end table (msc_sr_assignments)

Content (please ensure you mask any confidential information):

The ship to site number is not matching with the assigned rule name/organization. In the front end, global order promising module has different data but in the back end table the data is different.

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

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

SELECT mas.assignment_set_name                                                                                                                                                                                                                                                                                ,

    msr.SOURCING_RULE_TYPE                                                                                                                                                                                                                                                                                 ,

    msr.ORGANIZATION_ID                                                                                                                                                                                                                                                                                  ,

    DECODE (msa.assignment_type, '4','Organization' ,'5','Category and Organization','6','Item and Organization' ,'10','Global','12','Item' ,'11','Category' ,'13','Region' ,'14','Category and Region' ,'15','Item and Region' ,'16','Demand Class' ,'17','Customer' ,'18','Customer and Customer Site' ,'19','Category and Demand Class' ,'20','Category and Customer' ,'21','Category and Customer and Customer Site' ,'22','Item and Demand Class' ,'23','Item and Customer' ,'24','Item and Customer and Customer Site','25','Item and Customer and Customer Site' ) "assignment_type",