[Home] [Help] [Dependency Information]
Object Name: | OKC_REVIEW_VAR_VALUES |
---|---|
Object Type: | TABLE |
Owner: | OKC |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_REVIEW_VAR_VALUES_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | REVIEW_UPLD_TERMS_ID |
OKC_REVIEW_VAR_VALUES_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | VARIABLE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REVIEW_VAR_VALUES_ID | NUMBER | Primary Key | ||
REVIEW_UPLD_TERMS_ID | NUMBER | Foreign key to OKC_REVIEW_UPLD_TERMS | ||
VARIABLE_NAME | VARCHAR2 | (150) | Variable Name for the Clause referred to using review_upld_terms_id | |
LANGUAGE | VARCHAR2 | (4) | Language in which User uploaded the document | |
VARIABLE_CODE | VARCHAR2 | (30) | This shows the Variable Code used in the document | |
VARIABLE_TYPE | VARCHAR2 | (1) | This shows the type of the variable. The valid values are S=System, U=User Defined, T=Table, D=Deliverable. | |
ATTRIBUTE_VALUE_SET_ID | NUMBER | This defines the Value Set of the user-defined variable value. | ||
VARIABLE_VALUE_ID | VARCHAR2 | (40) | Id of the Value chosen in the document. | |
VARIABLE_VALUE | VARCHAR2 | (2000) | Variable Value | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
CREATED_BY | NUMBER | Standard Who Column | ||
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
CHANGED | VARCHAR2 | (1) | This flag is used to track if a variable value was changed during upload. | |
OLD_REVIEW_UPLD_TERMS_ID | NUMBER | It stores the original id of the review terms before Merge. |
Cut, paste (and edit) the following text to query this object:
SELECT REVIEW_VAR_VALUES_ID
, REVIEW_UPLD_TERMS_ID
, VARIABLE_NAME
, LANGUAGE
, VARIABLE_CODE
, VARIABLE_TYPE
, ATTRIBUTE_VALUE_SET_ID
, VARIABLE_VALUE_ID
, VARIABLE_VALUE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CHANGED
, OLD_REVIEW_UPLD_TERMS_ID
FROM OKC.OKC_REVIEW_VAR_VALUES;
OKC.OKC_REVIEW_VAR_VALUES does not reference any database object
OKC.OKC_REVIEW_VAR_VALUES is referenced by following:
|
|
|