Range elastic domain)

A range elastic domain is an extension of the key elastic domain used. It does not have a dedicated auto registration function, and all comes from the structure definition of the key elastic domain:
Application table
Create Table flex_rang_ln
(
Concatenated_segments_low varchar2 (300 ),
Concatenated_segments_high varchar2 (300 ),
Segmentlow low varchar2 (30 ),
Segment2_low varchar2 (30 ),
Segment3_low varchar2 (30 ),
Segment4_low varchar2 (30 ),
Segment5_low varchar2 (30 ),
Segment6_low varchar2 (30 ),
Segment7_low varchar2 (30 ),
Segment1_high varchar2 (30 ),
Segment2_high varchar2 (30 ),
Segment3_high varchar2 (30 ),
Segment4_high varchar2 (30 ),
Segment5_high varchar2 (30 ),
Segment6_high varchar2 (30 ),
Segment7_high varchar2 (30)
);
Note: segmentn_low and segmentn_high are used to store the upper and lower range segments, which must appear in the application table,
Concatenated_segments_low and concatenated_segments_high must also appear in pairs, because in the application script, you must specify
/* Create a synonym */
Create synonym flex_rang_ln for erp_dev.flex_rang_ln;
Fnd_range_flex.define (
Block => 'flex _ rang_ln ', -- block of the operation
Field => 'range _ flex ',-the created item is used to hold the range elastic field (there is no range_flex data item in the Form interface, only
Range_flex_low and range_flex_high data items)
Data_field => 'concatenated _ segments ', -- save the value of the range field (concatenated_segments_low and
Concatenated_segments_high)
Appl_short_name => 'edv ',
Code => 'K _ ln ', -- Key auto domain registration Code Fnd_id_flex_structures.id_flex_code
Num => '000000', -- fnd_id_flex_structures.id_flex_num displayable => '! All ',
Updateable => '! All ',
Insertable => '! All ',
Allownulls => 'y ');
When using range elastic domains, you do not need any registry and fields, because the values are saved in the application table and the referenced segment structure of the key elastic domains is true.

Code Description:
Field => 'range _ flex 'does not exist in the form interface. In this example, rang_flex_low and
Rang_flex_high two range items, used to load the range elastic domain

Data_field => 'concatenated _ segments 'does not exist in the form interface. In this example
Concatenated_segments_low and concatenated_segments _ high are two range items used to store the combination information of range elastic domains.
Segmentn_low and segmentn_high are the information of each segment in the upper and lower ranges, from which you can see the storage form of records.