Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE SUBSCRIPTIONS(
SUBSCRIPTION_ID NUMBER,
PARAMETERS_XML  CLOB
);
insert into subscriptions (subscription_id, parameters_xml)
values (553219, to_clob('<Model>
  <Parameters>
    <Parameter>
      <userParameter>outlets</userParameter>
       <Values>
         <Value>45</Value>
         <Value>676</Value>
         <Value>1502</Value>
         ...
       </Values>
    </Parameter>
  </Parameters>
</Model>'));
1 rows affected

SELECT
s.SUBSCRIPTION_ID,
s.PARAMETERS_XML,
xt.*
FROM SUBSCRIPTIONS s,
XMLTABLE(
    '/Model/Parameters/Parameter'
    PASSING XMLTYPE(s.PARAMETERS_XML)
    COLUMNS USER_PARAM  VARCHAR2(100)  PATH 'userParameter',
    PARAM_VALUE VARCHAR2(1000) PATH '//*:Values',
    CHECKED_LIST_EXCLUDE VARCHAR2(100) PATH '//*:CheckedListExclude'                        
) xt ORDER BY 1 DESC;


SUBSCRIPTION_ID
PARAMETERS_XML
USER_PARAM
PARAM_VALUE
CHECKED_LIST_EXCLUDE


553219
<Model>
  <Parameters>
    <Parameter>
      <userParameter>outlets</userParameter>
       <Values>
         <Value>45</Value>
         <Value>676</Value>
         <Value>1502</Value>
         ...
       </Values>
    </Parameter>
  </Parameters>
</Model>
outlets
456761502
         ...
       
null


SELECT
    s.SUBSCRIPTION_ID,
    xt1.USER_PARAM,
    xt2.PARAM_VALUE,
    xt1.CHECKED_LIST_EXCLUDE
FROM SUBSCRIPTIONS s
CROSS APPLY XMLTABLE(
    '/Model/Parameters/Parameter'
    PASSING XMLTYPE(s.PARAMETERS_XML)
    COLUMNS USER_PARAM  VARCHAR2(100)  PATH 'userParameter',
    PARAM_VALUES XMLTYPE PATH '//*:Values',
    CHECKED_LIST_EXCLUDE VARCHAR2(100) PATH '//*:CheckedListExclude'
) xt1
OUTER APPLY XMLTABLE(
    '/*:Values/Value'
    PASSING xt1.PARAM_VALUES
    COLUMNS PARAM_VALUE VARCHAR2(1000) PATH '.'
) xt2
ORDER BY 1 DESC;


SUBSCRIPTION_ID
USER_PARAM
PARAM_VALUE
CHECKED_LIST_EXCLUDE


553219
outlets
45
null

553219
outlets
1502
null

553219
outlets
676
null


SELECT
    s.SUBSCRIPTION_ID,
    xt1.USER_PARAM,
    LISTAGG(xt2.PARAM_VALUE, ',') WITHIN GROUP (ORDER BY xt2.PARAM_VALUE) as PARAM_VALUES,
    xt1.CHECKED_LIST_EXCLUDE
FROM SUBSCRIPTIONS s
CROSS APPLY XMLTABLE(
    '/Model/Parameters/Parameter'
    PASSING XMLTYPE(s.PARAMETERS_XML)
    COLUMNS USER_PARAM  VARCHAR2(100)  PATH 'userParameter',
    PARAM_VALUES XMLTYPE PATH '//*:Values',
    CHECKED_LIST_EXCLUDE VARCHAR2(100) PATH '//*:CheckedListExclude'
) xt1
OUTER APPLY XMLTABLE(
    '/*:Values/Value'
    PASSING xt1.PARAM_VALUES
    COLUMNS PARAM_VALUE VARCHAR2(1000) PATH '.'
) xt2
GROUP BY
    s.SUBSCRIPTION_ID,
    xt1.USER_PARAM,
    xt1.CHECKED_LIST_EXCLUDE
ORDER BY 1 DESC;


SUBSCRIPTION_ID
USER_PARAM
PARAM_VALUES
CHECKED_LIST_EXCLUDE


553219
outlets
1502,45,676
null
SUBSCRIPTION_ID	USER_PARAM	PARAM_VALUE	CHECKED_LIST_EXCLUDE
553219	outlets	45	null
553219	outlets	1502	null
553219	outlets	676	null