Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE /*M.*/AD (DE, AT, LO) AS
SELECT 1.01, 1, 0 FROM DUAL UNION ALL
SELECT 1.02, 1, 0 FROM DUAL UNION ALL
SELECT 1.11, 1, 1 FROM DUAL UNION ALL
SELECT 1.12, 1, 1 FROM DUAL UNION ALL
SELECT 2.01, 2, 0 FROM DUAL UNION ALL
SELECT 2.02, 2, 0 FROM DUAL UNION ALL
SELECT 2.21, 2, 2 FROM DUAL UNION ALL
SELECT 2.22, 2, 2 FROM DUAL UNION ALL
SELECT 3.01, 3, 0 FROM DUAL UNION ALL
SELECT 3.11, 3, 1 FROM DUAL UNION ALL
SELECT 3.12, 3, 1 FROM DUAL UNION ALL
SELECT 3.21, 3, 2 FROM DUAL;
12 rows affected

SELECT *
FROM  ( SELECT DE, AT, LO
        FROM   /*M.*/AD
      )
      PIVOT (
        MAX(DE) AS DE
        FOR (LO) IN(0 AS LO0, 1 AS LO1, 2 AS LO2)
      )
WHERE (  LO0_DE IS NULL
      OR LO1_DE IS NULL
      OR LO2_DE IS NULL
      );


AT
LO0_DE
LO1_DE
LO2_DE


1
1.02
1.12
null

2
2.02
null
2.22