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

VIEW: APPS.OKC_STD_ART_VERSIONS_V

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

View Type

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


Standard Articles (such as the FAR and DFAR) are frequently changed.
Copies of each version must be retained.
It appears that the default behaviour is that a new contract always uses
the current version.
Whether it is possible to override this is unknown.
It is however possible with this model.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The address of the row in the database
SAE_ID NUMBER
Yes Foreign key to OKC_STD_ARTICLES_B.
SAV_RELEASE VARCHAR2 (50)
Version of the article.
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SFWT_FLAG CHAR (1)
Indicates a value was changed in another language. Not fully implemented in 11i
DATE_ACTIVE DATE

Date and time this occurrence is active for user access.
TEXT CLOB (4000)
The article text as written in the contract element.
SHORT_DESCRIPTION VARCHAR2 (2000)
User entered free format abbreviated text description.
ARTICLE_STATUS VARCHAR2 (30)
Status of the version of the Std Article
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield category column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
CREATED_BY NUMBER
Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER
Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER

Standard Who column.
Query Text

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


SELECT ROW_ID
,      SAE_ID
,      SAV_RELEASE
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      DATE_ACTIVE
,      TEXT
,      SHORT_DESCRIPTION
,      ARTICLE_STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_STD_ART_VERSIONS_V;

Dependencies

[top of page]

APPS.OKC_STD_ART_VERSIONS_V references the following:

SchemaAPPS
PL/SQL PackageMO_GLOBAL - show dependent code
SynonymOKC_ARTICLES
SynonymOKC_ARTICLE_ADOPTIONS
SynonymOKC_ARTICLE_VERSIONS
APPS.OKC_STD_ART_VERSIONS_V is referenced by following:

SchemaAPPS
Package BodyOKC_COPY_CONTRACT_PVT - show dependent code
Package BodyOKC_SAV_PVT - show dependent code
PL/SQL PackageOKC_SAV_PVT - show dependent code
Package BodyOKE_KCOPY_PKG - show dependent code
Package BodyOKL_ARTICLE_PUB - show dependent code
Package BodyOKL_MASTER_LEASE_AGREEMENT_PUB - show dependent code
Package BodyOKL_VENDOR_AGREEMENT_PUB - show dependent code
Package BodyOKL_VP_K_ARTICLE_PVT - show dependent code
ViewOKL_VP_STD_ARTICLES_UV
Package BodyOKS_CONTRACTS_PUB - show dependent code