[Home] [Help]
View: WF_ALL_USER_ROLE_ASSIGNMENTS
View Text
SELECT USER_NAME
, ROLE_NAME
,
ASSIGNING_ROLE
, START_DATE
, END_DATE
, DECODE(RELATIONSHIP_ID
, -1
,
'DIRECT'
, 'INHERITED')
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
,
LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ASSIGNMENT_REASON
FROM WF_USER_ROLE_ASSIGNMENTS