VIEW: APPS.WF_ENG_LIST_UR

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)