SELECT

I.CODIGO,
I.DESCRICAO,
'KG' AS UNIDADE,

SUM(CASE WHEN E.ESTADO = 'GO'  THEN CAST(NFSI.QUANTIDADE_ESTOQUE*I.PESO_LIQUIDO AS NUMERIC(16,3)) ELSE 0 END) AS GO,
SUM(CASE WHEN E.ESTADO = 'PR'  THEN CAST(NFSI.QUANTIDADE_ESTOQUE*I.PESO_LIQUIDO AS NUMERIC(16,3)) ELSE 0 END) AS PR,
SUM(CASE WHEN E.ESTADO = 'AP'  THEN CAST(NFSI.QUANTIDADE_ESTOQUE*I.PESO_LIQUIDO AS NUMERIC(16,3)) ELSE 0 END) AS AP,
SUM(CASE WHEN E.ESTADO = 'MG'  THEN CAST(NFSI.QUANTIDADE_ESTOQUE*I.PESO_LIQUIDO AS NUMERIC(16,3)) ELSE 0 END) AS MG,
SUM(CASE WHEN E.ESTADO = 'ES'  THEN CAST(NFSI.QUANTIDADE_ESTOQUE*I.PESO_LIQUIDO AS NUMERIC(16,3)) ELSE 0 END) AS ES,
SUM(CASE WHEN E.ESTADO = 'RJ'  THEN CAST(NFSI.QUANTIDADE_ESTOQUE*I.PESO_LIQUIDO AS NUMERIC(16,3)) ELSE 0 END) AS RJ,
SUM(CASE WHEN E.ESTADO = 'SP'  THEN CAST(NFSI.QUANTIDADE_ESTOQUE*I.PESO_LIQUIDO AS NUMERIC(16,3)) ELSE 0 END) AS SP

FROM NFSAIDA NFS

INNER JOIN NFSITENS NFSI ON (NFS.ID_NFSAIDA = NFSI.ID_NFSAIDA)
INNER JOIN NATOPERA      ON ( NFSI.ID_NATOPERA      = NATOPERA.ID_NATOPERA ) LEFT JOIN CCUSTO ON ( NFS.ID_CCUSTO = CCUSTO.ID_CCUSTO )
INNER JOIN ITENS I ON (I.ID_ITEM = NFSI.ID_ITEM)
LEFT JOIN EMPRESAS E ON (NFS.ID_EMPRESA = E.ID_EMPRESA)

WHERE NFS.EMISSAO BETWEEN :DTINICIAL AND :DTFINAL
AND NFS.SERIE = '1' 
AND ( NFS.TIPO = 'S' )
AND NFS.NFE_STATUS = 'Autorizada'

AND (I.CODIGO = '001.001.0006' OR I.CODIGO = '001.001.0016' OR I.CODIGO = '001.001.0005' OR I.CODIGO = '001.001.0004' OR I.CODIGO = '001.001.0010'
OR   I.CODIGO = '001.001.0015' OR I.CODIGO = '001.001.0008' OR I.CODIGO = '001.001.0012' OR I.CODIGO = '001.001.0009' OR I.CODIGO = '001.001.0013'
OR   I.CODIGO = '001.001.0011' OR I.CODIGO = '001.001.0014' OR I.CODIGO = '001.001.0017' OR I.CODIGO = '001.002.0005' OR I.CODIGO = '001.002.0009' 
OR   I.CODIGO = '001.002.0008' OR I.CODIGO = '001.002.0010' OR I.CODIGO = '001.002.0011' OR I.CODIGO = '001.002.0001' OR I.CODIGO = '010.001.0002' 
OR   I.CODIGO = '010.001.0007' OR I.CODIGO = '010.001.0001' OR I.CODIGO = '010.001.0003' OR I.CODIGO = '010.001.0006' OR I.CODIGO = '010.001.0004' 
OR   I.CODIGO = '010.001.0005' OR I.CODIGO = '001.001.0022' OR I.CODIGO = '001.001.0023' OR I.CODIGO = '001.001.0018' OR I.CODIGO = '001.001.0007')

AND (NATOPERA.CODIGO = '5.101' OR NATOPERA.CODIGO = '6.101' OR NATOPERA.CODIGO = '6.902' OR NATOPERA.CODIGO = '5.910')

GROUP BY 1,2,3