Advertisement
Guest User

Untitled

a guest
Aug 13th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.73 KB | None | 0 0
  1. SELECT st.nrotabvenda,
  2.        aliquotast,
  3.        aliquota_st_bc,
  4.        base_calculo,      
  5.        tipo,
  6.        tp_aplica_base,
  7.        mva,
  8.        aliqst,
  9.        aliqicms,
  10.        reducao_vpe,
  11.        ind_calc_vpe,
  12.        aliqvpe,
  13.        pauta_st,      
  14.        nrotributacao
  15.   FROM poseidon.dpcv_vnd_produto_st st
  16.  WHERE st.nrotabvenda = 1
  17.    AND st.nroempresa = 1
  18.    AND st.seqproduto = 20;
  19.  
  20. SELECT ss.NROTABVENDA,
  21.        ss.tipo,
  22.        ss.tp_aplica_base,
  23.        ss.mva,
  24.        ss.aliqSt,
  25.        ss.aliqIcms,
  26.        ss.reducao_Vpe,
  27.        ss.ind_calc_Vpe,
  28.        ss.aliqVpe,
  29.        ss.Pauta_St
  30.   FROM poseidon.dpcv_vnd_cliente_st ss
  31.  WHERE ss.seqpessoa = 135567
  32.    AND ss.nrotabvenda = 1
  33.    AND ss.nrotributacao = 9;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement