View: AMS_ORG_CONTACT_ROLES_V

Product:	AMS - Marketing
Description:	Roles played by organization contacts
Implementation/DBA Data:	APPS.AMS_ORG_CONTACT_ROLES_V

View Text

SELECT HOCR.ORG_CONTACT_ROLE_ID
, HOCR.ORG_CONTACT_ID
, HOCR.CREATION_DATE
, HOCR.CREATED_BY
, HOCR.LAST_UPDATE_DATE
, HOCR.LAST_UPDATED_BY
, HOCR.LAST_UPDATE_LOGIN
, HOCR.ORIG_SYSTEM_REFERENCE
, HOCR.ROLE_LEVEL
, HOCR.ROLE_TYPE
, HOCR.PRIMARY_FLAG
, HOCR.PRIMARY_CONTACT_PER_ROLE_TYPE
, HOCR.REQUEST_ID
, HOCR.PROGRAM_APPLICATION_ID
, HOCR.PROGRAM_ID
, HOCR.PROGRAM_UPDATE_DATE
, HOCR.WH_UPDATE_DATE
, HOCR.CREATED_BY CREATED_BY_NAME
, HOCR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_NAME
, HOCR.LAST_UPDATED_BY LAST_UPDATED_BY_NAME
FROM HZ_ORG_CONTACT_ROLES HOCR
, HZ_PARTIES HP
, HZ_ORG_CONTACTS HOC
, HZ_RELATIONSHIPS HPR
WHERE HP.PARTY_ID = HPR.OBJECT_ID
AND HPR.DIRECTIONAL_FLAG = 'F'
AND HPR.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
AND HOC.ORG_CONTACT_ID = HOCR.ORG_CONTACT_ID
AND ( HPR.END_DATE IS NULL OR SYSDATE <= HPR.END_DATE)
AND HPR.ACTUAL_CONTENT_SOURCE = 'USER_ENTERED'
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'ORGANIZATION'

Columns