Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Cambios de Precios que se van a ejecutar el día de hoy en RPM
SELECT DECODE (PRICE_EVENT_TYPE,
'PC',
'Cambios de Precio',
'PS',
'Inicio de Promocion',
'PE',
'Fin de Promocion') PRICE_EVENT_TYPE,
DECODE (STATUS,
'N',
'Nuevo / Por Comenzar',
'C',
'Completado') STATUS,
COUNT ( * )
FROM rpm_price_event_thread_status
GROUP BY PRICE_EVENT_TYPE, status
ORDER BY 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.