◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源异常 记录时间:2020-04-16 00:10:39 记录内容:cyys_2017@123cyys_2017@12311000firstpage12020-04-162020-04-30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源异常 记录时间:2020-04-16 00:10:39 记录内容: SELECT * FROM(SELECT ac.*, ROWNUM ROWNUM_ FROM( SELECT TIME_DESC, CLINIC_TYPE, CLINIC_DATE,REGIST_PRICE, REGISTRATION_NUM,APPOINTMENT_LIMITS,b.clinic_dept DEPT_CODE, c.CLINIC_LABEL,d.dept_name from CLINIC_INDEX b left join CLINIC_FOR_REGIST c on (b.clinic_label = c.clinic_label) left join DEPT_DICT d on (b.clinic_dept = d.dept_code) where 1=1 and CLINIC_TYPE='普通号' and CLINIC_DATE between to_date('2020-04-16','yyyy-mm-dd') and to_date('2020-04-30','yyyy-mm-dd') order by CLINIC_DATE asc ) ac ) c where ROWNUM_ between 1 and 100 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 00:10:40 记录内容:1成功146851002020/4/16 0:00:00_白天_神经内科普通号2020/4/16 0:00:00白天0303门诊神经内科普通号4.001.0012020/4/16 0:00:00_白天_神经外科普通号2020/4/16 0:00:00白天0313门诊神经外科普通号4.001.0012020/4/16 0:00:00_白天_皮肤科普通号2020/4/16 0:00:00白天0318门诊皮肤科普通号4.001.0012020/4/16 0:00:00_白天_风湿免疫科普通号2020/4/16 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/4/16 0:00:00_白天_心血管一科普通号2020/4/16 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/4/16 0:00:00_白天_呼吸内科普通号2020/4/16 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/4/16 0:00:00_白天_老年病科普通号2020/4/16 0:00:00白天0354门诊老年病科普通号4.001.0012020/4/16 0:00:00_白天_内分泌科普通号2020/4/16 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/16 0:00:00_白天_糖尿病照护门诊2020/4/16 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/16 0:00:00_白天_胸外科普通号2020/4/16 0:00:00白天0366门诊胸外科普通号4.001.0012020/4/16 0:00:00_白天_中医科梁文林2020/4/16 0:00:00白天0301门诊中医科普通号4.001.0012020/4/16 0:00:00_白天_中医科金光明2020/4/16 0:00:00白天0301门诊中医科普通号4.001.0012020/4/16 0:00:00_白天_戒烟门诊普通号2020/4/16 0:00:00白天0381戒烟门诊普通号4.001.0012020/4/16 0:00:00_白天_中医针灸门诊2020/4/16 0:00:00白天0301门诊中医科普通号4.001.0012020/4/16 0:00:00_白天_放射介入科普通号2020/4/16 0:00:00白天0384门诊放射介入科普通号4.001.0012020/4/16 0:00:00_白天_感染性疾病普通号2020/4/16 0:00:00白天0305感染性疾病科普通号4.001.0012020/4/16 0:00:00_白天_核医学普通号2020/4/16 0:00:00白天0345门诊核医学普通号4.001.0012020/4/16 0:00:00_白天_生殖科普通号2020/4/16 0:00:00白天0371门诊生殖科普通号4.001.0012020/4/16 0:00:00_白天_妇科内分泌普通号2020/4/16 0:00:00白天0370门诊妇科内分泌普通号4.001.0012020/4/16 0:00:00_白天_耳鼻喉科普通号2020/4/16 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/4/16 0:00:00_白天_血管外科门诊2020/4/16 0:00:00白天0394门诊血管外科普通号4.001.0012020/4/16 0:00:00_白天_麻醉科普通号2020/4/16 0:00:00白天020901麻醉科普通号4.001.0012020/4/16 0:00:00_白天_妇科韩卫灵2020/4/16 0:00:00白天0316门诊妇科普通号4.001.0012020/4/16 0:00:00_白天_口腔科普通号2020/4/16 0:00:00白天0319口腔科普通号4.001.0012020/4/16 0:00:00_白天_产科马卫国2020/4/16 0:00:00白天0330门诊产科普通号4.001.0012020/4/16 0:00:00_白天_泌尿外科普通号2020/4/16 0:00:00白天0311门诊泌尿外科普通号4.001.0012020/4/16 0:00:00_白天_消化内科普通号2020/4/16 0:00:00白天0302门诊消化内科普通号4.001.0012020/4/16 0:00:00_白天_产科安国倩2020/4/16 0:00:00白天0330门诊产科普通号4.001.0012020/4/16 0:00:00_白天_心血管二科普通号2020/4/16 0:00:00白天0359门诊心血管内二科普通号4.001.0012020/4/16 0:00:00_白天_眼科普通号2020/4/16 0:00:00白天0327眼科普通号4.001.0012020/4/16 0:00:00_白天_普通外科普通号2020/4/16 0:00:00白天0335门诊普通外科普通号4.001.0012020/4/16 0:00:00_白天_骨科普通号2020/4/16 0:00:00白天0312门诊骨科普通号4.001.0012020/4/16 0:00:00_白天_门诊血液净化科2020/4/16 0:00:00白天0308门诊血液净化科普通号4.001.0012020/4/17 0:00:00_白天_神经内科普通号2020/4/17 0:00:00白天0303门诊神经内科普通号4.001.0012020/4/17 0:00:00_白天_神经外科普通号2020/4/17 0:00:00白天0313门诊神经外科普通号4.001.0012020/4/17 0:00:00_白天_皮肤科普通号2020/4/17 0:00:00白天0318门诊皮肤科普通号4.001.0012020/4/17 0:00:00_白天_风湿免疫科普通号2020/4/17 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/4/17 0:00:00_白天_心血管一科普通号2020/4/17 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/4/17 0:00:00_白天_肾病科普通号2020/4/17 0:00:00白天0333门诊肾病科普通号4.001.0012020/4/17 0:00:00_白天_呼吸内科普通号2020/4/17 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/4/17 0:00:00_白天_老年病科普通号2020/4/17 0:00:00白天0354门诊老年病科普通号4.001.0012020/4/17 0:00:00_白天_内分泌科普通号2020/4/17 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/17 0:00:00_白天_糖尿病照护门诊2020/4/17 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/17 0:00:00_白天_胸外科普通号2020/4/17 0:00:00白天0366门诊胸外科普通号4.001.0012020/4/17 0:00:00_白天_中医科梁文林2020/4/17 0:00:00白天0301门诊中医科普通号4.001.0012020/4/17 0:00:00_白天_戒烟门诊普通号2020/4/17 0:00:00白天0381戒烟门诊普通号4.001.0012020/4/17 0:00:00_白天_中医针灸门诊2020/4/17 0:00:00白天0301门诊中医科普通号4.001.0012020/4/17 0:00:00_白天_放射介入科普通号2020/4/17 0:00:00白天0384门诊放射介入科普通号4.001.0012020/4/17 0:00:00_白天_感染性疾病普通号2020/4/17 0:00:00白天0305感染性疾病科普通号4.001.0012020/4/17 0:00:00_白天_核医学普通号2020/4/17 0:00:00白天0345门诊核医学普通号4.001.0012020/4/17 0:00:00_白天_生殖科普通号2020/4/17 0:00:00白天0371门诊生殖科普通号4.001.0012020/4/17 0:00:00_白天_妇科内分泌普通号2020/4/17 0:00:00白天0370门诊妇科内分泌普通号4.001.0012020/4/17 0:00:00_白天_耳鼻喉科普通号2020/4/17 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/4/17 0:00:00_白天_麻醉科普通号2020/4/17 0:00:00白天020901麻醉科普通号4.001.0012020/4/17 0:00:00_白天_妇科郑淑华2020/4/17 0:00:00白天0316门诊妇科普通号4.001.0012020/4/17 0:00:00_白天_口腔科普通号2020/4/17 0:00:00白天0319口腔科普通号4.001.0012020/4/17 0:00:00_白天_泌尿外科普通号2020/4/17 0:00:00白天0311门诊泌尿外科普通号4.001.0012020/4/17 0:00:00_白天_消化内科普通号2020/4/17 0:00:00白天0302门诊消化内科普通号4.001.0012020/4/17 0:00:00_白天_产科杨芳2020/4/17 0:00:00白天0330门诊产科普通号4.001.0012020/4/17 0:00:00_白天_产科周雪静2020/4/17 0:00:00白天0330门诊产科普通号4.001.0012020/4/17 0:00:00_白天_心血管二科普通号2020/4/17 0:00:00白天0359门诊心血管内二科普通号4.001.0012020/4/17 0:00:00_白天_眼科普通号2020/4/17 0:00:00白天0327眼科普通号4.001.0012020/4/17 0:00:00_白天_肛肠门诊普通号2020/4/17 0:00:00白天0383门诊肛肠外科普通号4.001.0012020/4/17 0:00:00_白天_普通外科普通号2020/4/17 0:00:00白天0335门诊普通外科普通号4.001.0012020/4/17 0:00:00_白天_骨科普通号2020/4/17 0:00:00白天0312门诊骨科普通号4.001.0012020/4/17 0:00:00_白天_门诊血液净化科2020/4/17 0:00:00白天0308门诊血液净化科普通号4.001.0012020/4/18 0:00:00_白天_神经内科普通号2020/4/18 0:00:00白天0303门诊神经内科普通号4.001.0012020/4/18 0:00:00_白天_神经外科普通号2020/4/18 0:00:00白天0313门诊神经外科普通号4.001.0012020/4/18 0:00:00_白天_皮肤科普通号2020/4/18 0:00:00白天0318门诊皮肤科普通号4.001.0012020/4/18 0:00:00_白天_风湿免疫科普通号2020/4/18 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/4/18 0:00:00_白天_心血管一科普通号2020/4/18 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/4/18 0:00:00_白天_老年病科普通号2020/4/18 0:00:00白天0354门诊老年病科普通号4.001.0012020/4/18 0:00:00_白天_内分泌科普通号2020/4/18 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/18 0:00:00_白天_呼吸内科普通号2020/4/18 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/4/18 0:00:00_白天_胸外科普通号2020/4/18 0:00:00白天0366门诊胸外科普通号4.001.0012020/4/18 0:00:00_白天_中医科金光明2020/4/18 0:00:00白天0301门诊中医科普通号4.001.0012020/4/18 0:00:00_白天_戒烟门诊普通号2020/4/18 0:00:00白天0381戒烟门诊普通号4.001.0012020/4/18 0:00:00_白天_中医针灸门诊2020/4/18 0:00:00白天0301门诊中医科普通号4.001.0012020/4/18 0:00:00_白天_放射介入科普通号2020/4/18 0:00:00白天0384门诊放射介入科普通号4.001.0012020/4/18 0:00:00_白天_感染性疾病普通号2020/4/18 0:00:00白天0305感染性疾病科普通号4.001.0012020/4/18 0:00:00_白天_核医学普通号2020/4/18 0:00:00白天0345门诊核医学普通号4.001.0012020/4/18 0:00:00_白天_生殖科普通号2020/4/18 0:00:00白天0371门诊生殖科普通号4.001.0012020/4/18 0:00:00_白天_妇科内分泌普通号2020/4/18 0:00:00白天0370门诊妇科内分泌普通号4.001.0012020/4/18 0:00:00_白天_耳鼻喉科普通号2020/4/18 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/4/18 0:00:00_白天_妇科郑淑华2020/4/18 0:00:00白天0316门诊妇科普通号4.001.0012020/4/18 0:00:00_白天_口腔科普通号2020/4/18 0:00:00白天0319口腔科普通号4.001.0012020/4/18 0:00:00_白天_泌尿外科普通号2020/4/18 0:00:00白天0311门诊泌尿外科普通号4.001.0012020/4/18 0:00:00_白天_消化内科普通号2020/4/18 0:00:00白天0302门诊消化内科普通号4.001.0012020/4/18 0:00:00_白天_产科杨芳2020/4/18 0:00:00白天0330门诊产科普通号4.001.0012020/4/18 0:00:00_白天_心血管二科普通号2020/4/18 0:00:00白天0359门诊心血管内二科普通号4.001.0012020/4/18 0:00:00_白天_眼科普通号2020/4/18 0:00:00白天0327眼科普通号4.001.0012020/4/18 0:00:00_白天_普通外科普通号2020/4/18 0:00:00白天0335门诊普通外科普通号4.001.0012020/4/18 0:00:00_白天_骨科普通号2020/4/18 0:00:00白天0312门诊骨科普通号4.001.0012020/4/18 0:00:00_白天_门诊血液净化科2020/4/18 0:00:00白天0308门诊血液净化科普通号4.001.0012020/4/19 0:00:00_白天_神经内科普通号2020/4/19 0:00:00白天0303门诊神经内科普通号4.001.0012020/4/19 0:00:00_白天_神经外科普通号2020/4/19 0:00:00白天0313门诊神经外科普通号4.001.0012020/4/19 0:00:00_白天_风湿免疫科普通号2020/4/19 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/4/19 0:00:00_白天_心血管一科普通号2020/4/19 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/4/19 0:00:00_白天_老年病科普通号2020/4/19 0:00:00白天0354门诊老年病科普通号4.001.0012020/4/19 0:00:00_白天_内分泌科普通号2020/4/19 0:00:00白天0315门诊内分泌科普通号4.001.001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源异常 记录时间:2020-04-16 12:10:39 记录内容:cyys_2017@123cyys_2017@12311000firstpage12020-04-162020-04-30 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源异常 记录时间:2020-04-16 12:10:39 记录内容: SELECT * FROM(SELECT ac.*, ROWNUM ROWNUM_ FROM( SELECT TIME_DESC, CLINIC_TYPE, CLINIC_DATE,REGIST_PRICE, REGISTRATION_NUM,APPOINTMENT_LIMITS,b.clinic_dept DEPT_CODE, c.CLINIC_LABEL,d.dept_name from CLINIC_INDEX b left join CLINIC_FOR_REGIST c on (b.clinic_label = c.clinic_label) left join DEPT_DICT d on (b.clinic_dept = d.dept_code) where 1=1 and CLINIC_TYPE='普通号' and CLINIC_DATE between to_date('2020-04-16','yyyy-mm-dd') and to_date('2020-04-30','yyyy-mm-dd') order by CLINIC_DATE asc ) ac ) c where ROWNUM_ between 1 and 100 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:39 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-04-16 12:10:40 记录内容:1成功146851002020/4/16 0:00:00_白天_神经内科普通号2020/4/16 0:00:00白天0303门诊神经内科普通号4.001.0012020/4/16 0:00:00_白天_神经外科普通号2020/4/16 0:00:00白天0313门诊神经外科普通号4.001.0012020/4/16 0:00:00_白天_皮肤科普通号2020/4/16 0:00:00白天0318门诊皮肤科普通号4.001.0012020/4/16 0:00:00_白天_风湿免疫科普通号2020/4/16 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/4/16 0:00:00_白天_心血管一科普通号2020/4/16 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/4/16 0:00:00_白天_呼吸内科普通号2020/4/16 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/4/16 0:00:00_白天_老年病科普通号2020/4/16 0:00:00白天0354门诊老年病科普通号4.001.0012020/4/16 0:00:00_白天_内分泌科普通号2020/4/16 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/16 0:00:00_白天_糖尿病照护门诊2020/4/16 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/16 0:00:00_白天_胸外科普通号2020/4/16 0:00:00白天0366门诊胸外科普通号4.001.0012020/4/16 0:00:00_白天_中医科梁文林2020/4/16 0:00:00白天0301门诊中医科普通号4.001.0012020/4/16 0:00:00_白天_中医科金光明2020/4/16 0:00:00白天0301门诊中医科普通号4.001.0012020/4/16 0:00:00_白天_戒烟门诊普通号2020/4/16 0:00:00白天0381戒烟门诊普通号4.001.0012020/4/16 0:00:00_白天_中医针灸门诊2020/4/16 0:00:00白天0301门诊中医科普通号4.001.0012020/4/16 0:00:00_白天_放射介入科普通号2020/4/16 0:00:00白天0384门诊放射介入科普通号4.001.0012020/4/16 0:00:00_白天_感染性疾病普通号2020/4/16 0:00:00白天0305感染性疾病科普通号4.001.0012020/4/16 0:00:00_白天_核医学普通号2020/4/16 0:00:00白天0345门诊核医学普通号4.001.0012020/4/16 0:00:00_白天_生殖科普通号2020/4/16 0:00:00白天0371门诊生殖科普通号4.001.0012020/4/16 0:00:00_白天_妇科内分泌普通号2020/4/16 0:00:00白天0370门诊妇科内分泌普通号4.001.0012020/4/16 0:00:00_白天_耳鼻喉科普通号2020/4/16 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/4/16 0:00:00_白天_血管外科门诊2020/4/16 0:00:00白天0394门诊血管外科普通号4.001.0012020/4/16 0:00:00_白天_麻醉科普通号2020/4/16 0:00:00白天020901麻醉科普通号4.001.0012020/4/16 0:00:00_白天_妇科韩卫灵2020/4/16 0:00:00白天0316门诊妇科普通号4.001.0012020/4/16 0:00:00_白天_口腔科普通号2020/4/16 0:00:00白天0319口腔科普通号4.001.0012020/4/16 0:00:00_白天_产科马卫国2020/4/16 0:00:00白天0330门诊产科普通号4.001.0012020/4/16 0:00:00_白天_泌尿外科普通号2020/4/16 0:00:00白天0311门诊泌尿外科普通号4.001.0012020/4/16 0:00:00_白天_消化内科普通号2020/4/16 0:00:00白天0302门诊消化内科普通号4.001.0012020/4/16 0:00:00_白天_产科安国倩2020/4/16 0:00:00白天0330门诊产科普通号4.001.0012020/4/16 0:00:00_白天_心血管二科普通号2020/4/16 0:00:00白天0359门诊心血管内二科普通号4.001.0012020/4/16 0:00:00_白天_眼科普通号2020/4/16 0:00:00白天0327眼科普通号4.001.0012020/4/16 0:00:00_白天_普通外科普通号2020/4/16 0:00:00白天0335门诊普通外科普通号4.001.0012020/4/16 0:00:00_白天_骨科普通号2020/4/16 0:00:00白天0312门诊骨科普通号4.001.0012020/4/16 0:00:00_白天_门诊血液净化科2020/4/16 0:00:00白天0308门诊血液净化科普通号4.001.0012020/4/17 0:00:00_白天_神经内科普通号2020/4/17 0:00:00白天0303门诊神经内科普通号4.001.0012020/4/17 0:00:00_白天_神经外科普通号2020/4/17 0:00:00白天0313门诊神经外科普通号4.001.0012020/4/17 0:00:00_白天_皮肤科普通号2020/4/17 0:00:00白天0318门诊皮肤科普通号4.001.0012020/4/17 0:00:00_白天_风湿免疫科普通号2020/4/17 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/4/17 0:00:00_白天_心血管一科普通号2020/4/17 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/4/17 0:00:00_白天_肾病科普通号2020/4/17 0:00:00白天0333门诊肾病科普通号4.001.0012020/4/17 0:00:00_白天_呼吸内科普通号2020/4/17 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/4/17 0:00:00_白天_老年病科普通号2020/4/17 0:00:00白天0354门诊老年病科普通号4.001.0012020/4/17 0:00:00_白天_内分泌科普通号2020/4/17 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/17 0:00:00_白天_糖尿病照护门诊2020/4/17 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/17 0:00:00_白天_胸外科普通号2020/4/17 0:00:00白天0366门诊胸外科普通号4.001.0012020/4/17 0:00:00_白天_中医科梁文林2020/4/17 0:00:00白天0301门诊中医科普通号4.001.0012020/4/17 0:00:00_白天_戒烟门诊普通号2020/4/17 0:00:00白天0381戒烟门诊普通号4.001.0012020/4/17 0:00:00_白天_中医针灸门诊2020/4/17 0:00:00白天0301门诊中医科普通号4.001.0012020/4/17 0:00:00_白天_放射介入科普通号2020/4/17 0:00:00白天0384门诊放射介入科普通号4.001.0012020/4/17 0:00:00_白天_感染性疾病普通号2020/4/17 0:00:00白天0305感染性疾病科普通号4.001.0012020/4/17 0:00:00_白天_核医学普通号2020/4/17 0:00:00白天0345门诊核医学普通号4.001.0012020/4/17 0:00:00_白天_生殖科普通号2020/4/17 0:00:00白天0371门诊生殖科普通号4.001.0012020/4/17 0:00:00_白天_妇科内分泌普通号2020/4/17 0:00:00白天0370门诊妇科内分泌普通号4.001.0012020/4/17 0:00:00_白天_耳鼻喉科普通号2020/4/17 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/4/17 0:00:00_白天_麻醉科普通号2020/4/17 0:00:00白天020901麻醉科普通号4.001.0012020/4/17 0:00:00_白天_妇科郑淑华2020/4/17 0:00:00白天0316门诊妇科普通号4.001.0012020/4/17 0:00:00_白天_口腔科普通号2020/4/17 0:00:00白天0319口腔科普通号4.001.0012020/4/17 0:00:00_白天_泌尿外科普通号2020/4/17 0:00:00白天0311门诊泌尿外科普通号4.001.0012020/4/17 0:00:00_白天_消化内科普通号2020/4/17 0:00:00白天0302门诊消化内科普通号4.001.0012020/4/17 0:00:00_白天_产科杨芳2020/4/17 0:00:00白天0330门诊产科普通号4.001.0012020/4/17 0:00:00_白天_产科周雪静2020/4/17 0:00:00白天0330门诊产科普通号4.001.0012020/4/17 0:00:00_白天_心血管二科普通号2020/4/17 0:00:00白天0359门诊心血管内二科普通号4.001.0012020/4/17 0:00:00_白天_眼科普通号2020/4/17 0:00:00白天0327眼科普通号4.001.0012020/4/17 0:00:00_白天_肛肠门诊普通号2020/4/17 0:00:00白天0383门诊肛肠外科普通号4.001.0012020/4/17 0:00:00_白天_普通外科普通号2020/4/17 0:00:00白天0335门诊普通外科普通号4.001.0012020/4/17 0:00:00_白天_骨科普通号2020/4/17 0:00:00白天0312门诊骨科普通号4.001.0012020/4/17 0:00:00_白天_门诊血液净化科2020/4/17 0:00:00白天0308门诊血液净化科普通号4.001.0012020/4/18 0:00:00_白天_神经内科普通号2020/4/18 0:00:00白天0303门诊神经内科普通号4.001.0012020/4/18 0:00:00_白天_神经外科普通号2020/4/18 0:00:00白天0313门诊神经外科普通号4.001.0012020/4/18 0:00:00_白天_皮肤科普通号2020/4/18 0:00:00白天0318门诊皮肤科普通号4.001.0012020/4/18 0:00:00_白天_风湿免疫科普通号2020/4/18 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/4/18 0:00:00_白天_心血管一科普通号2020/4/18 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/4/18 0:00:00_白天_老年病科普通号2020/4/18 0:00:00白天0354门诊老年病科普通号4.001.0012020/4/18 0:00:00_白天_内分泌科普通号2020/4/18 0:00:00白天0315门诊内分泌科普通号4.001.0012020/4/18 0:00:00_白天_呼吸内科普通号2020/4/18 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/4/18 0:00:00_白天_胸外科普通号2020/4/18 0:00:00白天0366门诊胸外科普通号4.001.0012020/4/18 0:00:00_白天_中医科金光明2020/4/18 0:00:00白天0301门诊中医科普通号4.001.0012020/4/18 0:00:00_白天_戒烟门诊普通号2020/4/18 0:00:00白天0381戒烟门诊普通号4.001.0012020/4/18 0:00:00_白天_中医针灸门诊2020/4/18 0:00:00白天0301门诊中医科普通号4.001.0012020/4/18 0:00:00_白天_放射介入科普通号2020/4/18 0:00:00白天0384门诊放射介入科普通号4.001.0012020/4/18 0:00:00_白天_感染性疾病普通号2020/4/18 0:00:00白天0305感染性疾病科普通号4.001.0012020/4/18 0:00:00_白天_核医学普通号2020/4/18 0:00:00白天0345门诊核医学普通号4.001.0012020/4/18 0:00:00_白天_生殖科普通号2020/4/18 0:00:00白天0371门诊生殖科普通号4.001.0012020/4/18 0:00:00_白天_妇科内分泌普通号2020/4/18 0:00:00白天0370门诊妇科内分泌普通号4.001.0012020/4/18 0:00:00_白天_耳鼻喉科普通号2020/4/18 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/4/18 0:00:00_白天_妇科郑淑华2020/4/18 0:00:00白天0316门诊妇科普通号4.001.0012020/4/18 0:00:00_白天_口腔科普通号2020/4/18 0:00:00白天0319口腔科普通号4.001.0012020/4/18 0:00:00_白天_泌尿外科普通号2020/4/18 0:00:00白天0311门诊泌尿外科普通号4.001.0012020/4/18 0:00:00_白天_消化内科普通号2020/4/18 0:00:00白天0302门诊消化内科普通号4.001.0012020/4/18 0:00:00_白天_产科杨芳2020/4/18 0:00:00白天0330门诊产科普通号4.001.0012020/4/18 0:00:00_白天_心血管二科普通号2020/4/18 0:00:00白天0359门诊心血管内二科普通号4.001.0012020/4/18 0:00:00_白天_眼科普通号2020/4/18 0:00:00白天0327眼科普通号4.001.0012020/4/18 0:00:00_白天_普通外科普通号2020/4/18 0:00:00白天0335门诊普通外科普通号4.001.0012020/4/18 0:00:00_白天_骨科普通号2020/4/18 0:00:00白天0312门诊骨科普通号4.001.0012020/4/18 0:00:00_白天_门诊血液净化科2020/4/18 0:00:00白天0308门诊血液净化科普通号4.001.0012020/4/19 0:00:00_白天_神经内科普通号2020/4/19 0:00:00白天0303门诊神经内科普通号4.001.0012020/4/19 0:00:00_白天_神经外科普通号2020/4/19 0:00:00白天0313门诊神经外科普通号4.001.0012020/4/19 0:00:00_白天_风湿免疫科普通号2020/4/19 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/4/19 0:00:00_白天_心血管一科普通号2020/4/19 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/4/19 0:00:00_白天_老年病科普通号2020/4/19 0:00:00白天0354门诊老年病科普通号4.001.0012020/4/19 0:00:00_白天_内分泌科普通号2020/4/19 0:00:00白天0315门诊内分泌科普通号4.001.001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆