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_QUALIFIERS

Object Details

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

FND_FLEX_VALIDATION_QUALIFIERS stores information about
flexfield qualifiers and segment qualifiers. Each row includes
a key flexfield code, a flexfield qualifier, a segment
qualifier, and the date these qualifiers were assigned to the
flexfield. You need one row for each qualifier assignment.
Oracle Application Object Library uses this information to
correctly interpret the denormalized qualifier information
stored in the column COMPILED_ATTRIBUTE_VALUES for the table
FND_FLEX_VALUES.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_FLEX_VALIDATION_QUALS_U1	NORMAL	UNIQUE	APPS_TS_SEED	FLEX_VALUE_SET_ID ID_FLEX_APPLICATION_ID ID_FLEX_CODE SEGMENT_ATTRIBUTE_TYPE VALUE_ATTRIBUTE_TYPE ZD_EDITION_NAME
FND_FLEX_VALIDATION_QUALS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	FLEX_VALUE_SET_ID ASSIGNMENT_DATE VALUE_ATTRIBUTE_TYPE SEGMENT_ATTRIBUTE_TYPE ID_FLEX_APPLICATION_ID ID_FLEX_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
FLEX_VALUE_SET_ID	NUMBER	(10)	Yes	The flexfield value set identifier
ID_FLEX_APPLICATION_ID	NUMBER	(10)	Yes	Key flexfield application identifier
ID_FLEX_CODE	VARCHAR2	(4)	Yes	Key flexfield code
SEGMENT_ATTRIBUTE_TYPE	VARCHAR2	(30)	Yes	Flexfield qualifier
VALUE_ATTRIBUTE_TYPE	VARCHAR2	(30)	Yes	Segment qualifier
ASSIGNMENT_DATE	DATE		Yes	When the qualifier was assigned to this value set
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT FLEX_VALUE_SET_ID
,      ID_FLEX_APPLICATION_ID
,      ID_FLEX_CODE
,      SEGMENT_ATTRIBUTE_TYPE
,      VALUE_ATTRIBUTE_TYPE
,      ASSIGNMENT_DATE
,      ZD_EDITION_NAME
FROM APPLSYS.FND_FLEX_VALIDATION_QUALIFIERS;

Dependencies

[top of page]

APPLSYS.FND_FLEX_VALIDATION_QUALIFIERS does not reference any database object

APPLSYS.FND_FLEX_VALIDATION_QUALIFIERS is referenced by following:

APPLSYS: FND_FLEX_VALIDATION_QUALIFIER#