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

TABLE: CS.CS_MESSAGES

Object Details
Object Name: CS_MESSAGES
Object Type: TABLE
Owner: CS
FND Design Data: TableCS.CS_MESSAGES
Subobject Name:
Status: VALID


CS_MESSAGES stores information about the messages sent from the service requests, repairs, and charges windows. Each message is associated with a source type and two source identifiers. The source type can be either service request or repairs. The internal source identifier is the foreign key reference to the table that stores the source object. The external source identifier is the user-visable number of the source object, such as the service request number or the repair line number.While the column SOURCE_OBJECT_TYPE_CODE is mapped to the QuickCodes type CS_OBJECT_SOURCE_TYPE, 'INC' and 'DEPOT' are the only valid codes because messaging is not currently supported in the install base and calls modules.You can set up valid codes for MESSAGE_ACTION_REQUEST in the Message Action Request QuickCodes window.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CS_MESSAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMESSAGE_ID
CS_MESSAGES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSOURCE_OBJECT_INT_ID
ColumnSOURCE_OBJECT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER (15) Yes Message unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column - with the user id from FND_USER
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column - with the user id from FND_USER
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DATE_SENT DATE
Yes Date this message is sent
NOTIFICATION_ID NUMBER (15) Yes Notification identifier. This is a foreign key reference to WF_NOTIFICATIONS.
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30) Yes Identifies whether the message is for a service request or repair
SOURCE_OBJECT_INT_ID NUMBER (15) Yes Internal source object identifier
SOURCE_OBJECT_EXT_ID VARCHAR2 (100)
User-visible source object identifier
SENDER VARCHAR2 (240) Yes Name of the sender
SENDER_ROLE VARCHAR2 (100)
Workflow role name of the sender
RECEIVER VARCHAR2 (240) Yes Name of the recipient
PRIORITY VARCHAR2 (10) Yes Priority of the message
ACTION_CODE VARCHAR2 (30)
Action the recipient is requested to take
EXPAND_ROLES VARCHAR2 (1) Yes Indicates whether a separate message is sent to all the users assigned to the recipient role
CONFIRMATION VARCHAR2 (1) Yes Indicates whether to send a confirmation to the sender once a recipient has responded
MESSAGE VARCHAR2 (2000)
Message body
RESPONDER VARCHAR2 (240)
User who responded to the message
RESPONSE_DATE DATE

Date the user completed the response to the message
RESPONSE VARCHAR2 (30)
Response to the message
RESPONDER_COMMENT VARCHAR2 (2000)
Optional comment on the response
OBJECT_VERSION_NUMBER NUMBER

Sequential number used for database locking control when using HTML as a user interface
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT MESSAGE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DATE_SENT
,      NOTIFICATION_ID
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_INT_ID
,      SOURCE_OBJECT_EXT_ID
,      SENDER
,      SENDER_ROLE
,      RECEIVER
,      PRIORITY
,      ACTION_CODE
,      EXPAND_ROLES
,      CONFIRMATION
,      MESSAGE
,      RESPONDER
,      RESPONSE_DATE
,      RESPONSE
,      RESPONDER_COMMENT
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
FROM CS.CS_MESSAGES;

Dependencies

[top of page]

CS.CS_MESSAGES does not reference any database object

CS.CS_MESSAGES is referenced by following:

SchemaAPPS
SynonymCS_MESSAGES