1 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =131002 order by RCKMXH 2 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130902 order by RCKMXH 3 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130902 order by RCKMXH 4 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130903 order by RCKMXH 5 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130903 order by RCKMXH 6 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130904 order by RCKMXH 7 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130904 order by RCKMXH 8 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130905 order by RCKMXH 9 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130905 order by RCKMXH 10 17:23:10 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130906 order by RCKMXH 11 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130906 order by RCKMXH 12 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130907 order by RCKMXH 13 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130907 order by RCKMXH 14 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130908 order by RCKMXH 15 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130908 order by RCKMXH 16 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =131001 order by RCKMXH 17 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =131001 order by RCKMXH 18 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130701 order by RCKMXH 19 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =130701 order by RCKMXH 20 17:23:11 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =131002 order by RCKMXH 21 17:23:11 SQL Execute: ORACLE - Select COUNT(DISTINCT FPH000) as FPZS00 from WZ_RCKMX0 Where FPH000 is not null and rckid0 in (130902,130903,130904,130905,130906,130907,130908,131001,130701,131002) 22 17:23:11 SQL Execute: ORACLE - select FKDXH0,FKRQ00 from WZ_RCK000 Where rckid0 in (130902,130903,130904,130905,130906,130907,130908,131001,130701,131002) 23 17:23:11 SQL Execute: ORACLE - Select SUM(ZJE000) as HJJE00 from WZ_RCKMX0 Where rckid0 in (130902,130903,130904,130905,130906,130907,130908,131001,130701,131002) 24 17:23:11 SQL Execute: ORACLE - SELECT WZSXMC,WZEJFL,sum(ZJE000) ZJE000 FROM VW_WZ_RCKMX0 WHERE RCKID0 in (130902,130903,130904,130905,130906,130907,130908,131001,130701,131002) group by WZSXMC,WZEJFL 25 17:23:11 SQL Execute: ORACLE - select (select SP_WZ_RCKDH0_TJ(208004249) from dual) FKDHZ0,'其中：卫生材料(骨科高值易耗材料:97533.000,骨科内外固定材料:21837.000)' HKSY00,'壹拾壹万玖仟叁佰柒拾元整' RMBDX0,'119370.00' RMBXX0,10 FPZS00,208004249 FKDH00,FHBMMC DWQC00,substr(a.KDRQ00,1,4)||'年'||substr(a.KDRQ00,5,2)||'月'||substr(a.KDRQ00,7,2)||'日' ZWKDRQ, substr(a.QRRQ00,1,4)||'年'||substr(a.QRRQ00,5,2)||'月'||substr(a.QRRQ00,7,2)||'日' ZWQRRQ,substr(a.SHRQ00,1,4)||'年'||substr(a.SHRQ00,5,2)||'月'||substr(a.SHRQ00,7,2)||'日' ZWSHRQ,a.* from vw_wz_RCK000 a where rckid0 in (130902,130903,130904,130905,130906,130907,130908,131001,130701,131002) and rownum=1 26 17:23:11 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 27 17:23:11 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 28 17:23:11 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 29 17:23:11 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 30 17:23:11 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 31 17:23:11 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 32 17:23:11 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 33 17:23:11 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 34 17:23:11 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 35 17:23:11 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 36 17:23:11 SQL Execute: ORACLE - select (select SP_WZ_RCKDH0_TJ('0') from dual) FKDHZ0,(select FKDXH0 from wz_rck000 where rckid0=0) FKDH00 ,a.* from vw_SB_RCK000 a where rckid0=0 37 17:23:11 SQL Execute: ORACLE - select 1 from dual