1       18:21:06  SQL Data In: ORACLE - Param = 1, Name = P_YKBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 169.000000
2       18:21:06  SQL Data In: ORACLE - Param = 2, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
3       18:21:06  SQL Data In: ORACLE - Param = 3, Name = P_LBBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
4       18:21:06  SQL Data In: ORACLE - Param = 4, Name = P_YLBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
5       18:21:06  SQL Data In: ORACLE - Param = 5, Name = P_JXBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
6       18:21:06  SQL Data In: ORACLE - Param = 6, Name = P_ZDFD00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
7       18:21:06  SQL Data In: ORACLE - Param = 7, Name = P_CKYF00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999999
8       18:21:06  SQL Data In: ORACLE - Param = 8, Name = P_SYYP00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
9       18:21:06  SQL Data In: ORACLE - Param = 9, Name = P_CGJHDH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
10      18:21:06  SQL Data In: ORACLE - Param = 10, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
11      18:21:06  SQL Data In: ORACLE - Param = 11, Name = P_GHDW00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
12      18:21:06  SQL Data In: ORACLE - Param = 12, Name = P_GHZQ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
13      18:21:06  SQL Execute: ORACLE - BEGIN "SP_YK_YPCGJHSC" (P_YKBMBH => :P_YKBMBH,P_CZYBH0 => :P_CZYBH0,P_LBBH00 => :P_LBBH00,P_YLBH00 => :P_YLBH00,P_JXBH00 => :P_JXBH00,P_ZDFD00 => :P_ZDFD00,P_CKYF00 => :P_CKYF00,P_SYYP00 => :P_SYYP00,P_CGJHDH => :P_CGJHDH,P_MESSAGE => :P_MESSAGE,P_GHDW00 => :P_GHDW00,P_GHZQ00 => :P_GHZQ00); END;
14      18:21:06  SQL Execute: ORACLE - Commit

15      18:21:06  SQL Data In: ORACLE - Rows affected = 0
16      18:21:06  SQL Execute: ORACLE - SELECT D.CGJHDH,D.YKBMBH,D.CZYBH0,D.QRRBH0,D.SFQR00,D.JHBZRQ,D.QRRQ00,D.GHDWNM,
W.GHDWMC
 from YK_YPCGJH D,BM_YPGHDW W 
 WHERE SFQR00='N'
 AND YKBMBH=169
 AND CGJHDH='003024'
 AND D.GHDWNM=W.GHDWNM(+) 

17      18:21:06  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

18      18:21:06  SQL Execute: ORACLE - SELECT To_Char(SYSDATE-30, 'YYYYMMDD') OraSysDate FROM DUAL

19      18:21:06  SQL Execute: ORACLE -  select bmbh00 from bm_bmbm00 where yyid00='223455' and bmxz00 in ('2','3') 

20      18:21:06  SQL Execute: ORACLE - select C.CGJHDH,C.YPNM00,C.YPMC00,C.YPGG00,C.CGDW00,C.ZHL000,C.BZ0000,
C.LSDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,C.CGCKSL,nvl(C.GHDWNM,1) GHDWNM,nvl(C.CGMXXH,1) CGMXXH,D.YPBM00,
C.JHCGSL,C.GJDJ00,D.KCSL00,D.KCSX00,D.KCXX00,D.ZBXH00,D.PYSM00,
(select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC, 
E.YPTYM0,E.ZBQMC0,
 D.YFZSL0,
(select MAX(JZRQ00) ZHCKRQ FROM YK_YPMXZ0 WHERE YKBMBH=D.YKBMBH
 AND YPNM00=C.YPNM00 AND JZXZ00='C') ZHCKRQ,E.SFZBYP,
 (DECODE('Y','N',0,
 (SELECT Round(Sum(Nvl(a.FCSL00*a.ZHL000/a.K2J000,0)),3) FROM VW_YK_YFYPSYL a WHERE  a.YPNM00=C.YPNM00 
 AND a.JZRQ00 BETWEEN '20220325' AND '20220401' GROUP BY a.YPNM00))) YFSYL0,E.YPMLBZ, 
 (SELECT Round(Sum(Nvl(FCSL00*ZHL000/K2J000,0)),3) FROM VW_YK_YFYPSYL WHERE YPNM00=C.YPNM00 AND JZRQ00 BETWEEN '20220302' AND '20220401' AND yfbmbh in (165,166,5,173,179,226,1329,163,1389,2809,2909,2910,2972)) JQYL00 
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YD0000 E 
 WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=169
 AND CGJHDH='003024' AND C.YPNM00=E.YPNM00 
  ORDER BY GHDWNM,CGMXXH