GL Chart of Accounts - Rollup Range Listing

Description

Imported from BI Publisher
Description: Reports on parent/child rollups by range
Application: General Ledger
Source: Chart of Accounts - Rollup Range Listing (XML)
Short Name: GLXRLRUR_XML
DB package: GL_GLXRLRUR_XMLP_PKG

GL Chart of Accounts - Rollup Range Listing and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

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