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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

DISTINCT values in table based value set with multiple tables in FROM clause

edited Nov 4, 2024 2:29PM in Human Capital Management 1 comment

Summary:

I am trying to create a value set which has multiple tables in FROM clause and SELECT clause has just one column. Need DISTINCT values and for that I tried using ROWID as suggested in this forum but its not working when there are multiple tables. Below is the query I am trying to create a value set on.

SELECT DISTINCT PECT.CLASSIFICATION_NAME FROM
pay_balance_types_vl PBT , pay_balance_feeds_f PBF , pay_element_types_vl PET , PAY_ELE_CLASSIFICATIONS_VL PECT
WHERE
PBT.BALANCE_TYPE_ID = PBF.BALANCE_TYPE_ID
AND TRUNC(SYSDATE) BETWEEN PBF.EFFECTIVE_START_DATE AND PBF.EFFECTIVE_END_DATE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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