[Home] [Help]
View: WF_ENG_LIST_UR
Product: | FND - Application Object Library |
Description: | Bulk Sync Directory Service User Role View for Role Orig System ENG_LIST |
Implementation/DBA Data: |
APPS.WF_ENG_LIST_UR
|
View Text
SELECT USR.USER_NAME
, 'PER'
, PER.PERSON_ID
, 'ENG_LIST'||':'||EEAL.APPROVAL_LIST_ID
, 'ENG_LIST'
, EEAL.APPROVAL_LIST_ID
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 7
FROM FND_USER USR
, PER_ALL_PEOPLE_F PER
, ENG_ECN_APPROVAL_LISTS EEAL
, ENG_ECN_APPROVERS EEA
WHERE EEA.EMPLOYEE_ID = PER.PERSON_ID
AND PER.PERSON_ID = USR.EMPLOYEE_ID
AND EEA.APPROVAL_LIST_ID = EEAL.APPROVAL_LIST_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN USR.START_DATE
AND NVL(USR.END_DATE
, SYSDATE+1)
AND TRUNC(SYSDATE) <= NVL(EEA.DISABLE_DATE
, SYSDATE+1)
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 |