SELECT
    /*+ parallel (16) */
    TRUNC(ordercreationdate, 'mi') fecha,
    'Ordenes Creadas' metrica,
    oh.requesttype,
    OH.STATUS,
    OH.MILESTONE,
    JSON_VALUE(LTRIM(CDRO_CH.DATA, '$JSON'),
    '$.orderCommercialChannel') CHANNEL,
    COUNT(1) total
FROM
    eoc.OM_ORDER_HEADER_POSTPAID OH,
    eoc.CWORDERINSTANCE oi,
    EOC.cwt_do_relatedobjects CDRO_CH
WHERE
    oh.ordercreationdate >= CAST(:sql_last_value AS DATE)
    AND oh.REQUESTNUMBER = oi.ORDERNUM
    AND oi.ORDERROLE = 'Q'
    AND oh.cworderid = cdro_ch.orderid
    AND CDRO_CH.NAMESEARCHKEY = 'RelatedEntity/Channel'
GROUP BY
    TRUNC(ordercreationdate, 'mi'),
    oh.requesttype,
    OH.STATUS,
    OH.MILESTONE,
    JSON_VALUE(LTRIM(CDRO_CH.DATA, '$JSON'),
    '$.orderCommercialChannel')