1       23:51:20  SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000
2       23:51:20  SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 779794.000000
3       23:51:20  SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
4       23:51:20  SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
5       23:51:20  SQL Data In: ORACLE - Param = 5, Name = PYFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
6       23:51:20  SQL Data In: ORACLE - Param = 6, Name = PYPLBBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
7       23:51:20  SQL Data In: ORACLE - Param = 7, Name = PTQRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 6/28/2017 0:0:0:0
8       23:51:20  SQL Data In: ORACLE - Param = 8, Name = PBCTQID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
9       23:51:20  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      23:51:20  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3118631.000000
11      23:51:20  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

12      23:51:20  SQL Execute: ORACLE - select yfbmbh,yfbmmc,yplbbh from VW_BQ_YPFWFX WHERE SLBMBH=482

13      23:51:20  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',482,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '482')
  AND (INSTR (',' || a.jsksbh || ',',',482,') > 0 or a.jsksbh is null)