1       08:31:54  SQL Execute: ORACLE - select  SF_SF_CHECKHSXM  NUM  from  dual 

2       08:31:54  SQL Execute: ORACLE - select '所有病人' as YBMC00 from dual

3       08:31:54  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220506
4       08:31:54  SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00
5       08:31:54  SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220506
6       08:31:54  SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59
7       08:31:54  SQL Data In: ORACLE - Param = 5, Name = AS_HSXMMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有项目
8       08:31:54  SQL Data In: ORACLE - Param = 6, Name = AS_XXLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
9       08:31:54  SQL Data In: ORACLE - Param = 7, Name = AS_TJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
10      08:31:54  SQL Data In: ORACLE - Param = 8, Name = AS_FYFSLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
11      08:31:54  SQL Data In: ORACLE - Param = 9, Name = AS_FBBH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
12      08:31:54  SQL Data In: ORACLE - Param = 10, Name = AS_BRFBMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病人
13      08:31:54  SQL Data In: ORACLE - Param = 11, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
14      08:31:54  SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
15      08:31:54  SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
16      08:31:54  SQL Data In: ORACLE - Param = 14, Name = as_YYJC00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
17      08:31:54  SQL Data In: ORACLE - Param = 15, Name = AS_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
18      08:31:54  SQL Execute: ORACLE - BEGIN "SP_SF_MZFPSR_TJ0000" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_HSXMMC => :AS_HSXMMC,AS_XXLB00 => :AS_XXLB00,AS_TJLB00 => :AS_TJLB00,AS_FYFSLB => :AS_FYFSLB,AS_FBBH00 => :AS_FBBH00,AS_BRFBMC => :AS_BRFBMC,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYJC00 => :as_YYJC00,AS_SFDZX0 => :AS_SFDZX0); END;
19      08:31:55  SQL Execute: ORACLE - select ID0000,XMBH01,XMMC01,XMJE01,XMBH02,XMMC02,XMJE02 from (
select ID0000,XMBH01,XMMC01,XMJE01,XMBH02,XMMC02,XMJE02,ORDER0  
 from  BM_MZSRTJ  where  ID0000 in (210809)
  and  (XMBH01<>'-1' or XMBH01 is null)
  )order  by  ID0000,order0,XMBH01,XMBH02  

20      08:31:55  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 = '4') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '44')
  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)