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
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
|
|
|