[Home] [Help] [Dependency Information]
Object Name: | OKC_STD_ART_VERSIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_STD_ART_VERSIONS_V |
Subobject Name: | |
Status: | VALID |
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.
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) | Yes | 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. |
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;
|
|
|