--手术麻醉系统【手术费用划价】界面跟踪:
Select * from (select xmmc00,bh0000,pysm00,wbsm00,sfxmid,sfje00,sfsx00,sfxx00,gg0000,gjbm00,jsxm00,YBLBMC,ZFBL00,NBLBMC,NBZFBL 
from vw_ss_ybfy00_inp where (pysm00 Like 'l%') 
and( ((ybbrlb='0' and FBBH00='3' and YBZXLB='@' and sfsfxm='Y') or 
(sfsfxm='N')) and ((JSXM00='0')  or jsxm00='0'  or 
(jsxm00='1' and '331003022' Like GJBM00||'%') 
or (JSXM00='2' and Instr
('910010,950058,950059,910123,910161,910162,950060,950061,930010,930001,930003,930002,960015,910096,910077,910203,910170,910218,910219,910220',
substrb(BH0000,1,6))>0)) )  Order By pysm00) where Rownum<=99

其中区别如下：
(JSXM00='0')  or jsxm00='0'


--医技系统【项目执行】界面跟踪:
Select * from (select XMMC00,bh0000,PYSM00,WBSM00,SFXMID,sfje00,gjbm00,jsxm00,YBLBMC,ZFBL00,BZ0000 
from VW_YJ_YBSFXM1 where (pysm00 Like 'l%') and(  (ybbrlb='0' and YBZXLB='@' and fbbh00='3')  
and ((JSXM00='0' and SFXMID in (select SFXMID from XT_ZLSFGX where ZLXMID in 
(select ZLXMID from YJ_YW0000 where YJDJH0=38407691 union all select ZLXMID from YJ_YWMX00 where YJDJH0=38407691)))
or (JSXM00='1' and ('331003022' Like GJBM00||'%')) 
or 
(JSXM00='2' and 
Instr('910010,950058,950059,910123,910161,910162,950060,950061,930010,930001,930003,930002,960015,910096,910077,910203,910170,910218,910219,910220',
substrb(BH0000,1,6))>0)) and (FYID00=rpad('0',6,' ') or FYID00=rpad('B',6,' ')) 
)  Order By Instrb(pysm00,'l'),pysm00) where Rownum<=99

其中区别如下：
(JSXM00='0' and SFXMID in (select SFXMID from XT_ZLSFGX where ZLXMID in 
(select ZLXMID from YJ_YW0000 where YJDJH0=38407691 union all select ZLXMID from YJ_YWMX00 where YJDJH0=38407691)))