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.

[Home] [Help]

VIEW: OKC.OKC_TERMS_DEVIATIONS_T#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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