View: PER_ALL_PEOPLE_D

Product:	PER - Human Resources
Description:	Used by Datetrack History
Implementation/DBA Data:	APPS.PER_ALL_PEOPLE_D

View Text

SELECT PEOPLE.PERSON_ID
, PEOPLE.EFFECTIVE_START_DATE
, PEOPLE.EFFECTIVE_END_DATE /*
, PTYPETL.USER_PERSON_TYPE */
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(PEOPLE.EFFECTIVE_END_DATE
, PEOPLE.PERSON_ID)
, PEOPLE.LAST_NAME
, PEOPLE.DATE_EMPLOYEE_DATA_VERIFIED
, PEOPLE.DATE_OF_BIRTH
, PEOPLE.EMAIL_ADDRESS
, PEOPLE.EMPLOYEE_NUMBER
, HR1.MEANING
, PEOPLE.FIRST_NAME
, PEOPLE.FULL_NAME
, PEOPLE.KNOWN_AS
, HR2.MEANING
, PEOPLE.MIDDLE_NAMES
, HR3.MEANING
, PEOPLE.NATIONAL_IDENTIFIER
, PEOPLE.PREVIOUS_LAST_NAME
, HR8.MEANING
, HR4.MEANING
, HR5.MEANING
, PEOPLE.LAST_UPDATE_DATE
, FUSER.USER_NAME
, HR6.MEANING
, HR7.MEANING
, PEOPLE.FTE_CAPACITY
, HR9.MEANING
, HR10.MEANING
, PEOPLE.OFFICE_NUMBER
, PEOPLE.INTERNAL_LOCATION
, PEOPLE.MAILSTOP
, PEOPLE.HONORS
, PEOPLE.PRE_NAME_ADJUNCT
, PEOPLE.HOLD_APPLICANT_DATE_UNTIL
, PEOPLE.SUFFIX
FROM PER_PEOPLE_F PEOPLE
, PER_PERSON_TYPES PTYPE
, PER_PERSON_TYPES_TL PTYPETL
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, HR_LOOKUPS HR3
, HR_LOOKUPS HR4
, HR_LOOKUPS HR5
, HR_LOOKUPS HR6
, HR_LOOKUPS HR7
, HR_LOOKUPS HR8
, HR_LOOKUPS HR9
, HR_LOOKUPS HR10
, FND_USER FUSER
WHERE PTYPE.PERSON_TYPE_ID = PEOPLE.PERSON_TYPE_ID
AND PTYPE.PERSON_TYPE_ID = PTYPETL.PERSON_TYPE_ID
AND PTYPETL.LANGUAGE = USERENV('LANG')
AND HR1.LOOKUP_TYPE (+)= 'HOME_OFFICE'
AND HR1.LOOKUP_CODE (+)= PEOPLE.EXPENSE_CHECK_SEND_TO_ADDRESS
AND HR2.LOOKUP_TYPE (+)= 'MAR_STATUS'
AND HR2.LOOKUP_CODE (+)= PEOPLE.MARITAL_STATUS
AND HR3.LOOKUP_TYPE (+)= 'NATIONALITY'
AND HR3.LOOKUP_CODE (+)= PEOPLE.NATIONALITY
AND HR4.LOOKUP_TYPE (+)= 'SEX'
AND HR4.LOOKUP_CODE (+)= PEOPLE.SEX
AND HR5.LOOKUP_TYPE (+)= 'TITLE'
AND HR5.LOOKUP_CODE (+)= PEOPLE.TITLE
AND HR6.LOOKUP_TYPE (+)= 'WORK_SCHEDULE'
AND HR6.LOOKUP_CODE (+)= PEOPLE.WORK_SCHEDULE
AND HR7.LOOKUP_TYPE (+)= 'STUDENT_STATUS'
AND HR7.LOOKUP_CODE (+)= PEOPLE.STUDENT_STATUS
AND HR8.LOOKUP_TYPE (+)= 'REGISTERED_DISABLED'
AND HR8.LOOKUP_CODE (+)= PEOPLE.REGISTERED_DISABLED_FLAG
AND HR9.LOOKUP_TYPE (+)= 'YES_NO'
AND HR9.LOOKUP_CODE (+)= PEOPLE.ON_MILITARY_SERVICE
AND HR10.LOOKUP_TYPE (+)= 'YES_NO'
AND HR10.LOOKUP_CODE (+)= PEOPLE.SECOND_PASSPORT_EXISTS
AND FUSER.USER_ID (+)= PEOPLE.LAST_UPDATED_BY

Columns