Table type value set [message #498878] |
Fri, 11 March 2011 13:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1ad9152e6a5358ca8ed6c14f9c3d7be1?s=64&d=mm&r=g) |
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?
|
|
|
|
|
|