Product: | ENG - Engineering |
---|---|
Description: | Engineering change order approvers |
Implementation/DBA Data: | APPS.ENG_ECN_APPROVERS_V |
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