delete from ur_da_dwxx_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_ZCFZB_XZ_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZCFZB_SY_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZCFZB_GS_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_LRB_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_XJLLB_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_SYZQY_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_SYZQY_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_SZZB_XZ_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_SZZB_SY_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_ZCGC_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_ZJZW_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_GCXMXX_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_GCXMXX_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_JJXX_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_JJXX_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_HKJH_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_HKJH_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_CHBJ_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_CHBJ_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZFLXFX_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZFLXFX_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZFFY_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZFFY_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZCXX_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZCXX_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));


delete from UR_DA_DBZW_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_ZDZW_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_ZDZWZC_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZDZWZC_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZDZW_SHBX_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_ZDZW_SHBX_02 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_ZCXGZ_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));
delete from UR_DA_SDHHJ_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_TQGZ_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_DA_GCXM_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));


delete from ur_task_dw where dw_id in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from ur_task_dw_rpt where dw_id in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from ur_task_dw_rpt_chk where dw_id in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from UR_TASK_DW_RPT_CHK_REASON where dw_id in (select dw_id from ur_sys_dw dw where exists(select 1 from ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));

delete from ur_da_dbyebd_01 where dw in (select dw_id from ur_sys_dw dw where exists(select 1 from 
ur_sys_dw sub_dw where dw.dw_code = sub_dw.p_code));