SQL> column null_column for a10
SQL> set null '<NULL>'
SQL>
SQL> -- prerequisite
SQL>
SQL> CREATE OR REPLACE FUNCTION f(X IN VARCHAR2) RETURN  SYS.ODCIVARCHAR2LIST
  2        PIPELINED IS
  3     BEGIN
  4        PIPE ROW(x);
  5        RETURN;
  6     EXCEPTION
  7        WHEN OTHERS THEN
  8           RETURN;
  9  END f;
 10  /

Function created.

SQL>
SQL>
SQL> -- /* To make the script idempotent uncomment the block below */
SQL>
SQL> -- begin
SQL> -- execute immediate 'DROP TABLE t';
SQL> -- exception
SQL> -- when others then null;
SQL> -- end;
SQL> -- /
SQL> --
SQL>
SQL> create table t(id primary key)
  2  as select rownum
  3  from dual connect by level <=100
  4  ;

Table created.

SQL>
SQL> SELECT X.NULL_COLUMN
  2  FROM
  3  (
  4    WITH FIRST_TABLE AS
  5    (
  6       SELECT  B.ID AS NULL_COLUMN
  7       FROM  T A
  8       LEFT OUTER JOIN T B ON 1=2
  9    ),
 10    SECOND_TABLE AS (
 11      SELECT A.NULL_COLUMN
 12      FROM FIRST_TABLE A
 13          ,FIRST_TABLE
 14      WHERE 1=1
 15        AND ROWNUM <=8 -- restriction to 8 rows is meaningless, just to reduce the amount of resultset
 16    ),
 17    PROBLEM AS (
 18      SELECT (SELECT MAX(column_value) FROM TABLE(CAST(f('X') AS SYS.ODCIVARCHAR2LIST))),
 19             (SELECT MIN(column_value) FROM TABLE(CAST(f('X') AS SYS.ODCIVARCHAR2LIST)))
 20       FROM  DUAL
 21    )
 22    SELECT  NULL_COLUMN
 23    FROM SECOND_TABLE
 24  ) X
 25  WHERE 1=1
 26  AND X.NULL_COLUMN IS NOT NULL;

NULL_COLUMN
-----------
<NULL>
<NULL>
<NULL>
<NULL>
<NULL>
<NULL>
<NULL>
<NULL>

8 rows selected.

alter session set "_with_subquery"=inline;

alter session set "_with_subquery"=inline;
alter session set "_optimizer_ansi_join_lateral_enhance" = false;