Relatório

[digo_neves 0]

Prezados colegas, poderiam me ajudar a solucionar o problema deste relatório?

-- Start of DDL Script for View DBAMV.VDIC_REL_MOVDOC

-- Generated 15-set-2014 13:32:14 from DBAMV@producao


CREATE OR REPLACE VIEW vdic_rel_prod_scma (
   USUARIO,
   DS_USUARIO,
   AGENDADO,
   ENCAIXE,
   CANCELADO,
   DATA
    )
AS
select  SELECT  USUARIO,
        DS_USUARIO,
        COUNT(AGENDADO)     AGENDADO,
        COUNT(ENCAIXE)      ENCAIXE,
        COUNT(CANCELADO)    CANCELADO,
        data_agenda         DATA


FROM    (


select  v.cod_usuario_agendamento                   Usuario,
        v.nm_usuario_agendamento                    DS_usuario,
        decode(v.tipo_situacao, 'A', 'Agendado')    Agendado,
        ''                                          Encaixe,
        ''                                          Cancelado
from    dbamv.vdic_horarios_agenda_scma v
where   v.data_agenda between '01/ago/2014' and '31/ago/2014'
and     v.tipo_situacao = 'A'


union  all


select  v.cod_usuario_agendamento                   Usuario,
        v.nm_usuario_agendamento                    DS_usuario,
        ''                                          Agendado,
        decode(v.tipo_situacao, 'E', 'Encaixe')     Encaixe,
        ''                                          Cancelado                                
from    dbamv.vdic_horarios_agenda_scma v
where   v.data_agenda between '01/ago/2014' and '31/ago/2014'
and     v.tipo_situacao = 'E'


union all


select  v.cod_usuario_agendamento                   Usuario,
        v.nm_usuario_agendamento                    DS_usuario,
        ''                                          Agendado,
        ''                                          Encaixe,  
        decode(v.tipo_situacao, 'C', 'Cancelado')   Cancelado
from    dbamv.vdic_horarios_agenda_scma v
where   v.data_agenda between '01/ago/2014' and '31/ago/2014'
and     v.tipo_situacao = 'C')


GROUP BY    USUARIO,
            DS_USUARIO
            
ORDER BY 1
/
-- Grants for View
GRANT DELETE ON vdic_rel_prod_scma TO mv2000
/


GRANT INSERT ON vdic_rel_prod_scma TO mv2000
/
GRANT SELECT ON vdic_rel_prod_scma TO mv2000
/
GRANT UPDATE ON vdic_rel_prod_scma TO mv2000
/
GRANT DELETE ON vdic_rel_prod_scma TO dbaps
/
GRANT INSERT ON vdic_rel_prod_scma TO dbaps
/
GRANT SELECT ON vdic_rel_prod_scma TO dbaps
/
GRANT UPDATE ON vdic_rel_prod_scma TO dbaps
/
GRANT DELETE ON vdic_rel_prod_scma TO dbasgu
/
GRANT INSERT ON vdic_rel_prod_scma TO dbasgu
/
GRANT SELECT ON vdic_rel_prod_scma TO dbasgu
/
GRANT UPDATE ON vdic_rel_prod_scma TO dbasgu
/
GRANT DELETE ON vdic_rel_prod_scma TO mvintegra
/
GRANT INSERT ON vdic_rel_prod_scma TO mvintegra
/
GRANT SELECT ON vdic_rel_prod_scma TO mvintegra
/
GRANT UPDATE ON vdic_rel_prod_scma TO mvintegra
/


-- End of DDL Script for View DBAMV.VDIC_REL_MOVDOC
*/

[Motta 645]

Mas qual o problema ?!