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.

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

VIEW: OKC.OKC_CLS_CLAUSE_BUFFER_T#

Object Details

Object Name:	OKC_CLS_CLAUSE_BUFFER_T#
Object Type:	VIEW
Owner:	OKC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
BUFFER_SEQ_ID	NUMBER
CLAUSE_SEQUENCE	NUMBER
FULLTEXT_YN	VARCHAR2	(1)
PRESECRIBED_YN	VARCHAR2	(1)
REQUIRED_YN	VARCHAR2	(1)
CLAUSE_CLS_ID	NUMBER
CLAUSE_REF_YN	VARCHAR2	(1)
CLAUSE_PROVISION_YN	VARCHAR2	(1)
CLAUSE_NUMBER	VARCHAR2	(240)
REGULATION_ID	NUMBER
REGULATION_NAME	VARCHAR2	(200)
REGULATION_TITLE	VARCHAR2	(200)
REGULATION_URL	VARCHAR2	(250)
SECTION_ID	NUMBER
SECTION_NAME	VARCHAR2	(100)
SECTION_TITLE	VARCHAR2	(100)
ALTERNATE_OR_DEVIATION	VARCHAR2	(100)
VARIATION_NAME	VARCHAR2	(200)
REVISION_ID	NUMBER
REVISION_FILLINS_YN	VARCHAR2	(1)
REVISION_EDITABLE_YN	VARCHAR2	(1)
REVISION_TITLE	VARCHAR2	(200)
CLAUSE_TEXT	CLOB	(4000)
EFF_START_DATE	DATE
EFF_END_DATE	DATE
SERIAL_NUMBER	NUMBER
ORIG_SECTION_ID	NUMBER
TOKEN	VARCHAR2	(50)
ORIG_ARTICLE_ID	NUMBER
ORIG_ARTICLE_VERSION_ID	NUMBER
CLAUSE_DISPLAY_SEQUENCE	NUMBER
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

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


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

Dependencies

[top of page]

OKC.OKC_CLS_CLAUSE_BUFFER_T# references the following:

OKC: OKC_CLS_CLAUSE_BUFFER_T

OKC.OKC_CLS_CLAUSE_BUFFER_T# is referenced by following:

APPS: OKC_CLS_CLAUSE_BUFFER_T