View: CS_SR_HZ_CONT_PTS_EMAILS_V

Product:	CS - Service
Description:
Implementation/DBA Data:	APPS.CS_SR_HZ_CONT_PTS_EMAILS_V

View Text

SELECT CP.EMAIL_ADDRESS EMAIL
, AR.MEANING CONT_POINT_TYPE_MEANING
, CP.OWNER_TABLE_ID
, CP.CONTACT_POINT_ID
, CP.TIMEZONE_ID
, CP.CONTACT_POINT_TYPE
, CP.PRIMARY_FLAG
, CP.STATUS
FROM HZ_CONTACT_POINTS CP
, AR_LOOKUPS AR
WHERE CP.CONTACT_POINT_TYPE = 'EMAIL'
AND CP.CONTACT_POINT_TYPE = AR.LOOKUP_CODE (+)
AND AR.LOOKUP_TYPE (+) = 'COMMUNICATION_TYPE'
AND CP.OWNER_TABLE_NAME = 'HZ_PARTIES'

Columns