Exclude terminate assignment in list of values
Dear Oracle Community,
I would like to request assistance on how to exclude terminated assignments when I search for a position on the web page.
Please see the Value Sets for your reference.
Value Set Name: UP_HR_ASSIGNMENTS_FOR_PERSON_V2
List Type: List of Values
Security Type: No Security
Format Type: Char
Maximum Size: 250
Validation Type: Table
Validation Table Information
Table Application: Human Resources
Table Name: PER_ALL_ASSIGNMENTS_F PAF, PER_POSITIONS_V PPV, PER_ASSIGNMENT_STATUS_TYPES PAST, FND_USER FU
Table Columns: PPV.NAME
Type: Char
Size: 250
ID: PAF.ASSIGNMENT_ID
Type: Number
Size: 30
Where/Order By: