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_UPLD_TERMS

Object Details

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

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_REVIEW_UPLD_TERMS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	REVIEW_UPLD_TERMS_ID
SYS_IL0000406867C00006$$	LOB	UNIQUE	APPS_TS_INTERFACE
SYS_IL0000406867C00026$$	LOB	UNIQUE	APPS_TS_INTERFACE
OKC_REVIEW_UPLD_TERMS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DOCUMENT_TYPE DOCUMENT_ID OBJECT_TYPE

Columns

Name	Datatype	Length	Comments
REVIEW_UPLD_TERMS_ID	NUMBER		Sequence Id
DOCUMENT_ID	NUMBER		Id of the business document for which the word document has been uploaded
DOCUMENT_TYPE	VARCHAR2	(30)	Document Type of the business document for which the word document has been uploaded
OBJECT_ID	NUMBER		Object Id Refers to Cat_id for Clauses Section_id for Sections Cat_id for Clauses Section_id for Sections Object Id Refers to Cat_id for Clauses Section_id for Sections
OBJECT_TYPE	VARCHAR2	(30)	Object type to define �document�, �Section�, �Article�
OBJECT_TEXT	CLOB	(4000)	Refers to Clause Text
PARENT_OBJECT_TYPE	VARCHAR2	(30)	Object Type of the Parent Object
PARENT_ID	NUMBER		Object Id of the Parent Object
ARTICLE_ID	NUMBER		Article Id
ARTICLE_VERSION_ID	NUMBER		Article Version Id
OBJECT_VERSION_NUMBER	NUMBER	(9)	Object Version Number
LABEL	VARCHAR2	(60)	Stores the Numbering Sequence
DISPLAY_SEQ	NUMBER		Display Sequence
ACTION	VARCHAR2	(30)	Action Column. 'ADDED','UPDATED','DELETED'. FndLookups.LookupType='OKC_REVIEW_ACTIONS'
ERROR_MESSAGE_COUNT	NUMBER		Message Count for Errors
WARNING_MESSAGE_COUNT	NUMBER		Message Count for Warnings
LAST_UPDATE_LOGIN	NUMBER		Standard Who Column
CREATED_BY	NUMBER		Standard Who Column
CREATION_DATE	DATE		Standard Who Column
LAST_UPDATED_BY	NUMBER		Standard Who Column
LAST_UPDATE_DATE	DATE		Standard Who Column
NON_STANDARD_FLAG	VARCHAR2	(1)	Is the Article Non-Standard? Populated as part of Sync Process
MANDATORY_FLAG	VARCHAR2	(1)	Is the Article Mandatory? Populated as part of Sync Process
LOCK_TEXT	VARCHAR2	(1)	Is the Article Lock Text Enabled? Populated as part of Sync Process
NEW_PARENT_ID	NUMBER		New Parent Id . Populated as part of Upload process
OBJECT_TITLE	CLOB	(4000)	it refers to Section or Clause Title
UPLOAD_LEVEL	NUMBER		It denotes at what level was the Section or Clause identified in the word document.
OLD_REVIEW_UPLD_TERMS_ID	NUMBER		It stores the original id of the review terms before Merge.

Query Text

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


SELECT REVIEW_UPLD_TERMS_ID
,      DOCUMENT_ID
,      DOCUMENT_TYPE
,      OBJECT_ID
,      OBJECT_TYPE
,      OBJECT_TEXT
,      PARENT_OBJECT_TYPE
,      PARENT_ID
,      ARTICLE_ID
,      ARTICLE_VERSION_ID
,      OBJECT_VERSION_NUMBER
,      LABEL
,      DISPLAY_SEQ
,      ACTION
,      ERROR_MESSAGE_COUNT
,      WARNING_MESSAGE_COUNT
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      NON_STANDARD_FLAG
,      MANDATORY_FLAG
,      LOCK_TEXT
,      NEW_PARENT_ID
,      OBJECT_TITLE
,      UPLOAD_LEVEL
,      OLD_REVIEW_UPLD_TERMS_ID
FROM OKC.OKC_REVIEW_UPLD_TERMS;

Dependencies

[top of page]

OKC.OKC_REVIEW_UPLD_TERMS does not reference any database object

OKC.OKC_REVIEW_UPLD_TERMS is referenced by following:

APPS: OKC_REVIEW_UPLD_TERMS