Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement