1       10:02:54  SQL Execute: ORACLE - Select * from YF_YPPD00
 where YPPDPC=100011339
 and SFQR00='N'

2       10:02:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
3       10:02:54  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6000.000000
4       10:02:54  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
5       10:02:54  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6000.000000
6       10:02:54  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
7       10:02:54  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6000.000000
8       10:02:54  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = ΊΠ
9       10:02:54  SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.100000
10      10:02:54  SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.100000
11      10:02:54  SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6000.000000
12      10:02:54  SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
13      10:02:54  SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 100011339.000000
14      10:02:54  SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5267.000000
15      10:02:54  SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.100000
16      10:02:54  SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.100000
17      10:02:54  SQL Execute: ORACLE - update yf_yppdmx
set
  SJSL00 = round(? * ? ,3),
  YKSL00 = round(? * ? ,3),
  ZMSL00 = round(? * ? ,3),
  PDDW00 = ?,
  PDDJ00 = ?,
  GJJ000 = ?,
  ZHL000 = ?,
  BZ0000 = ?
where
  YPPDPC = ? and
  YPNM00 = ? and 
  PDDJ00 = ? and
  GJJ000 = ?

18      10:02:54  SQL Data In: ORACLE - Rows affected = 1
19      10:02:54  SQL Execute: ORACLE -  update YF_YPPDMX a set a.ZMSL00=(select nvl(sum(b.SJKCSL),0) from YF_PCKCMX b where a.YPNM00=b.YPNM00 and b.YFBMBH=1074) where a.YPPDPC=100011339

20      10:02:54  SQL Data In: ORACLE - Rows affected = 614
21      10:02:54  SQL Execute: ORACLE -  update YF_YPPDMX a set a.YKSL00=(a.SJSL00-a.ZMSL00) where a.YPPDPC=100011339 and a.SJSL00 is not null

22      10:02:54  SQL Data In: ORACLE - Rows affected = 1
23      10:02:54  SQL Execute: ORACLE - commit

24      10:02:54  SQL Data In: ORACLE - Rows affected = 0
25      10:03:22  Log started for: SQL Navigator for Oracle