FND Rollup Groups

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

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