View: PER_CONTACT_EXTRA_INFO_D

Product:	PER - Human Resources
Description:	Used by DateTrack History.
Implementation/DBA Data:	APPS.PER_CONTACT_EXTRA_INFO_D

View Text

SELECT CEI.CONTACT_EXTRA_INFO_ID
, CEI.EFFECTIVE_START_DATE
, CEI.EFFECTIVE_END_DATE
, EMP.FULL_NAME
, CON.FULL_NAME
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CONTACT'
, REL.CONTACT_TYPE)
, 1
, 80)
, CITT.DESCRIPTION
, CEI.LAST_UPDATE_DATE
, USR.USER_NAME
FROM PER_CONTACT_EXTRA_INFO_F CEI
, PER_ALL_PEOPLE_F EMP
, PER_ALL_PEOPLE_F CON
, PER_CONTACT_RELATIONSHIPS REL
, PER_CONTACT_INFO_TYPES_TL CITT
, FND_USER USR
WHERE CEI.CONTACT_RELATIONSHIP_ID = REL.CONTACT_RELATIONSHIP_ID
AND REL.PERSON_ID = EMP.PERSON_ID
AND REL.CONTACT_PERSON_ID = CON.PERSON_ID
AND CEI.INFORMATION_TYPE = CITT.INFORMATION_TYPE
AND CITT.LANGUAGE = USERENV('LANG')
AND CEI.LAST_UPDATED_BY = USR.USER_ID(+)
AND CEI.EFFECTIVE_START_DATE BETWEEN NVL(EMP.EFFECTIVE_START_DATE
, CEI.EFFECTIVE_START_DATE)
AND NVL(EMP.EFFECTIVE_END_DATE
, CEI.EFFECTIVE_START_DATE)
AND CEI.EFFECTIVE_START_DATE BETWEEN NVL(CON.EFFECTIVE_START_DATE
, CEI.EFFECTIVE_START_DATE)
AND NVL(CON.EFFECTIVE_END_DATE
, CEI.EFFECTIVE_START_DATE)
AND CEI.EFFECTIVE_START_DATE BETWEEN NVL(REL.DATE_START
, CEI.EFFECTIVE_START_DATE)
AND NVL(REL.DATE_END
, CEI.EFFECTIVE_START_DATE) WITH READ ONLY

Columns