DBA Data[Home] [Help] [Dependency Information]


TABLE: APPLSYS.FND_FLEX_VALUE_SETS

Object Details
Object Name: FND_FLEX_VALUE_SETS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.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.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_FLEX_VALUE_SETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnFLEX_VALUE_SET_ID
ColumnZD_EDITION_NAME
FND_FLEX_VALUE_SETS_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnFLEX_VALUE_SET_NAME
ColumnZD_EDITION_NAME
Columns
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
Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_FLEX_VALUE_SETS does not reference any database object

APPLSYS.FND_FLEX_VALUE_SETS is referenced by following:

SchemaAPPLSYS
ViewFND_FLEX_VALUE_SETS#