Created
October 14, 2016 01:28
-
-
Save arbo-hacker/03a7c4e346b3d9751e0c3bea2c426f02 to your computer and use it in GitHub Desktop.
Cambios de Precios que se van a ejecutar el día de hoy en RPM
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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