Oracle Message ORA-22818 - subquery expressions not allowed here

ERRORsubquery expressions not allowed here
CAUSEAn attempt was made to use a subquery expression where these are not supported.
ACTIONRewrite the statement without the subquery expression.