637: usg.usage
638: FROM jtf_rs_group_members gm
639: ,jtf_rs_role_relations rrl
640: ,jtf_rs_roles_b rol
641: ,jtf_rs_resource_extns_vl res
642: ,jtf_rs_group_usages usg
643: WHERE gm.delete_flag = 'N'
644: AND gm.group_member_id = rrl.role_resource_id
645: AND rrl.role_resource_type = 'RS_GROUP_MEMBER'