View: PER_CONTACT_RELATIONSHIPS_V

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

View Text

SELECT CON.ROWID
, CON.CONTACT_RELATIONSHIP_ID
, CON.BUSINESS_GROUP_ID + 0
, CON.PERSON_ID
, CON.CONTACT_PERSON_ID
, CON.CONTACT_TYPE
, C.MEANING
, CON.COMMENTS
, CON.THIRD_PARTY_PAY_FLAG
, CON.BONDHOLDER_FLAG
, CON.PRIMARY_CONTACT_FLAG
, CON.DATE_START
, LER1.NAME
, CON.START_LIFE_REASON_ID
, CON.DATE_END
, LER2.NAME
, CON.END_LIFE_REASON_ID
, CON.RLTD_PER_RSDS_W_DSGNTR_FLAG
, CON.REQUEST_ID
, CON.PROGRAM_APPLICATION_ID
, CON.PROGRAM_ID
, CON.PROGRAM_UPDATE_DATE
, CON.CONT_ATTRIBUTE_CATEGORY
, CON.CONT_ATTRIBUTE1
, CON.CONT_ATTRIBUTE2
, CON.CONT_ATTRIBUTE3
, CON.CONT_ATTRIBUTE4
, CON.CONT_ATTRIBUTE5
, CON.CONT_ATTRIBUTE6
, CON.CONT_ATTRIBUTE7
, CON.CONT_ATTRIBUTE8
, CON.CONT_ATTRIBUTE9
, CON.CONT_ATTRIBUTE10
, CON.CONT_ATTRIBUTE11
, CON.CONT_ATTRIBUTE12
, CON.CONT_ATTRIBUTE13
, CON.CONT_ATTRIBUTE14
, CON.CONT_ATTRIBUTE15
, CON.CONT_ATTRIBUTE16
, CON.CONT_ATTRIBUTE17
, CON.CONT_ATTRIBUTE18
, CON.CONT_ATTRIBUTE19
, CON.CONT_ATTRIBUTE20
, CON.LAST_UPDATE_DATE
, CON.LAST_UPDATED_BY
, CON.LAST_UPDATE_LOGIN
, CON.CREATED_BY
, CON.CREATION_DATE
, P.LAST_NAME
, P.FIRST_NAME
, P.MIDDLE_NAMES
, P.TITLE
, P.PRE_NAME_ADJUNCT
, P.SUFFIX
, P.SEX
, P.DATE_OF_BIRTH
, TRUNC(MONTHS_BETWEEN(FND.EFFECTIVE_DATE
, P.DATE_OF_BIRTH)/12)
, P.EMPLOYEE_NUMBER
, P.APPLICANT_NUMBER
, P.NATIONAL_IDENTIFIER
, P.FULL_NAME
, P.ORDER_NAME
, T.MEANING
, P.PERSON_TYPE_ID /*
, PTTL.USER_PERSON_TYPE */
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(FND.EFFECTIVE_DATE
, P.PERSON_ID)
, PT.SYSTEM_PERSON_TYPE
, P.CURRENT_EMPLOYEE_FLAG
, P.CURRENT_APPLICANT_FLAG
, P.CURRENT_EMP_OR_APL_FLAG
, P.REGISTERED_DISABLED_FLAG
, P.ATTRIBUTE_CATEGORY
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, P.ATTRIBUTE11
, P.ATTRIBUTE12
, P.ATTRIBUTE13
, P.ATTRIBUTE14
, P.ATTRIBUTE15
, P.ATTRIBUTE16
, P.ATTRIBUTE17
, P.ATTRIBUTE18
, P.ATTRIBUTE19
, P.ATTRIBUTE20
, P.ATTRIBUTE21
, P.ATTRIBUTE22
, P.ATTRIBUTE23
, P.ATTRIBUTE24
, P.ATTRIBUTE25
, P.ATTRIBUTE26
, P.ATTRIBUTE27
, P.ATTRIBUTE28
, P.ATTRIBUTE29
, P.ATTRIBUTE30
, P.COMMENT_ID
, P.PER_INFORMATION_CATEGORY
, P.PER_INFORMATION1
, P.PER_INFORMATION2
, P.PER_INFORMATION3
, P.PER_INFORMATION4
, P.PER_INFORMATION5
, P.PER_INFORMATION6
, P.PER_INFORMATION7
, P.PER_INFORMATION8
, P.PER_INFORMATION9
, P.PER_INFORMATION10
, P.PER_INFORMATION11
, P.PER_INFORMATION12
, P.PER_INFORMATION13
, P.PER_INFORMATION14
, P.PER_INFORMATION15
, P.PER_INFORMATION16
, P.PER_INFORMATION17
, P.PER_INFORMATION18
, P.PER_INFORMATION19
, P.PER_INFORMATION20
, P.PER_INFORMATION21
, P.PER_INFORMATION22
, P.PER_INFORMATION23
, P.PER_INFORMATION24
, P.PER_INFORMATION25
, P.PER_INFORMATION26
, P.PER_INFORMATION27
, P.PER_INFORMATION28
, P.PER_INFORMATION29
, P.PER_INFORMATION30
, P.KNOWN_AS
FROM HR_LOOKUPS C
, HR_LOOKUPS T
, PER_PERSON_TYPES PT
, PER_PERSON_TYPES_TL PTTL
, PER_ALL_PEOPLE_F P
, PER_CONTACT_RELATIONSHIPS CON
, FND_SESSIONS FND
, BEN_LER_F LER1
, BEN_LER_F LER2
WHERE T.LOOKUP_TYPE(+) = 'TITLE'
AND T.LOOKUP_CODE(+) = P.TITLE
AND C.LOOKUP_TYPE = 'CONTACT'
AND C.LOOKUP_CODE = CON.CONTACT_TYPE
AND CON.CONTACT_PERSON_ID = P.PERSON_ID
AND P.PERSON_TYPE_ID = PT.PERSON_TYPE_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND ((FND.EFFECTIVE_DATE BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE) OR (NOT EXISTS (SELECT NULL
FROM PER_ALL_PEOPLE_F P2
WHERE P2.PERSON_ID = P.PERSON_ID
AND FND.EFFECTIVE_DATE BETWEEN P2.EFFECTIVE_START_DATE
AND P2.EFFECTIVE_END_DATE)
AND P.EFFECTIVE_START_DATE = P.START_DATE))
AND CON.START_LIFE_REASON_ID = LER1.LER_ID (+)
AND FND.EFFECTIVE_DATE BETWEEN NVL(LER1.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE) AND NVL(LER1.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)
AND CON.END_LIFE_REASON_ID = LER2.LER_ID (+)
AND FND.EFFECTIVE_DATE BETWEEN NVL(LER2.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE) AND NVL(LER2.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)
AND PT.PERSON_TYPE_ID = PTTL.PERSON_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')

Columns