1       15:21:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 221.000000
2       15:21:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 75.000000
3       15:21:29  SQL Execute: ORACLE - SELECT DISTINCT Q.CKDH00,Q.FYRQ00,Q.FYSJ00,Y1.ZWXM00 AS FYRXM0
FROM YF_YZYPSQ Q,BM_YGBM00 Y1
WHERE Q.YFBMBH=?
 AND  Q.BQBMBH=?
 AND  Q.FYR000=Y1.YGBH00
 AND  Q.QLZT00='2'
 AND  Q.HZBZ00='1'
ORDER BY CKDH00 

4       15:21:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
5       15:21:29  SQL Execute: ORACLE - SELECT DISTINCT  BRXM00,ZYID00,BQBMBH,YFBMBH,
     ZYH000, CH0000,CKDH00
FROM YF_YZYPSQ 
WHERE  CKDH00=?
ORDER BY CH0000


 

6       15:21:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
7       15:21:29  SQL Execute: ORACLE - SELECT DISTINCT  BRXM00,ZYID00,BQBMBH,YFBMBH,
     ZYH000, CH0000,CKDH00
FROM YF_YZYPSQ 
WHERE  CKDH00=?
ORDER BY CH0000


 

8       15:21:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
9       15:21:29  SQL Execute: ORACLE - SELECT DISTINCT  BRXM00,ZYID00,BQBMBH,YFBMBH,
     ZYH000, CH0000,CKDH00
FROM YF_YZYPSQ 
WHERE  CKDH00=?
ORDER BY CH0000


 

10      15:21:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
11      15:21:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
12      15:21:29  SQL Execute: ORACLE - SELECT ZYH000,trim(YPMC00)||'/'||trim(YPGG00) as YPMC00,
DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,
PCMC00,CH0000,
rtrim(YFSMMC)||trim(YPYFMC)||rtrim(ZJYFMC)||trim(XMYFMC) as YYFF00,
LSDJ00,YPZSL0,YPZSL0||'('||rtrim(QLDW00)||')' AS LYSL00,
BRXM00,ZYID00,ZYTS00,YPDLBH,YZID00,
decode(SRCS00,-1,null,SRCS00) SRCS00 
FROM YF_YZYPSQ 
WHERE  CKDH00=?
  AND  ZYID00=?
ORDER BY CH0000,DECODE(YPDLBH,'2',TO_CHAR(YZID00),YPMC00)