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]

VIEW: APPS.CS_MESSAGES_V

Object Details

Object Name:	CS_MESSAGES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_MESSAGES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Rowid from the base table
MESSAGE_ID	NUMBER	(15)	Yes	Message unique identifier
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)	Yes	Identifies whether the message is for a service request or repair
SENDER	VARCHAR2	(240)	Yes	Name of the sender
RECEIVER	VARCHAR2	(240)	Yes	Name of the recipient
DATE_SENT	DATE		Yes	Date this message is sent
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
OBJECT_EXT_ID	VARCHAR2	(100)		User-visible source object identifier
OBJECT_ID	NUMBER	(15)	Yes	Object identifier
OBJECT_TYPE_CODE	VARCHAR2	(30)	Yes	Identifies whether the message is for a service request or repair
PRIORITY	VARCHAR2	(80)		Priority of the message
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	(80)		Response to the message
RESPONDER_COMMENT	VARCHAR2	(2000)		Optional comment on the response
ACTION_TYPE	VARCHAR2	(80)		Type of action the recipient is requested to take
SOURCE_OBJECT	VARCHAR2	(80)		Source Object
ENTERED_BY	VARCHAR2	(100)	Yes	Entered By

Query Text

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


SELECT ROW_ID
,      MESSAGE_ID
,      SOURCE_OBJECT_TYPE_CODE
,      SENDER
,      RECEIVER
,      DATE_SENT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_EXT_ID
,      OBJECT_ID
,      OBJECT_TYPE_CODE
,      PRIORITY
,      EXPAND_ROLES
,      CONFIRMATION
,      MESSAGE
,      RESPONDER
,      RESPONSE_DATE
,      RESPONSE
,      RESPONDER_COMMENT
,      ACTION_TYPE
,      SOURCE_OBJECT
,      ENTERED_BY
FROM APPS.CS_MESSAGES_V;

Dependencies

[top of page]

APPS.CS_MESSAGES_V references the following:

APPS: CS_LOOKUPS; CS_MESSAGES; FND_GLOBAL - show dependent code; FND_USER

APPS.CS_MESSAGES_V is not referenced by any database object