How to get the Distinct Values in TABLE Value set?

Method 1

Create the VIEW based on DISTINCT values; use the VIEW for creates the VALUESET.

Method 2

Paste the QUERY in TABLE field with alias name, and give the column name (with alias name).

(For an example):

TABLE: (SELECT  DISTINCT W.NAME,W.TRIP_ID,W.STATUS_NAME,WV.SOURCE_CODE,
WV.RELEASED_STATUS,WV.ORGANIZATION_ID,WV.INV_INTERFACED_FLAG FROM APPS.WSH_DELIVERABLE_TRIPS_V W,APPS.WSH_DELIVERABLES_V WV WHERE W.DELIVERY_DETAIL_ID=WV.DELIVERY_DETAIL_ID) Z

Value: Z.NAME
Id: Z.TRIP_ID

Ur's
AmarAlam