List of Item Classes

SELECT
o100632.i102368 item_class_name,
o100632.i102366 || ' . ' || o100632.i102064 primary_folder,
o100632.i102364 || ' . ' || o100632.i101789 used_by,
nvl(o100632.i102356 || '.' || o100632.i101793, ' ') alternate_sort
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 = 100032 or lower(o100577.ba_name) like lower('HRMS - Administration - Compensation and Benefits (Core)') ))
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 o100634.i101787 AS i101789,
o100626.i101781 AS i101793,
decode(SUBSTR((o100634.i101949), 1, 19), 'AUTO_GENERATED_NAME', 'Yes', 'No') AS
i101953,
o100634.i102044 AS i102046,
o100633.i101785 AS i102064,
o100626.i102350 AS i102356,
o100634.i102360 AS i102364,
o100633.i102358 AS i102366,
decode(SUBSTR((o100634.i101949), 1, 19), 'AUTO_GENERATED_NAME', (o100633.i102358) || '.' ||(o100633.i101785), (o100634.i101949)) AS
i102368
FROM
(SELECT o100607.obj_name AS i102350,
(EUL5_get_autogen_item_name(o100592.exp_id)) AS
i101781,
o100589.dom_id AS i101907
FROM EUL5_domains o100589,
EUL5_expressions o100592,
EUL5_objs o100607
WHERE(o100592.exp_id = o100589.dom_it_id_rank)
AND(o100607.obj_id = o100592.it_obj_id))
o100626,
(SELECT o100607.obj_name AS i102358,
(EUL5_get_autogen_item_name(o100592.exp_id)) AS
i101785,
o100589.dom_id AS i101909
FROM EUL5_domains o100589,
EUL5_expressions o100592,
EUL5_objs o100607
WHERE(o100592.exp_id = o100589.dom_it_id_lov)
AND(o100607.obj_id = o100592.it_obj_id))
o100633,
(SELECT o100607.obj_name AS i102360,
(EUL5_get_autogen_item_name(o100592.exp_id)) AS
i101787,
o100589.dom_name AS i101949,
o100592.exp_id AS i102044,
o100589.dom_id AS i101911
FROM EUL5_domains o100589,
EUL5_expressions o100592,
EUL5_objs o100607
WHERE(o100589.dom_id = o100592.it_dom_id)
AND(o100607.obj_id = o100592.it_obj_id))
o100634
WHERE(o100626.i101907(+) = o100634.i101911)
AND(o100633.i101909(+) = o100634.i101911))
o100632
WHERE((o100627.i102327 = o100630.i102116)
AND(o100630.i102222 = o100632.i102046))
ORDER BY o100632.i102368 ASC,
o100632.i101953 ASC,
o100632.i102366 || ' . ' || o100632.i102064 ASC,
nvl(o100632.i102356 || '.' || o100632.i101793, ' ') ASC,
o100632.i102364 || ' . ' || o100632.i101789 ASC