VIEW: APPS.WF_USER_ROLES

Source

View Text - Preformatted

select
  WUR.USER_NAME,
  WUR.ROLE_NAME,
  WUR.USER_ORIG_SYSTEM,
  WUR.USER_ORIG_SYSTEM_ID,
  WUR.ROLE_ORIG_SYSTEM,
  WUR.ROLE_ORIG_SYSTEM_ID,
  WUR.START_DATE,
  WUR.EXPIRATION_DATE,
  WUR.ASSIGNMENT_TYPE,
  WUR.PARENT_ORIG_SYSTEM,
  WUR.PARENT_ORIG_SYSTEM_ID,
  WUR.PARTITION_ID,
  WUR.ASSIGNMENT_REASON
  from wf_local_user_roles wur
  where ((wur.effective_start_date is null
  and (wur.start_date is NULL or
       trunc(sysdate) >= trunc(wur.start_date))
  and  (wur.user_start_date is NULL or
       trunc(sysdate) >= trunc(wur.user_start_date))
  and  (wur.role_start_date is NULL or
       trunc(sysdate) >= trunc(wur.role_start_date)))
  or  trunc(sysdate)>=trunc(wur.effective_start_date))
  and ((wur.effective_end_date is null
  and (wur.expiration_date is NULL or
       trunc(sysdate) < trunc(wur.expiration_date))
  and  (wur.user_end_date is NULL or
       trunc(sysdate) < trunc(wur.user_end_date))
  and  (wur.role_end_date is NULL or
       trunc(sysdate) < trunc(wur.role_end_date)))
  or  trunc(sysdate) < trunc(wur.effective_end_date))

   

View Text - HTML Formatted

SELECT WUR.USER_NAME
, WUR.ROLE_NAME
, WUR.USER_ORIG_SYSTEM
, WUR.USER_ORIG_SYSTEM_ID
, WUR.ROLE_ORIG_SYSTEM
, WUR.ROLE_ORIG_SYSTEM_ID
, WUR.START_DATE
, WUR.EXPIRATION_DATE
, WUR.ASSIGNMENT_TYPE
, WUR.PARENT_ORIG_SYSTEM
, WUR.PARENT_ORIG_SYSTEM_ID
, WUR.PARTITION_ID
, WUR.ASSIGNMENT_REASON
FROM WF_LOCAL_USER_ROLES WUR
WHERE ((WUR.EFFECTIVE_START_DATE IS NULL
AND (WUR.START_DATE IS NULL OR TRUNC(SYSDATE) >= TRUNC(WUR.START_DATE))
AND (WUR.USER_START_DATE IS NULL OR TRUNC(SYSDATE) >= TRUNC(WUR.USER_START_DATE))
AND (WUR.ROLE_START_DATE IS NULL OR TRUNC(SYSDATE) >= TRUNC(WUR.ROLE_START_DATE))) OR TRUNC(SYSDATE)>=TRUNC(WUR.EFFECTIVE_START_DATE))
AND ((WUR.EFFECTIVE_END_DATE IS NULL
AND (WUR.EXPIRATION_DATE IS NULL OR TRUNC(SYSDATE) < TRUNC(WUR.EXPIRATION_DATE))
AND (WUR.USER_END_DATE IS NULL OR TRUNC(SYSDATE) < TRUNC(WUR.USER_END_DATE))
AND (WUR.ROLE_END_DATE IS NULL OR TRUNC(SYSDATE) < TRUNC(WUR.ROLE_END_DATE))) OR TRUNC(SYSDATE) < TRUNC(WUR.EFFECTIVE_END_DATE))