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