ORA-06550: line 5, column 1:
PLS-00103: Encountered the symbol "WITH" when expecting one of the following:

   begin function pragma procedure subtype type <an identifier>
   <a double-quoted delimited-identifier> current cursor delete
   exists prior

1 rows affected

dbms_output:

with cntp as (select distinct 
cnt.code code_container,
*STUFF*
FROM container cnt

WHERE 

cnt.status !='DESTROYED'
order by cnt.code)

SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2022
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2022','DD/MM/YYYY') AND TO_DATE('31/12/2022','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2023
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2023','DD/MM/YYYY') AND TO_DATE('31/12/2023','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2024
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2024','DD/MM/YYYY') AND TO_DATE('31/12/2024','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2025
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2025','DD/MM/YYYY') AND TO_DATE('31/12/2025','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2026
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2026','DD/MM/YYYY') AND TO_DATE('31/12/2026','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2027
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2027','DD/MM/YYYY') AND TO_DATE('31/12/2027','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2028
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2028','DD/MM/YYYY') AND TO_DATE('31/12/2028','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2029
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2029','DD/MM/YYYY') AND TO_DATE('31/12/2029','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2030
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2030','DD/MM/YYYY') AND TO_DATE('31/12/2030','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2031
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2031','DD/MM/YYYY') AND TO_DATE('31/12/2031','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

UNION
SELECT cntp.code_container *STUFF*
FROM cntp 
GROUP BY cntp.code_container ,cntp.label_container, cntp.Plan_Classement, Years
HAVING
cntp.Years=2032
AND
MAX(TO_DATE(cntp.DISPOSITION_DATE,'DD/MM/YYYY')) BETWEEN TO_DATE('01/01/2032','DD/MM/YYYY') AND TO_DATE('31/12/2032','DD/MM/YYYY')
AND SUM(cntp.IsA)=0
AND SUM(cntp.IsB)=0

;