1       08:56:10  SQL Execute: ORACLE - Select SYSDATE from Dual

2       08:56:10  SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'

3       08:56:10  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')

4       08:56:10  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-FZYB'
and KLDH00 not in ('CK','JMCK')

5       08:56:10  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-FJYB'
and KLDH00 not in ('CK','JMCK')

6       08:56:10  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-MTYB'
and KLDH00 not in ('CK','JMCK')

7       08:56:10  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')

8       08:56:12  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'FZYBA10220587'
and ICKNBH = 'FZYBA10220587'

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

12      08:56:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA10220587
13      08:56:12  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

14      08:56:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4143287.000000
15      08:56:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
16      08:56:12  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

17      08:56:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA10220587
18      08:56:12  SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00  from dual

19      08:56:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4143287.000000
20      08:56:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
21      08:56:12  SQL Execute: ORACLE -  select SF_SF_ZHDJZT(?,?)FHJG00 from dual

22      08:56:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA10220587
23      08:56:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000
24      08:56:12  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?)FHJG00 from dual

25      08:56:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA10220587
26      08:56:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001
27      08:56:12  SQL Execute: ORACLE -  select SF_SF_YYTOPEN(?,?)FHJG00 from dual

28      08:56:12  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=4143287 

29      08:56:12  SQL Execute: ORACLE - Select To_date('19540306','YYYY.MM.DD') from dual

30      08:56:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4143287
31      08:56:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 李微
32      08:56:12  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 
   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')

33      08:56:12  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 = 'D') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1249
  AND b.JSKSBH = '721')
  AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null)