VIEW: APPS.OKL_AM_PARTY_CONTACTS_UV

Source

View Text - Preformatted

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, C.JOB_TITLE JOB_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'

View Text - HTML Formatted

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
, C.JOB_TITLE JOB_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'