ativ() {
            return con.execute("SELECT PCPEDC.CODFILIAL, PCPEDC.CODCLI, PCCLIENT.CLIENTE, PCCARREG.NUMCAR, PCPEDC.NUMPED, PCROTAEXP.DESCRICAO ROTA, PCPRACA.PRACA, PCPEDC.DATA ||' '||  HORA||  ':' ||MINUTO PEDIDO, PCPEDC.DTLIBERA AS LIBERACAO, PCCARREG.datamon ||' '|| DECODE(PCCARREG.HORAMON, null,'',PCCARREG.HORAMON ||':') || PCCARREG.MINUTOMON AS MONTAGEM, PCPEDC.dtfat ||' '|| DECODE(PCPEDC.HORAFAT, null,'',PCPEDC.HORAFAT ||':')  ||   MINUTOFAT FATURAMENTO, E.DATAHORA AS ENTREGA,(CASE when PCPEDC.POSICAO = 'F' AND E.datahora IS NOT NULL THEN 'PEDIDO ENTREGUE' when PCPEDC.posicao = 'L' THEN 'PEDIDO CONFIRMADO' when PCPEDC.posicao = 'M' THEN 'PEDIDO EM SEPARAÇÃO' when PCPEDC.POSICAO = 'F' AND E.datahora IS NULL THEN 'PEDIDO PREPARADO PARA O ENVIO' END) AS STATUS FROM PCPEDC, PCCARREG, PCCLIENT,PCPRACA, PCROTAEXP, FUSIONTRAK_INT_EVENTOS E WHERE (   ((PCPEDC.CONDVENDA IN (1,5,10)) AND (PCPEDC.ORIGEMPED NOT IN ('B', 'R'))) OR ( (PCPEDC.CONDVENDA = 8) AND ((SELECT COUNT (NUMPED) FROM PCPEDI PI WHERE PI.NUMPED = PCPEDC.NUMPED AND PI.TIPOENTREGA IN ('EN', 'EF')) > 0))) AND ( PCPEDC.CODFILIAL IN (1,2,3,4,5,6 )) AND PCCARREG.NUMCAR = PCPEDC.NUMCAR AND PCPEDC.CODCLI = PCCLIENT.CODCLI AND PCPRACA.ROTA = PCROTAEXP.CODROTA AND PCPEDC.CODPRACA = PCPRACA.CODPRACA AND PCPEDC.NUMPED = E.SEQ_PEDIDO_ERP(+) AND E.DESCRICAO(+) = 'Entrega Realizada'AND PCPEDC.NUMPED = :NUMPED ");
        },