Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*) FROM ( SELECT T.*, DECODE(T.STATUS, 1, 'Ativo', 2, 'Pausado', 3, 'Cancelado', 4, 'Finalizado',5, 'Finalizado com Erro',6, 'Deletado', 'Outros') STATUSNOME FROM ( SELECT P.INSTANCIA_ID PROCESSO, P.STATUS, P.DESCRICAO, CAST(fnc_vlr_processo_campo(P.INSTANCIA_ID,'nroProcessoImportacao') AS NUMBER(15)) PROCESSOID FROM PROCESSO_INSTANCIA P, PROCESSO_VERSAO PV, PROCESSO PR WHERE PV.CODIGO = P.PROCESSO_VERSAO_FK AND PR.CODIGO = PV.PROCESSO_ID AND PR.BPMN_KEY = 'processRevisaoImportacao' ) t WHERE T.PROCESSOID = :1 ORDER BY 1 DESC ) main
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement