This discussion is archived
2 Replies Latest reply: Dec 18, 2012 1:05 AM by 853595 RSS

Oracle 11i - Collection Plans (Discrete Manufacturing)

853595 Newbie
Currently Being Moderated
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.
Thanks

Edited by: user11340385 on Dec 17, 2012 11:29 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points