[Home] [Help]
View: WF_FND_USR_UR
Product: | FND - Application Object Library |
Description: | |
Implementation/DBA Data: |
APPS.WF_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
Columns
Name |
USER_NAME |
USER_ORIG_SYSTEM |
USER_ORIG_SYSTEM_ID |
ROLE_NAME |
ROLE_ORIG_SYSTEM |
ROLE_ORIG_SYSTEM_ID |
START_DATE |
EXPIRATION_DATE |
SECURITY_GROUP_ID |
PARTITION_ID |