VIEW: APPS.WSH_CARRIER_SITE_CONTACTS_V

Source

View Text - Preformatted

SELECT rel.party_id, org.org_contact_id, hcp.contact_point_id, org.party_site_id, party.party_id, party.person_first_name, party.person_last_name, org.contact_number, hcp.email_address, org.decision_maker_flag, party.person_pre_name_adjunct, org.job_title_code, party.status FROM hz_relationships rel, hz_parties party_rel, hz_org_contacts org, hz_contact_points hcp, hz_parties party WHERE rel.party_id = party_rel.party_id and org.party_relationship_id = rel.relationship_id and hcp.owner_table_id = party_rel.party_id and hcp.contact_point_type = 'EMAIL' and party.party_id = rel.subject_id and party.party_type = 'PERSON' and hcp.owner_table_name = 'HZ_PARTIES' and subject_table_name = 'HZ_PARTIES' and object_table_name = 'HZ_PARTIES' and directional_flag = 'F'

View Text - HTML Formatted

SELECT REL.PARTY_ID
, ORG.ORG_CONTACT_ID
, HCP.CONTACT_POINT_ID
, ORG.PARTY_SITE_ID
, PARTY.PARTY_ID
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, ORG.CONTACT_NUMBER
, HCP.EMAIL_ADDRESS
, ORG.DECISION_MAKER_FLAG
, PARTY.PERSON_PRE_NAME_ADJUNCT
, ORG.JOB_TITLE_CODE
, PARTY.STATUS
FROM HZ_RELATIONSHIPS REL
, HZ_PARTIES PARTY_REL
, HZ_ORG_CONTACTS ORG
, HZ_CONTACT_POINTS HCP
, HZ_PARTIES PARTY
WHERE REL.PARTY_ID = PARTY_REL.PARTY_ID
AND ORG.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND HCP.OWNER_TABLE_ID = PARTY_REL.PARTY_ID
AND HCP.CONTACT_POINT_TYPE = 'EMAIL'
AND PARTY.PARTY_ID = REL.SUBJECT_ID
AND PARTY.PARTY_TYPE = 'PERSON'
AND HCP.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F'