Oracle 11g Release 2

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

WITH t(id,lotyp,proid,lockr) AS
(
 SELECT 'XXXXX', '06',  '01',  'Y' FROM dual UNION ALL
 SELECT 'XXXXX', '06',  '02',  'X' FROM dual UNION ALL
 SELECT 'XXXXX', '06',  '02',  'S' FROM dual UNION ALL
 SELECT 'XXXXX', '06',  '01',  'R' FROM dual UNION ALL
 SELECT 'XXXXX', '02',  '01',  'Y' FROM dual UNION ALL
 SELECT 'XXXXX', '02',  '02',  'X' FROM dual UNION ALL
 SELECT 'XXXXX', '02',  '02',  'S' FROM dual UNION ALL
 SELECT 'XXXXX', '02',  '01',  'R' FROM dual UNION ALL
 SELECT 'YYYYY', '06',  '01',  'Y' FROM dual UNION ALL
 SELECT 'YYYYY', '06',  '02',  'X' FROM dual UNION ALL
 SELECT 'YYYYY', '06',  '02',  'S' FROM dual UNION ALL
 SELECT 'YYYYY', '06',  '01',  'R' FROM dual UNION ALL
 SELECT 'YYYYY', '02',  '01',  'Y' FROM dual UNION ALL
 SELECT 'YYYYY', '02',  '02',  'X' FROM dual UNION ALL
 SELECT 'YYYYY', '02',  '02',  'S' FROM dual UNION ALL
 SELECT 'YYYYY', '02',  '01',  'R' FROM dual
) 
SELECT *
  FROM
  (
    SELECT id,lotyp||proid As title,
           LISTAGG(lockr,',') WITHIN GROUP (ORDER BY lotyp||proid) AS value
      FROM t
     GROUP BY id,lotyp||proid )
 PIVOT (
         MAX(value) FOR title IN ('0201' AS "0201",
                                  '0202' AS "0202",
                                  '0601' AS "0601",
                                  '0602' AS "0602"))   
 ORDER BY id

ID	0201	0202	0601	0602
XXXXX	R,Y	S,X	R,Y	S,X
YYYYY	R,Y	S,X	R,Y	S,X