View: PER_PEOPLE_V7

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_PEOPLE_V7

View Text

SELECT PER.ROWID
, PER.PERSON_ID
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID + 0
, PER.PERSON_TYPE_ID
, PER.LAST_NAME
, PER.START_DATE
, PER.APPLICANT_NUMBER
, PER.COMMENT_ID
, PER.CURRENT_APPLICANT_FLAG
, PER.CURRENT_EMP_OR_APL_FLAG
, PER.CURRENT_EMPLOYEE_FLAG
, PER.DATE_EMPLOYEE_DATA_VERIFIED
, PER.DATE_OF_BIRTH
, PER.EMAIL_ADDRESS
, PER.EMPLOYEE_NUMBER
, PER.EXPENSE_CHECK_SEND_TO_ADDRESS
, PER.FIRST_NAME
, PER.FULL_NAME
, PER.KNOWN_AS
, PER.MARITAL_STATUS
, PER.MIDDLE_NAMES
, PER.NATIONALITY
, PER.NATIONAL_IDENTIFIER
, PER.PREVIOUS_LAST_NAME
, PER.REGISTERED_DISABLED_FLAG
, PER.SEX
, PER.TITLE
, PER.VENDOR_ID
, HR_GENERAL.GET_PHONE_NUMBER(PER.PERSON_ID
, 'W1'
, PER.EFFECTIVE_START_DATE)
, PER.REQUEST_ID
, PER.PROGRAM_APPLICATION_ID
, PER.PROGRAM_ID
, PER.PROGRAM_UPDATE_DATE
, PER.ATTRIBUTE_CATEGORY
, PER.ATTRIBUTE1
, PER.ATTRIBUTE2
, PER.ATTRIBUTE3
, PER.ATTRIBUTE4
, PER.ATTRIBUTE5
, PER.ATTRIBUTE6
, PER.ATTRIBUTE7
, PER.ATTRIBUTE8
, PER.ATTRIBUTE9
, PER.ATTRIBUTE10
, PER.ATTRIBUTE11
, PER.ATTRIBUTE12
, PER.ATTRIBUTE13
, PER.ATTRIBUTE14
, PER.ATTRIBUTE15
, PER.ATTRIBUTE16
, PER.ATTRIBUTE17
, PER.ATTRIBUTE18
, PER.ATTRIBUTE19
, PER.ATTRIBUTE20
, PER.ATTRIBUTE21
, PER.ATTRIBUTE22
, PER.ATTRIBUTE23
, PER.ATTRIBUTE24
, PER.ATTRIBUTE25
, PER.ATTRIBUTE26
, PER.ATTRIBUTE27
, PER.ATTRIBUTE28
, PER.ATTRIBUTE29
, PER.ATTRIBUTE30
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.LAST_UPDATE_LOGIN
, PER.CREATED_BY
, PER.CREATION_DATE
, PER.PER_INFORMATION_CATEGORY
, PER.PER_INFORMATION1
, PER.PER_INFORMATION2
, PER.PER_INFORMATION3
, PER.PER_INFORMATION4
, PER.PER_INFORMATION5
, PER.PER_INFORMATION6
, PER.PER_INFORMATION7
, PER.PER_INFORMATION8
, PER.PER_INFORMATION9
, PER.PER_INFORMATION10
, PER.PER_INFORMATION11
, PER.PER_INFORMATION12
, PER.PER_INFORMATION13
, PER.PER_INFORMATION14
, PER.PER_INFORMATION15
, PER.PER_INFORMATION16
, PER.PER_INFORMATION17
, PER.PER_INFORMATION18
, PER.PER_INFORMATION19
, PER.PER_INFORMATION20
, PER.PER_INFORMATION21
, PER.PER_INFORMATION22
, PER.PER_INFORMATION23
, PER.PER_INFORMATION24
, PER.PER_INFORMATION25
, PER.PER_INFORMATION26
, PER.PER_INFORMATION27
, PER.PER_INFORMATION28
, PER.PER_INFORMATION29
, PER.PER_INFORMATION30
, PER.ORIGINAL_DATE_OF_HIRE
, HL1.MEANING
, HL2.MEANING /*
, PPTTL.USER_PERSON_TYPE */
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(PER.EFFECTIVE_START_DATE
, PER.PERSON_ID)
, PPT.SYSTEM_PERSON_TYPE
, HL3.MEANING
, HL4.MEANING
, HL5.MEANING
, PPS.PERIOD_OF_SERVICE_ID
, PPS.DATE_START
, PPS.ACTUAL_TERMINATION_DATE
FROM HR_LOOKUPS HL1
, HR_LOOKUPS HL2
, HR_LOOKUPS HL3
, HR_LOOKUPS HL4
, HR_LOOKUPS HL5
, PER_PERSON_TYPES_TL PPTTL
, PER_PERSON_TYPES PPT
, PER_PERIODS_OF_SERVICE PPS
, PER_PEOPLE_F PER
WHERE HL1.LOOKUP_TYPE (+) = 'TITLE'
AND HL1.LOOKUP_CODE (+) = PER.TITLE
AND HL2.LOOKUP_TYPE (+) = 'SEX'
AND HL2.LOOKUP_CODE (+) = PER.SEX
AND HL3.LOOKUP_TYPE (+) = 'HOME_OFFICE'
AND HL3.LOOKUP_CODE (+) = PER.EXPENSE_CHECK_SEND_TO_ADDRESS
AND HL4.LOOKUP_TYPE (+) = 'MAR_STATUS'
AND HL4.LOOKUP_CODE (+) = PER.MARITAL_STATUS
AND HL5.LOOKUP_TYPE (+) = 'NATIONALITY'
AND HL5.LOOKUP_CODE (+) = PER.NATIONALITY
AND PPT.PERSON_TYPE_ID = PER.PERSON_TYPE_ID
AND PPT.PERSON_TYPE_ID = PPTTL.PERSON_TYPE_ID
AND PPTTL.LANGUAGE = USERENV('LANG')
AND PPS.PERSON_ID (+) = PER.PERSON_ID
AND ((PER.EMPLOYEE_NUMBER IS NULL) OR (PER.EMPLOYEE_NUMBER IS NOT NULL
AND PPS.DATE_START = (SELECT MAX(PPS1.DATE_START)
FROM PER_PERIODS_OF_SERVICE PPS1
WHERE PPS1.PERSON_ID = PER.PERSON_ID)))
AND PER.EFFECTIVE_START_DATE = (SELECT MAX(PER1.EFFECTIVE_START_DATE)
FROM PER_PEOPLE_F PER1
WHERE PER1.PERSON_ID = PER.PERSON_ID)

Columns