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_CODES_B

Object Details

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

Base table for all action definitions.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_CODE	VARCHAR2	(30)	Yes	Identifier column for the action codes
NOTIFICATION_TEMPLATE_NAME	VARCHAR2	(1)	Yes	Indicator column for the notification template action detail - the value(R,H) indicates whether this action detail is required or hidden for the corresponding action code
NEW_STATUS	VARCHAR2	(1)	Yes	Indicator column for the service request status action detail - the value(R,H) indicates whether this action detail is required or hidden for the corresponding action code
RELATIONSHIP_TYPE	VARCHAR2	(1)	Yes	Indicator column for the link type action detail - the value(R,H) indicates whether this action detail is required or hidden for the corresponding action code
NEW_RESOLUTION_CODE	VARCHAR2	(1)	Yes	Resolution code
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_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.

Query Text

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


SELECT ACTION_CODE
,      NOTIFICATION_TEMPLATE_NAME
,      NEW_STATUS
,      RELATIONSHIP_TYPE
,      NEW_RESOLUTION_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SEEDED_FLAG
,      APPLICATION_ID
,      OBJECT_VERSION_NUMBER
FROM CS.CS_SR_ACTION_CODES_B;

Dependencies

[top of page]

CS.CS_SR_ACTION_CODES_B does not reference any database object

CS.CS_SR_ACTION_CODES_B is referenced by following:

APPS: CS_SR_ACTION_CODES_B