View: OKX_PARTY_CONTACTS_V

Product:	OKX - Contracts Integration
Description:	Party contacts
Implementation/DBA Data:	APPS.OKX_PARTY_CONTACTS_V

View Text

SELECT R.PARTY_ID ID1
, '#' ID2
, R.STATUS B_STATUS
, R.STATUS STATUS
, R.OBJECT_ID PARTY_ID
, '#' PARTY_ID2
, P2.PARTY_NUMBER PARTY_NUMBER
, SUBSTR(P2.PERSON_LAST_NAME||'
, '||P2.PERSON_FIRST_NAME
, 1
, 255) NAME
, P2.PARTY_NAME DESCRIPTION
, P2.PARTY_TYPE PARTY_TYPE
, R.RELATIONSHIP_ID PARTY_RELATIONSHIP_ID
, R.RELATIONSHIP_CODE PARTY_RELATIONSHIP_TYPE
, R.DIRECTIONAL_FLAG DIRECTION_FLAG
, R.START_DATE START_DATE_ACTIVE
, R.END_DATE END_DATE_ACTIVE
, P3.EMAIL_ADDRESS EMAIL_ADDRESS
FROM HZ_RELATIONSHIPS R
, HZ_PARTIES P3
, HZ_PARTIES P2
WHERE P2.PARTY_ID = R.SUBJECT_ID
AND R.RELATIONSHIP_CODE IN ( 'CONTACT_OF'
, 'EMPLOYEE_OF')
AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND P3.PARTY_ID = R.PARTY_ID
AND EXISTS (SELECT '1'
FROM HZ_ORG_CONTACTS OC
WHERE OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID)

Columns