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.

VIEW: OKC.OKC_CLS_CLAUSE_BUFFER_T#

Source

View Text - Preformatted


select BUFFER_SEQ_ID BUFFER_SEQ_ID, CLAUSE_SEQUENCE CLAUSE_SEQUENCE, FULLTEXT_YN FULLTEXT_YN, PRESECRIBED_YN PRESECRIBED_YN, REQUIRED_YN REQUIRED_YN, CLAUSE_CLS_ID CLAUSE_CLS_ID, CLAUSE_REF_YN CLAUSE_REF_YN, CLAUSE_PROVISION_YN CLAUSE_PROVISION_YN, CLAUSE_NUMBER CLAUSE_NUMBER, REGULATION_ID REGULATION_ID, REGULATION_NAME REGULATION_NAME, REGULATION_TITLE REGULATION_TITLE, REGULATION_URL REGULATION_URL, SECTION_ID SECTION_ID, SECTION_NAME SECTION_NAME, SECTION_TITLE SECTION_TITLE, ALTERNATE_OR_DEVIATION ALTERNATE_OR_DEVIATION, VARIATION_NAME VARIATION_NAME, REVISION_ID REVISION_ID, REVISION_FILLINS_YN REVISION_FILLINS_YN, REVISION_EDITABLE_YN REVISION_EDITABLE_YN, REVISION_TITLE REVISION_TITLE, CLAUSE_TEXT CLAUSE_TEXT, EFF_START_DATE EFF_START_DATE, EFF_END_DATE EFF_END_DATE, SERIAL_NUMBER SERIAL_NUMBER, ORIG_SECTION_ID ORIG_SECTION_ID, TOKEN TOKEN, ORIG_ARTICLE_ID ORIG_ARTICLE_ID, ORIG_ARTICLE_VERSION_ID ORIG_ARTICLE_VERSION_ID, CLAUSE_DISPLAY_SEQUENCE CLAUSE_DISPLAY_SEQUENCE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "OKC"."OKC_CLS_CLAUSE_BUFFER_T"

View Text - HTML Formatted

SELECT BUFFER_SEQ_ID BUFFER_SEQ_ID
, CLAUSE_SEQUENCE CLAUSE_SEQUENCE
, FULLTEXT_YN FULLTEXT_YN
, PRESECRIBED_YN PRESECRIBED_YN
, REQUIRED_YN REQUIRED_YN
, CLAUSE_CLS_ID CLAUSE_CLS_ID
, CLAUSE_REF_YN CLAUSE_REF_YN
, CLAUSE_PROVISION_YN CLAUSE_PROVISION_YN
, CLAUSE_NUMBER CLAUSE_NUMBER
, REGULATION_ID REGULATION_ID
, REGULATION_NAME REGULATION_NAME
, REGULATION_TITLE REGULATION_TITLE
, REGULATION_URL REGULATION_URL
, SECTION_ID SECTION_ID
, SECTION_NAME SECTION_NAME
, SECTION_TITLE SECTION_TITLE
, ALTERNATE_OR_DEVIATION ALTERNATE_OR_DEVIATION
, VARIATION_NAME VARIATION_NAME
, REVISION_ID REVISION_ID
, REVISION_FILLINS_YN REVISION_FILLINS_YN
, REVISION_EDITABLE_YN REVISION_EDITABLE_YN
, REVISION_TITLE REVISION_TITLE
, CLAUSE_TEXT CLAUSE_TEXT
, EFF_START_DATE EFF_START_DATE
, EFF_END_DATE EFF_END_DATE
, SERIAL_NUMBER SERIAL_NUMBER
, ORIG_SECTION_ID ORIG_SECTION_ID
, TOKEN TOKEN
, ORIG_ARTICLE_ID ORIG_ARTICLE_ID
, ORIG_ARTICLE_VERSION_ID ORIG_ARTICLE_VERSION_ID
, CLAUSE_DISPLAY_SEQUENCE CLAUSE_DISPLAY_SEQUENCE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "OKC"."OKC_CLS_CLAUSE_BUFFER_T"