◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:56
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1 and 100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:56
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:56
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 101 and 200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:56
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:56
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 201 and 300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:56
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 301 and 400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 401 and 500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 501 and 600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 601 and 700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 701 and 800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:58
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 801 and 900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:58
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:58
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 901 and 1000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:58
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:58
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1001 and 1100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:58
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:58
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1101 and 1200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:58
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:59
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1201 and 1300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:59
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:59
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1301 and 1400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:59
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:59
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1401 and 1500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:59
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 00:59:59
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1501 and 1600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 00:59:59
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:00
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1601 and 1700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:00
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:00
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1701 and 1800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:00
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:00
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1801 and 1900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:00
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:00
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1901 and 2000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:00
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:00
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2001 and 2100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:00
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:01
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2101 and 2200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:01
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:01
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2201 and 2300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:01
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:01
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2301 and 2400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:01
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:01
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2401 and 2500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:01
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:02
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2501 and 2600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:02
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:02
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2601 and 2700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:02
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:02
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2701 and 2800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:02
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:02
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2801 and 2900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:02
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:02
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2901 and 3000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:02
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:03
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3001 and 3100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:03
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:03
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3101 and 3200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:03
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:03
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3201 and 3300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:03
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:03
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3301 and 3400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:03
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:04
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3401 and 3500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:04
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 01:00:04
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3501 and 3600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 01:00:04
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:55
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1 and 100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:55
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:56
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 101 and 200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:56
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:56
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 201 and 300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:56
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:56
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 301 and 400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:56
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 401 and 500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 501 and 600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 601 and 700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 701 and 800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:57
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 801 and 900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:57
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:58
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 901 and 1000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:58
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:58
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1001 and 1100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:58
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:58
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1101 and 1200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:58
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:58
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1201 and 1300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:58
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:59
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1301 and 1400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:59
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:59
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1401 and 1500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:59
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:59
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1501 and 1600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:59
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:59
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1601 and 1700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:59
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 12:59:59
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1701 and 1800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 12:59:59
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:00
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1801 and 1900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:00
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:00
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 1901 and 2000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:00
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:00
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2001 and 2100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:00
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:00
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2101 and 2200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:00
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:01
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2201 and 2300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:01
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:01
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2301 and 2400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:01
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:01
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2401 and 2500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:01
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:02
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2501 and 2600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:02
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:02
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2601 and 2700  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:02
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:02
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2701 and 2800  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:02
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:02
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2801 and 2900  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:02
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:03
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 2901 and 3000  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:03
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:03
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3001 and 3100  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:03
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:03
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3101 and 3200  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:03
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:03
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3201 and 3300  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:03
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:03
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3301 and 3400  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:03
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:04
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3401 and 3500  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:04
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询
记录时间：2024-06-14 13:00:04
记录内容：         select  * from (  SELECT ac.*, ROWNUM ROWNUM_ FROM(    select a.QUANTITY,a.STORAGE, b.PRICE PRICE, a.purchase_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.package_spec||a.firm_id = b.item_spec )ac )a         where ROWNUM_ between 3501 and 3600  
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：药品查询 总数
记录时间：2024-06-14 13:00:04
记录内容：          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     
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆