1       09:05:47  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 = '3') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',11,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1150
  AND b.JSKSBH = '11')
  AND (INSTR (',' || a.jsksbh || ',',',11,') > 0 or a.jsksbh is null)  

2       09:05:53  SQL Execute: ORACLE - SELECT R.CGJHDH,Y.ZWXM00,R.JHBZRQ,W.GHDWMC,R.BZ0000
,(select zwxm00 from bm_ygbm00 where ygbh00=r.cgqrr0) cgqrr0,r.cgqrrq,r.cgqrsj
 FROM YK_YPCGJH R,BM_YGBM00 Y,BM_YPGHDW W
 WHERE R.YKBMBH=11
 AND R.CZYBH0=Y.YGBH00(+) AND R.GHDWNM=W.GHDWNM(+)
 AND R.SFQR00='N'
 ORDER BY R.CGJHDH DESC

3       09:05:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 004376
4       09:05:53  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 004376
5       09:05:53  SQL Execute: ORACLE - select * from(
select nvl(to_char(C.SHSL00),to_char(C.JHCGSL)) SHSL00,nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL,C.BZ0000,
to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCZSL0) AS KCSL00,D.ZBXH00, 
 (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC, 
to_char(D.KCSX00) As KCSX00,to_char(D.KCXX00) KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPZKC0 D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=11
 AND D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00 
 AND C.CGJHDH=? 
 union all 
select ' ' SHSL00,9999999999999 CGMXXH,' ' CGJHDH,'ºÏ ¼Æ' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL,' ' BZ0000,
 ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' YPTYM0,' ' YPBM00,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM, 
 ' ' KCSL00,' ' ZBXH00,' ' GHDWMC,' ' KCSX00,' ' KCXX00,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000,' ' YFZSL0,' ' YPMLBZ,0 ypnm00 
 from YK_CGJHMX C
 WHERE C.CGJHDH=?
 )ORDER BY GHDWNM,CGMXXH

6       09:05:53  SQL Execute: ORACLE - update YK_CGJHMX set SHSL00=6where CGMXXH=308158

7       09:05:53  SQL Data In: ORACLE - Rows affected = 1
8       09:05:53  SQL Execute: ORACLE - commit

9       09:05:53  SQL Data In: ORACLE - Rows affected = 0
10      09:05:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 004376
11      09:05:53  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 004376
12      09:05:53  SQL Execute: ORACLE - select * from(
select nvl(to_char(C.SHSL00),to_char(C.JHCGSL)) SHSL00,nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL,C.BZ0000,
to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCZSL0) AS KCSL00,D.ZBXH00, 
 (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC, 
to_char(D.KCSX00) As KCSX00,to_char(D.KCXX00) KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPZKC0 D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=11
 AND D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00 
 AND C.CGJHDH=? 
 union all 
select ' ' SHSL00,9999999999999 CGMXXH,' ' CGJHDH,'ºÏ ¼Æ' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL,' ' BZ0000,
 ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' YPTYM0,' ' YPBM00,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM, 
 ' ' KCSL00,' ' ZBXH00,' ' GHDWMC,' ' KCSX00,' ' KCXX00,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000,' ' YFZSL0,' ' YPMLBZ,0 ypnm00 
 from YK_CGJHMX C
 WHERE C.CGJHDH=?
 )ORDER BY GHDWNM,CGMXXH

13      09:05:57  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 = '3') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',11,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1150
  AND b.JSKSBH = '11')
  AND (INSTR (',' || a.jsksbh || ',',',11,') > 0 or a.jsksbh is null)  

14      09:06:07  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 = '3') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',11,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1150
  AND b.JSKSBH = '11')
  AND (INSTR (',' || a.jsksbh || ',',',11,') > 0 or a.jsksbh is null)  

15      09:06:17  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 = '3') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',11,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1150
  AND b.JSKSBH = '11')
  AND (INSTR (',' || a.jsksbh || ',',',11,') > 0 or a.jsksbh is null)