EXISTS Clause in View criteria
Hi All
Jdeveloper 11.1.1.6.0
I have a VO in which I want to define a view criteria that is an EXISTS clause
SELECT bu_id,
contract,
...
...
from TABLE1 -------VO query ends here
AND EXISTS -------VC Starts
(
SELECT 1
FROM TABLE2
WHERE id = TABLE1.id
AND contract ='VALID'
AND type = :bindvar
) --------VC Ends
Is it possible to achieve it in ADF.
Thanks a lot