Query to get GL Account Hierarchy Query in fusion

Below is the query used in the fusion to know about the GL account Hierarchy

Common tables unsed int eh GL Hierarchy 

1.

SELECT DISTINCT segment_name,
                application_column_name
FROM   fnd_flex_values_vl f,
       fnd_id_flex_segments fifs
WHERE  f.flex_value_set_id IN (SELECT flex_value_set_id
                               FROM   fnd_id_flex_segments
                               WHERE  application_id = 101
                                      AND id_flex_code = 'GL#'
                                      AND enabled_flag = 'Y'
                                      AND application_column_name IN (
                                          'SEGMENT1', 'SEGMENT2', 'SEGMENT3',
                                          'SEGMENT4',
                                          'SEGMENT5', 'SEGMENT6', 'SEGMENT7' )
                              ---Account Segment
                              )
       AND fifs.flex_value_set_id = f.flex_value_set_id
--         AND flex_value = 21801