[Home] [Help]
View: OKL_CS_PARTY_CONTACTS_UV
View Text
SELECT R.OBJECT_ID PARTY_ID
, P.PARTY_ID PERSON_PARTY_ID
, PA.PARTY_NAME PARTY_NAME
, P.PERSON_FIRST_NAME PERSON_FIRST_NAME
, P.PERSON_LAST_NAME PERSON_LAST_NAME
, C.DEPARTMENT DEPARTMENT
, P.PERSON_TITLE TITLE
, C.RANK RANK
, CP.CONTACT_POINT_TYPE CONTACT_POINT_TYPE
, CP.RAW_PHONE_NUMBER RAW_PHONE_NUMBER
, CP.EMAIL_ADDRESS EMAIL_ADDRESS
, CP.TELEX_NUMBER TELEX_NUMBER
, CP.LAST_CONTACT_DT_TIME DATE_NOTIFIED
, CP.PRIMARY_FLAG PRIMARY_FLAG
, CP.CONTACT_POINT_TYPE DETAILS
FROM HZ_RELATIONSHIPS R
, HZ_ORG_CONTACTS C
, HZ_ORG_CONTACT_ROLES CR
, HZ_PARTIES P
, HZ_PARTIES PA
, HZ_CONTACT_POINTS CP
WHERE R.SUBJECT_TYPE = 'PERSON'
AND R.OBJECT_TYPE = 'ORGANIZATION'
AND R.SUBJECT_ID = P.PARTY_ID
AND R.OBJECT_ID = PA.PARTY_ID
AND P.PARTY_TYPE = 'PERSON'
AND R.RELATIONSHIP_CODE = 'CONTACT_OF'
AND C.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
AND R.DIRECTIONAL_FLAG = 'F'
AND CR.ORG_CONTACT_ID = C.ORG_CONTACT_ID
AND R.SUBJECT_ID = CP.OWNER_TABLE_ID (+)
AND CP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
Columns
Name |
PARTY_ID |
PERSON_PARTY_ID |
PARTY_NAME |
PERSON_FIRST_NAME |
PERSON_LAST_NAME |
DEPARTMENT |
TITLE |
RANK |
CONTACT_POINT_TYPE |
RAW_PHONE_NUMBER |
EMAIL_ADDRESS |
TELEX_NUMBER |
DATE_NOTIFIED |
PRIMARY_FLAG |
DETAILS |