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_EVENT_CODES_B

Object Details

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

Base table for all event definitions.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_SR_EVENT_CODES_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	EVENT_CODE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_CODE	VARCHAR2	(30)	Yes	Primary Key column. Event Identifier.
FROM_TO_STATUS	VARCHAR2	(1)	Yes	Indicator column for "from or to" event condition detail - the value(R,H) indicates whether this event condition detail is required or hidden for the corresponding event code
INCIDENT_STATUS	VARCHAR2	(1)	Yes	Indicator column for service request status event condition detail - the value(R,H) indicates whether this event condition detail is required or hidden for the corresponding event code
RELATIONSHIP_TYPE	VARCHAR2	(1)	Yes	Indicator column for link type event condition detail - the value(R,H) indicates whether this event condition detail is required /hidden for the corresponding event code
START_DATE_ACTIVE	DATE		Yes	Effective Start Date
WF_BUSINESS_EVENT_ID	VARCHAR2	(240)	Yes	Work Flow business event name.
END_DATE_ACTIVE	DATE			Effective End Date
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	VARCHAR2	(240)	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)		Specifies how many updates the record has gone through. This value is used in obtaining a lock before updates are performed.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT EVENT_CODE
,      FROM_TO_STATUS
,      INCIDENT_STATUS
,      RELATIONSHIP_TYPE
,      START_DATE_ACTIVE
,      WF_BUSINESS_EVENT_ID
,      END_DATE_ACTIVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SEEDED_FLAG
,      APPLICATION_ID
,      OBJECT_VERSION_NUMBER
,      ZD_EDITION_NAME
FROM CS.CS_SR_EVENT_CODES_B;

Dependencies

[top of page]

CS.CS_SR_EVENT_CODES_B does not reference any database object

CS.CS_SR_EVENT_CODES_B is referenced by following:

CS: CS_SR_EVENT_CODES_B#