FND Flex Hierarchies (Rollup Groups)

Description
Categories: Enginatics
Repository: Github
Flex value sets with rollup groups
Run FND Flex Hierarchies (Rollup Groups) and other Oracle EBS reports with Blitz Report™ on our demo environment
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