[Home] [Help] [Dependency Information]
Object Name: | OKE_K_STANDARD_NOTES_VLH |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKE.OKE_K_STANDARD_NOTES_VLH |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The history view of standard notes made against contracts or particular lines. This view joins the translation table to the base table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Database generated row identifier | |
STANDARD_NOTES_ID | NUMBER | Yes | Contract standard notes unique identifier | |
MAJOR_VERSION | NUMBER | (4) | Yes | Major version number of contract document |
HEADER_ID | NUMBER | Yes | Contract header unique identifier | |
LINE_ID | NUMBER | Contract document line unique identifier | ||
DELIVERABLE_ID | NUMBER | Contract deliverable unique identifier | ||
TYPE_CODE | VARCHAR2 | (30) | Internal identifier for standard notes type | |
DEFAULT_FLAG | VARCHAR2 | (1) | Flag indicating whether this contract standard note should be defaulted down to lines and sub-lines | |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Multi-lingual indicator (not currently used) |
DESCRIPTION | VARCHAR2 | (240) | Description of standard notes | |
NAME | VARCHAR2 | (30) | User-entered contract standard notes name | |
TEXT | VARCHAR2 | (2000) | Contract standard notes text | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield attribute context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield attribute |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, STANDARD_NOTES_ID
, MAJOR_VERSION
, HEADER_ID
, LINE_ID
, DELIVERABLE_ID
, TYPE_CODE
, DEFAULT_FLAG
, SFWT_FLAG
, DESCRIPTION
, NAME
, TEXT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM APPS.OKE_K_STANDARD_NOTES_VLH;
APPS.OKE_K_STANDARD_NOTES_VLH is not referenced by any database object
|
|
|