[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_FLEX_VALUE_SETS |
|---|---|
| Object Type: | TABLE |
| Owner: | APPLSYS |
| FND Design Data: |  FND.FND_FLEX_VALUE_SETS
|
| Subobject Name: | |
| Status: | VALID |
FND_FLEX_VALUE_SETS stores information about the value sets used
by both key and descriptive flexfields. Each row includes
the application identifier, the name and description of the
value set, the validation type of value set (F for Table,
I for Independent, D for Dependent, N for None, P for Pair,
U for Special), the data format type, the maximum
and minimum values and precision for number format type value set.
Each row also contains flags that determine what size
values can be in this value set, and whether
flexfield value security and LOV's LongList feature are
enabled for this value set. NUMERIC_MODE_ENABLED_FLAG indicates
whether Oracle Application Object Library should right-justify and
zero-fill values that contain only the characters 0 through 9; it
does not indicate that values in this value set are of type NUMBER.
MAXIMUM_VALUE and MINIMUM_VALUE together do range checks on values.
If the value set is a dependent value
set, PARENT_FLEX_VALUE_SET_ID identifies the independent value set
the current dependent value set depends upon. Also if the value
set is a dependent value set, DEPENDANT_DEFAULT_VALUE and
DEPENDANT_DEFAULT_MEANING contain the default value and
description that Oracle Application Object Library should
automatically create in the dependent value set whenever you create
a new value in the independent value set it depends upon.
You need one row for each value set you
have for your flexfields. Oracle Application Object Library uses
this information to assign groups of valid values to flexfield
segments.
.
.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 20 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FND_FLEX_VALUE_SETS_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 FLEX_VALUE_SET_ID
ZD_EDITION_NAME
|
| FND_FLEX_VALUE_SETS_U2 | NORMAL | UNIQUE |
APPS_TS_SEED
|
FLEX_VALUE_SET_NAME
ZD_EDITION_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FLEX_VALUE_SET_ID | NUMBER | (10) | Yes | Flexfield value set identifier |
| FLEX_VALUE_SET_NAME | VARCHAR2 | (60) | Yes | Value set name |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
| VALIDATION_TYPE | VARCHAR2 | (1) | Yes | Validation type |
| PROTECTED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if this is a protected value set |
| SECURITY_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the flexfield security rules for the value set are enabled |
| LONGLIST_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the LOV LongList feature for the value set is enabled |
| FORMAT_TYPE | VARCHAR2 | (1) | Yes | Format type |
| MAXIMUM_SIZE | NUMBER | (3) | Yes | The maximum size of values in the value set |
| ALPHANUMERIC_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether values with alphanumeric characters can be in the value set |
| UPPERCASE_ONLY_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if all the values in the value set should all be in uppercase |
| NUMERIC_MODE_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if Oracle Application Object Library should right-justify and zero-fill values for segments that use the value set |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| DEPENDANT_DEFAULT_VALUE | VARCHAR2 | (60) | The default value for the dependent value set | |
| DEPENDANT_DEFAULT_MEANING | VARCHAR2 | (240) | Descritpion of default value | |
| PARENT_FLEX_VALUE_SET_ID | NUMBER | (10) | The independent value set on which the dependent value set depends | |
| MINIMUM_VALUE | VARCHAR2 | (150) | Minimum value | |
| MAXIMUM_VALUE | VARCHAR2 | (150) | Maximum value | |
| NUMBER_PRECISION | NUMBER | (2) | Precision | |
| ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT FLEX_VALUE_SET_ID
, FLEX_VALUE_SET_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, VALIDATION_TYPE
, PROTECTED_FLAG
, SECURITY_ENABLED_FLAG
, LONGLIST_FLAG
, FORMAT_TYPE
, MAXIMUM_SIZE
, ALPHANUMERIC_ALLOWED_FLAG
, UPPERCASE_ONLY_FLAG
, NUMERIC_MODE_ENABLED_FLAG
, DESCRIPTION
, DEPENDANT_DEFAULT_VALUE
, DEPENDANT_DEFAULT_MEANING
, PARENT_FLEX_VALUE_SET_ID
, MINIMUM_VALUE
, MAXIMUM_VALUE
, NUMBER_PRECISION
, ZD_EDITION_NAME
FROM APPLSYS.FND_FLEX_VALUE_SETS;
APPLSYS.FND_FLEX_VALUE_SETS does not reference any database object
APPLSYS.FND_FLEX_VALUE_SETS is referenced by following:
APPLSYS
FND_FLEX_VALUE_SETS#
|
|
|
|