Product: | IGS - Student System |
---|---|
Description: | Describes the institution Contact Details |
Implementation/DBA Data: | APPS.IGS_OR_CONTACTS_V |
SELECT REL.ROWID
, TO_NUMBER(NULL)/* CONTACT_ID */
, REL.PARTY_ID /* REL_PARTY_ID */
, REL.STATUS
, NULL /* ORIG_SYSTEM_REFERENCE */
, PP.PERSON_NUMBER
, PP.FULL_NAME
, ORG_CONT.TITLE
, NULL /*TITLE_MEANING */
, ORG_CONT.MAIL_STOP
, ORG_CONT.ATTRIBUTE_CATEGORY
, ORG_CONT.ATTRIBUTE1
, ORG_CONT.ATTRIBUTE2
, ORG_CONT.ATTRIBUTE3
, ORG_CONT.ATTRIBUTE4
, ORG_CONT.ATTRIBUTE5
, ORG_CONT.ATTRIBUTE6
, ORG_CONT.ATTRIBUTE7
, ORG_CONT.ATTRIBUTE8
, ORG_CONT.ATTRIBUTE9
, ORG_CONT.ATTRIBUTE10
, ORG_CONT.ATTRIBUTE11
, ORG_CONT.ATTRIBUTE12
, ORG_CONT.ATTRIBUTE13
, ORG_CONT.ATTRIBUTE14
, ORG_CONT.ATTRIBUTE15
, ORG_CONT.ATTRIBUTE16
, ORG_CONT.ATTRIBUTE17
, ORG_CONT.ATTRIBUTE18
, ORG_CONT.ATTRIBUTE19
, ORG_CONT.ATTRIBUTE20
, ORG_CONT.ATTRIBUTE21
, ORG_CONT.ATTRIBUTE22
, ORG_CONT.ATTRIBUTE23
, ORG_CONT.ATTRIBUTE24
, ORG_CONT.REFERENCE_USE_FLAG
, ORG_CONT.CONTACT_NUMBER
, NULL /* PRIMARY_ROLE */
, REL_PARTY.EMAIL_ADDRESS
, PP.PERSON_ID PARTY_ID /* CONTACT_PARTY_ID*/
, ORG_CONT.ORG_CONTACT_ID
, REL.RELATIONSHIP_ID
, REL.OBJECT_ID /* ORG_PARTY_ID*/
, REL.CREATED_BY
, REL.CREATION_DATE
, REL.LAST_UPDATED_BY
, REL.LAST_UPDATE_DATE
, REL.LAST_UPDATE_LOGIN
, TO_NUMBER(NULL) ORG_ROLE_OVN
, REL.OBJECT_VERSION_NUMBER REL_OVN
, REL_PARTY.OBJECT_VERSION_NUMBER REL_PARTY_OVN
, ORG_CONT.OBJECT_VERSION_NUMBER ORG_CONT_OVN
FROM IGS_PE_PERSON_BASE_V PP
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_PARTIES REL_PARTY
WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND REL.SUBJECT_ID = PP.PERSON_ID
AND REL.OBJECT_ID = REL_PARTY.PARTY_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.DIRECTIONAL_FLAG = 'F'
AND REL.RELATIONSHIP_TYPE ='CONTACT'