1       19:14:59  SQL Execute: ORACLE - select trim(SF_YF_BYTJMX('a','7')) BYTJ00 from dual

2       19:14:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
3       19:14:59  SQL Execute: ORACLE - select BYFHBZ from YF_BYTJ00 where ID0000=?

4       19:14:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 862.000000
5       19:14:59  SQL Execute: ORACLE - SELECT B.BMBH00,B.BMMC00 from BM_BMBM00 B where  EXISTS (select 1 
FROM VW_YF_ZYBYXX A  
WHERE  A.YFBMBH=? AND A.BQBMBH=B.BMBH00 
and a.ZBYBZ0='0' 
 and (( (a.YZXZ00='4'))) and ( a.PSPC00 is null or a.PSPC00 is not null and a.YYRQ00>=to_char(sysdate,'YYYYMMDD') )
) order by pxxh00,bmbh00 

6       19:14:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
7       19:14:59  SQL Execute: ORACLE - select count(1) NUM from YF_BYTJMX where bytjid=? and (tjmc00='非注射剂' or GLMC00='配送批次' and SFFZ00='N' 
 or GLMC00 = '医嘱属性' and tjmc00<>'长期医嘱' ) 

8       19:14:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
9       19:14:59  SQL Execute: ORACLE - select count(1) NUM from YF_BYTJMX where bytjid=? and (tjmc00='非注射剂' or GLMC00='配送批次' and SFFZ00='N' 
 or GLMC00 = '医嘱属性' and tjmc00='长期医嘱' ) 

10      19:14:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 862.000000
11      19:14:59  SQL Execute: ORACLE - select count(distinct(ZYID00)) SL0000 from VW_YF_ZYBYXX a where 1=1 
 and nvl(a.ZBYBZ0,'0')='0' 
 and YFBMBH=?  and (( (a.YZXZ00='4'))) and ( a.PSPC00 is null or a.PSPC00 is not null and a.YYRQ00>=to_char(sysdate,'YYYYMMDD') )

12      19:15:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 862.000000
13      19:15:05  SQL Execute: ORACLE - select rownum PXXH00,a.*,' ' as FYSBYY,'     ' as NEWPC0  from VW_YF_ZYBYXX a where 1=1 
 and YFBMBH=?  and (( (a.YZXZ00='4'))) and ( a.PSPC00 is null or a.PSPC00 is not null and a.YYRQ00>=to_char(sysdate,'YYYYMMDD') )
and a.ZBYBZ0='0' 
 Order by a.CH0000,a.YYRQ00,a.yzid00,a.YZMXID 

14      19:19:05  SQL Execute: ORACLE - select trim(SF_YF_BYTJMX('a','10')) BYTJ00 from dual

15      19:19:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10
16      19:19:05  SQL Execute: ORACLE - select BYFHBZ from YF_BYTJ00 where ID0000=?

17      19:19:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 160.000000
18      19:19:05  SQL Execute: ORACLE - SELECT B.BMBH00,B.BMMC00 from BM_BMBM00 B where  EXISTS (select 1 
FROM VW_YF_ZYBYXX A  
WHERE  A.YFBMBH=? AND A.BQBMBH=B.BMBH00 
and a.ZBYBZ0='0' 
 and (( (a.YZXZ00='3'))) and ( a.PSPC00 is null or a.PSPC00 is not null and a.YYRQ00>=to_char(sysdate,'YYYYMMDD') )
) order by pxxh00,bmbh00 

19      19:19:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10
20      19:19:05  SQL Execute: ORACLE - select count(1) NUM from YF_BYTJMX where bytjid=? and (tjmc00='非注射剂' or GLMC00='配送批次' and SFFZ00='N' 
 or GLMC00 = '医嘱属性' and tjmc00<>'长期医嘱' ) 

21      19:19:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10
22      19:19:05  SQL Execute: ORACLE - select count(1) NUM from YF_BYTJMX where bytjid=? and (tjmc00='非注射剂' or GLMC00='配送批次' and SFFZ00='N' 
 or GLMC00 = '医嘱属性' and tjmc00='长期医嘱' ) 

23      19:19:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 160.000000
24      19:19:05  SQL Execute: ORACLE - select count(distinct(ZYID00)) SL0000 from VW_YF_ZYBYXX a where 1=1 
 and nvl(a.ZBYBZ0,'0')='0' 
 and YFBMBH=?  and (( (a.YZXZ00='3'))) and ( a.PSPC00 is null or a.PSPC00 is not null and a.YYRQ00>=to_char(sysdate,'YYYYMMDD') )

25      19:19:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 160.000000
26      19:19:12  SQL Execute: ORACLE - select rownum PXXH00,a.*,' ' as FYSBYY,'     ' as NEWPC0  from VW_YF_ZYBYXX a where 1=1 
 and YFBMBH=?  and (( (a.YZXZ00='3'))) and ( a.PSPC00 is null or a.PSPC00 is not null and a.YYRQ00>=to_char(sysdate,'YYYYMMDD') )
and a.ZBYBZ0='0' 
 Order by a.CH0000,a.YYRQ00,a.yzid00,a.YZMXID