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

VIEW: APPS.OKC_K_ARTICLES_V

Object Details
Object Name: OKC_K_ARTICLES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_K_ARTICLES_V
Subobject Name:
Status: VALID

View Type

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


DEFINITION
An ARTICLE is supertype for "Terms and Conditions" which specify, in plain (?!) language, requirements which may be specified in the RFP to apply to preparation of the proposal, offering (PROVISION) or which apply to the execution of an agreed, signed active contract (CLAUSE)
An ARTICLE may be parsed into 1 or more RULE which store the intent of the ARTICLE as executable data
EXAMPLE
"The proposal must be printed on both sides of recycled paper and sent to arrive 3 days before the first full moon of May" is a PROVISION (which shold result in 2 RULES)
"The pencils must be packaged and marked according to Federal Military standard BLAH1.2.3" is a clause
MISCELLANEOUS
DEFINITION
A STANDARD type of ARTICLE is one that is based on an existing instance of a STANDARD ARTICLE. The STANDARD ARTICLE can be referenced as-is, or varied in some fashion.
If an ARTICLE is simply a reference to an existing STANDARD ARTICLE then the text of the ARTICLE is found in STANDARD ARTICLE. If the text is significantly varied then the text is found in ARTICLE.VARIED TEXT
EXAMPLE
FAR 354
MISCELLANEOUS
DEFINITION
A NON STANDARD type of ARTICLE is a custom article written exclusively for the use in a contract.
EXAMPLE
MISCELLANEOUS


[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. Denormalized 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.OKC_K_ARTICLES_V;

Dependencies

[top of page]

APPS.OKC_K_ARTICLES_V references the following:

SchemaAPPS
SynonymOKC_ARTICLES_ALL
SynonymOKC_ARTICLE_VERSIONS
SynonymOKC_K_ARTICLES_B
APPS.OKC_K_ARTICLES_V is referenced by following:

SchemaAPPS
Package BodyOKC_CAT_PVT - show dependent code
PL/SQL PackageOKC_CAT_PVT - show dependent code
Package BodyOKC_K_ARTICLE_PUB - show dependent code
Package BodyOKC_QA_DATA_INTEGRITY - show dependent code
Package BodyOKC_REPORT_PVT - show dependent code
Package BodyOKC_SAV_PVT - show dependent code
Package BodyOKC_STD_ARTICLE_PVT - show dependent code
Package BodyOKE_CONTRACT_PRINTING_PKG - show dependent code
ViewOKE_K_ARTICLES_PRINT_V
ViewOKE_K_ARTICLES_V
Package BodyOKE_UTILS - show dependent code
Package BodyOKE_VERSION_COMPARISON_PKG - show dependent code
Package BodyOKL_ARTICLE_PUB - show dependent code
ViewOKL_K_ARTICLES_UV
PL/SQL PackageOKL_MASTER_LEASE_AGREEMENT_PUB - show dependent code
PL/SQL PackageOKL_VENDOR_AGREEMENT_PUB - show dependent code
Package BodyOKL_VP_CAT_PVT - show dependent code
PL/SQL PackageOKL_VP_CAT_PVT - show dependent code
Package BodyOKL_VP_K_ARTICLE_PUB - show dependent code
Package BodyOKL_VP_K_ARTICLE_PVT - show dependent code
Package BodyOKL_VP_SYNC_CR_PVT - show dependent code
Package BodyOKS_RENCPY_PVT - show dependent code