Dashboards
Nao foi possivel executar a query.
sql: SELECT
(SELECT COUNT(E02_NM_CLIENTE) FROM ENT_002 WHERE E02_CD_COMPANY='' AND E02_FL_ATIVO='S' AND E02_NM_CLIENTE IS NOT NULL ) AS TOTAL_CLIENTES,
(SELECT COUNT(P57_NR_PROCESSO) FROM PER_057 WHERE P57_CD_COMPANY='' AND P57_FL_TIPO='A' ) AS TOTAL_RNCS_ABERTAS,
(SELECT COUNT(P57_NR_PROCESSO) FROM PER_057 WHERE P57_CD_COMPANY='' AND P57_FL_TIPO='P' ) AS TOTAL_RNCS_PENDENTES,
(SELECT COUNT(P57_NR_PROCESSO) FROM PER_057 WHERE P57_CD_COMPANY='' AND P57_FL_TIPO='T' ) AS TOTAL_RNCS_TRATAMENTO,
(SELECT COUNT(P57_NR_PROCESSO) FROM PER_057 WHERE P57_CD_COMPANY='' AND P57_FL_TIPO='F' ) AS TOTAL_RNCS_FINALIZADAS
FROM ENT_001
Erro:Dynamic SQL Error SQL error code = -204 Table unknown PER_057 At line 3, column 49
Clientes Ativos
0
RNCs Abertas
0
RNCs Pendentes
0
RNCs Em Tratamento
0
RNCs Finalizadas
0
Status de RNCs