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

VIEW: APPS.OKE_K_ARTICLES_V

Object Details
Object Name: OKE_K_ARTICLES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view gives information about use of standard and non-standard ("custom", one-time use) clauses in project contract document..
When associated with a contract header, the clause governs the entire contract.. When associated with a line, the clause governs that line and all of its sublines.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The address of the row in the database
ID NUMBER
Yes Primary key column.
CHR_ID NUMBER

Foreign key to OKC_K_HEADERS_B.
CLE_ID NUMBER

Foreign key to OKC_K_LINES_B.
CAT_ID NUMBER

Category ID.
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.
SFWT_FLAG VARCHAR2 (0)
Indicates a value was changed in another language. Not fully implemented in 11i
SAV_SAE_ID NUMBER

Surrogate key used for primary unique identifiers.
SAV_SAV_RELEASE VARCHAR2 (50)
Version of the article.
SBT_CODE VARCHAR2 (30)
Surrogate key used for primary unique identifiers.
DNZ_CHR_ID NUMBER

Contract ID. De-normalized for performance.
COMMENTS VARCHAR2 (2000)
User entered comment.
FULLTEXT_YN VARCHAR2 (3)
Indicates whether the article should contain the full text of the article or should be referenced by name.
VARIATION_DESCRIPTION VARCHAR2 (240)
Standard article variation description.
NAME VARCHAR2 (450)
Used for Non-Standard articles.
TEXT CLOB (4000)
Used for Non-Standard articles.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column.
CAT_TYPE VARCHAR2 (3)
Category type.
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 ROW_ID
,      ID
,      CHR_ID
,      CLE_ID
,      CAT_ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      SAV_SAE_ID
,      SAV_SAV_RELEASE
,      SBT_CODE
,      DNZ_CHR_ID
,      COMMENTS
,      FULLTEXT_YN
,      VARIATION_DESCRIPTION
,      NAME
,      TEXT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CAT_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKE_K_ARTICLES_V;

Dependencies

[top of page]

APPS.OKE_K_ARTICLES_V references the following:

SchemaAPPS
PL/SQL PackageMO_GLOBAL - show dependent code
ViewOKC_K_ARTICLES_V
ViewOKC_STD_ARTICLES_V

APPS.OKE_K_ARTICLES_V is not referenced by any database object