VIEW: APPS.OKX_PER_ALL_PEOPLE_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)