[Home] [Help]
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
Name |
PERSON_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
BUSINESS_GROUP_ID |
PERSON_TYPE_ID |
LAST_NAME |
START_DATE |
EMAIL_ADDRESS |
EMPLOYEE_NUMBER |
FIRST_NAME |
FULL_NAME |
VENDOR_ID |
WORK_TELEPHONE |