VIEW: HR.PER_CONTACT_RELATIONSHIPS#

Source

View Text - Preformatted

select CONTACT_RELATIONSHIP_ID CONTACT_RELATIONSHIP_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PERSON_ID PERSON_ID, CONTACT_PERSON_ID CONTACT_PERSON_ID, CONTACT_TYPE CONTACT_TYPE, PRIMARY_CONTACT_FLAG PRIMARY_CONTACT_FLAG, DATE_START DATE_START, START_LIFE_REASON_ID START_LIFE_REASON_ID, DATE_END DATE_END, END_LIFE_REASON_ID END_LIFE_REASON_ID, RLTD_PER_RSDS_W_DSGNTR_FLAG RLTD_PER_RSDS_W_DSGNTR_FLAG, PERSONAL_FLAG PERSONAL_FLAG, SEQUENCE_NUMBER SEQUENCE_NUMBER, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CONT_ATTRIBUTE_CATEGORY CONT_ATTRIBUTE_CATEGORY, CONT_ATTRIBUTE1 CONT_ATTRIBUTE1, CONT_ATTRIBUTE2 CONT_ATTRIBUTE2, CONT_ATTRIBUTE3 CONT_ATTRIBUTE3, CONT_ATTRIBUTE4 CONT_ATTRIBUTE4, CONT_ATTRIBUTE5 CONT_ATTRIBUTE5, CONT_ATTRIBUTE6 CONT_ATTRIBUTE6, CONT_ATTRIBUTE7 CONT_ATTRIBUTE7, CONT_ATTRIBUTE8 CONT_ATTRIBUTE8, CONT_ATTRIBUTE9 CONT_ATTRIBUTE9, CONT_ATTRIBUTE10 CONT_ATTRIBUTE10, CONT_ATTRIBUTE11 CONT_ATTRIBUTE11, CONT_ATTRIBUTE12 CONT_ATTRIBUTE12, CONT_ATTRIBUTE13 CONT_ATTRIBUTE13, CONT_ATTRIBUTE14 CONT_ATTRIBUTE14, CONT_ATTRIBUTE15 CONT_ATTRIBUTE15, CONT_ATTRIBUTE16 CONT_ATTRIBUTE16, CONT_ATTRIBUTE17 CONT_ATTRIBUTE17, CONT_ATTRIBUTE18 CONT_ATTRIBUTE18, CONT_ATTRIBUTE19 CONT_ATTRIBUTE19, CONT_ATTRIBUTE20 CONT_ATTRIBUTE20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, THIRD_PARTY_PAY_FLAG THIRD_PARTY_PAY_FLAG, BONDHOLDER_FLAG BONDHOLDER_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DEPENDENT_FLAG DEPENDENT_FLAG, BENEFICIARY_FLAG BENEFICIARY_FLAG, PARTY_ID PARTY_ID, CONT_INFORMATION_CATEGORY CONT_INFORMATION_CATEGORY, CONT_INFORMATION1 CONT_INFORMATION1, CONT_INFORMATION2 CONT_INFORMATION2, CONT_INFORMATION3 CONT_INFORMATION3, CONT_INFORMATION4 CONT_INFORMATION4, CONT_INFORMATION5 CONT_INFORMATION5, CONT_INFORMATION6 CONT_INFORMATION6, CONT_INFORMATION7 CONT_INFORMATION7, CONT_INFORMATION8 CONT_INFORMATION8, CONT_INFORMATION9 CONT_INFORMATION9, CONT_INFORMATION10 CONT_INFORMATION10, CONT_INFORMATION11 CONT_INFORMATION11, CONT_INFORMATION12 CONT_INFORMATION12, CONT_INFORMATION13 CONT_INFORMATION13, CONT_INFORMATION14 CONT_INFORMATION14, CONT_INFORMATION15 CONT_INFORMATION15, CONT_INFORMATION16 CONT_INFORMATION16, CONT_INFORMATION17 CONT_INFORMATION17, CONT_INFORMATION18 CONT_INFORMATION18, CONT_INFORMATION19 CONT_INFORMATION19, CONT_INFORMATION20 CONT_INFORMATION20, COMMENTS COMMENTS from "HR"."PER_CONTACT_RELATIONSHIPS"

View Text - HTML Formatted

SELECT CONTACT_RELATIONSHIP_ID CONTACT_RELATIONSHIP_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PERSON_ID PERSON_ID
, CONTACT_PERSON_ID CONTACT_PERSON_ID
, CONTACT_TYPE CONTACT_TYPE
, PRIMARY_CONTACT_FLAG PRIMARY_CONTACT_FLAG
, DATE_START DATE_START
, START_LIFE_REASON_ID START_LIFE_REASON_ID
, DATE_END DATE_END
, END_LIFE_REASON_ID END_LIFE_REASON_ID
, RLTD_PER_RSDS_W_DSGNTR_FLAG RLTD_PER_RSDS_W_DSGNTR_FLAG
, PERSONAL_FLAG PERSONAL_FLAG
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CONT_ATTRIBUTE_CATEGORY CONT_ATTRIBUTE_CATEGORY
, CONT_ATTRIBUTE1 CONT_ATTRIBUTE1
, CONT_ATTRIBUTE2 CONT_ATTRIBUTE2
, CONT_ATTRIBUTE3 CONT_ATTRIBUTE3
, CONT_ATTRIBUTE4 CONT_ATTRIBUTE4
, CONT_ATTRIBUTE5 CONT_ATTRIBUTE5
, CONT_ATTRIBUTE6 CONT_ATTRIBUTE6
, CONT_ATTRIBUTE7 CONT_ATTRIBUTE7
, CONT_ATTRIBUTE8 CONT_ATTRIBUTE8
, CONT_ATTRIBUTE9 CONT_ATTRIBUTE9
, CONT_ATTRIBUTE10 CONT_ATTRIBUTE10
, CONT_ATTRIBUTE11 CONT_ATTRIBUTE11
, CONT_ATTRIBUTE12 CONT_ATTRIBUTE12
, CONT_ATTRIBUTE13 CONT_ATTRIBUTE13
, CONT_ATTRIBUTE14 CONT_ATTRIBUTE14
, CONT_ATTRIBUTE15 CONT_ATTRIBUTE15
, CONT_ATTRIBUTE16 CONT_ATTRIBUTE16
, CONT_ATTRIBUTE17 CONT_ATTRIBUTE17
, CONT_ATTRIBUTE18 CONT_ATTRIBUTE18
, CONT_ATTRIBUTE19 CONT_ATTRIBUTE19
, CONT_ATTRIBUTE20 CONT_ATTRIBUTE20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, THIRD_PARTY_PAY_FLAG THIRD_PARTY_PAY_FLAG
, BONDHOLDER_FLAG BONDHOLDER_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DEPENDENT_FLAG DEPENDENT_FLAG
, BENEFICIARY_FLAG BENEFICIARY_FLAG
, PARTY_ID PARTY_ID
, CONT_INFORMATION_CATEGORY CONT_INFORMATION_CATEGORY
, CONT_INFORMATION1 CONT_INFORMATION1
, CONT_INFORMATION2 CONT_INFORMATION2
, CONT_INFORMATION3 CONT_INFORMATION3
, CONT_INFORMATION4 CONT_INFORMATION4
, CONT_INFORMATION5 CONT_INFORMATION5
, CONT_INFORMATION6 CONT_INFORMATION6
, CONT_INFORMATION7 CONT_INFORMATION7
, CONT_INFORMATION8 CONT_INFORMATION8
, CONT_INFORMATION9 CONT_INFORMATION9
, CONT_INFORMATION10 CONT_INFORMATION10
, CONT_INFORMATION11 CONT_INFORMATION11
, CONT_INFORMATION12 CONT_INFORMATION12
, CONT_INFORMATION13 CONT_INFORMATION13
, CONT_INFORMATION14 CONT_INFORMATION14
, CONT_INFORMATION15 CONT_INFORMATION15
, CONT_INFORMATION16 CONT_INFORMATION16
, CONT_INFORMATION17 CONT_INFORMATION17
, CONT_INFORMATION18 CONT_INFORMATION18
, CONT_INFORMATION19 CONT_INFORMATION19
, CONT_INFORMATION20 CONT_INFORMATION20
, COMMENTS COMMENTS
FROM "HR"."PER_CONTACT_RELATIONSHIPS"