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

TABLE: OKC.OKC_TERMS_DEVIATIONS_T

Object Details
Object Name: OKC_TERMS_DEVIATIONS_T
Object Type: TABLE
Owner: OKC
Subobject Name:
Status: VALID


Temporary Table to store Contract Standard Deviations data


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_TERMS_DEVIATIONS_T_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
DEVIATION_CATEGORY VARCHAR2 (30)
Deviation Category
DEVIATION_CODE VARCHAR2 (240)
Deviation rule name
DEVIATION_CATEGORY_MEANING VARCHAR2 (80)
Deviation Category Meaning
DEVIATION_CODE_MEANING VARCHAR2 (2000)
Deviation rule description
DEVIATION_CATEGORY_PRIORITY NUMBER

Deviation Category Priority
SEQUENCE_ID NUMBER

Sequence ID
SCN_ID NUMBER

Section ID
SECTION_HEADING VARCHAR2 (300)
Section Heading
DOC_ARTICLE_ID NUMBER

Document Clause ID
DOC_ARTICLE_VERSION_ID NUMBER

Document Clause Version ID
LABEL VARCHAR2 (60)
Clause Label
SCN_LABEL VARCHAR2 (60)
Section Label
ARTICLE_TITLE VARCHAR2 (450)
Clause Title
REF_ARTICLE_ID NUMBER

Reference Clause ID
REF_ARTICLE_VERSION_ID NUMBER

Reference Clause Version ID
MANDATORY_FLAG VARCHAR2 (1)
Mandatory Flag
ARTICLE_STATUS VARCHAR2 (30)
Clause Status
COMPARE_TEXT_FLAG VARCHAR2 (1)
Compare Text Flag
ORIG_ARTICLE_ID NUMBER

Original Clause ID
CREATION_DATE DATE

Creation Date
ART_SEQ_ID NUMBER

ID from okc_k_articles_b
LOCK_TEXT_MOD_FLAG VARCHAR2 (1)
Lock text Modified flag
DISPLAY_SEQUENCE NUMBER

Display sequence for sections on deviations summary page.
DOCUMENT_TYPE VARCHAR2 (30)
DOCUMENT_ID NUMBER

SCN_SEQUENCE NUMBER

RULE_ID NUMBER

Rule_Id of a deviation rule
DEVIATION_TYPE VARCHAR2 (1)
Identify the deviation type P: Policy Deviation C: Clause Deviation
LINE_NUMBER VARCHAR2 (250)
Unique line number
ITEM_NAME VARCHAR2 (2000)
Item name
ITEM_DESCRIPTION VARCHAR2 (2000)
Item Description
OBJECT_TYPE VARCHAR2 (30)
Indicates if LHS of condition is Variable or Question.
OBJECT_CODE VARCHAR2 (40)
Variable code or Question id
OBJECT_DESCRIPTION VARCHAR2 (2000)
Variable name or Question prompt
DOCUMENT_VALUE VARCHAR2 (2000)
Value in the current document
CONFIG_HEADER_ID NUMBER

Configuration header id
CONFIG_REVISION_NUMBER NUMBER

Configuration revision number
ARTICLE_DESCRIPTION VARCHAR2 (2000)
Clause description
Query Text

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


SELECT DEVIATION_CATEGORY
,      DEVIATION_CODE
,      DEVIATION_CATEGORY_MEANING
,      DEVIATION_CODE_MEANING
,      DEVIATION_CATEGORY_PRIORITY
,      SEQUENCE_ID
,      SCN_ID
,      SECTION_HEADING
,      DOC_ARTICLE_ID
,      DOC_ARTICLE_VERSION_ID
,      LABEL
,      SCN_LABEL
,      ARTICLE_TITLE
,      REF_ARTICLE_ID
,      REF_ARTICLE_VERSION_ID
,      MANDATORY_FLAG
,      ARTICLE_STATUS
,      COMPARE_TEXT_FLAG
,      ORIG_ARTICLE_ID
,      CREATION_DATE
,      ART_SEQ_ID
,      LOCK_TEXT_MOD_FLAG
,      DISPLAY_SEQUENCE
,      DOCUMENT_TYPE
,      DOCUMENT_ID
,      SCN_SEQUENCE
,      RULE_ID
,      DEVIATION_TYPE
,      LINE_NUMBER
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      OBJECT_TYPE
,      OBJECT_CODE
,      OBJECT_DESCRIPTION
,      DOCUMENT_VALUE
,      CONFIG_HEADER_ID
,      CONFIG_REVISION_NUMBER
,      ARTICLE_DESCRIPTION
FROM OKC.OKC_TERMS_DEVIATIONS_T;

Dependencies

[top of page]

OKC.OKC_TERMS_DEVIATIONS_T does not reference any database object

OKC.OKC_TERMS_DEVIATIONS_T is referenced by following:

SchemaAPPS
SynonymOKC_TERMS_DEVIATIONS_T