1       11:04:50  SQL Execute: ORACLE - select C.*,FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,
MZFPMC,ZFBL00,YBLB00,SFYBXM,YBLB,SFXM00,YBBRLB,TZBZ00,JXMC00,YBPYSM,YBWBSM ,
(SELECT YLMC00 from BM_YPYL00 WHERE LBBH00=C.LBBH00 AND YLBH00=C.YLBH00) L_YPYL,
(SELECT JXMC00 from BM_YPJX00 WHERE LBBH00=C.LBBH00 AND JXBH00=C.JXBH00) L_YPJX, 
 substr(SF_YK_GetYBYLMC(C.YBYLID),1,120) YBYLMC, 0 YBYLXG 
,substr(SF_YK_GetLJYPFL(C.YPNM00),1,120) LJYPFL 
 FROM (select A.*,(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW,substr(SF_YK_GetYBYLID(a.YPNM00),1,100) YBYLID 
 from bm_yd0000 A,BM_CJYLBM B where 1=1 and A.CYLLSH=B.LSH000(+)
 and A.LBBH00 like '0%'
 and A.YLBH00 like '%'
 and A.JXBH00 like '%'
 and A.YKBMBH=522
 and A.TZRQ00 IS NULL
 ) C,
(select FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,MZFPMC,ZFBL00,YBLB00,SFYBXM,JXMC00,
DECODE(YBLB00,'4','甲类药品','5','乙类药品','6','民族药品','7','非医保药品','8','医保药品') YBLB,
DECODE(SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,YBBRLB,TZBZ00,PYSM00 YBPYSM,WBSM00 YBWBSM 
 from  VW_BM_YBSFDYYPMCFP where 1=1 
 and FBBH00='0'
 and YBZXLB=''
 and SFYBXM like '%'
 AND TZBZ00 like '%'
 ) B  where C.YPNM00=B.SFXMID(+) 
 order by C.YPBM00

2       11:04:50  SQL Data In: ORACLE - Rows affected = 0