[Home] [Help]
View: WSH_CARRIER_SITE_CONTACTS_V
View Text
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 SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F'
Columns
Name |
RELATION_PARTY_ID |
ORG_CONTACT_ID |
CONTACT_POINT_ID |
CARRIER_SITE_ID |
PERSON_ID |
FIRST_NAME |
LAST_NAME |
CONTACT_NUMBER |
EMAIL_ADDRESS |
ACCEPTS_LOAD_TENDER |
TITLE |
JOB_TITLE |
STATUS |