1       10:20:24  SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
2       10:20:24  SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 919294.000000
3       10:20:24  SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
4       10:20:24  SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
5       10:20:24  SQL Data In: ORACLE - Param = 5, Name = PYFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
6       10:20:24  SQL Data In: ORACLE - Param = 6, Name = PYPLBBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
7       10:20:24  SQL Data In: ORACLE - Param = 7, Name = PTQRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 10/20/2017 0:0:0:0
8       10:20:24  SQL Data In: ORACLE - Param = 8, Name = PBCTQID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
9       10:20:24  SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZTQ" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PYFLBID => :PYFLBID,PYPLBBH => :PYPLBBH,PTQRQ00 => :PTQRQ00,PBCTQID => :PBCTQID); END;
10      10:20:24  SQL Execute: ORACLE -  select 1 from xt_xtcs00 where name00='BQ_BQTQYPSFMRZL' and instr(substr(value0,3),22)>0 and value0 like 'Y%'

11      10:20:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3840184.000000
12      10:20:24  SQL Execute: ORACLE - SELECT 
ID0000,YFBMBH,ZYID00,CH0000,BRXM00,YPLBBH,
DECODE(YPLBBH,'0',NULL,'1',NULL,ZYTS00)"ZYTS00",
YPMC00,SFKCBZ,YPGG00,QLDW00,
JLDW00,ZHL000,CSL000,YPZSL0,
YZID00,YZMXID,YZCLLB,bmmc00,YPZSL0"CKSL00",ypnm00,
sfksly,zfbl00,round(YPZSL0*LSDJ00,2) hjje00
FROM BQ_YZYPSQ x,bm_bmbm00 b WHERE  id0000=? 
and x.yfbmbh=b.bmbh00
order by ch0000,YPLBBH,yzid00,YZMXID

13      10:20:24  SQL Execute: ORACLE - select yfbmbh,yfbmmc,yplbbh from VW_BQ_YPFWFX WHERE SLBMBH=22

14      10:20:49  Log started for: SQL Navigator for Oracle