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