VIEW: APPS.IGS_OR_CONTACTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'