GL Rollup Groups

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Flex value sets with rollup groups (FND Flex Hierarchies)

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
ffvs.flex_value_set_name,
ffhv.hierarchy_code,
ffhv.hierarchy_name,
ffhv.description,
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,
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_name
Download
   
Related Blitz Reports
FND Flex Hierarchies (Rollup Groups) FND Flex Value Hierarchy FND Flex Values AR Customers and Sites FND Concurrent Programs and Executables COPY OF: INV Material Account Distribution Detail from Eng AR Aging FA Asset Retirements FND Flex Value Sets, Usages and Values
Blitz Report™

Blitz Report™ provides multiple benefits: