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 |