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

TABLE: CSF.CSF_R_MESSAGES

Object Details
Object Name: CSF_R_MESSAGES
Object Type: TABLE
Owner: CSF
FND Design Data: TableCSF.CSF_R_MESSAGES
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSF_R_MESSAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMESSAGE_ID
CSF_R_MESSAGES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_TASK_ID
Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER
Yes rimary key for table CSF_R_MESSAGES.
REQUEST_TASK_ID NUMBER
Yes Foreign key to table CSF_R_REQUEST_TASKS.
NAME VARCHAR2 (30) Yes FND message name.
TYPE VARCHAR2 (30)
FND message type. (ERROR, WARNING). If NULL an error is assumed.
SECURITY_GROUP_ID NUMBER

Security group identifier.
OBJECT_VERSION_NUMBER NUMBER
Yes The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.
Query Text

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


SELECT MESSAGE_ID
,      REQUEST_TASK_ID
,      NAME
,      TYPE
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM CSF.CSF_R_MESSAGES;

Dependencies

[top of page]

CSF.CSF_R_MESSAGES does not reference any database object

CSF.CSF_R_MESSAGES is referenced by following:

SchemaAPPS
SynonymCSF_R_MESSAGES