Form Personalisation to restrict Value sets
Hello there,
We have a requirement to only give access to PO Item Category segment value sets 'MHP_PO_CATEGORY_PARENT','MHP_PO_CATEGORY_CHILD' for Purchasing users.
I have done the following form Personalisation.
Action Type: Builtin
Builtin Type: Create Record Group from Query
Argument:
select v.validation_type, v.flex_value_set_name,
l.meaning, v.parent_flex_value_set_id, v.flex_value_set_id
from fnd_flex_value_sets v,
fnd_lookups l,
fnd_flex_validation_tables t
where v.flex_value_set_id = t.flex_value_set_id
and ((v.validation_type in ('D','I','X','Y')) or