Job Req DFF - For Replacement showing duplicates in Valueset
Summary:
On The Job Req we have an option to select that it is a replacement for an employee.
Here is my Value Set:
From Clause “PER_ALL_PEOPLE_F PAPF,PER_PERSON_NAMES_F PPNF”
Value Column Name “PAPF.PERSON_NUMBER||' - '||PPNF.DISPLAY_NAME”
Where “1 = 1
AND TRUNC(SYSDATE)BETWEEN PAPF.EFFECTIVE_START_DATE AND
PAPF.EFFECTIVE_END_DATE
AND PPNF.PERSON_ID=PAPF.PERSON_ID”
Oreder by clause “1”
But it shows multiple options for each employee - is there a way to remove duplicates or add the assignment number to it?
Content (please ensure you mask any confidential information):