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: ViewCS.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:

SchemaAPPS
ViewCS_LOOKUPS
SynonymCS_MESSAGES
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_USER

APPS.CS_MESSAGES_V is not referenced by any database object