MSC Sourcing Rules (Plan Side)

Description
Categories: Toolkit - Setup & Support
Columns: Assigned To, Assignment Set Name, Description, Org Code, Customer Name, Ship To Address, Entity Name, Type, Rule, Region Code ...
BR100 source rules setup for the plan based assignment set rules
select
decode(msra.assignment_type,1,'instance' ,2, 'category',3,'item-instance', 4,'instance-organization',5,'category-instance-organization',6,'item-instance-organization', 7,'instance-region' ,8, 'category-instance-region' ,9,'item-instance-region', 'other') assigned_to,
mas.assignment_set_name,
mas.description,
msra.organization_code,
msra.customer_name,
msra.ship_to_address,
msra.entity_name,
msra.description,
msra.sourcing_rule_type_text type,
msra.sourcing_rule_name rule,
msra.region_code
from apps.msc_assignment_sets mas,apps.msc_sr_assignments_v  msra
where 1=1
--mas.assignment_set_name like '%rfg '
and msra.assignment_set_id = mas.assignment_set_id
--and          sourcing_rule_name='sc-sse-edc'
--and region_code like 'se%'
--and region_code in ('gauteng zone','durban zone','cape town zone')
--and assignment_type =8
--and msra.sourcing_rule_name='sc-edc'
--and category_name = 'scm-config-sw'
order by 2
Parameter Name SQL text Validation
Assignment Set
mas.assignment_set_name=:assignment_set
LOV