View: FND_USR_UR

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

View Text

( SELECT USR.USER_NAME
, 'PER'
, PER.ORIG_SYSTEM_ID
, USR.USER_NAME
, 'PER'
, PER.ORIG_SYSTEM_ID
, USR.START_DATE
, USR.END_DATE
, NULL
, 1
FROM FND_USER USR
, WF_LOCAL_ROLES PARTITION (PER_ROLE) PER
WHERE USR.EMPLOYEE_ID = PER.ORIG_SYSTEM_ID
AND TRUNC(SYSDATE) BETWEEN NVL(PER.START_DATE
, TRUNC(SYSDATE))
AND NVL(PER.EXPIRATION_DATE
, TRUNC(SYSDATE+1)) UNION ALL SELECT USR.USER_NAME
, 'FND_USR'
, USR.USER_ID
, USR.USER_NAME
, 'FND_USR'
, USR.USER_ID
, USR.START_DATE
, USR.END_DATE
, NULL
, 1
FROM FND_USER USR
WHERE USR.EMPLOYEE_ID IS NULL)