VIEW: APPS.ENG_ECN_APPROVERS_V

Source

View Text - Preformatted

SELECT E.ROWID , P1.FULL_NAME , EEAL.APPROVAL_LIST_NAME , E.APPROVAL_LIST_ID , E.EMPLOYEE_ID , E.LAST_UPDATE_DATE , E.LAST_UPDATED_BY , E.CREATION_DATE , E.CREATED_BY , E.LAST_UPDATE_LOGIN , E.SEQUENCE1 , E.SEQUENCE2 , E.DESCRIPTION , E.DISABLE_DATE , E.ATTRIBUTE_CATEGORY , E.ATTRIBUTE1 , E.ATTRIBUTE2 , E.ATTRIBUTE3 , E.ATTRIBUTE4 , E.ATTRIBUTE5 , E.ATTRIBUTE6 , E.ATTRIBUTE7 , E.ATTRIBUTE8 , E.ATTRIBUTE9 , E.ATTRIBUTE10 , E.ATTRIBUTE11 , E.ATTRIBUTE12 , E.ATTRIBUTE13 , E.ATTRIBUTE14 , E.ATTRIBUTE15 FROM PER_PEOPLE_X P1, ENG_ECN_APPROVERS E, ENG_ECN_APPROVAL_LISTS EEAL WHERE E.EMPLOYEE_ID = P1.PERSON_ID AND E.APPROVAL_LIST_ID = EEAL.APPROVAL_LIST_ID AND TRUNC(SYSDATE) between P1.effective_start_date and P1.effective_end_date AND P1.employee_number is not NULL

View Text - HTML Formatted

SELECT E.ROWID
, P1.FULL_NAME
, EEAL.APPROVAL_LIST_NAME
, E.APPROVAL_LIST_ID
, E.EMPLOYEE_ID
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.LAST_UPDATE_LOGIN
, E.SEQUENCE1
, E.SEQUENCE2
, E.DESCRIPTION
, E.DISABLE_DATE
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, E.ATTRIBUTE11
, E.ATTRIBUTE12
, E.ATTRIBUTE13
, E.ATTRIBUTE14
, E.ATTRIBUTE15
FROM PER_PEOPLE_X P1
, ENG_ECN_APPROVERS E
, ENG_ECN_APPROVAL_LISTS EEAL
WHERE E.EMPLOYEE_ID = P1.PERSON_ID
AND E.APPROVAL_LIST_ID = EEAL.APPROVAL_LIST_ID
AND TRUNC(SYSDATE) BETWEEN P1.EFFECTIVE_START_DATE
AND P1.EFFECTIVE_END_DATE
AND P1.EMPLOYEE_NUMBER IS NOT NULL