GL Chart of Accounts - Rollup Range Listing

select 
  ffv.flex_value  PARENT_VALUE,
  ffvt.description  PARENT_DESCRIPTION,
  ffh.hierarchy_name  ROLLUP_GROUP, 
  ffv.start_date_active  START_DATE,
  ffv.end_date_active  END_DATE,
  fl.meaning  ENABLED,
  ffvh.child_flex_value_low  CHILD_LOW,
  ffvh.child_flex_value_high  CHILD_HIGH
from
  fnd_lookups fl,
  fnd_flex_hierarchies_tl ffh,
  fnd_flex_value_hierarchies ffvh,
  fnd_flex_values_tl ffvt,
  fnd_flex_values ffv,
  fnd_id_flex_segments fifs
where
   ffh.flex_value_set_id (+) = 
     ffv.flex_value_set_id
   and ffh.hierarchy_id (+) = 
     ffv.structured_hierarchy_level
   and ffh.language (+) = userenv('LANG')
   and ffvh.flex_value_set_id = 
     ffv.flex_value_set_id
   and ffvh.parent_flex_value = 
     ffv.flex_value
   and ffvt.flex_value_id = ffv.flex_value_id + 0 
   and ffvt.language = userenv('LANG')
   and ffv.flex_value_set_id = 
     fifs.flex_value_set_id
   and fifs.application_id = 101
   and fifs.id_flex_code = 'GL#'
   and fifs.id_flex_num = :P_STRUCT_NUM
   and fifs.segment_name = :P_SEGMENT_NAME
   and fl.lookup_type = 'YES_NO'
   and fl.lookup_code = ffv.enabled_flag
order by 
  ffv.flex_value,
  ffvh.child_flex_value_low,
  ffvh.child_flex_value_high