View: WF_USER_ROLES

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.WF_USER_ROLES

View Text

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

Columns