Untitled

SELECT P.SEQPRODUTO AS CODPRODUTO,CAST(P.CODACESSO AS NUMERIC) AS CODACESSO,P.CODACESSO AS GTIN,P.TIPCODIGO,P.DESCCOMPLETA,P.DESCREDUZIDA,P.PRECOVALIDPROMOC100 AS PRECO_OFERTA,P.PRECOVALIDNORMAL100 AS PRECO,P.CUSTOBRUTOUNIT100 AS CUSTO,P.QTDEMBALAGEM,UPPER(P.EMBALAGEM) AS EMBALAGEM,P.PZOVALIDADEDIA,DECODE(NVL(P.SEQVASILHAME,0), 0, 0, consinco.FMAP_CODACESSOVASILHAME(P.SEQVASILHAME)) AS SEQVASILHAME,P.CODNBMSH,P.CODCEST,P.CODTIPI AS EXTIPI,P.CODORIGEMTRIB AS ORIGEM,P.PESAVEL,P.PMTDECIMAL,P.PMTMULTIPLICACAO,P.CODTRIBUTACAOPDV,P.NROTRIBUTACAO,P.TIPOTRIBUTACAO,P.ALIQTRIBUTACAOPDV100 AS ICMS_ALIQ,0 AS FCP_ALIQ,P.SITUACAONFPISSAI AS CST_PIS,P.PERPIS100 AS PERCPIS,P.PERCOFINS100 AS PERCCOFINS,P.SEQFAMILIA,P.INDBEBIDAALCOOLICA,P.NROSEGMENTO,NROSEGMENTOPRINC,P.INDVASILHAME,P.FATORPROMOCPDV1000 AS FATORPROMOCPDV,P.CODIGOANP,A.DESCRICAO AS DESCANP,P.DTABASEEXPORTACAO,F.CHECAPESO, M.PERALIQUOTA100 AS ALIQ_ORIGINAL, 0 AS PREDBCST, 0 AS ICMS_REDUCAO, CASE WHEN P.NROSEGMENTO IN (3,4) THEN 1 ELSE 0 END AS PLUDIF,'end' FROM consinco.MRLV_BASECARGAPDV P LEFT JOIN consinco.MRL_POSTOCOMBUSTANP A ON A.CODIGO = P.CODIGOANP LEFT JOIN consinco.MAP_TRIBUTACAOUF M ON P.NROTRIBUTACAO = M.NROTRIBUTACAO AND M.UFEMPRESA = P.UFEMPRESA AND M.UFCLIENTEFORNEC = 'SP' AND M.NROREGTRIBUTACAO = 0 AND M.TIPTRIBUTACAO = 'SN' LEFT JOIN consinco.MAP_FAMILIA F ON F.SEQFAMILIA = P.SEQFAMILIA WHERE P.CODACESSO IS NOT NULL AND P.NROEMPRESA = 42 AND P.NROSEGMENTO IN (1,3,4) AND P.PRECOVALIDNORMAL > 0 AND P.STATUSVENDA = 'A' ORDER BY P.SEQPRODUTO, P.QTDEMBALAGEM'