MSC Sourcing Rules (Plan Side)

Description
BR100 source rules setup for the plan based assignment set rules
Run MSC Sourcing Rules (Plan Side) and other Oracle EBS reports with Blitz Report™ on our demo environment
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