Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT pr.seqproduto,
- CASE
- WHEN pr.indbloqafv = 'B' THEN
- 'S'
- WHEN pr.indbloqafv = 'S' AND pr.nrosegmento = 2 THEN
- 'N'
- WHEN pr.indbloqafv = 'S' THEN
- 'S'
- WHEN pr.seqproduto IN (SELECT b.seqproduto
- FROM poseidon.dpcv_vnd_produto_bloqueado b
- WHERE b.seqpessoa = 1) THEN
- 'S'
- ELSE
- 'N'
- END bloqueado
- FROM poseidon.dpcv_next_produtos_lite pr
- WHERE pr.empresa = 1
- AND pr.nrosegmento = 2
- AND NOT EXISTS (SELECT 1
- FROM consinco.mad_tabvdafamexcecao tex
- WHERE tex.nrotabvenda = 1
- AND tex.seqfamilia = pr.seqfamilia)
- AND pr.status = 'A'
- AND pr.estoque > 0
- AND pr.descricao LIKE 'ABS%'
- ORDER BY descricao
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement