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 |
|
LOV |