List of all active workflow users and their roles

select  wu.name user_name,

        wr.name role_name

from    wf_users wu,

        wf_user_roles wur,

        wf_roles wr

where   wu.name = wur.user_name

and     wur.role_name = wr.name

and     wu.status = 'ACTIVE'

and     wr.status = 'ACTIVE'

and     wr.orig_system = 'WF_LOCAL_ROLES'

order by wu.name,

        wr.name