VIEW: APPS.ICX_PO_EMPLOYEE_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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