Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- to_char(v.dat_venda, 'DD/MM/YYYY') AS data_geracao,
- v.ind_status_faturamento,
- SUM (v.vlr_venda_abatido) AS total,
- COUNT (v. ID) AS qtd,
- cv. ID AS id_ciclo_venda
- FROM
- nacionallogistica.tb_ciclo_venda cv,
- nacionallogistica.tb_ponto_venda pv,
- nacionallogistica.tb_cliente cl,
- nacionallogistica.tb_venda v,
- nacionallogistica.tb_produto_distribuidor pd,
- nacionallogistica.tb_regional_marca_distribuidor rmd,
- nacionallogistica.tb_marca_distribuidor md
- WHERE
- cv.id_ponto_venda = pv. ID
- AND pv.id_cliente = cl. ID
- AND cl.id_empresa = 7
- AND v.ind_status_faturamento IN ('P', 'A', 'F')
- AND v.id_cobranca_vinculada = cv. ID
- AND v.id_produto_distribuidor = pd. ID
- AND pd.id_regional_marca_distribuidor = rmd. ID
- AND rmd.id_marca_distribuidor = md. ID
- AND md. ID IN (1, 3, 2, 4, 5, 8, 10, 11, 15, 16, 17, 18, 19, 20, 22)
- AND v.ind_faturada = 'S'
- AND v.dat_venda BETWEEN '2016-05-01 00:00:00' AND '2016-05-31 23:59:59'
- GROUP BY
- v.dat_venda,
- v.ind_status_faturamento,
- cv. ID
- ORDER BY
- v.dat_venda,
- v.ind_status_faturamento
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement