eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.FND_FLEX_VALIDATION_TABLES

Object Details

Object Name:	FND_FLEX_VALIDATION_TABLES
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_FLEX_VALIDATION_TABLES
Subobject Name:
Status:	VALID

FND_FLEX_VALIDATION_TABLES stores information about key
and descriptive flexfield
validation tables. Each row includes values identifying the table
validated value set and the application owning the value set and the
name of the application table you are using as a validation table
(APPLICATION_TABLE_NAME). Each row also includes the names of the
table columns that contain ID type values, regular values, and
meanings, as well as the size and type of each of those columns,
and additional columns to display for LOVs.
ADDITIONAL_WHERE_CLAUSE contains the WHERE clause that allows the
validation table values to include only a subset of all the values
in the application table. In some cases, application tables can
contain special columns that take advantage of special flexfield
features, such as the ability to use segment qualifiers and
enabled and start date and end date information.
.
{{"bul:1"}}If a column named SUMMARY_FLAG exists in the
validation table, Oracle Application Object Library stores that
column name in SUMMARY_COLUMN_NAME. Otherwise, Oracle Application
Object Library stores N in SUMMARY_COLUMN_NAME.
{{"bul:1"}}If a column named
STRUCTURED_HIERARCHY_LEVEL exists in the validation table, Oracle
Application Object Library stores that column name in
HIERARCHY_LEVEL_COLUMN_NAME. Otherwise, Oracle Application Object
Library stores NULL.
{{"bul:1"}}If a column named COMPILED_VALUE_ATTRIBUTES
exists in the validation table, Oracle Application Object Library
stores that column name in COMPILED_ATTRIBUTE_COLUMN_NAME.
Otherwise, Oracle Application Object Library stores either NULL or
derived default values in COMPILED_ATTRIBUTE_COLUMN_NAME.
{{"bul:1"}}If a
column named ENABLED_FLAG exists in the validation table, Oracle
Application Object Library stores that column name in
ENABLED_COLUMN_NAME. Otherwise, Oracle Application Object Library
stores Y in ENABLED_COLUMN_NAME.
{{"bul:1"}}If columns named
START_DATE_ACTIVE and END_DATE_ACTIVE exist in the validation
table, Oracle Application Object Library stores those column names
in START_DATE_COLUMN_NAME and END_DATE_COLUMN_NAME. Otherwise
Oracle Application Object Library stores NULL in those columns.
{{"bodytext"}}
If your validation table contains these types of columns but your
columns have different names, you can manually update this table's
values to reflect your column names after you have already
registered your validation table. However, in almost all cases,
your table's column names should correspond to Oracle Application
Object Library recommended column names.
.
You need one row for each table validated value set defined in
Oracle Application Object Library. Oracle
Application Object Library uses this information to allow users to
use application tables to ensure that flexfield segments contain
valid values.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_FLEX_VALIDATION_TABLES_U1	NORMAL	UNIQUE	APPS_TS_SEED	FLEX_VALUE_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FLEX_VALUE_SET_ID	NUMBER	(10)	Yes	Flexfield value set identifier
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
APPLICATION_TABLE_NAME	VARCHAR2	(240)	Yes	Table name
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
VALUE_COLUMN_NAME	VARCHAR2	(240)	Yes	Value column name
VALUE_COLUMN_TYPE	VARCHAR2	(1)	Yes	Value column type
VALUE_COLUMN_SIZE	NUMBER	(3)	Yes	Size of value column
COMPILED_ATTRIBUTE_COLUMN_NAME	VARCHAR2	(240)	Yes	The column name COMPILED_VALUE_ATTRIBUTES if the column exists in the validation table
ENABLED_COLUMN_NAME	VARCHAR2	(240)	Yes	The column name ENABLED_FLAG if the column exists in the validation table
HIERARCHY_LEVEL_COLUMN_NAME	VARCHAR2	(240)	Yes	The column name STRUCTURED_HIERARCHY_LEVEL if the column exists in the validation table
START_DATE_COLUMN_NAME	VARCHAR2	(240)	Yes	The column name START_DATE_ACTIVE if the column exists in the validation table
END_DATE_COLUMN_NAME	VARCHAR2	(240)	Yes	The column name END_DATE_ACTIVE if the column exists in the validation table
SUMMARY_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the parent value is allowed to be stored in the FND_FLEX_VALUES table and displayed in the LOV for a segment using this value set
SUMMARY_COLUMN_NAME	VARCHAR2	(240)	Yes	The column name SUMMARY_FLAG if the column exists in the validation table
ID_COLUMN_NAME	VARCHAR2	(240)		Hidden ID column name
ID_COLUMN_SIZE	NUMBER	(3)		Size of ID column
ID_COLUMN_TYPE	VARCHAR2	(1)		ID column type
MEANING_COLUMN_NAME	VARCHAR2	(240)		Meaning column name
MEANING_COLUMN_SIZE	NUMBER	(3)		Size of meaning column
MEANING_COLUMN_TYPE	VARCHAR2	(1)		Meaning column type
TABLE_APPLICATION_ID	NUMBER	(10)		Table application identifier
ADDITIONAL_QUICKPICK_COLUMNS	VARCHAR2	(240)		Additional columns to display in the LOV list
ADDITIONAL_WHERE_CLAUSE	LONG	(0)		The SQL WHERE clause

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FLEX_VALUE_SET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      APPLICATION_TABLE_NAME
,      LAST_UPDATE_LOGIN
,      VALUE_COLUMN_NAME
,      VALUE_COLUMN_TYPE
,      VALUE_COLUMN_SIZE
,      COMPILED_ATTRIBUTE_COLUMN_NAME
,      ENABLED_COLUMN_NAME
,      HIERARCHY_LEVEL_COLUMN_NAME
,      START_DATE_COLUMN_NAME
,      END_DATE_COLUMN_NAME
,      SUMMARY_ALLOWED_FLAG
,      SUMMARY_COLUMN_NAME
,      ID_COLUMN_NAME
,      ID_COLUMN_SIZE
,      ID_COLUMN_TYPE
,      MEANING_COLUMN_NAME
,      MEANING_COLUMN_SIZE
,      MEANING_COLUMN_TYPE
,      TABLE_APPLICATION_ID
,      ADDITIONAL_QUICKPICK_COLUMNS
,      ADDITIONAL_WHERE_CLAUSE
FROM APPLSYS.FND_FLEX_VALIDATION_TABLES;

Dependencies

[top of page]

APPLSYS.FND_FLEX_VALIDATION_TABLES does not reference any database object

APPLSYS.FND_FLEX_VALIDATION_TABLES is referenced by following:

APPS: FND_FLEX_VALIDATION_TABLES