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: OKC.OKC_REVIEW_MESSAGES

Object Details

Object Name:	OKC_REVIEW_MESSAGES
Object Type:	TABLE
Owner:	OKC
Subobject Name:
Status:	VALID

This table is used to store the messages during the upoload of Word document. As part of uploading the word document, message during the review process are stored in this table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_REVIEW_MESSAGES_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REVIEW_UPLD_TERMS_ID

Columns

Name	Datatype	Length	Comments
REVIEW_MESSAGES_ID	NUMBER		Sequence Id
REVIEW_UPLD_TERMS_ID	NUMBER		Reference to Clause or Section or root id stored in OKC_REVIEW_UPLOADED_TERMS table
ERROR_SEVERITY	VARCHAR2	(1)	Code that denotes Severity as Error or Warning
MESSAGE_NAME	VARCHAR2	(30)	Message Name for the error or warning.
OBJECT_VERSION_NUMBER	NUMBER		Object Version Number
VARIABLE_CODE	VARCHAR2	(30)	Variable Code for which this message is used

Query Text

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


SELECT REVIEW_MESSAGES_ID
,      REVIEW_UPLD_TERMS_ID
,      ERROR_SEVERITY
,      MESSAGE_NAME
,      OBJECT_VERSION_NUMBER
,      VARIABLE_CODE
FROM OKC.OKC_REVIEW_MESSAGES;

Dependencies

[top of page]

OKC.OKC_REVIEW_MESSAGES does not reference any database object

OKC.OKC_REVIEW_MESSAGES is referenced by following:

APPS: OKC_REVIEW_MESSAGES