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

TABLE: OKC.OKC_NUMBER_SCHEMES_B

Object Details
Object Name: OKC_NUMBER_SCHEMES_B
Object Type: TABLE
Owner: OKC
FND Design Data: TableOKC.OKC_NUMBER_SCHEMES_B
Subobject Name:
Status: VALID


Translation table for Numbering Schemes. Stores all the translatable attributes of a Numbering scheme.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_NUMBER_SCHEMES_B_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnNUM_SCHEME_ID
Columns
Name Datatype Length Mandatory Comments
NUM_SCHEME_ID NUMBER
Yes Unique Identifier for the Numbering Scheme. Primary key for the table
NUMBER_ARTICLE_YN VARCHAR2 (1) Yes Flag to Indicate whether to apply numbering to Clauses or not.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
NUM_SCHEME_PREVIEW VARCHAR2 (1000)
Preview of the terms numbering scheme when used in a document
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
Query Text

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


SELECT NUM_SCHEME_ID
,      NUMBER_ARTICLE_YN
,      OBJECT_VERSION_NUMBER
,      NUM_SCHEME_PREVIEW
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKC.OKC_NUMBER_SCHEMES_B;

Dependencies

[top of page]

OKC.OKC_NUMBER_SCHEMES_B does not reference any database object

OKC.OKC_NUMBER_SCHEMES_B is referenced by following:

SchemaAPPS
SynonymOKC_NUMBER_SCHEMES_B