Message Oracle ORA-38501 - sub-query not allowed in the expression

ERRORsub-query not allowed in the expression
CAUSEAn attempt was made to use a sub-query in the expression.
ACTIONDo not use sub-queries in the expressions.