[Home] [Help]
View: WF_USER_ROLE_ASSIGNMENTS_V
View Text
SELECT
WURA.USER_NAME
,
WURA.ROLE_NAME
,
WURA.ASSIGNING_ROLE
,
WURA.START_DATE
,
WURA.END_DATE
,
WURA.ROLE_ORIG_SYSTEM_ID
,
DECODE(WURA.RELATIONSHIP_ID
, -1
, 'DIRECT'
, 'INHERITED') RELATIONSHIP_ID
,
WURA.ASSIGNMENT_REASON
,
WURA.CREATION_DATE
,
WURA.CREATED_BY
,
WURA.LAST_UPDATE_DATE
,
WURA.LAST_UPDATED_BY
,
WURA.LAST_UPDATE_LOGIN
,
WURA.PARTITION_ID
,
WURA.ROLE_ORIG_SYSTEM
FROM WF_USER_ROLE_ASSIGNMENTS WURA
WHERE WURA.EFFECTIVE_START_DATE <= ( TRUNC(SYSDATE + 1) - .000011574 ) --THIS IS A NOT-NULL COLUMN
AND (WURA.EFFECTIVE_END_DATE IS NULL OR
WURA.EFFECTIVE_END_DATE > ( TRUNC(SYSDATE) - .000011574 ))