1       14:06:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 358283      
2       14:06:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170421
3       14:06:45  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170426
4       14:06:45  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 358283      
5       14:06:45  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170421
6       14:06:45  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170426
7       14:06:45  SQL Execute: ORACLE - SELECT  
to_char(S.TQDJH0) tqdjh1, 
 decode(YPDLBH,'0','西药','1','成药','2','草药')ypdlbh,
 DECODE(YPDLBH,'0',NULL,'1',NULL,ZYTS00)"ZYTS00",
 YPMC00,YPGG00,QLDW00,JLDW00,ZHL000,LSDJ00,CSL000,
 YPZSL0,YZID00,YZMXID,to_char(TQDJH0) TQDJH0,YPQLPC,CXPCID,BMMC00,CXBZ00,H.ZWXM00,
 TO_DATE(SRRQ00||SRSJ00,'YYYYMMDDHH24:MI:SS')CZRQSJ,
 DECODE(QLZT00,'0','申请','1','退费','2','退药','4','退药','5','退药','6','退费') QLZT00,
 S.BRXM00,S.ZYH000,S.CH0000,S.ZYID00,'医嘱领药' yzxz00 
,nvl(S.DJH000,0) DJH000
 FROM  YF_YZYPSQ S,BM_BMBM00 B,BM_YGBM00 H
 WHERE QLZT00 IN ('1','0','2','4','5','6') AND S.FYBZ00='0' 
 AND CXBZ00 IN ('-') AND S.YFBMBH=B.BMBH00(+)
 AND S.CZY000=H.YGBH00

 AND ZYID00 in (SELECT ZYID00 FROM ZY_BRXXB0 WHERE ZYH000=?) AND SRRQ00 BETWEEN ? AND ? AND BQBMBH+0=60 UNION ALL select C.bccfh0,decode(C.YPDLBH,'0','西药','1','成药','2','草药') ypdlbh, NULL ZYTS00 ,YPMC00,YPGG00,CFDW00,JLDW00,ZHL000,LSDJ00,CSL000,YPZSL0,YZID00,YZMXID,C.cflsh0 TQDJH0,to_number(null) YPQLPC,to_number(null) CXPCID,BMMC00,CXBZ00,H.ZWXM00, TO_DATE(c.SRRQ00||c.SRSJ00,'YYYYMMDDHH24:MI:SS') CZRQSJ, DECODE(C.cfzt00,'0','未记账','1','已记账','2','已发药','3','作废') QLZT00, c.BRXM00,c.ZYH000,c.CH0000,c.ZYID00,'自领' yzxz00  FROM YF_ZYCFMX A,YF_ZYCF00 C,BM_BMBM00 B,BM_YGBM00 H  WHERE a.cxbz00 in ('-') AND SFZBY0='N' AND C.YFBMBH=B.bmbh00(+) and  A.CFLSH0=C.CFLSH0 AND  YPZSL0<0 AND C.ZYID00 in (SELECT ZYID00 FROM ZY_BRXXB0 WHERE ZYH000=?) AND C.SRRQ00 BETWEEN ? AND ?  AND DQBQ00+0=60  AND c.CZY000=H.YGBH00 AND  C.CFZT00 IN ('0') AND C.YFBMBH=B.BMBH00(+) 

8       14:06:45  SQL Data In: ORACLE - Rows affected = 0
9       14:06:47  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 ||',', ',60,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1143
  AND b.JSKSBH = '60')
  AND (INSTR (',' || a.jsksbh || ',',',60,') > 0 or a.jsksbh is null)