with -- -> factored subqueries
  t1 as (select 1 id1 from dual)
, t2 as (select 1 id2 from dual)
, t3 as (select 1 id3 from dual)
select iv.*
       , (select 1 from dual) scalar
          -- -> scalar subqery
       , (select 1 from dual where iv.id1 * iv.id2 * iv.id3 = 1) corr_scalar
          -- -> correlated scalar subqery
from
(
select *
from (t1) -- -> table reference
join (t2 cross join t3) --> join clause
  on t1.id1 = t2.id2 * t3.id3
) iv -- > inline view
, lateral(select * from dual where iv.id1 * iv.id2 * iv.id3 = 1) --> lateral inline view
where (id1, id2, id3) in (select 1, 1, 1 from dual) --> nested subquery
and (id1, id2, id3) in ((1, 1, 1)) --> not a subquery
/

       ID1        ID2        ID3     SCALAR CORR_SCALAR
---------- ---------- ---------- ---------- -----------
         1          1          1          1           1