View: OKX_PER_ALL_PEOPLE_V

Product:	OKX - Contracts Integration
Description:	Personal information for employees, applicants and other people
Implementation/DBA Data:	APPS.OKX_PER_ALL_PEOPLE_V

View Text

SELECT PER.PERSON_ID PERSON_ID
, PER.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PER.PERSON_TYPE_ID PERSON_TYPE_ID
, PER.LAST_NAME LAST_NAME
, PER.START_DATE START_DATE
, PER.EMAIL_ADDRESS EMAIL_ADDRESS
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PER.FIRST_NAME FIRST_NAME
, PER.FULL_NAME FULL_NAME
, PER.VENDOR_ID VENDOR_ID
, PER.WORK_TELEPHONE WORK_TELEPHONE
FROM PER_ALL_PEOPLE_F PER
WHERE PER.EFFECTIVE_START_DATE = (SELECT MAX(A.EFFECTIVE_START_DATE)
FROM PER_ALL_PEOPLE_F A
WHERE A.PERSON_ID = PER.PERSON_ID)

Columns