1       14:56:07  SQL Execute: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='4' and (MKDM00='4TSBZ' or MKDM00='4BLBF') and ( 
 (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='4' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=1))))

2       14:56:07  SQL Execute: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 7  and  PJSYR0 =1
 and  SYBZ00 = 'Y'

3       14:56:07  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0'

4       14:56:07  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0'

5       14:56:07  SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0'

6       14:56:07  SQL Execute: ORACLE -  select *   from   VW_SF_BRJFLB  where  JFLBID <> 0  

7       14:56:07  SQL Execute: ORACLE -  select * from   BM_BRZTB0  

8       14:56:07  SQL Execute: ORACLE -  select *  from  BM_TYZD00  where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000  

9       14:56:07  SQL Execute: ORACLE - select * from  VW_BM_BRZFFS  where 1=1
 and ZFFSBH<>18 
order by nvl(XSXH00,0),ZFFSBH

10      14:56:07  SQL Execute: ORACLE - select BZ0000,XSXH00 from bm_tyzd00
 where  ZDMC00 = '病人证件类型' and MC0000 = 'Y' and YXBZ00 = '1' order by XSXH00

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