ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3F9BD79CA0B8B8C5E0630100007F0A54 FND Rollup Group Y select ffhv.hierarchy_id id, ffhv.hierarchy_name value, ffvs.flex_value_set_name||': '||ffhv.description description from fnd_flex_value_sets ffvs, fnd_flex_hierarchies_vl ffhv where (:$flex$.Flex_Value_Set is null or xxen_util.contains(:$flex$.Flex_Value_Set,ffvs.flex_value_set_name)='Y') and ffvs.flex_value_set_id=ffhv.flex_value_set_id order by ffhv.hierarchy_name US 12B51E4AE6AFAFB5E0630100007F9787 select ffvs.flex_value_set_name, ffhv.hierarchy_code, ffhv.hierarchy_name, ffhv.description, xxen_util.zero_to_null((select count(*) from fnd_flex_values ffv where ffhv.hierarchy_id=ffv.structured_hierarchy_level)) usage_count, xxen_util.user_name(ffhv.created_by) created_by, xxen_util.client_time(ffhv.creation_date) creation_date, xxen_util.user_name(ffhv.last_updated_by) last_updated_by, xxen_util.client_time(ffhv.last_update_date) last_update_date, ffhv.hierarchy_id from fnd_flex_value_sets ffvs, fnd_flex_hierarchies_vl ffhv where 1=1 and ffvs.flex_value_set_id=ffhv.flex_value_set_id order by ffvs.flex_value_set_name, ffhv.hierarchy_name Y US FND Rollup Groups Flex value sets with rollup groups (FND Flex Hierarchies) Enginatics 1=1 1 10 1=1 ffvs.flex_value_set_name=:flex_value_set_name LOV custom Y select ffvs.flex_value_set_name value, decode(ffvs.validation_type, 'D','Dependent', 'I','Independent', 'N','None', 'P','Pair', 'U','Special', 'F','Table', 'X','Translatable Independent', 'Y','Translatable Dependent' )||': '||ffvs.description description from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name not like '$FLEX$.%' and ffvs.flex_value_set_id in (select ffhv.flex_value_set_id from fnd_flex_hierarchies_vl ffhv) order by ffvs.flex_value_set_name US Flex Value Set 2 20 1=1 ffhv.hierarchy_id=:rollup_group_id LOV FND Rollup Group 3F9BD79CA0B8B8C5E0630100007F0A54 Y select ffhv.hierarchy_id id, ffhv.hierarchy_name value, ffvs.flex_value_set_name||': '||ffhv.description description from fnd_flex_value_sets ffvs, fnd_flex_hierarchies_vl ffhv where (:$flex$.Flex_Value_Set is null or xxen_util.contains(:$flex$.Flex_Value_Set,ffvs.flex_value_set_name)='Y') and ffvs.flex_value_set_id=ffhv.flex_value_set_id order by ffhv.hierarchy_name US Rollup Group :$flex$.Flex_Value_Set Flex Value Set Rollup Group