Award DFF to be read only and populated with a value
Summary:
I am trying to write a table validation value set to be used on a DFF to populate a read only field with the num defined in another value set. Can we use a bind variable to point to the award number? It is working when pointing to another DFF but having issues pointing to the award number.
Value set: Award to Num
Flex_Value | FFVV.description |
---|---|
Award A | 123 |
Award B | 234 |
Award C | 456 |
Value set: Table Validation AwardNum_View
select substr(FFVV.description ,1,25)
from FND_FLEX_VALUES_VL FFVV
where
value_category = 'Award and Num'
AND FFVV.ENABLED_FLAG = 'Y'