I have a query written for the EBS Oracle Database. I have to convert it into a SPARK SQL query as I need to run the same query in my data warehousing tool. The Spark environment does not allow subqueries to use tables outside of their scope. I am not able to resolve the “exists” clauses here, can someone help?