VIEW: APPS.PER_ALL_PEOPLE_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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