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]

TABLE: OKC.OKC_CLS_CLAUSE_BUFFER_T

Object Details

Object Name:	OKC_CLS_CLAUSE_BUFFER_T
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_CLS_CLAUSE_BUFFER_T
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_CLS_CLAUSE_BUFFER_T_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUFFER_SEQ_ID
SYS_IL0000873146C00023$$	LOB	UNIQUE	APPS_TS_TX_DATA

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 does not reference any database object

OKC.OKC_CLS_CLAUSE_BUFFER_T is referenced by following:

OKC: OKC_CLS_CLAUSE_BUFFER_T#