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_TRIGGERS

Object Details

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

This table contains event-condition details for all event rules.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_CONDITION_ID	NUMBER		Yes	Primary Key
EVENT_CODE	VARCHAR2	(30)	Yes	Event Identifier.
FROM_TO_STATUS_CODE	VARCHAR2	(30)		Condition identifier. This is a lookup code belonging to CS_SR_STATUS_CONDITIONS lookup type
INCIDENT_STATUS_ID	NUMBER			Condition identifier. This identifier is always used in conjunction with the FROM_TO_STATUS_CODE column.
RELATIONSHIP_TYPE_ID	NUMBER	(15)		Condition identifier. This identifier is mutually exclusive with the (FROM_TO_STATUS_CODE, INCIDENT_STATUS_ID) column pair.
START_DATE_ACTIVE	DATE		Yes	Effective Start Date
END_DATE_ACTIVE	DATE			Effective End Date
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		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.

Query Text

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


SELECT EVENT_CONDITION_ID
,      EVENT_CODE
,      FROM_TO_STATUS_CODE
,      INCIDENT_STATUS_ID
,      RELATIONSHIP_TYPE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SEEDED_FLAG
,      APPLICATION_ID
,      OBJECT_VERSION_NUMBER
FROM CS.CS_SR_ACTION_TRIGGERS;

Dependencies

[top of page]

CS.CS_SR_ACTION_TRIGGERS does not reference any database object

CS.CS_SR_ACTION_TRIGGERS is referenced by following:

APPS: CS_SR_ACTION_TRIGGERS