1       10:38:04  Log started for: Sickberth
2       10:38:40  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',641,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',2360,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =2360 AND b.JSKSBH = '641')
  AND (INSTR (',' || a.jsksbh || ',',',641,') > 0 or a.jsksbh is null)  

3       10:38:43  SQL Execute: ORACLE - select * from VW_BQ_JRZXD0 a  where BQH000=641 and zyid00 in (796000)  AND YFID00 IN (001,031)  and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00   and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')   and nvl( ZXDDY0,'0') in ('1','0'))

4       10:38:43  SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (15079103,'150791021')

5       10:38:43  SQL Data In: ORACLE - Rows affected = 1
6       10:38:43  SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (15079108,'150791071')

7       10:38:43  SQL Data In: ORACLE - Rows affected = 1
8       10:38:43  SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (15092743,'150927421')

9       10:38:43  SQL Data In: ORACLE - Rows affected = 1
10      10:38:43  SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (15084332,'150843311')

11      10:38:43  SQL Data In: ORACLE - Rows affected = 1
12      10:38:43  SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (15073675,'150736741')

13      10:38:43  SQL Data In: ORACLE - Rows affected = 1
14      10:38:43  SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (15073677,'150736761')

15      10:38:43  SQL Data In: ORACLE - Rows affected = 1
16      10:38:43  SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (15073681,'150736801')

17      10:38:43  SQL Data In: ORACLE - Rows affected = 1
18      10:38:43  SQL Execute: ORACLE - select a.*,decode(a.PCMC00,'qd','7','bid','17-7','tid','12-17-7',' ') PCMC01,a.MCSL00||a.JLDW00 MCSLDW from YJ_ZLXMID_TMP t1, VW_BQ_JRZXD0 a  where BQH000=641 and zyid00 in (796000)  AND YFID00 IN (001,031)  and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00   and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')   and nvl( ZXDDY0,'0') in ('1','0')) and a.YZMXID=t1.ZLXMID(+) order by Ch0000,yzid00,t1.zb0000,a.YZMXID 

19      10:38:43  SQL Execute: ORACLE - select '口服药发药治疗单' bt0000, to_char(sysdate,'yyyy-mm-dd') zxrq00,'急诊病区' BMMC00,to_char(sysdate,'yyyymmdd') zxrq01 from dual

20      10:38:43  SQL Execute: ORACLE - select a.*,decode(a.PCMC00,'qd','7','bid','17-7','tid','12-17-7',' ') PCMC01,a.MCSL00||a.JLDW00 MCSLDW from YJ_ZLXMID_TMP t1, VW_BQ_JRZXD0 a  where BQH000=641 and zyid00 in (796000)  AND YFID00 IN (001,031)  and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00   and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')   and nvl( ZXDDY0,'0') in ('1','0')) and a.YZMXID=t1.ZLXMID(+) order by Ch0000,yzid00,t1.zb0000,a.YZMXID 


21      10:38:43  SQL Execute: ORACLE - select '滴液类执行单' bt0000,to_char(sysdate,'yyyymmdd') zxrq00 from dual 

22      10:38:43  SQL Execute: ORACLE - select * from VW_BQ_JRZJYZ where 1=2