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

TABLE: APPLSYS.FND_FLEX_EXCLUDE_RULE_LINES

Object Details
Object Name: FND_FLEX_EXCLUDE_RULE_LINES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_FLEX_EXCLUDE_RULE_LINES
Subobject Name:
Status: VALID


FND_FLEX_EXCLUDE_RULE_LINES stores cross-validation rule elements
broken out into individual columns for key flexfield exclude rule
lines. This table duplicates information contained in
FND_FLEX_VALIDATION_RULE_LINES and is only used for validating
combinations with the server validation functions. The table contains
one row for each row of the FND_FLEX_VALIDATION_RULE_LINES table that
has the include_exclude_indicator value of 'E' (exclude). The
RULE_LINE_ID column is a primary key and a foreign key reference to
FND_FLEX_VALIDATION_RULE_LINES. The APPLICATION_ID, ID_FLEX_CODE,
ID_FLEX_NUM, and FLEX_VALIDATION_RULE_NAME columns are a multi-column
foreign key that uniquely identifies the cross-validation rule to
which the line is associated. The ENABLED_FLAG column indicates
whether this rule line is enabled ('Y' or 'N'). The SEGMENT_LOW
and SEGMENT_HIGH columns store the minimum and maximum values of
segment n that should be excluded by this line. Segments are
numbered from 1 to 30 in the order in which they are stored in the
CONCATENATED_SEGMENTS_LOW and CONCATENATED_SEGMENTS_HIGH columns of
FND_FLEX_VALIDATION_RULE_LINES (display order). The key flexfield
combination is excluded only if each segment value falls within its
low-high range for every segment in the combination. A null value in
the SEGMENT_LOW (SEGMENT_HIGH) column indicates that there is
no lower (upper) bound on the range of values to be excluded.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_FLEX_EXCLUDE_RULE_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnRULE_LINE_ID
FND_FLEX_EXCLUDE_RULE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnAPPLICATION_ID
ColumnID_FLEX_CODE
ColumnID_FLEX_NUM
Columns
Name Datatype Length Mandatory Comments
RULE_LINE_ID NUMBER (15) Yes Rule line identifier
APPLICATION_ID NUMBER (10) Yes Application identifier
ID_FLEX_CODE VARCHAR2 (4) Yes Key flexfield code
ID_FLEX_NUM NUMBER (15) Yes Structure number of the key flexfield structure
FLEX_VALIDATION_RULE_NAME VARCHAR2 (15) Yes Name of cross-validation rule
ENABLED_FLAG VARCHAR2 (1) Yes Indicates whether this rule is enabled
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
SEGMENT1_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT1_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT2_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT2_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT3_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT3_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT4_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT4_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT5_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT5_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT6_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT6_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT7_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT7_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT8_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT8_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT9_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT9_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT10_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT10_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT11_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT11_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT12_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT12_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT13_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT13_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT14_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT14_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT15_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT15_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT16_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT16_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT17_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT17_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT18_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT18_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT19_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT19_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT20_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT20_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT21_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT21_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT22_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT22_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT23_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT23_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT24_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT24_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT25_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT25_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT26_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT26_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT27_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT27_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT28_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT28_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT29_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT29_HIGH VARCHAR2 (150)
Maximum value to exclude
SEGMENT30_LOW VARCHAR2 (150)
Minimum value to exclude
SEGMENT30_HIGH VARCHAR2 (150)
Maximum value to exclude
Query Text

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


SELECT RULE_LINE_ID
,      APPLICATION_ID
,      ID_FLEX_CODE
,      ID_FLEX_NUM
,      FLEX_VALIDATION_RULE_NAME
,      ENABLED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SEGMENT1_LOW
,      SEGMENT1_HIGH
,      SEGMENT2_LOW
,      SEGMENT2_HIGH
,      SEGMENT3_LOW
,      SEGMENT3_HIGH
,      SEGMENT4_LOW
,      SEGMENT4_HIGH
,      SEGMENT5_LOW
,      SEGMENT5_HIGH
,      SEGMENT6_LOW
,      SEGMENT6_HIGH
,      SEGMENT7_LOW
,      SEGMENT7_HIGH
,      SEGMENT8_LOW
,      SEGMENT8_HIGH
,      SEGMENT9_LOW
,      SEGMENT9_HIGH
,      SEGMENT10_LOW
,      SEGMENT10_HIGH
,      SEGMENT11_LOW
,      SEGMENT11_HIGH
,      SEGMENT12_LOW
,      SEGMENT12_HIGH
,      SEGMENT13_LOW
,      SEGMENT13_HIGH
,      SEGMENT14_LOW
,      SEGMENT14_HIGH
,      SEGMENT15_LOW
,      SEGMENT15_HIGH
,      SEGMENT16_LOW
,      SEGMENT16_HIGH
,      SEGMENT17_LOW
,      SEGMENT17_HIGH
,      SEGMENT18_LOW
,      SEGMENT18_HIGH
,      SEGMENT19_LOW
,      SEGMENT19_HIGH
,      SEGMENT20_LOW
,      SEGMENT20_HIGH
,      SEGMENT21_LOW
,      SEGMENT21_HIGH
,      SEGMENT22_LOW
,      SEGMENT22_HIGH
,      SEGMENT23_LOW
,      SEGMENT23_HIGH
,      SEGMENT24_LOW
,      SEGMENT24_HIGH
,      SEGMENT25_LOW
,      SEGMENT25_HIGH
,      SEGMENT26_LOW
,      SEGMENT26_HIGH
,      SEGMENT27_LOW
,      SEGMENT27_HIGH
,      SEGMENT28_LOW
,      SEGMENT28_HIGH
,      SEGMENT29_LOW
,      SEGMENT29_HIGH
,      SEGMENT30_LOW
,      SEGMENT30_HIGH
FROM APPLSYS.FND_FLEX_EXCLUDE_RULE_LINES;

Dependencies

[top of page]

APPLSYS.FND_FLEX_EXCLUDE_RULE_LINES does not reference any database object

APPLSYS.FND_FLEX_EXCLUDE_RULE_LINES is referenced by following:

SchemaAPPS
SynonymFND_FLEX_EXCLUDE_RULE_LINES