View: CS_HZ_SR_CONTACT_POINTS_V

Product:	CS - Service
Description:	This view is created for backward compatibility for CS_HZ_SR_CONTACT_POINTS table.
Implementation/DBA Data:	APPS.CS_HZ_SR_CONTACT_POINTS_V

View Text

SELECT SR_CONTACT_POINT_ID
, PARTY_ID
, INCIDENT_ID
, CONTACT_POINT_TYPE
, CONTACT_POINT_ID
, PRIMARY_FLAG
, CONTACT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PARTY_ROLE_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM CS_HZ_SR_CONTACT_POINTS
WHERE PARTY_ROLE_CODE = 'CONTACT'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE))

Columns