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_SR_ACTION_DETAILS

Object Details

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

Table contains action details associated to all event rules.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_SR_ACTION_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_SEED	EVENT_ACTION_DETAIL_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ACTION_DETAIL_ID	NUMBER		Yes	Primary Key column.
EVENT_CONDITION_ID	NUMBER		Yes	This column identifies the event- condition to which the action detail is being mapped.
ACTION_CODE	VARCHAR2	(30)	Yes	This column contains the action code mapped to the event-condition.
NOTIFICATION_TEMPLATE_ID	VARCHAR2	(30)		This column contains the notification template identifier. The notification template is associated to the event-condition-action details.
RESOLUTION_CODE	VARCHAR2	(30)		Resolution code identifier.
INCIDENT_STATUS_ID	NUMBER			The Incident status identifier
START_DATE_ACTIVE	DATE		Yes	Effective Start Date
END_DATE_ACTIVE	DATE			Effective End Date
RELATIONSHIP_TYPE_ID	NUMBER	(15)		Link type identifier.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
SEEDED_FLAG	VARCHAR2	(3)		Flag to denote if the record is seeded or not. Valued provided by lookup codes for lookup type CS_YES_NO.
APPLICATION_ID	NUMBER	(15)		ID of the application that owns the seeded record. FK to fnd_application.application_id
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Specifies how many updates the record has gone through. This value is used in obtaining a lock before updates are performed.
ROLE_GROUP_TYPE	VARCHAR2	(30)		This column will hold value of either Role or Role Group to indentify if current record is for Role or Role Group.
ROLE_GROUP_CODE	VARCHAR2	(30)		This column will hold value of Role or Role Group Code.
HTML_NOTIFICATION	VARCHAR2	(1)		Indicates whether the Notification should be sent in HTML format.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT EVENT_ACTION_DETAIL_ID
,      EVENT_CONDITION_ID
,      ACTION_CODE
,      NOTIFICATION_TEMPLATE_ID
,      RESOLUTION_CODE
,      INCIDENT_STATUS_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      RELATIONSHIP_TYPE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SEEDED_FLAG
,      APPLICATION_ID
,      OBJECT_VERSION_NUMBER
,      ROLE_GROUP_TYPE
,      ROLE_GROUP_CODE
,      HTML_NOTIFICATION
,      ZD_EDITION_NAME
FROM CS.CS_SR_ACTION_DETAILS;

Dependencies

[top of page]

CS.CS_SR_ACTION_DETAILS does not reference any database object

CS.CS_SR_ACTION_DETAILS is referenced by following:

CS: CS_SR_ACTION_DETAILS#