VIEW: APPS.CS_SR_HZ_CONT_PTS_EMAILS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'