$FLEX$ is used in value sets to get the selected value of some other value set on a field on the form.
So you could compare that value with a column in second value set and get the filtered result.
Let me show you through an example if you could not understand :)
Lets create two independent value sets.
Value set 1
Enter values
Value set 2
Enter values
Scenario: I attached value set1 to form field 1 and created a Table validated value set and fetched the values from value set 2 on the basis of value selected in value set 1
How to create Table Validated Value set
Here are creation details of Table validated value set
TABLE NAME: fnd_flex_values_vl ffvv , FND_FLEX_VALUE_SETS ffvs
WHERE CLAUSE:
where ffvv.flex_value_set_id = ffvs.flex_value_set_id
So you could compare that value with a column in second value set and get the filtered result.
Let me show you through an example if you could not understand :)
Lets create two independent value sets.
Value set 1
Enter values
Value set 2
Scenario: I attached value set1 to form field 1 and created a Table validated value set and fetched the values from value set 2 on the basis of value selected in value set 1
How to create Table Validated Value set
Here are creation details of Table validated value set
Press Edit Information
WHERE CLAUSE:
where ffvv.flex_value_set_id = ffvs.flex_value_set_id
and ffvs.flex_value_set_name = 'XX_FLEX_2_VALUE_SET'
and ffvv.description = :$FLEX$.XX_FLEX_1_VALUE_SET
Value selected in field 1 is matched to description in XX_FLEX_2_VALUE_SET.
I attached value set 1 to form filed 1 and XX_FLEX_USAGE to form filed 2.
Here is the result.
Bingo...We achieved the result...
0 comments