Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- cod_item,
- (select i.vl_ipi/quantidade from ek_item_nota i
- inner join ek_nota n on i.seq_nota = n.seq_nota
- where ind_oper = '0' and cod_item = v.cod_item and quantidade > 0
- order by dt_e_s desc limit 1) as ipi
- from
- ek_dados_inventario v
- where seq_inventario = 38
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement