SELECT NF.CODINTNF AS CODINTNF
, NF.CODIGOEMPRESA AS EMPRESA
, NF.CODIGOFL AS FILIAL
, NF.CODIGOGA AS GARAGEM
, NF.SERIENF AS SERIE
, NF.NUMERONF AS NUMERO
, TO_DATE(NF.DATAEMISSAONF) AS DATA
, NF.CODIGOFORN AS CODFORN
, FO.RSOCIALFORN AS FORNECEDOR
, SUM(SE.VALORNFSERVICO) AS VR_SERVICO
, SE.CODIGOVEIC AS VEICULOS
, SE.DESCRICAONFSERVICO AS DESCRICAO
FROM BGM_NOTAFISCAL NF, EST_NFSERVICO SE, BGM_FORNECEDOR FO
WHERE NF.DATAEMISSAONF >= ’01-JAN-2022′
AND NF.CODINTNF= SE.CODINTNF
AND NF.CODIGOFORN=FO.CODIGOFORN
GROUP BY
NF.CODINTNF
, NF.CODIGOEMPRESA
, NF.CODIGOFL
, NF.CODIGOGA
