20200615  10:13:38  select jyjg00 from jy_jyjg00 where bgxmid in (select BGxmID from jy_bgxmzd where JGLX00='N' and ywmc00 like '%GLU%' OR BZBM00='GLU') AND JYYWID IN (SELECT JYYWID FROM jy_yw0000 WHERE BRID00=96119922) order by bgrq00 desc,bgsj00 desc
/*  */

20200615  10:13:38  select a.xtnd00,b.ghrq00 from ys_brbqb0 a,sf_brxxb0 b where a.ghid00=b.ghid00 and nvl(a.xtnd00,' ')<>' 'and b.ghrq00>=to_char(sysdate-60,'yyyymmdd')  and b.brid00=96119922
/*  */

20200615  10:13:38  select to_char(SSY000)  displayname, to_char(to_char(SZY000))  cmbvalue from YS_BRBQB0   where GHID00 = (select max(b.ghid00) from sf_brxxb0 b where 1=1 and thbz00<>0 and b.ghlb00<>-99999 and brid00 = 96119922) 
/*  */

20200615  10:13:38  select HZLBMC  displayname, to_char(HZLB00)  cmbvalue from BM_HZLB00
/*  */

20200615  10:13:38   select d.xmmc00 czxmmc,sum(c.sfje00) sfje00, sum(c.sfje00 - c.jmje00) zfje00, x.YDJM00, x.JMHJE0 from  BM_GHXMDY x,bm_zlzd00 a,xt_zlsfgx b, bm_yysfxm c,bm_fpxm00 d  where 1=1  and x.zlxmid=a.zlxmid  and a.zlxmid=b.zlxmid and b.sfxmid=c.sfxmid and c.mzfpid=d.fpxmid   and x.SYBZ00='1' and x.lbbh00 = ?  and (d.xmmc00 = '挂号费' or d.xmmc00 = '诊察费')   and ( x.ghks00 = ? or x.ghks00=-1 )  and (X.ZLXMID not in (select Z.ZLXMID from XT_ZLXMFF Z) or B.ZLXMID in (select Z.ZLXMID from XT_ZLXMFF Z,BM_BMBM00 Y where Z.ZLXMID=B.ZLXMID and Z.YYID00=Y.YYID00 and Z.YXBZ00='1' and Y.BMBH00=?)) group by d.xmmc00,x.YDJM00,x.JMHJE0 
/* parameters:  [<15>^<67>^<67>] */

20200615  10:13:38  select LBMC00  displayname, to_char(LBBH00)  cmbvalue from VW_BM_GHLBB0_MZDZBL9   where (lbbh00 in ( 15,16,25,23))   and lbbh00 not in(23)  and (SFJZLB in('0','2') or lbbh00  in(23)) order by xsxh00 
/*  */

20200615  10:13:38  select MC0000  displayname, to_char(BZ0000)  cmbvalue from bm_tyzd00  where zdmc00='科室门诊挂号类别'
/*  */

20200615  10:13:38  select YGBH00  displayname, to_char(YGBH00)  cmbvalue from BM_BRXXB0   where brid00=96119922
/*  */

20200615  10:13:38   select * from Vw_ys_yxgh00_mzdzbl a where ghlb00 <> -99999 and jzys00 = ?  and ( sfzz00 = '0' or sfzz00 is null)  and brid00 = ?  and ghrq00 = ?  and exists (select 1 from bm_bmbm00 where yyid00 = a.ghyyid and bmbh00 = ? ) order by ghrq00 desc,ghsj00 desc,ghh000 desc 
/* parameters:  [<1017>^<96119922>^<20200615>^<67>] */

20200615  10:13:38   select * from Vw_ys_yxgh00_mzdzbl a where ghlb00 <> -99999 and jzys00 = ?  and ( sfzz00 = '0' or sfzz00 is null)  and brid00 = ?  and ghrq00 = ?  and exists (select 1 from bm_bmbm00 where yyid00 = a.ghyyid and bmbh00 = ? ) order by ghrq00 desc,ghsj00 desc,ghh000 desc 
/* parameters:  [<1017>^<96119922>^<20200615>^<67>] */

20200615  10:13:38  {? = call SF_YS_GHXZ00(?,?,?)}
/* parameters:  [<RESOBJECT~out~12~null>^<Pghks00~in~null~67>^<Pghys00~in~null~1017>^<Pbrid00~in~null~96119922>] */

20200615  10:13:38  select to_char(SF_YF_JudgeSFLNYD(96119922))  displayname, to_char('0')  cmbvalue from dual
/*  */

20200615  10:13:38  select BZ0000  displayname, to_char(MC0000)  cmbvalue from BM_TYZD00  where zdmc00='节假日信息维护' and MC0000>=to_char(sysdate,'yyyyMMdd')
/*  */

20200615  10:13:38  select to_char(sysdate,'yyyyMMdd')  displayname, to_char(to_char(sysdate,'yyyyMMdd'))  cmbvalue from dual
/*  */

20200615  10:13:38  select to_char(sysdate,'D')  displayname, to_char(to_char(sysdate,'D'))  cmbvalue from dual
/*  */

20200615  10:13:38  select mc0000 from bm_tyzd00 where zdmc00='默认急诊号时段' and bh0000='224465'
/*  */

20200615  10:13:38  {? = call SF_YS_GHXZ00(?,?,?)}
/* parameters:  [<RESOBJECT~out~12~null>^<Pghks00~in~null~67>^<Pghys00~in~null~1017>^<Pbrid00~in~null~96119922>] */

20200615  10:13:38   select ROUND((SYSDATE-TO_DATE(GHRQ00||GHSJ00,'YYYY-MM-DD HH24:MI:SS'))*24,1) SJCZ00 from sf_brxxb0  where GHID00 = (select max(ghid00)ghid00 from sf_brxxb0 b where brid00= ? and thbz00<>0) and rownum=1 
/* parameters:  [<96119922>] */

20200615  10:13:38   select DM0000,MC0000 from BM_BRGMXX where JLFL00='4' and SFYX00 = 'Y' AND MZBZ00 = '0'  and BRID00 = ?  and GHID00 = ? 
/* parameters:  [<96119922>^<50084898>] */

20200615  10:13:38   select * from sf_brxxb0  where ghid00 = (select max(b.ghid00) from sf_brxxb0 b where 1=1 and thbz00<>0 and b.brid00 = ?  ) 
/* parameters:  [<96119922>] */

20200615  10:13:38    select * from YS_GHJMSZ where KS0000=? and YS0000=?   and exists(select 1 from BM_TYZD00 where ZDMC00='免挂号费医保中心' and BH0000=? ) 
/* parameters:  [<67>^<1017>^<0>] */

20200615  10:13:38   select  NVL(ZYE000,0) ZYE000, sfdj00  from  sf_brzhxx  where  jflbid = 1  and  brid00 = ? 
/* parameters:  [<96119922>] */

20200615  10:13:38   select GHLBBH,GHLBMC,GHXHS0,GHYGHS  from SF_YSGHHB where 1=1  and GHKSBH= ?  and GHYSBH= ?  and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD')  and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS')  and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS') 
/* parameters:  [<67>^<1017>] */

20200615  10:13:38   select a.*,b.ickh00,b.kmh000 from vw_ys_brxxb0_mzdzbl a,(select * from ic_yhxx00 where zt0000='1') b where a.BRID00 = b.brid00(+)   and a.BRID00=? 
/* parameters:  [<96119922>] */

20200615  10:13:38  select DYZYKS  displayname, to_char((select bmmc00 from bm_bmbm00 where bmbh00=a.dyzyks))  cmbvalue from BM_BMBM00 a   where BMBH00=67
/*  */

20200615  10:13:38  select bh0000,mc0000 from bm_tyzd00 where zdmc00='快马合理用药'
/*  */

20200615  10:13:37  select mc0000 from bm_tyzd00 where zdmc00='PACS图象浏览网址' and bh0000='224465'
/*  */

20200615  10:13:37  select mc0000 from bm_tyzd00 where zdmc00='PACS图文报告网址' and bh0000='224465'
/*  */

20200615  10:13:37  select BBMC00  displayname, to_char(BBID00)  cmbvalue from bm_bbzd00
/*  */

20200615  10:13:37  select mc0000 from bm_tyzd00 where zdmc00='PACS图象浏览网址' and bh0000='224465'
/*  */

20200615  10:13:37  select mc0000 from bm_tyzd00 where zdmc00='PACS图文报告网址' and bh0000='224465'
/*  */

20200615  10:13:37  select BBMC00  displayname, to_char(BBID00)  cmbvalue from bm_bbzd00
/*  */

20200615  10:13:37  select MC0000  displayname, to_char(MC0000)  cmbvalue from bm_tyzd00  where zdmc00 like '证件类型'
/*  */

20200615  10:13:37  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:37  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:37  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:37  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:37  select MC0000  displayname, to_char(MC0000)  cmbvalue from bm_tyzd00  where zdmc00 like '证件类型'
/*  */

20200615  10:13:37  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:37  select MC0000  displayname, to_char(MC0000)  cmbvalue from bm_tyzd00  where zdmc00 like '证件类型'
/*  */

20200615  10:13:37  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:37   Select KLDH00,KLLB00,KHQZBH from IC_KLDM00  where SYBZ00 <> '0'  and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')  Order by SYBZ00 
/*  */

20200615  10:13:37  select DYZYKS  displayname, to_char((select bmmc00 from bm_bmbm00 where bmbh00=a.dyzyks))  cmbvalue from BM_BMBM00 a   where BMBH00=67
/*  */

20200615  10:13:37  select bh0000,mc0000 from bm_tyzd00 where zdmc00='快马合理用药'
/*  */

20200615  10:13:37  select mc0000 from bm_tyzd00 where zdmc00='PACS图象浏览网址' and bh0000='224465'
/*  */

20200615  10:13:37  select mc0000 from bm_tyzd00 where zdmc00='PACS图文报告网址' and bh0000='224465'
/*  */

20200615  10:13:36  select BBMC00  displayname, to_char(BBID00)  cmbvalue from bm_bbzd00
/*  */

20200615  10:13:36  select mc0000 from bm_tyzd00 where zdmc00='PACS图象浏览网址' and bh0000='224465'
/*  */

20200615  10:13:36  select mc0000 from bm_tyzd00 where zdmc00='PACS图文报告网址' and bh0000='224465'
/*  */

20200615  10:13:36  select BBMC00  displayname, to_char(BBID00)  cmbvalue from bm_bbzd00
/*  */

20200615  10:13:36  select MC0000  displayname, to_char(MC0000)  cmbvalue from bm_tyzd00  where zdmc00 like '证件类型'
/*  */

20200615  10:13:36  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:36  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:36  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:36  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:36  select MC0000  displayname, to_char(MC0000)  cmbvalue from bm_tyzd00  where zdmc00 like '证件类型'
/*  */

20200615  10:13:36  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:36  select MC0000  displayname, to_char(MC0000)  cmbvalue from bm_tyzd00  where zdmc00 like '证件类型'
/*  */

20200615  10:13:36  select CFSM00  displayname, to_char(BH0000)  cmbvalue from ys_cfsm00
/*  */

20200615  10:13:36   Select KLDH00,KLLB00,KHQZBH from IC_KLDM00  where SYBZ00 <> '0'  and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')  Order by SYBZ00 
/*  */