View: OKL_AM_PARTY_CONTACTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_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
, 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'

Columns