136: )
137: )
138: ) name
139: FROM Jtf_rs_groups_denorm grpd
140: , Jtf_rs_groups_tl grptl
141: , (SELECT DISTINCT grpb.group_id
142: , rrb2.manager_flag
143: FROM Jtf_rs_groups_b grpb
144: , Jtf_rs_role_relations rrel2