Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
DISTINCT values in table based value set with multiple tables in FROM clause
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:
0