FND Flex Hierarchies (Rollup Groups)

Description
Categories: Enginatics
Repository: Github Columns: Flex Value Set Name, Hierarchy Code, Hierarchy Name, Description, Created By, Creation Date, Last Updated By, Last Update Date, Flex Value Set Id ...
Flex value sets with rollup groups
select
ffvs.flex_value_set_name,
ffhv.hierarchy_code,
ffhv.hierarchy_name,
ffhv.description,
xxen_util.user_name(ffhv.created_by) created_by,
ffhv.creation_date,
xxen_util.user_name(ffhv.last_updated_by) last_updated_by,
ffhv.last_update_date,
ffvs.flex_value_set_id
from
fnd_flex_value_sets ffvs,
fnd_flex_hierarchies_vl ffhv
where
ffvs.flex_value_set_id=ffhv.flex_value_set_id
order by
ffvs.flex_value_set_name,
ffhv.hierarchy_code