SELECT
'PV' AS DE,
TM.DESCRICAO,
TM.VOLUMEFATURADOCX AS VOLUMEFATURADOCX,
TM.VOLUMEVENDIDO AS VOLUMEVENDIDO,
TM.VOLUMEFATURADOKG AS VOLUMEFATURADOKG,
TM.VOLUMEVENDIDOKG AS VOLUMEVENDIDOKG,
TM.FATURAMENTORS AS FATURAMENTORS,
TM.PRECOMEDIOFATURADORSCX AS PRECOMEDIOFATURADORSCX,
TM.PRECOMEDIOFATURADORSKG AS PRECOMEDIOFATURADORSKG,
FATCOMMODITIES.VLRPRAZOPAGTO AS FATURAMENTOCOMMODITIES,
'' AS FATURAMENTOMIXIDEAL,
QTDECATEGORIAS.QTDECATEGORIAS AS QTDECATEGORIAS,
HIST.PVITEMCLIENTE AS NROITENSPORCLIENTE,
HIST.PVPOSITIVADO AS CLIENTESPOSITIVADOSQTDE,
HIST.PVPOSITIVADO AS PEDIDOSQTDE
FROM
(
			SELECT
				TC.DESCRICAO,
				SUM(COALESCE(TM.VOLUMEOBJ, 0)) AS VOLUMEFATURADOCX,
				SUM(COALESCE(TM.VOLUMEOBJ, 0)) AS VOLUMEVENDIDO,
				SUM(COALESCE(TM.TONELADAOBJ, 0)) AS VOLUMEFATURADOKG,
				SUM(COALESCE(TM.TONELADAOBJ, 0)) AS VOLUMEVENDIDOKG,
				SUM(TM.RECLIQOBJ) AS FATURAMENTORS,
				CASE WHEN SUM(TM.VOLUMEOBJ) = 0 OR SUM(TM.VOLUMEOBJ) = 0 THEN 0 ELSE SUM(TM.VOLUMEOBJ)/SUM(TM.VOLUMEOBJ) END AS PRECOMEDIOFATURADORSCX,
				CASE WHEN SUM(TM.TONELADAOBJ) = 0 OR SUM(TM.TONELADAOBJ) = 0 THEN 0 ELSE SUM(TM.TONELADAOBJ)/SUM(TM.TONELADAOBJ) END AS PRECOMEDIOFATURADORSKG,
				'' AS FATURAMENTOMIXIDEAL
			FROM TESP_META TM
			INNER JOIN TC_ESTRUTURA TE ON (TE.CODIGOSUBORDINADO = TM.CODIGOVENDEDOR)
			INNER JOIN TE_PRODUTO TP ON (TP.CODIGO = TM.CODIGOPRODUTO)
			INNER JOIN T_CATEGORIA TC ON (TC.CODIGO = TP.CODIGOCATEGORIA)
			WHERE
				TE.CODIGOSUPERIOR = '1050' AND
				TM.ANO = '2017' AND
				TM.MES = '02'
			GROUP BY TC.DESCRICAO
	) AS TM,

(SELECT SUM(VLRPRAZOPAGTO.VLRPRAZOPAGTO) AS VLRPRAZOPAGTO FROM(
SELECT TSM.VLRPRAZOPAGTO AS VLRPRAZOPAGTO
FROM TESP_META TSM
INNER JOIN TC_ESTRUTURA TE ON (TE.CODIGOSUBORDINADO = TSM.CODIGOVENDEDOR)
LEFT JOIN TESP_CATEGFOCOPROD CATFOCOPROD ON (CATFOCOPROD.CODIGOPRODUTO = TSM.CODIGOPRODUTO)
LEFT JOIN TESP_CATEGORIASFOCO CATFOCO ON (CATFOCO.CODIGO = CATFOCOPROD.CODIGOCATEGFOCO)
WHERE
TE.CODIGOSUPERIOR = '1050' AND
TSM.ANO = '2017' AND
TSM.MES = '02' AND
TSM.VOLUMEREAL > 0 AND
CATFOCO.DESCRICAO = 'Commodities') VLRPRAZOPAGTO) AS FATCOMMODITIES,

(SELECT COUNT(QTDECATEGORIAS.CATEGORIASQTDE) AS QTDECATEGORIAS FROM (
SELECT TC.DESCRICAO, COUNT(TP.CODIGO) AS CATEGORIASQTDE FROM TESP_META TSM
INNER JOIN TC_ESTRUTURA TE ON (TE.CODIGOSUBORDINADO = TSM.CODIGOVENDEDOR)
INNER JOIN TE_PRODUTO TP ON (TP.CODIGO = TSM.CODIGOPRODUTO)
INNER JOIN T_CATEGORIA TC ON (TC.CODIGO = TP.CODIGOCATEGORIA)
WHERE
TE.CODIGOSUPERIOR = '1050' AND
TSM.ANO = '2017' AND
TSM.MES = '02' AND
TSM.VOLUMEREAL > 0
GROUP BY TC.DESCRICAO) QTDECATEGORIAS) AS QTDECATEGORIAS,

(SELECT
	COALESCE(TCM.PVITEMCLIENTE, 0) AS PVITEMCLIENTE,
	COALESCE(TCM.PVPEDIDO, 0) AS PVPEDIDO,
	COALESCE(TCM.PVPOSITIVADO, 0) AS PVPOSITIVADO
FROM TESP_COMPLMETA TCM
INNER JOIN TC_ESTRUTURA TE ON (TE.CODIGOSUBORDINADO = TCM.CODIGOVENDEDOR)
WHERE
TE.CODIGOSUPERIOR = '1050' AND
TCM.ANO = '2017' AND
TCM.MES = '02') AS HIST