eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CS.CS_HZ_SR_CONTACT_PNTS_AUDIT

Object Details

Object Name:	CS_HZ_SR_CONTACT_PNTS_AUDIT
Object Type:	TABLE
Owner:	CS
FND Design Data:	CS.CS_HZ_SR_CONTACT_PNTS_AUDIT
Subobject Name:
Status:	VALID

To maintain audit history for service request party role information. This audit table will be populated when existing service request party role records are updated either via online user transaction or through the public api's.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_HZ_SR_CNT_PNTS_AUDIT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SR_CONTACT_POINT_AUDIT_ID
CS_HZ_SR_CNT_PNTS_AUDIT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
CS_HZ_SR_CNT_PNTS_AUDIT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCIDENT_ID
CS_HZ_SR_CNT_PNTS_AUDIT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SR_CONTACT_POINT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SR_CONTACT_POINT_AUDIT_ID	NUMBER		Yes	System generated number to uniquely identify audit record.
SR_CONTACT_POINT_ID	NUMBER		Yes	Service request contact point id
INCIDENT_ID	NUMBER			Service request id
PARTY_ID	NUMBER			New Customer Id
OLD_PARTY_ID	NUMBER			Old Customer Id
PRIMARY_FLAG	VARCHAR2	(1)		Primary contact for service request.
OLD_PRIMARY_FLAG	VARCHAR2	(1)		Old primary contact for service request.
CONTACT_TYPE	VARCHAR2	(30)		New customer contact type.
OLD_CONTACT_TYPE	VARCHAR2	(30)		Old customer contact type.
CONTACT_POINT_TYPE	VARCHAR2	(30)		New customer contact point type.
OLD_CONTACT_POINT_TYPE	VARCHAR2	(30)		Old customer contact point type.
CONTACT_POINT_ID	NUMBER			New customer contact point type id
OLD_CONTACT_POINT_ID	NUMBER			Old customer contact point type id.
CONTACT_POINT_MODIFIED_BY	NUMBER			Contact point modified by.
CONTACT_POINT_MODIFIED_ON	DATE			Contact point modified on date.
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object version number
PARTY_ROLE_CODE	VARCHAR2	(30)		New party role code.
OLD_PARTY_ROLE_CODE	VARCHAR2	(30)		Old party role code
START_DATE_ACTIVE	DATE			Current start date for the party role.
OLD_START_DATE_ACTIVE	DATE			Old start date for the party role.
END_DATE_ACTIVE	DATE			Current end date for the party role.
OLD_END_DATE_ACTIVE	DATE			Old end date for the party role.
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SR_CONTACT_POINT_AUDIT_ID
,      SR_CONTACT_POINT_ID
,      INCIDENT_ID
,      PARTY_ID
,      OLD_PARTY_ID
,      PRIMARY_FLAG
,      OLD_PRIMARY_FLAG
,      CONTACT_TYPE
,      OLD_CONTACT_TYPE
,      CONTACT_POINT_TYPE
,      OLD_CONTACT_POINT_TYPE
,      CONTACT_POINT_ID
,      OLD_CONTACT_POINT_ID
,      CONTACT_POINT_MODIFIED_BY
,      CONTACT_POINT_MODIFIED_ON
,      OBJECT_VERSION_NUMBER
,      PARTY_ROLE_CODE
,      OLD_PARTY_ROLE_CODE
,      START_DATE_ACTIVE
,      OLD_START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      OLD_END_DATE_ACTIVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM CS.CS_HZ_SR_CONTACT_PNTS_AUDIT;

Dependencies

[top of page]

CS.CS_HZ_SR_CONTACT_PNTS_AUDIT does not reference any database object

CS.CS_HZ_SR_CONTACT_PNTS_AUDIT is referenced by following:

CS: CS_HZ_SR_CONTACT_PNTS_AUDIT#