1       15:35:02  Log started for: SQL Navigator for Oracle
2       15:35:17  Log started for: 门诊护士工作站
3       15:35:27  SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual 

4       15:35:27  SQL Execute: ORACLE - select (select VALUE0 from XT_XTCS00 where NAME00='XT_XNDK') VALUE0,SF_BM_SQXQTSXX('XT_XNDK','0',1,'191608779') TSXX00   from dual 

5       15:35:27  SQL Execute: ORACLE - Select SYSDATE from Dual

6       15:35:27  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')

7       15:35:27  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'PTYBB39699373'
and ICKNBH = 'PTYBB39699373'

8       15:35:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
9       15:35:27  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen
10      15:35:27  SQL Execute: ORACLE -  select SF_SF_TYZD00(?,?)FHJG00 from dual

11      15:35:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB39699373
12      15:35:27  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

13      15:35:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1018265.000000
14      15:35:27  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
15      15:35:27  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

16      15:35:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB39699373
17      15:35:27  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

18      15:35:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1018265.000000
19      15:35:27  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
20      15:35:27  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

21      15:35:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB39699373
22      15:35:27  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000
23      15:35:27  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
24      15:35:27  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual

25      15:35:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = PTYBB39699373
26      15:35:27  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001
27      15:35:27  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
28      15:35:27  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?,?) FHJG00 from dual

29      15:35:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
30      15:35:27  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = BC00.03.00.34
31      15:35:27  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
32      15:35:27  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1018265.000000
33      15:35:27  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
34      15:35:27  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
35      15:35:27  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
36      15:35:27  SQL Execute: ORACLE - select SF_SF_CREDPAY_JKOPEN(?,?,?,?,?,?,?) AS FHXX00 from dual 

37      15:35:27  SQL Execute: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00,
a.KYJE00,a.BRZJBH,a.BRLXDH 
 from vw_ys_brxxb0 a where a.brid00=1018265 

38      15:35:27  SQL Execute: ORACLE - Select To_date('19830917','YYYY.MM.DD') from dual

39      15:35:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1018265
40      15:35:27  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 吴果琴
41      15:35:27  SQL Execute: ORACLE - select a.*,decode(a.BRID00,0,'Y','N') FLAG00,decode(a.BRID00,0,'未对应','已对应') DYBZ00,
 (select SCKBH0 from BM_CKDY00 where DCKBH0=a.GHHZCK and rownum=1) FZCKBH 
,ceil((to_date(TO_char(sysdate, 'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')-to_date(YYRQ00||YYJSSJ,'YYYYMMDD HH24:MI:SS'))* 24 * 60) YYCDSJ 
, nvl((select TZBZ00 from SF_YSGHHB where GHHBID=a.GHHBID and rownum=1),'0') TZBZ00,YYQYZM,YYQH01,a.YYYGBH 
   from vw_yy_bryyxxcx a where 1=1 
 and (a.BRID00=? or a.BRXM00=?) 
 and a.YYRQ00=to_char(sysdate, 'YYYYMMDD') and ((a.YYJSSJ>'12:00:00' and to_char(sysdate, 'HH24:MI:SS')>'12:00:00' ) or (a.YYJSSJ<='12:00:00' and to_char(sysdate, 'HH24:MI:SS')<='12:00:00' ) )
 and a.YYZT00 in ('0','1')
 and a.DPFYID='223455'