Assistance Needed: Value Set SQL Query (UNION Constraint) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Assistance Needed: Value Set SQL Query (UNION Constraint)

Hi All,
I need some help adding a specific SQL query to a Value Set. The main thing is, I can only use UNION to get the data I need.

Please note, the FROM clause has a 200-character limit.If you've worked on similar requirements, any guidance would be greatly appreciated.

Query :-
Select EMP.DISPLAY_VALUEFROM (SELECT    pj.JOB_CODE || ' - ' || pj.NAME || ' - ' || ppnf.display_name AS DISPLAY_VALUE,    pj.JOB_ID AS RETURN_VALUE -- Assuming you need a return value, e.g., JOB_IDFROM    PER_JOBS_F_VL pj,    per_person_names_f ppnf,    per_all_assignments_f paaf,    HR_ORGANIZATION_UNITS BU_UNITWHERE    PJ.ACTIVE_STATUS = 'A'    AND PJ.ATTRIBUTE2 = 'Y' -- This is the key filter on Job Page    AND pj.job_id = paaf.job_id    AND paaf.assignment_type = 'E'    AND paaf.assignment_status_type = 'ACTIVE'    AND ppnf.person_id = paaf.person_id    AND ppnf.name_type = 'GLOBAL'    AND BU_UNIT.ORGANIZATION_ID = paaf.BUSINESS_UNIT_ID    AND BU_UNIT.NAME = '****'    AND TRUNC(paaf.effective_end_date)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!