填报单位列表的值列表根据填报层级和代码进行了筛选。
select distinct mc as display_value,dm as return_value from d_khdw where yx_bz='Y' and ((instr(dm,:khr_dw_dm)>0 and :KHR_CJ='1') or (instr(dm,substr(:khr_dw_dm,1,6))>0 and :KHR_CJ='2') or (instr(dm,substr(:khr_dw_dm,1,4))>0 and (:KHR_CJ='3' or :KHR_CJ='9'))) and (substr(dm,7,2)<>'00' or substr(dm,5,2)<>'00') order by 2