Perguntas Nota cancela

Talvez ajude;

SELECT
F3.F3_FILIAL,
F3_NFISCAL,
F3_SERIE,
F3_CLIEFOR,
F3_LOJA,
TO_DATE(F3_EMISSAO,'YYYYMMDD') AS "Emissão",
TO_DATE(F3_DTCANC,'YYYYMMDD') AS "Data Canc."
FROM
SF3010 F3
WHERE
F3.F3_FILIAL = '01'
AND F3.F3_EMISSAO BETWEEN '20150101' AND '20150401'
AND F3.F3_DTCANC <> ' '
AND F3.D_E_L_E_T_ <> '*'