[Home] [Help] [Dependency Information]
Object Name: | EGO_VALUE_SETS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_VALUE_SETS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VALUE_SET_ID | NUMBER | (10) | Yes | Value set identifier |
VALUE_SET_NAME | VARCHAR2 | (60) | Yes | Value set name |
FORMAT_CODE | VARCHAR2 | (1) | Yes | Data type format (Eg: C,N ..) |
FORMAT_MEANING | VARCHAR2 | (80) | Yes | Meaning of format code (Eg Char, Number ..) |
MAXIMUM_SIZE | NUMBER | (3) | Yes | Maximum size |
DESCRIPTION | VARCHAR2 | (240) | Description | |
LONGLIST_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the LOV LongList feature for the value set is enabled |
LONGLIST_FLAG_MEANING | VARCHAR2 | (80) | Yes | Meaning of longlist flag |
VALIDATION_CODE | VARCHAR2 | (30) | Validation Type | |
VALIDATION_MEANING | VARCHAR2 | (80) | Yes | Meaning of Validation code |
MINIMUM_VALUE | VARCHAR2 | (150) | Maximum value | |
MAXIMUM_VALUE | VARCHAR2 | (150) | Minimum value | |
VALIDATION_CODE_ADMIN | VARCHAR2 | (1) | Yes | This column stores the Validation Type of Value Set |
PARENT_VALUE_SET_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT VALUE_SET_ID
, VALUE_SET_NAME
, FORMAT_CODE
, FORMAT_MEANING
, MAXIMUM_SIZE
, DESCRIPTION
, LONGLIST_FLAG
, LONGLIST_FLAG_MEANING
, VALIDATION_CODE
, VALIDATION_MEANING
, MINIMUM_VALUE
, MAXIMUM_VALUE
, VALIDATION_CODE_ADMIN
, PARENT_VALUE_SET_ID
FROM APPS.EGO_VALUE_SETS_V;
|
|
|