GMS_EXTERNAL_CONTACTS_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
PARTY_NAME PARTY_ID EMAIL_ADDRESS PRIMARY_PHONE_NUMBER ORG_CONTACT_ID DEPARTMENT DEPARTMENT_CODE JOB_TITLE JOB_TITLE_CODE CONTACT_NUMBER PARTY_RELATIONSHIP_ID SUBJECT_ID

Query

SQL_Statement

select child.party_name, child.party_id, child.email_address, child.primary_phone_number, hzc.org_contact_id, hzc.department, hzc.department_code, hzc.job_title, hzc.job_title_code, hzc.CONTACT_NUMBER, hzc.party_relationship_id, hzr.subject_id from hz_parties child, hz_relationships hzr, hz_org_contacts hzc where child.party_id = hzr.object_id and hzr.object_type = 'PERSON' and hzr.relationship_code = 'CONTACT' and hzc.party_relationship_id(+) = hzr.relationship_id