
delete from ur_task_dw where task_id='19B24A779FBB4EDA9F5FE029B0E41923' 
and not exists (select 1 from UR_DA_ZJZW_01 t 
where t.dw=ur_task_dw.dw_id and t.qj = ur_task_dw.perd_code and t.s_mdata_id = ur_task_dw.proj_id);

delete from ur_task_dw_rpt where task_id='19B24A779FBB4EDA9F5FE029B0E41923' 
and not exists (select 1 from UR_DA_ZJZW_01 t 
where t.dw=ur_task_dw_rpt.dw_id and t.qj = ur_task_dw_rpt.perd_code and t.s_mdata_id = ur_task_dw_rpt.proj_id);

delete from ur_task_dw_rpt_chk where task_id='19B24A779FBB4EDA9F5FE029B0E41923' 
and not exists (select 1 from UR_DA_ZJZW_01 t 
where t.dw=ur_task_dw_rpt_chk.dw_id and t.qj = ur_task_dw_rpt_chk.perd_code and t.s_mdata_id = ur_task_dw_rpt_chk.proj_id);

delete from UR_TASK_DW_RPT_CHK_REASON where task_id='19B24A779FBB4EDA9F5FE029B0E41923' 
and not exists (select 1 from UR_DA_ZJZW_01 t 
where t.dw=UR_TASK_DW_RPT_CHK_REASON.dw_id and t.qj = UR_TASK_DW_RPT_CHK_REASON.perd_code and t.s_mdata_id = UR_TASK_DW_RPT_CHK_REASON.proj_id);


delete from ur_task_dw where task_id='A2978165DD63470ABCBAB215ED8A1C42' 
and not exists (select 1 from UR_DA_DBZW_01 t 
where t.dw=ur_task_dw.dw_id and t.qj = ur_task_dw.perd_code and t.s_mdata_id = ur_task_dw.proj_id);

delete from ur_task_dw_rpt where task_id='A2978165DD63470ABCBAB215ED8A1C42' 
and not exists (select 1 from UR_DA_DBZW_01 t 
where t.dw=ur_task_dw_rpt.dw_id and t.qj = ur_task_dw_rpt.perd_code and t.s_mdata_id = ur_task_dw_rpt.proj_id);

delete from ur_task_dw_rpt_chk where task_id='A2978165DD63470ABCBAB215ED8A1C42' 
and not exists (select 1 from UR_DA_DBZW_01 t 
where t.dw=ur_task_dw_rpt_chk.dw_id and t.qj = ur_task_dw_rpt_chk.perd_code and t.s_mdata_id = ur_task_dw_rpt_chk.proj_id);

delete from UR_TASK_DW_RPT_CHK_REASON where task_id='A2978165DD63470ABCBAB215ED8A1C42' 
and not exists (select 1 from UR_DA_DBZW_01 t 
where t.dw=UR_TASK_DW_RPT_CHK_REASON.dw_id and t.qj = UR_TASK_DW_RPT_CHK_REASON.perd_code and t.s_mdata_id = UR_TASK_DW_RPT_CHK_REASON.proj_id);


delete from ur_task_dw where task_id='082A6FFDB766473B89B059F7C8A988EB' 
and not exists (select 1 from UR_DA_ZDZW_01 t 
where t.dw=ur_task_dw.dw_id and t.qj = ur_task_dw.perd_code and t.s_mdata_id = ur_task_dw.proj_id);

delete from ur_task_dw_rpt where task_id='082A6FFDB766473B89B059F7C8A988EB' 
and not exists (select 1 from UR_DA_ZDZW_01 t 
where t.dw=ur_task_dw_rpt.dw_id and t.qj = ur_task_dw_rpt.perd_code and t.s_mdata_id = ur_task_dw_rpt.proj_id);

delete from ur_task_dw_rpt_chk where task_id='082A6FFDB766473B89B059F7C8A988EB' 
and not exists (select 1 from UR_DA_ZDZW_01 t 
where t.dw=ur_task_dw_rpt_chk.dw_id and t.qj = ur_task_dw_rpt_chk.perd_code and t.s_mdata_id = ur_task_dw_rpt_chk.proj_id);

delete from UR_TASK_DW_RPT_CHK_REASON where task_id='082A6FFDB766473B89B059F7C8A988EB' 
and not exists (select 1 from UR_DA_ZDZW_01 t 
where t.dw=UR_TASK_DW_RPT_CHK_REASON.dw_id and t.qj = UR_TASK_DW_RPT_CHK_REASON.perd_code and t.s_mdata_id = UR_TASK_DW_RPT_CHK_REASON.proj_id);


delete from ur_task_dw where task_id='DBA1CCC9CA2B4E55887DCB697316AA82' 
and not exists (select 1 from UR_DA_GCXM_01 t 
where t.dw=ur_task_dw.dw_id and t.qj = ur_task_dw.perd_code and t.s_mdata_id = ur_task_dw.proj_id);

delete from ur_task_dw_rpt where task_id='DBA1CCC9CA2B4E55887DCB697316AA82' 
and not exists (select 1 from UR_DA_GCXM_01 t 
where t.dw=ur_task_dw_rpt.dw_id and t.qj = ur_task_dw_rpt.perd_code and t.s_mdata_id = ur_task_dw_rpt.proj_id);

delete from ur_task_dw_rpt_chk where task_id='DBA1CCC9CA2B4E55887DCB697316AA82' 
and not exists (select 1 from UR_DA_GCXM_01 t 
where t.dw=ur_task_dw_rpt_chk.dw_id and t.qj = ur_task_dw_rpt_chk.perd_code and t.s_mdata_id = ur_task_dw_rpt_chk.proj_id);

delete from UR_TASK_DW_RPT_CHK_REASON where task_id='DBA1CCC9CA2B4E55887DCB697316AA82' 
and not exists (select 1 from UR_DA_GCXM_01 t 
where t.dw=UR_TASK_DW_RPT_CHK_REASON.dw_id and t.qj = UR_TASK_DW_RPT_CHK_REASON.perd_code and t.s_mdata_id = UR_TASK_DW_RPT_CHK_REASON.proj_id);
