◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:22
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1 and 100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:22
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:26
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 101 and 200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:26
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:29
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 201 and 300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:29
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:32
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 301 and 400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:32
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:33
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 401 and 500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:33
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:34
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 501 and 600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:34
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:35
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 601 and 700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:35
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:35
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 701 and 800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:35
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:36
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 801 and 900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:36
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:37
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 901 and 1000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:37
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:37
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1001 and 1100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:37
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:38
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1101 and 1200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:38
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:38
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1201 and 1300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:38
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:39
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1301 and 1400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:39
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:39
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1401 and 1500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:39
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:40
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1501 and 1600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:40
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:41
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1601 and 1700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:41
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:41
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1701 and 1800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:41
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:42
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1801 and 1900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:42
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:42
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1901 and 2000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:42
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:43
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2001 and 2100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:43
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:43
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2101 and 2200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:43
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:43
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2201 and 2300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:43
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:44
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2301 and 2400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:44
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:44
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2401 and 2500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:44
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:45
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2501 and 2600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:45
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:45
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2601 and 2700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:45
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:45
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2701 and 2800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:45
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:46
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2801 and 2900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:46
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:09:46
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2901 and 3000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:09:46
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:31
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1 and 100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:31
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:32
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 101 and 200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:32
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:32
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 201 and 300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:32
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:32
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 301 and 400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:32
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:33
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 401 and 500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:33
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:33
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 501 and 600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:33
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:34
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 601 and 700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:34
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:34
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 701 and 800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:34
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:34
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 801 and 900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:34
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:35
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 901 and 1000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:35
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:35
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1001 and 1100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:35
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:36
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1101 and 1200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:36
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:36
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1201 and 1300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:36
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:36
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1301 and 1400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:36
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:37
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1401 and 1500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:37
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:37
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1501 and 1600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:37
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:38
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1601 and 1700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:38
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:38
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1701 and 1800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:38
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:38
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1801 and 1900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:38
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:39
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1901 and 2000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:39
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:39
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2001 and 2100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:39
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:40
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2101 and 2200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:40
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:40
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2201 and 2300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:40
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:41
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2301 and 2400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:41
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:41
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2401 and 2500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:41
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:42
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2501 and 2600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:42
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:42
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2601 and 2700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:42
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:43
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2701 and 2800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:43
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:43
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2801 and 2900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:43
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2019-12-05 20:10:44
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE*a.SUB_PACKAGE_1 PRICE, a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units 
           from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')   ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2901 and 3000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2019-12-05 20:10:44
记录内容：          select  Count(1)Count from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select  a.DRUG_CODE,b.item_class, b.STOP_DATE,  b.item_name,  a.DRUG_SPEC, a.UNITS, a.BATCH_NO, a.FIRM_ID, a.package_spec, a.package_units from (    select DISTINCT   * from  drug_stock WHERE EXPIRE_DATE>= SYSDATE  and STORAGE in('050101','050201')  ) a, (select * from price_list where   ITEM_CLASS in('A','B') and   STOP_DATE is    null  ) b where a.drug_code = b.item_code and   a.drug_spec||a.firm_id = b.item_spec )ac )a     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆