View: EGO_PERSON_COMPANY_V

Product:	EGO - Advanced Product Catalog
Description:	View contains Person to Company information
Implementation/DBA Data:	APPS.EGO_PERSON_COMPANY_V

View Text

SELECT P.PARTY_ID PERSON_ID
, P.PARTY_NAME PERSON_NAME
, R.OBJECT_ID COMPANY_ID
, (SELECT PARTY_NAME
FROM HZ_PARTIES
WHERE PARTY_ID = R.OBJECT_ID) COMPANY_NAME
FROM HZ_PARTIES P
, HZ_RELATIONSHIPS R
WHERE R.SUBJECT_ID(+) = P.PARTY_ID
AND R.SUBJECT_TYPE(+) = 'PERSON'
AND R.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND R.OBJECT_TYPE(+) = 'ORGANIZATION'
AND R.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND R.RELATIONSHIP_CODE(+) = 'EMPLOYEE_OF'
AND R.START_DATE(+) <= SYSDATE
AND R.STATUS(+) = 'A'
AND (R.END_DATE >= SYSDATE OR R.END_DATE IS NULL)

Columns