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
FND Design Data: TableOKC.OKC_REVIEW_UPLD_TERMS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_REVIEW_UPLD_TERMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnREVIEW_UPLD_TERMS_ID
SYS_IL0000406867C00006$$ LOB UNIQUE TablespaceAPPS_TS_INTERFACE
SYS_IL0000406867C00026$$ LOB UNIQUE TablespaceAPPS_TS_INTERFACE
OKC_REVIEW_UPLD_TERMS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnDOCUMENT_TYPE
ColumnDOCUMENT_ID
ColumnOBJECT_TYPE
Columns
Name Datatype Length Mandatory 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:

SchemaOKC
ViewOKC_REVIEW_UPLD_TERMS#