Table type value set [message #498878] |
Fri, 11 March 2011 13:32 |
|
barnanag
Messages: 2 Registered: March 2011
|
Junior Member |
|
|
Hi there,
I need to create a value set which accepts dates and add the following condition to it :$FLEX$.TEST_PROG_ENABLE_OD = 'Y'
In this way I must create a value set of table type validation, but must define a table and a column for the validation too. Is there any table which has a date type column and contains every day of the years? I tried to use the creation_date of the oe_order_headers_all table which works, but the validation takes more than 5 minutes, which is a lot.. Moreover, it is possible, that there is a date for which is no record in the oe_order_headers_all table...
Do you have any ideas?
Is that possible to use somehow that FLEX condition in a value set of Special type validation?
|
|
|
|
|
|