In Oracle Quality, Collection Elements can use SQL validation code to provide a LOV for data entry into a Collection Plan.
Collection Element values can also be determined using SQL code that includes using Token field values for data already entered into the current Collection Plan (e.g. JOB) as part of the query. However, the result of this query must be a unique value.
Can anyone tell me if its possible to use Token fields from Collection Elements already entered into a Collection Plan as part of the validation code to display a LOV?
I cannot see any way to do this.
I'm a newbie and it got posted there by accident.
I did notice this afterwards but then couldn't find somewhere for "EBS Discrete Manufacturing".
What's the best place for it and can it be moved there without me resending it?