这个应该是有表名的别名是重复的，导致没有办法判断

WITH record_state1 AS (
    SELECT job_id, oper, report_state FROM (
        SELECT 
            a.job_id,  
            a.oper,  
            a.report_state,  
            a.id, 
            ROW_NUMBER() OVER(PARTITION BY a.job_id,  a.report_state  ORDER BY id DESC) rn 
        FROM dcab_report_state_record a 
        WHERE a.opflag  = 'UPDATE'
        AND a.oper  <> 'handle'
    ) 
    WHERE report_state = 1 AND rn = 1 
),
record_state2 AS (
    SELECT job_id, oper, report_state FROM (
        SELECT 
            a.job_id,  
            a.oper,  
            a.report_state,  
            a.id, 
            ROW_NUMBER() OVER(PARTITION BY a.job_id,  a.report_state  ORDER BY id DESC) rn 
        FROM dcab_report_state_record a 
        WHERE a.opflag  = 'UPDATE'
        AND a.oper  <> 'handle'
    ) 
    WHERE report_state = 2 AND rn = 1 
)
SELECT 
    DISTINCT 
    DECODE(NVL(a.DEF_FILED1,'0'),'demand','demand','0') AS "defFiled1",
    A.BSQJ "name",
    A.BSQJ "value",
    A.SJRQ "dataDate"
FROM DCAB_REPORT_STATE A 
LEFT JOIN DCAB_BS_BSNR B ON A.BSNRBH = B.BSNRBH 
LEFT JOIN record_state1 t1 ON t1.job_id  = a.id  
LEFT JOIN record_state2 t2 ON t2.job_id  = a.id  
LEFT JOIN dcab_report_biz_process_state c ON a.id  = c.report_id  
WHERE A.LOCKED = 0 
AND a.report_state  IN (2,3,-3)