Discoverer Hierarchies

SELECT
o100631.i102167 hierarchy_name,
o100631.i102174 created_by,
o100631.i102376 hierarchy_level,
o100631.i102312 hierarchy_details
FROM
(SELECT o100577.ba_name AS i101816,
o100607.obj_id AS i102327
FROM EUL5_bas o100577,
EUL5_objs o100607,
EUL5_ba_obj_links o100582
WHERE(o100577.ba_id = o100582.bol_ba_id)
AND(o100607.obj_id = o100582.bol_obj_id)
and ( o100577.ba_id = 100018 or lower(o100577.ba_name) like lower('ABM Activities') ))
o100627,
(SELECT o100607.obj_id AS i102116,
o100592.exp_id AS i102222
FROM EUL5_expressions o100592,
EUL5_objs o100607
WHERE(o100607.obj_id = o100592.it_obj_id))
o100630,
(SELECT o100603.hil_exp_id AS i102139,
(decode(SUBSTR(o100600.hi_name, 1, 19), 'AUTO_GENERATED_NAME', (EUL5_get_foldername((decode(o100600.ibh_dbh_id, NULL, to_number(NULL), EUL5_get_hier_expid(o100600.hi_name))))) || '.' ||(EUL5_get_autogen_item_name((decode(o100600.ibh_dbh_id, NULL, to_number(NULL), EUL5_get_hier_expid(o100600.hi_name))))) || ' : ' ||(decode(o100600.ibh_dbh_id, NULL, NULL, EUL5_get_datehier_tmplt_name(o100600.ibh_dbh_id))), o100600.hi_name)) AS
i102167,
decode((o100600.hi_sys_generated), 1, 'System', 'User') AS
i102174,
lpad('^------', 12 *((EUL5_get_hierlvl((o100600.hi_id), (o100601.hn_id))) -1)) ||(decode(SUBSTR((o100601.hn_name), 1, 19), 'AUTO_GENERATED_NAME', ((EUL5_get_foldername(EUL5_get_hiernode_expid(o100601.hn_id))) || '.' ||(EUL5_get_autogen_item_name(EUL5_get_hiernode_expid(o100601.hn_id)))), (o100601.hn_name))) AS
i102312,
EUL5_get_hierord((o100600.hi_id), (o100603.hil_hn_id)) AS
i102376
FROM EUL5_hierarchies o100600,
EUL5_hi_nodes o100601,
EUL5_ig_exp_links o100603
WHERE(o100600.hi_id = o100601.hn_hi_id)
AND(o100601.hn_id = o100603.hil_hn_id))
o100631
WHERE((o100627.i102327 = o100630.i102116)
AND(o100630.i102222 = o100631.i102139))
ORDER BY o100631.i102167 ASC,
o100631.i102376 ASC