1       15:02:00  Log started for: 项目管理系统
2       15:02:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
3       15:02:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
4       15:02:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
5       15:02:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 950002%
6       15:02:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
7       15:02:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
8       15:02:02  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
9       15:02:02  SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00,
DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb,
DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00,
SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00,DYBZ00,SCCJ00,YBSCCJ,YBBZ00 
FROM  VW_BM_YBSFDYXMMCFP
WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ?
) and sfybxm like ? and TZBZ00 like ?
 and FYID00=rpad(?,6,' ') 
order by YYXMBH