View: ICX_PO_EMPLOYEE_DETAILS_V

Product:	ICX - Oracle iProcurement
Description:	Internal Employee Contacts View
Implementation/DBA Data:	APPS.ICX_PO_EMPLOYEE_DETAILS_V

View Text

SELECT P.PERSON_ID
, P.EMPLOYEE_NUMBER
, P.FULL_NAME
, P.FIRST_NAME
, P.LAST_NAME
, P.EMAIL_ADDRESS
, HR_GENERAL.GET_WORK_PHONE(P.PERSON_ID) "WORK_TELEPHONE"
, A.LOCATION_ID
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, P.ATTRIBUTE11
, P.ATTRIBUTE12
, P.ATTRIBUTE13
, P.ATTRIBUTE14
, P.ATTRIBUTE15
, P.ATTRIBUTE16
, P.ATTRIBUTE17
, P.ATTRIBUTE18
, P.ATTRIBUTE19
, P.ATTRIBUTE20
, HOU.NAME
, POS.NAME
, P.MAILSTOP
, HR_GENERAL.GET_PHONE_NUMBER( P.PERSON_ID
, 'WF'
, SYSDATE )
, HR_GENERAL.GET_PHONE_NUMBER( P.PERSON_ID
, 'P'
, SYSDATE )
FROM PER_PEOPLE_F P
, PER_ASSIGNMENTS_F A
, HR_ORGANIZATION_UNITS HOU
, PER_POSITIONS POS
WHERE A.PERSON_ID = P.PERSON_ID
AND A.PRIMARY_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE
AND P.EMPLOYEE_NUMBER IS NOT NULL
AND A.ASSIGNMENT_TYPE = 'E'
AND HOU.ORGANIZATION_ID = P.BUSINESS_GROUP_ID
AND HOU.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID
AND POS.POSITION_ID (+) = A.POSITION_ID

Columns