> select q.lager SITE,
>        q.id_klient CLIENTE,
>        SYSDATE DATA,
>        q.id_artikel PRODUTO,
>        ar.bez_1 DESCRICAO,
>        ar.art_mat FAMILIA,
>        ar.gr_waren GRUPO,
>        ar.art_art SUBGRUPO,
>        AR.STAT ATIVO,
>        round(sum(q.mng_frei))QTD,
>          decode(fct_ret_dias_sem_giro(V_ID_ARTIKEL => Q.ID_ARTIKEL),-1,'SEM GIRO',fct_ret_dias_sem_giro(V_ID_ARTIKEL =>
> Q.ID_ARTIKEL))DIAS_SEM_GIRO from quanten q, artikel ar, we we where
> q.lager = q.lager and   q.id_klient = q.id_klient and   q.id_artikel =
> q.id_artikel and q.id_klient = ar.id_klient and q.id_artikel =
> ar.id_artikel and q.nr_we = we.nr_we and q.mng_frei > 0 and q.bereich
> <> 'AD' and we.typ_we <> 'KR'
> --and q.id_artikel = '605323' and (trunc(sysdate)-trunc(we.datum_we)) >30 having fct_ret_dias_sem_giro(V_ID_ARTIKEL => Q.ID_ARTIKEL) >= 30 or  fct_ret_dias_sem_giro(V_ID_ARTIKEL => Q.ID_ARTIKEL)= -1 group by
> q.lager,q.id_klient,sysdate,q.id_artikel,ar.bez_1,TRUNC(SYSDATE),ar.art_mat,ar.gr_waren,ar.art_art,ar.stat
> ;