[Home] [Help] [Dependency Information]
Object Name: | OKC_TERMS_DEVIATIONS_T# |
---|---|
Object Type: | VIEW |
Owner: | OKC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEVIATION_CATEGORY | VARCHAR2 | (30) | ||
DEVIATION_CODE | VARCHAR2 | (240) | ||
DEVIATION_CATEGORY_MEANING | VARCHAR2 | (80) | ||
DEVIATION_CODE_MEANING | VARCHAR2 | (2000) | ||
DEVIATION_CATEGORY_PRIORITY | NUMBER | |||
SEQUENCE_ID | NUMBER | |||
SCN_ID | NUMBER | |||
SECTION_HEADING | VARCHAR2 | (300) | ||
DOC_ARTICLE_ID | NUMBER | |||
DOC_ARTICLE_VERSION_ID | NUMBER | |||
LABEL | VARCHAR2 | (60) | ||
SCN_LABEL | VARCHAR2 | (60) | ||
ARTICLE_TITLE | VARCHAR2 | (450) | ||
REF_ARTICLE_ID | NUMBER | |||
REF_ARTICLE_VERSION_ID | NUMBER | |||
MANDATORY_FLAG | VARCHAR2 | (1) | ||
ARTICLE_STATUS | VARCHAR2 | (30) | ||
COMPARE_TEXT_FLAG | VARCHAR2 | (1) | ||
ORIG_ARTICLE_ID | NUMBER | |||
CREATION_DATE | DATE | |||
ART_SEQ_ID | NUMBER | |||
LOCK_TEXT_MOD_FLAG | VARCHAR2 | (1) | ||
DISPLAY_SEQUENCE | NUMBER | |||
DOCUMENT_TYPE | VARCHAR2 | (30) | ||
DOCUMENT_ID | NUMBER | |||
SCN_SEQUENCE | NUMBER | |||
RULE_ID | NUMBER | |||
DEVIATION_TYPE | VARCHAR2 | (1) | ||
LINE_NUMBER | VARCHAR2 | (250) | ||
ITEM_NAME | VARCHAR2 | (2000) | ||
ITEM_DESCRIPTION | VARCHAR2 | (2000) | ||
OBJECT_TYPE | VARCHAR2 | (30) | ||
OBJECT_CODE | VARCHAR2 | (40) | ||
OBJECT_DESCRIPTION | VARCHAR2 | (2000) | ||
DOCUMENT_VALUE | VARCHAR2 | (2000) | ||
CONFIG_HEADER_ID | NUMBER | |||
CONFIG_REVISION_NUMBER | NUMBER | |||
ARTICLE_DESCRIPTION | VARCHAR2 | (2000) |
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#;
|
|
|