1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle quality collections element - sql validation

Discussion in 'Oracle SCM & Manufacturing' started by sri Harsha Challapalli, Feb 8, 2018.

  1. sri Harsha Challapalli

    sri Harsha Challapalli Premium Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    50
    Location:
    valders
    upload_2018-2-8_15-17-57.png
    The Above collection plan is based on back-end data

    upload_2018-2-8_15-18-56.png


    If I enter 217371 in Job# Collection element, can the list of values in Job_name be List of Values like Select distinct(Job_name) from the back end table where job# = &JOB#. (Where & Job number is the value entered in Job# Collection Element)

    Can you let me know the logic on how this can be done and where this logic needs to be updated( I believe it is at the collection element set up for Job NAme Collection Element)
     
    Last edited: Feb 8, 2018