1       08:47:48  SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B
 WHERE F.BQBMBH=B.BMBH00 
   AND F.YFBMBH=35
   AND B.BMXZ00='9' AND B.FLAG00='1'
 ORDER BY B.BH0000

2       08:47:48  SQL Execute: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2'
 WHERE YFBMBH=35
   AND BQBMBH=29

3       08:47:48  SQL Data In: ORACLE - Rows affected = 1
4       08:47:48  SQL Execute: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1'
 WHERE YFBMBH=35
   AND BQBMBH=29
   AND QLZT00 IN ('0','1')
   AND FYBZ00='0'
   AND THBZ00='0'
   AND CXBZ00='Z'

5       08:47:48  SQL Data In: ORACLE - Rows affected = 390
6       08:47:48  SQL Execute: ORACLE - COMMIT

7       08:47:48  SQL Data In: ORACLE - Rows affected = 0
8       08:47:49  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000
9       08:47:49  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35.000000
10      08:47:49  SQL Execute: ORACLE - SELECT DISTINCT BRXM00,ZYID00,BQBMBH,YFBMBH,ZYH000,CH0000 
FROM YF_YZYPSQ 
WHERE BQBMBH=? AND YFBMBH=? 
AND QLZT00 IN ('0','1') AND HZBZ00='1' 
AND FYBZ00='1' AND CXBZ00='Z' 
ORDER BY CH0000

11      08:47:49  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1295496.000000
12      08:47:49  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000
13      08:47:49  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35.000000
14      08:47:49  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
15      08:47:49  SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00,
  DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000,
  decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00,
  a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00,
  a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*)  from yf_yzypsq where yzid00=a.YZID00 and ypnm00=a.YPNM00
and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0
FROM YF_YZYPSQ a
WHERE ZYID00=?
  AND a.BQBMBH=?
  AND a.YFBMBH=?
  AND a.CLBZ00 LIKE ?
  AND a.QLZT00 IN('0','1')
  AND a.HZBZ00='1'
  AND a.FYBZ00='1'
  AND a.CXBZ00='Z'
ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID