1       09:23:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 24524
2       09:23:31  SQL Execute: ORACLE - select * from vw_py_dycfdl where brid00=?  and PYCKBH=58 and  jzrq00>=to_char(sysdate-0,'YYYYMMDD')  order by FYDLXH,dysj00

3       09:23:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1503645         
4       09:23:31  SQL Execute: ORACLE - Update YF_CFDL00 set DYRQ00=to_char(sysdate,'YYYYMMDD'),DYSJ00=to_char(sysdate,'HH24:MI:SS'),ZT0000='1' where CFLSH0=?

5       09:23:31  SQL Data In: ORACLE - Rows affected = 1
6       09:23:31  SQL Execute: ORACLE - commit

7       09:23:31  SQL Data In: ORACLE - Rows affected = 0
8       09:23:31  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

9       09:23:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1503645         
10      09:23:31  SQL Execute: ORACLE - select YPDLBH,ZYDJS0,TRIM(CFDGS0) CFDGS0, 
 SF_YF_GETCFDGS0(CFLSH0,'0') CFDGS1,BRXM00,NVL(CFBDCS,0) CFBDCS from YF_MZCF00 WHERE CFLSH0=?

11      09:23:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1503645         
12      09:23:31  SQL Execute: ORACLE - SELECT trim(GETCFJNDJCTS(B.CFLSH0))||' '||DECODE(INSTR(BMMC00,'¼±'),0,DECODE(INSTR(BMMC00,'¶ù'),0,'','¶ù¿Æ'),'¼±Õï') XZKS00 FROM SF_BRXXB0 A,YF_MZCF00 B,BM_BMBM00 C WHERE A.GHID00=B.GHID00 AND A.JZKS00=C.BMBH00 AND B.CFLSH0=?

13      09:23:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1503645         
14      09:23:31  SQL Execute: ORACLE - select * from VW_YF_MZZYDY_BZ Where CFLSH0=?  

15      09:23:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1503645         
16      09:23:31  SQL Execute: ORACLE - select * from VW_YF_MZZYMX_BZ Where CFLSH0=? and CFID00>0 order by CFID00 

17      09:23:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1503645         
18      09:23:31  SQL Execute: ORACLE -  SELECT * FROM VW_YF_DJDDY  WHERE CFLSH0=?

19      09:23:31  SQL Execute: ORACLE - update YF_MZCF00 set CFBDCS=nvl(CFBDCS,0)+1 where CFLSH0='1503645'

20      09:23:31  SQL Data In: ORACLE - Rows affected = 1
21      09:23:31  SQL Execute: ORACLE - COMMIT

22      09:23:31  SQL Data In: ORACLE - Rows affected = 0
23      09:23:32  SQL Execute: ORACLE - select * from vw_py_dycfdl a where PYCKBH=58  and  a.jzrq00>=to_char(sysdate-0,'YYYYMMDD')  order by a.FYDLXH

24      09:23:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data =                 
25      09:23:32  SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'¼å·þ','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00,
 trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,
trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,
decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),
trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 
from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0  and b.cflsh0=?

 
 
 
 
 
 
 

26      09:23:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data =                 
27      09:23:32  SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'¼å·þ','',a.YPYFMC) as yfmcbm , a.YPZSL0*a.lsdj00 as xjje00,
 trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,
trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,
decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),
trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 
from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0  and b.cflsh0=?