1       11:42:24  SQL Execute: ORACLE - update yf_ypckd0 set dycs00=nvl(dycs00,0)+1 where ckdh00='1525331' 

2       11:42:24  SQL Data In: ORACLE - Rows affected = 1
3       11:42:24  SQL Execute: ORACLE -  commit 

4       11:42:24  SQL Data In: ORACLE - Rows affected = 0
5       11:42:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YF_ZYBYHZDPXZD
6       11:42:25  SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 

7       11:42:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YF_ZYBYHZDPXZD
8       11:42:25  SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 

9       11:42:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = YF_BYDCZSFXSTYD
10      11:42:25  SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 

11      11:42:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1525331
12      11:42:25  SQL Execute: ORACLE - select distinct CKDH00,TJRXM0,KSMC00,FYRQSJ,YSXM00,FYRXM0,SHRXM0,YFMC00,BQMC00,BYTJ00,FYDLXH,DQKSMC,DYCZ00,SFBD00,FYZJXM,SHZJXM from VW_YF_ZYBYDYDJ where  SFZDBY<>'1' and CKDH00=? and CXBZ00<>'+' 

13      11:42:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YF_ZYBYDYHZDPX
14      11:42:25  SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 

15      11:42:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1525331
16      11:42:25  SQL Execute: ORACLE -  select rownum XH,c.* from (select a.YPMC00,a.YPGG00,a.YPJE00,b.PYSM00,(select SCCJZW from BM_YPSCCJ where SCCJBH = b.SCCJBH) SCCJZW,substr(SF_YF_YPSLZH(a.YPZSL0,a.YPNM00,3),1,50) YPZSL0, substr(SF_YF_YPSLZH(a.SFZSL0,a.YPNM00,3),1,50) SFZSL0,decode(a.JYZSL0,0,'',substr(SF_YF_YPSLZH(a.JYZSL0,a.YPNM00,3),1,50)) JYZSL0, decode(a.GHZSL0,0,'',substr(SF_YF_YPSLZH(a.GHZSL0,a.YPNM00,3),1,50)) GHZSL0,decode(a.SYJYZL,0,'',substr(SF_YF_YPSLZH(a.SYJYZL,a.YPNM00,3),1,50)) SYJYZL, decode(a.JCZSL0,0,'',substr(SF_YF_YPSLZH(a.JCZSL0,a.YPNM00,3),1,50)) JCZSL0,a.LSDJ00,a.QLDW00,a.YPZSL1,   (a.SFZSL0/b.K2J000)  SFZSL1, substr(SF_YF_YPSLZH(a.ZCXSL0,a.YPNM00,3),1,50) ZCXSL0,   substr(SF_YF_YPSLZH(a.SFZSL0,a.YPNM00,2),1,50) SFXSL0,substr(sf_yf_ypslzh(a.SFZSL0*b.K2ZJJL,a.YPNM00,1),1,50)||b.ZJJLDW JJSL00,QWM000,a.GZDJ00,b.ypbm00,a.PDXH00,b.DXSYBZ,b.LBBH00,b.JXBH00,a.CH0000  from (select YPNM00,YPMC00,YPGG00,LSDJ00,QLDW00,PYSM00,SUM(YPZSL0) YPZSL1,SUM(YPZSL0*ZHL000) YPZSL0,SUM((YPZSL0-nvl(JCZSL0,0)-nvl(GHZSL0,0))*ZHL000) SFZSL0,SUM(ZCXSL0*ZHL000) ZCXSL0, sum(JYZSL0*ZHL000) JYZSL0,sum(nvl(GHZSL0,0)*ZHL000) GHZSL0,SUM((JYZSL0-nvl(GHZSL0,0))*ZHL000) SYJYZL,sum(nvl(JCZSL0,0)*ZHL000) JCZSL0,SUM(YPJE00) YPJE00,1 as QWM000,PYSM00,GZDJ00 ,max(PDXH00) PDXH00,wm_concat(a.ch0000) ch0000 from VW_YF_ZYBYDYMX a where  SFZDBY<>'1' and CKDH00= ? GROUP BY YPNM00,YPMC00,YPGG00,LSDJ00,QLDW00,PYSM00,GZDJ00 ) a,bm_yd0000 b where a.ypnm00=b.ypnm00 order by a.QWM000,b.DXSYBZ,b.LBBH00,b.JXBH00,b.YPBM00) c