FND Flex Hierarchies (Rollup Groups)

➜ Back to Library
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
Download
Related Blitz Reports
FND Flex Values FND Concurrent Programs and Executables INV Item cross-references listing INV Item categories FND Key Flexfields FND Flex Value Sets, Usages and Values FND Flex Value Hierarchy FND Descriptive Flexfields PO Approval Groups
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: