The following query can be used:
SELECT
DISTINCT(g.group_code)
FROM
CMN_SEC_GROUPS_V gv
JOIN cmn_sec_group_hierarchies gh ON gh.group_id = gv.id
JOIN cmn_sec_groups g ON g.id = gh.parent_group_id
WHERE
gv.language_code = 'en'
AND lower(gv.group_code) LIKE '%idea%'
In this example, a list of all groups with 'idea' related global access rights in them is being determined.