◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源记录 记录时间:2020-05-12 00:10:46 记录内容:cyys_2017@123cyys_2017@12311000firstpage12020-05-122020-05-26 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源记录 记录时间:2020-05-12 00:10:47 记录内容: 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='0元号' or CLINIC_TYPE='普通号' ) and CLINIC_DATE between to_date('2020-05-12','yyyy-mm-dd') and to_date('2020-05-26','yyyy-mm-dd') order by CLINIC_DATE asc ) ac ) c where ROWNUM_ between 1 and 100 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:47 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 00:10:48 记录内容:1成功11110121002020/5/12 0:00:00_白天_耳鼻喉科普通号2020/5/12 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/5/12 0:00:00_白天_胸外科普通号2020/5/12 0:00:00白天0366门诊胸外科普通号4.001.0012020/5/12 0:00:00_上午_中医妇科门诊2020/5/12 0:00:00上午0301门诊中医科普通号4.001.0012020/5/12 0:00:00_白天_骨科普通号2020/5/12 0:00:00白天0312门诊骨科普通号4.001.0012020/5/12 0:00:00_白天_普通外科普通号2020/5/12 0:00:00白天0335门诊普通外科普通号4.001.0012020/5/12 0:00:00_白天_皮肤科普通号2020/5/12 0:00:00白天0318门诊皮肤科普通号4.001.0012020/5/12 0:00:00_白天_老年病科普通号2020/5/12 0:00:00白天0354门诊老年病科普通号4.001.0012020/5/12 0:00:00_白天_呼吸内科普通号2020/5/12 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/5/12 0:00:00_白天_ICU转诊号2020/5/12 0:00:00白天0380门诊ICU0元号0.000.0012020/5/12 0:00:00_白天_助产士咨询门诊2020/5/12 0:00:00白天0330门诊产科普通号4.001.0012020/5/12 0:00:00_白天_神经内科普通号2020/5/12 0:00:00白天0303门诊神经内科普通号4.001.0012020/5/12 0:00:00_白天_病理科转诊号2020/5/12 0:00:00白天0346门诊病理0元号0.000.0012020/5/12 0:00:00_白天_产科转诊号2020/5/12 0:00:00白天0330门诊产科0元号0.000.0012020/5/12 0:00:00_白天_儿科转诊号2020/5/12 0:00:00白天0304门诊儿科0元号0.000.0012020/5/12 0:00:00_白天_耳鼻喉科转诊号2020/5/12 0:00:00白天0306门诊耳鼻喉科0元号0.000.0012020/5/12 0:00:00_白天_风湿免疫科转诊号2020/5/12 0:00:00白天0337门诊风湿免疫科0元号0.000.0012020/5/12 0:00:00_白天_妇科内分泌转诊号2020/5/12 0:00:00白天0370门诊妇科内分泌0元号0.000.0012020/5/12 0:00:00_白天_妇科转诊号2020/5/12 0:00:00白天0316门诊妇科0元号0.000.0012020/5/12 0:00:00_白天_感染性疾病转诊号2020/5/12 0:00:00白天0305感染性疾病科0元号0.000.0012020/5/12 0:00:00_白天_肛肠门诊转诊号2020/5/12 0:00:00白天0383门诊肛肠外科0元号0.000.0012020/5/12 0:00:00_白天_高压氧转诊号2020/5/12 0:00:00白天0340门诊高压氧科0元号0.000.0012020/5/12 0:00:00_白天_功能检查科转诊号2020/5/12 0:00:00白天0341门诊功能检查科0元号0.000.0012020/5/12 0:00:00_白天_骨科转诊号2020/5/12 0:00:00白天0312门诊骨科0元号0.000.0012020/5/12 0:00:00_白天_核磁转诊号2020/5/12 0:00:00白天0343门诊核磁0元号0.000.0012020/5/12 0:00:00_白天_呼吸内科转诊号2020/5/12 0:00:00白天0317呼吸与危重症医学科0元号0.000.0012020/5/12 0:00:00_白天_康复医学科转诊号2020/5/12 0:00:00白天0314门诊康复医学科0元号0.000.0012020/5/12 0:00:00_白天_口腔科转诊号2020/5/12 0:00:00白天0319口腔科0元号0.000.0012020/5/12 0:00:00_白天_老年病科转诊号2020/5/12 0:00:00白天0354门诊老年病科0元号0.000.0012020/5/12 0:00:00_白天_门诊血液净化科2020/5/12 0:00:00白天0308门诊血液净化科普通号4.001.0012020/5/12 0:00:00_白天_泌尿外科转诊号2020/5/12 0:00:00白天0311门诊泌尿外科0元号0.000.0012020/5/12 0:00:00_白天_内分泌科转诊号2020/5/12 0:00:00白天0315门诊内分泌科0元号0.000.0012020/5/12 0:00:00_白天_皮肤科转诊号2020/5/12 0:00:00白天0318门诊皮肤科0元号0.000.0012020/5/12 0:00:00_白天_普通外科转诊号2020/5/12 0:00:00白天0335门诊普通外科0元号0.000.0012020/5/12 0:00:00_白天_乳腺外科转诊号2020/5/12 0:00:00白天0335门诊普通外科0元号0.000.0012020/5/12 0:00:00_白天_神经外科转诊号2020/5/12 0:00:00白天0313门诊神经外科0元号0.000.0012020/5/12 0:00:00_白天_生殖科转诊号2020/5/12 0:00:00白天0371门诊生殖科0元号0.000.0012020/5/12 0:00:00_白天_输血科转诊号2020/5/12 0:00:00白天0413输血科0元号0.000.0012020/5/12 0:00:00_白天_消化内科转诊号2020/5/12 0:00:00白天0302门诊消化内科0元号0.000.0012020/5/12 0:00:00_白天_新生儿科转诊号2020/5/12 0:00:00白天0378门诊新生儿科0元号0.000.0012020/5/12 0:00:00_白天_心血管二科转诊号2020/5/12 0:00:00白天0359门诊心血管内二科0元号0.000.0012020/5/12 0:00:00_白天_心血管一科转诊号2020/5/12 0:00:00白天0307门诊心血管内一科0元号0.000.0012020/5/12 0:00:00_白天_胸外科转诊号2020/5/12 0:00:00白天0366门诊胸外科0元号0.000.0012020/5/12 0:00:00_白天_血液净化科转诊号2020/5/12 0:00:00白天0308门诊血液净化科0元号0.000.0012020/5/12 0:00:00_白天_眼科转诊号2020/5/12 0:00:00白天0327眼科0元号0.000.0012020/5/12 0:00:00_白天_影像科转诊号2020/5/12 0:00:00白天0342门诊CT0元号0.000.0012020/5/12 0:00:00_白天_中医科转诊号2020/5/12 0:00:00白天0301门诊中医科0元号0.000.0012020/5/12 0:00:00_白天_肿瘤科转诊号2020/5/12 0:00:00白天0338门诊肿瘤科0元号0.000.0012020/5/12 0:00:00_白天_核医学转诊号2020/5/12 0:00:00白天0345门诊核医学0元号0.000.0012020/5/12 0:00:00_白天_神经内科转诊号2020/5/12 0:00:00白天0303门诊神经内科0元号0.000.0012020/5/12 0:00:00_白天_健康体检科刘樊茵2020/5/12 0:00:00白天0326健康体检科0元号0.000.0012020/5/12 0:00:00_白天_放射介入科普通号2020/5/12 0:00:00白天0384门诊放射介入科普通号4.001.0012020/5/12 0:00:00_白天_感染性疾病普通号2020/5/12 0:00:00白天0305感染性疾病科普通号4.001.0012020/5/12 0:00:00_白天_核医学普通号2020/5/12 0:00:00白天0345门诊核医学普通号4.001.0012020/5/12 0:00:00_昼夜_急诊科_院前2020/5/12 0:00:00昼夜0377急诊科_院前0元号0.000.0012020/5/12 0:00:00_白天_戒烟门诊普通号2020/5/12 0:00:00白天0381戒烟门诊普通号4.001.0012020/5/12 0:00:00_白天_老年病二科2020/5/12 0:00:00白天0349老年病二科0元号0.000.0012020/5/12 0:00:00_白天_社区卫生服务门诊2020/5/12 0:00:00白天0369社区卫生服务门诊0元号0.000.0012020/5/12 0:00:00_白天_手术室2020/5/12 0:00:00白天020903手术室0元号0.000.0012020/5/12 0:00:00_白天_内镜转诊号2020/5/12 0:00:00白天0302门诊消化内科0元号0.000.0012020/5/12 0:00:00_白天_内分泌科普通号2020/5/12 0:00:00白天0315门诊内分泌科普通号4.001.0012020/5/12 0:00:00_白天_糖尿病照护门诊2020/5/12 0:00:00白天0315门诊内分泌科普通号4.001.0012020/5/12 0:00:00_白天_妇科内分泌普通号2020/5/12 0:00:00白天0370门诊妇科内分泌普通号4.001.0012020/5/12 0:00:00_白天_生殖科普通号2020/5/12 0:00:00白天0371门诊生殖科普通号4.001.0012020/5/12 0:00:00_白天_眼科普通号2020/5/12 0:00:00白天0327眼科普通号4.001.0012020/5/12 0:00:00_白天_心血管二科普通号2020/5/12 0:00:00白天0359门诊心血管内二科普通号4.001.0012020/5/12 0:00:00_白天_口腔科普通号2020/5/12 0:00:00白天0319口腔科普通号4.001.0012020/5/12 0:00:00_白天_泌尿外科普通号2020/5/12 0:00:00白天0311门诊泌尿外科普通号4.001.0012020/5/12 0:00:00_白天_消化内科普通号2020/5/12 0:00:00白天0302门诊消化内科普通号4.001.0012020/5/12 0:00:00_白天_产科周雪静2020/5/12 0:00:00白天0330门诊产科普通号4.001.0012020/5/12 0:00:00_白天_麻醉科普通号2020/5/12 0:00:00白天020901麻醉科普通号4.001.0012020/5/12 0:00:00_白天_中医针灸门诊2020/5/12 0:00:00白天0301门诊中医科普通号4.001.0012020/5/12 0:00:00_白天_心血管一科普通号2020/5/12 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/5/12 0:00:00_白天_风湿免疫科普通号2020/5/12 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/5/12 0:00:00_白天_中医科梁文林2020/5/12 0:00:00白天0301门诊中医科普通号4.001.0012020/5/13 0:00:00_白天_妇科王晓雯2020/5/13 0:00:00白天0316门诊妇科普通号4.001.0012020/5/13 0:00:00_白天_妇科郑淑华2020/5/13 0:00:00白天0316门诊妇科普通号4.001.0012020/5/13 0:00:00_白天_中医科闫晋升2020/5/13 0:00:00白天0301门诊中医科普通号4.001.0012020/5/13 0:00:00_白天_耳鼻喉科普通号2020/5/13 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/5/13 0:00:00_白天_胸外科普通号2020/5/13 0:00:00白天0366门诊胸外科普通号4.001.0012020/5/13 0:00:00_白天_中医科金光明2020/5/13 0:00:00白天0301门诊中医科普通号4.001.0012020/5/13 0:00:00_上午_中医肾病门诊2020/5/13 0:00:00上午0301门诊中医科普通号4.001.0012020/5/13 0:00:00_白天_骨科普通号2020/5/13 0:00:00白天0312门诊骨科普通号4.001.0012020/5/13 0:00:00_白天_普通外科普通号2020/5/13 0:00:00白天0335门诊普通外科普通号4.001.0012020/5/13 0:00:00_白天_皮肤科普通号2020/5/13 0:00:00白天0318门诊皮肤科普通号4.001.0012020/5/13 0:00:00_白天_老年病科普通号2020/5/13 0:00:00白天0354门诊老年病科普通号4.001.0012020/5/13 0:00:00_白天_呼吸内科普通号2020/5/13 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/5/13 0:00:00_白天_ICU转诊号2020/5/13 0:00:00白天0380门诊ICU0元号0.000.0012020/5/13 0:00:00_上午_口腔科普通号2020/5/13 0:00:00上午0319口腔科普通号4.001.0012020/5/13 0:00:00_下午_口腔科普通号2020/5/13 0:00:00下午0319口腔科普通号4.001.0012020/5/13 0:00:00_白天_肿瘤科转诊号2020/5/13 0:00:00白天0338门诊肿瘤科0元号0.000.0012020/5/13 0:00:00_白天_神经内科普通号2020/5/13 0:00:00白天0303门诊神经内科普通号4.001.0012020/5/13 0:00:00_白天_病理科转诊号2020/5/13 0:00:00白天0346门诊病理0元号0.000.0012020/5/13 0:00:00_白天_产科转诊号2020/5/13 0:00:00白天0330门诊产科0元号0.000.0012020/5/13 0:00:00_白天_儿科转诊号2020/5/13 0:00:00白天0304门诊儿科0元号0.000.0012020/5/13 0:00:00_白天_耳鼻喉科转诊号2020/5/13 0:00:00白天0306门诊耳鼻喉科0元号0.000.0012020/5/13 0:00:00_白天_风湿免疫科转诊号2020/5/13 0:00:00白天0337门诊风湿免疫科0元号0.000.0012020/5/13 0:00:00_白天_妇科内分泌转诊号2020/5/13 0:00:00白天0370门诊妇科内分泌0元号0.000.0012020/5/13 0:00:00_白天_妇科转诊号2020/5/13 0:00:00白天0316门诊妇科0元号0.000.0012020/5/13 0:00:00_白天_感染性疾病转诊号2020/5/13 0:00:00白天0305感染性疾病科0元号0.000.0012020/5/13 0:00:00_白天_肛肠门诊转诊号2020/5/13 0:00:00白天0383门诊肛肠外科0元号0.000.001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源记录 记录时间:2020-05-12 12:10:49 记录内容:cyys_2017@123cyys_2017@12311000firstpage12020-05-122020-05-26 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源记录 记录时间:2020-05-12 12:10:49 记录内容: 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='0元号' or CLINIC_TYPE='普通号' ) and CLINIC_DATE between to_date('2020-05-12','yyyy-mm-dd') and to_date('2020-05-26','yyyy-mm-dd') order by CLINIC_DATE asc ) ac ) c where ROWNUM_ between 1 and 100 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:49 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '普通号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容: select * from price_list where item_code in( select price_item from CLINIC_TYPE_SETTING where clinic_type = '0元号' ) and STOP_DATE is null ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆ ◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆ 记录描述:获取普通号源 记录时间:2020-05-12 12:10:50 记录内容:1成功11112121002020/5/12 0:00:00_白天_心血管一科普通号2020/5/12 0:00:00白天0307门诊心血管内一科普通号4.001.0012020/5/12 0:00:00_白天_风湿免疫科普通号2020/5/12 0:00:00白天0337门诊风湿免疫科普通号4.001.0012020/5/12 0:00:00_白天_中医科梁文林2020/5/12 0:00:00白天0301门诊中医科普通号4.001.0012020/5/12 0:00:00_白天_耳鼻喉科普通号2020/5/12 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/5/12 0:00:00_白天_胸外科普通号2020/5/12 0:00:00白天0366门诊胸外科普通号4.001.0012020/5/12 0:00:00_上午_中医妇科门诊2020/5/12 0:00:00上午0301门诊中医科普通号4.001.0012020/5/12 0:00:00_白天_骨科普通号2020/5/12 0:00:00白天0312门诊骨科普通号4.001.0012020/5/12 0:00:00_白天_普通外科普通号2020/5/12 0:00:00白天0335门诊普通外科普通号4.001.0012020/5/12 0:00:00_白天_皮肤科普通号2020/5/12 0:00:00白天0318门诊皮肤科普通号4.001.0012020/5/12 0:00:00_白天_老年病科普通号2020/5/12 0:00:00白天0354门诊老年病科普通号4.001.0012020/5/12 0:00:00_白天_呼吸内科普通号2020/5/12 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/5/12 0:00:00_白天_高压氧科张树琴2020/5/12 0:00:00白天0340门诊高压氧科普通号4.001.0012020/5/12 0:00:00_白天_神经内科普通号2020/5/12 0:00:00白天0303门诊神经内科普通号4.001.0012020/5/12 0:00:00_白天_病理科转诊号2020/5/12 0:00:00白天0346门诊病理0元号0.000.0012020/5/12 0:00:00_白天_产科转诊号2020/5/12 0:00:00白天0330门诊产科0元号0.000.0012020/5/12 0:00:00_白天_儿科转诊号2020/5/12 0:00:00白天0304门诊儿科0元号0.000.0012020/5/12 0:00:00_白天_耳鼻喉科转诊号2020/5/12 0:00:00白天0306门诊耳鼻喉科0元号0.000.0012020/5/12 0:00:00_白天_风湿免疫科转诊号2020/5/12 0:00:00白天0337门诊风湿免疫科0元号0.000.0012020/5/12 0:00:00_白天_妇科内分泌转诊号2020/5/12 0:00:00白天0370门诊妇科内分泌0元号0.000.0012020/5/12 0:00:00_白天_妇科转诊号2020/5/12 0:00:00白天0316门诊妇科0元号0.000.0012020/5/12 0:00:00_白天_感染性疾病转诊号2020/5/12 0:00:00白天0305感染性疾病科0元号0.000.0012020/5/12 0:00:00_白天_肛肠门诊转诊号2020/5/12 0:00:00白天0383门诊肛肠外科0元号0.000.0012020/5/12 0:00:00_白天_高压氧转诊号2020/5/12 0:00:00白天0340门诊高压氧科0元号0.000.0012020/5/12 0:00:00_白天_功能检查科转诊号2020/5/12 0:00:00白天0341门诊功能检查科0元号0.000.0012020/5/12 0:00:00_白天_骨科转诊号2020/5/12 0:00:00白天0312门诊骨科0元号0.000.0012020/5/12 0:00:00_白天_核磁转诊号2020/5/12 0:00:00白天0343门诊核磁0元号0.000.0012020/5/12 0:00:00_白天_呼吸内科转诊号2020/5/12 0:00:00白天0317呼吸与危重症医学科0元号0.000.0012020/5/12 0:00:00_白天_康复医学科转诊号2020/5/12 0:00:00白天0314门诊康复医学科0元号0.000.0012020/5/12 0:00:00_白天_口腔科转诊号2020/5/12 0:00:00白天0319口腔科0元号0.000.0012020/5/12 0:00:00_白天_老年病科转诊号2020/5/12 0:00:00白天0354门诊老年病科0元号0.000.0012020/5/12 0:00:00_白天_门诊血液净化科2020/5/12 0:00:00白天0308门诊血液净化科普通号4.001.0012020/5/12 0:00:00_白天_泌尿外科转诊号2020/5/12 0:00:00白天0311门诊泌尿外科0元号0.000.0012020/5/12 0:00:00_白天_内分泌科转诊号2020/5/12 0:00:00白天0315门诊内分泌科0元号0.000.0012020/5/12 0:00:00_白天_皮肤科转诊号2020/5/12 0:00:00白天0318门诊皮肤科0元号0.000.0012020/5/12 0:00:00_白天_普通外科转诊号2020/5/12 0:00:00白天0335门诊普通外科0元号0.000.0012020/5/12 0:00:00_白天_乳腺外科转诊号2020/5/12 0:00:00白天0335门诊普通外科0元号0.000.0012020/5/12 0:00:00_白天_神经外科转诊号2020/5/12 0:00:00白天0313门诊神经外科0元号0.000.0012020/5/12 0:00:00_白天_生殖科转诊号2020/5/12 0:00:00白天0371门诊生殖科0元号0.000.0012020/5/12 0:00:00_白天_输血科转诊号2020/5/12 0:00:00白天0413输血科0元号0.000.0012020/5/12 0:00:00_白天_消化内科转诊号2020/5/12 0:00:00白天0302门诊消化内科0元号0.000.0012020/5/12 0:00:00_白天_新生儿科转诊号2020/5/12 0:00:00白天0378门诊新生儿科0元号0.000.0012020/5/12 0:00:00_白天_心血管二科转诊号2020/5/12 0:00:00白天0359门诊心血管内二科0元号0.000.0012020/5/12 0:00:00_白天_心血管一科转诊号2020/5/12 0:00:00白天0307门诊心血管内一科0元号0.000.0012020/5/12 0:00:00_白天_胸外科转诊号2020/5/12 0:00:00白天0366门诊胸外科0元号0.000.0012020/5/12 0:00:00_白天_血液净化科转诊号2020/5/12 0:00:00白天0308门诊血液净化科0元号0.000.0012020/5/12 0:00:00_白天_眼科转诊号2020/5/12 0:00:00白天0327眼科0元号0.000.0012020/5/12 0:00:00_白天_影像科转诊号2020/5/12 0:00:00白天0342门诊CT0元号0.000.0012020/5/12 0:00:00_白天_中医科转诊号2020/5/12 0:00:00白天0301门诊中医科0元号0.000.0012020/5/12 0:00:00_白天_肿瘤科转诊号2020/5/12 0:00:00白天0338门诊肿瘤科0元号0.000.0012020/5/12 0:00:00_白天_核医学转诊号2020/5/12 0:00:00白天0345门诊核医学0元号0.000.0012020/5/12 0:00:00_白天_神经内科转诊号2020/5/12 0:00:00白天0303门诊神经内科0元号0.000.0012020/5/12 0:00:00_白天_健康体检科刘樊茵2020/5/12 0:00:00白天0326健康体检科0元号0.000.0012020/5/12 0:00:00_白天_放射介入科普通号2020/5/12 0:00:00白天0384门诊放射介入科普通号4.001.0012020/5/12 0:00:00_白天_感染性疾病普通号2020/5/12 0:00:00白天0305感染性疾病科普通号4.001.0012020/5/12 0:00:00_白天_核医学普通号2020/5/12 0:00:00白天0345门诊核医学普通号4.001.0012020/5/12 0:00:00_昼夜_急诊科_院前2020/5/12 0:00:00昼夜0377急诊科_院前0元号0.000.0012020/5/12 0:00:00_白天_戒烟门诊普通号2020/5/12 0:00:00白天0381戒烟门诊普通号4.001.0012020/5/12 0:00:00_白天_老年病二科2020/5/12 0:00:00白天0349老年病二科0元号0.000.0012020/5/12 0:00:00_白天_社区卫生服务门诊2020/5/12 0:00:00白天0369社区卫生服务门诊0元号0.000.0012020/5/12 0:00:00_白天_手术室2020/5/12 0:00:00白天020903手术室0元号0.000.0012020/5/12 0:00:00_白天_内镜转诊号2020/5/12 0:00:00白天0302门诊消化内科0元号0.000.0012020/5/12 0:00:00_白天_血管外科转诊号2020/5/12 0:00:00白天0394门诊血管外科0元号0.000.0012020/5/12 0:00:00_白天_助产士咨询门诊2020/5/12 0:00:00白天0330门诊产科普通号4.001.0012020/5/12 0:00:00_白天_内分泌科普通号2020/5/12 0:00:00白天0315门诊内分泌科普通号4.001.0012020/5/12 0:00:00_白天_糖尿病照护门诊2020/5/12 0:00:00白天0315门诊内分泌科普通号4.001.0012020/5/12 0:00:00_白天_妇科内分泌普通号2020/5/12 0:00:00白天0370门诊妇科内分泌普通号4.001.0012020/5/12 0:00:00_白天_生殖科普通号2020/5/12 0:00:00白天0371门诊生殖科普通号4.001.0012020/5/12 0:00:00_白天_ICU转诊号2020/5/12 0:00:00白天0380门诊ICU0元号0.000.0012020/5/12 0:00:00_白天_眼科普通号2020/5/12 0:00:00白天0327眼科普通号4.001.0012020/5/12 0:00:00_白天_心血管二科普通号2020/5/12 0:00:00白天0359门诊心血管内二科普通号4.001.0012020/5/12 0:00:00_白天_口腔科普通号2020/5/12 0:00:00白天0319口腔科普通号4.001.0012020/5/12 0:00:00_白天_泌尿外科普通号2020/5/12 0:00:00白天0311门诊泌尿外科普通号4.001.0012020/5/12 0:00:00_白天_消化内科普通号2020/5/12 0:00:00白天0302门诊消化内科普通号4.001.0012020/5/12 0:00:00_白天_产科周雪静2020/5/12 0:00:00白天0330门诊产科普通号4.001.0012020/5/12 0:00:00_白天_麻醉科普通号2020/5/12 0:00:00白天020901麻醉科普通号4.001.0012020/5/12 0:00:00_白天_中医针灸门诊2020/5/12 0:00:00白天0301门诊中医科普通号4.001.0012020/5/13 0:00:00_白天_妇科王晓雯2020/5/13 0:00:00白天0316门诊妇科普通号4.001.0012020/5/13 0:00:00_白天_妇科郑淑华2020/5/13 0:00:00白天0316门诊妇科普通号4.001.0012020/5/13 0:00:00_白天_中医科闫晋升2020/5/13 0:00:00白天0301门诊中医科普通号4.001.0012020/5/13 0:00:00_白天_耳鼻喉科普通号2020/5/13 0:00:00白天0306门诊耳鼻喉科普通号4.001.0012020/5/13 0:00:00_白天_胸外科普通号2020/5/13 0:00:00白天0366门诊胸外科普通号4.001.0012020/5/13 0:00:00_白天_中医科金光明2020/5/13 0:00:00白天0301门诊中医科普通号4.001.0012020/5/13 0:00:00_上午_中医肾病门诊2020/5/13 0:00:00上午0301门诊中医科普通号4.001.0012020/5/13 0:00:00_白天_骨科普通号2020/5/13 0:00:00白天0312门诊骨科普通号4.001.0012020/5/13 0:00:00_白天_普通外科普通号2020/5/13 0:00:00白天0335门诊普通外科普通号4.001.0012020/5/13 0:00:00_白天_皮肤科普通号2020/5/13 0:00:00白天0318门诊皮肤科普通号4.001.0012020/5/13 0:00:00_白天_老年病科普通号2020/5/13 0:00:00白天0354门诊老年病科普通号4.001.0012020/5/13 0:00:00_白天_呼吸内科普通号2020/5/13 0:00:00白天0317呼吸与危重症医学科普通号4.001.0012020/5/13 0:00:00_白天_ICU转诊号2020/5/13 0:00:00白天0380门诊ICU0元号0.000.0012020/5/13 0:00:00_上午_口腔科普通号2020/5/13 0:00:00上午0319口腔科普通号4.001.0012020/5/13 0:00:00_下午_口腔科普通号2020/5/13 0:00:00下午0319口腔科普通号4.001.0012020/5/13 0:00:00_白天_肿瘤科转诊号2020/5/13 0:00:00白天0338门诊肿瘤科0元号0.000.0012020/5/13 0:00:00_白天_神经内科普通号2020/5/13 0:00:00白天0303门诊神经内科普通号4.001.0012020/5/13 0:00:00_白天_病理科转诊号2020/5/13 0:00:00白天0346门诊病理0元号0.000.0012020/5/13 0:00:00_白天_产科转诊号2020/5/13 0:00:00白天0330门诊产科0元号0.000.0012020/5/13 0:00:00_白天_儿科转诊号2020/5/13 0:00:00白天0304门诊儿科0元号0.000.0012020/5/13 0:00:00_白天_耳鼻喉科转诊号2020/5/13 0:00:00白天0306门诊耳鼻喉科0元号0.000.0012020/5/13 0:00:00_白天_风湿免疫科转诊号2020/5/13 0:00:00白天0337门诊风湿免疫科0元号0.000.0012020/5/13 0:00:00_白天_妇科内分泌转诊号2020/5/13 0:00:00白天0370门诊妇科内分泌0元号0.000.0012020/5/13 0:00:00_白天_妇科转诊号2020/5/13 0:00:00白天0316门诊妇科0元号0.000.001 ◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆