[SQL] Handling WITH query fetching null rows in Oracle

I have a WITH query which return NULL rows i.e no rows are returned. So while displaying NULL rows my logic is not working in front end. So I want to handle it from procedure which is as below

WITH CTE_FSA_TASK as(
Select TaskID,FSAID from app_fttx.Fttx_Taskmaster FT WHERE FSAID= 'KZKD0238' AND FT.STATUS ='ACCEPTED'
)
SELECT NVL(ROUND(SUM( CASE WHEN SPAN_REF_NAME IN ('3x40-F-RG-ST-1L','2x40-F-G-ST-1L','1x40-F-G-ST-1L','2x40-F-RG-ST-1L','3x40-F-G-ST-1L',
'1x40-F-1L-RED','4x40-F-RG-ST-1L')
THEN NVL(CALCULATED_LENGTH,0)/1000 END),4),0) - 0 AS UG_LENGTH
FROM NE.MV_SPAN@DB_LINK_NE_VIEWER
INNER JOIN CTE_FSA_TASK
ON SPAN_NAME = CTE_FSA_TASK.taskid
WHERE RJ_FSA_ID= 'KZKD0238'
GROUP BY RJ_FSA_ID;


Please suggest how to handle it

Continue reading...