ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A8228D159BFB3BA0E053B46B63584E0C 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 Y US MSC Sourcing Rules (Plan Side) BR100 source rules setup for the plan based assignment set rules 1=1 1 10 1=1 mas.assignment_set_name=:assignment_set LOV custom select ASSIGNMENT_SET_NAME value, description from MSC_ASSIGNMENT_SETS mas where 1=1 US Assignment Set