[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 20 |
PCT Used: |
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 |
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 |
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 |
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
FROM APPLSYS.FND_FLEX_VALIDATION_QUALIFIERS;
APPLSYS.FND_FLEX_VALIDATION_QUALIFIERS does not reference any database object
APPLSYS.FND_FLEX_VALIDATION_QUALIFIERS is referenced by following:
|
|
|