VIEW: APPS.OKX_PARTY_CONTACTS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)