1       16:45:13  SQL Prepare: 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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

2       16:45:13  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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

3       16:45:23  SQL Prepare: ORACLE - update YK_CGJHMX
set
  SHSL00= :1
where
  CGMXXH = :2

4       16:45:23  SQL Execute: ORACLE - update YK_CGJHMX
set
  SHSL00= ?
where
  CGMXXH = ?

5       16:45:25  SQL Prepare: ORACLE - COMMIT WORK
6       16:45:25  SQL Execute: ORACLE - COMMIT WORK
7       16:45:25  SQL Prepare: 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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

8       16:45:25  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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

9       16:45:33  SQL Prepare: 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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

10      16:45:33  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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

11      16:45:43  SQL Prepare: 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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

12      16:45:43  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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

13      16:45:44  SQL Prepare: ORACLE - update YK_CGJHMX set SHSL00 = 350where CGMXXH = 1028859

14      16:45:44  SQL Execute: ORACLE - update YK_CGJHMX set SHSL00 = 350where CGMXXH = 1028859

15      16:45:45  SQL Prepare: ORACLE - UPDATE YK_CGJHMX X SET X.KCSL00=(SELECT D.KCSL00 FROM VW_YK_YPKCXX D 
WHERE X.YPNM00=D.YPNM00 AND D.YKBMBH=12)
 WHERE X.CGJHDH = '025445'

16      16:45:45  SQL Execute: ORACLE - UPDATE YK_CGJHMX X SET X.KCSL00=(SELECT D.KCSL00 FROM VW_YK_YPKCXX D 
WHERE X.YPNM00=D.YPNM00 AND D.YKBMBH=12)
 WHERE X.CGJHDH = '025445'

17      16:45:46  SQL Prepare: ORACLE - DELETE FROM YK_CGJHMX 
 WHERE CGJHDH = '025445' and JHCGSL IS null

18      16:45:46  SQL Execute: ORACLE - DELETE FROM YK_CGJHMX 
 WHERE CGJHDH = '025445' and JHCGSL IS null

19      16:45:46  SQL Prepare: ORACLE - UPDATE YK_YPCGJH SET SFQR00='Y'
,QRRBH0=1143
,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 WHERE CGJHDH = '025445'

20      16:45:46  SQL Execute: ORACLE - UPDATE YK_YPCGJH SET SFQR00='Y'
,QRRBH0=1143
,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 WHERE CGJHDH = '025445'

21      16:45:46  SQL Prepare: ORACLE - SELECT COUNT(1) COUNT0 FROM YK_CGJHMX 
 WHERE CGJHDH = '025445' AND GHDWNM IS NULL

22      16:45:46  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YK_CGJHMX 
 WHERE CGJHDH = '025445' AND GHDWNM IS NULL

23      16:45:46  SQL Prepare: ORACLE - SELECT COUNT(1) COUNT0 FROM YK_CGJHMX 
 WHERE CGJHDH = '025445' 

24      16:45:46  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YK_CGJHMX 
 WHERE CGJHDH = '025445' 

25      16:45:46  SQL Prepare: ORACLE - SELECT SQ_YK_YPCGD0_CGDBH0.NEXTVAL CGDBH0 FROM DUAL

26      16:45:46  SQL Execute: ORACLE - SELECT SQ_YK_YPCGD0_CGDBH0.NEXTVAL CGDBH0 FROM DUAL

27      16:45:46  SQL Prepare: ORACLE - INSERT INTO YK_YPCGD0(CGDLSH,CGDBH0,YPNM00,YPMC00,JXMC00,
YPGG00,KCDW00,JLDW00,ZHL000,SCCJBH,SCCJMC,YKBMBH,YKBMMC,ZBJ000,GJJ000,
LSJ000,JHSL00,BCGRSL,GHDWNM,GHDWMC,CGHBR0,JHHBRQ,JHGBSJ)
SELECT SQ_YK_YPCGD0_CGDLSH.NEXTVAL,296449,A.YPNM00,A.YPMC00,
(SELECT J.JXMC00 FROM BM_YPJX00 J WHERE A.JXBH00=J.JXBH00 AND A.LBBH00=J.LBBH00) JXMC00, 
A.YPGG00,A.CGDW00,A.JLDW00,A.ZHL000,A.SCCJBH,A.SCCJZW,A.YKBMBH, 
(SELECT M.BMMC00 FROM BM_BMBM00 M WHERE M.BMBH00=A.YKBMBH) YKBMMC, 
A.ZBJ000,A.GJDJ00,A.LSJ000,A.JHCGSL,A.BCGRSL,A.GHDWNM, 
(SELECT W.GHDWMC FROM BM_YPGHDW W WHERE A.GHDWNM=W.GHDWNM) GHDWMC,1143
,TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH:MM:SS')FROM( 
SELECT C.YPNM00,C.YPMC00,D.JXBH00,D.LBBH00, 
C.YPGG00,C.CGDW00,C.CGDW00 JLDW00,1 ZHL000,C.SCCJBH,C.SCCJZW,R.YKBMBH,
D.ZBJ000,C.GJDJ00,D.LSJ000,SUM(C.JHCGSL) JHCGSL,SUM(C.JHCGSL) BCGRSL,C.GHDWNM 
FROM YK_YPCGJH R,YK_CGJHMX C,BM_YD0000 D 
WHERE R.CGJHDH=C.CGJHDH AND C.YPNM00=D.YPNM00 
AND R.CGJHDH ='025445' and C.JHCGSL IS NOT NULL 
GROUP BY R.CGJHDH,C.YPNM00,C.YPMC00,D.JXBH00,D.LBBH00,C.YPGG00,
C.CGDW00,C.CGDW00,C.SCCJBH,C.SCCJZW,R.YKBMBH,D.ZBJ000,C.GJDJ00,D.LSJ000,C.GHDWNM)A

28      16:45:46  SQL Execute: ORACLE - INSERT INTO YK_YPCGD0(CGDLSH,CGDBH0,YPNM00,YPMC00,JXMC00,
YPGG00,KCDW00,JLDW00,ZHL000,SCCJBH,SCCJMC,YKBMBH,YKBMMC,ZBJ000,GJJ000,
LSJ000,JHSL00,BCGRSL,GHDWNM,GHDWMC,CGHBR0,JHHBRQ,JHGBSJ)
SELECT SQ_YK_YPCGD0_CGDLSH.NEXTVAL,296449,A.YPNM00,A.YPMC00,
(SELECT J.JXMC00 FROM BM_YPJX00 J WHERE A.JXBH00=J.JXBH00 AND A.LBBH00=J.LBBH00) JXMC00, 
A.YPGG00,A.CGDW00,A.JLDW00,A.ZHL000,A.SCCJBH,A.SCCJZW,A.YKBMBH, 
(SELECT M.BMMC00 FROM BM_BMBM00 M WHERE M.BMBH00=A.YKBMBH) YKBMMC, 
A.ZBJ000,A.GJDJ00,A.LSJ000,A.JHCGSL,A.BCGRSL,A.GHDWNM, 
(SELECT W.GHDWMC FROM BM_YPGHDW W WHERE A.GHDWNM=W.GHDWNM) GHDWMC,1143
,TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH:MM:SS')FROM( 
SELECT C.YPNM00,C.YPMC00,D.JXBH00,D.LBBH00, 
C.YPGG00,C.CGDW00,C.CGDW00 JLDW00,1 ZHL000,C.SCCJBH,C.SCCJZW,R.YKBMBH,
D.ZBJ000,C.GJDJ00,D.LSJ000,SUM(C.JHCGSL) JHCGSL,SUM(C.JHCGSL) BCGRSL,C.GHDWNM 
FROM YK_YPCGJH R,YK_CGJHMX C,BM_YD0000 D 
WHERE R.CGJHDH=C.CGJHDH AND C.YPNM00=D.YPNM00 
AND R.CGJHDH ='025445' and C.JHCGSL IS NOT NULL 
GROUP BY R.CGJHDH,C.YPNM00,C.YPMC00,D.JXBH00,D.LBBH00,C.YPGG00,
C.CGDW00,C.CGDW00,C.SCCJBH,C.SCCJZW,R.YKBMBH,D.ZBJ000,C.GJDJ00,D.LSJ000,C.GHDWNM)A

29      16:45:46  SQL Prepare: ORACLE - UPDATE YK_YPCGJH SET CGDBH0=296449
 WHERE CGJHDH ='025445'

30      16:45:46  SQL Execute: ORACLE - UPDATE YK_YPCGJH SET CGDBH0=296449
 WHERE CGJHDH ='025445'

31      16:45:46  SQL Prepare: ORACLE - Commit

32      16:45:46  SQL Execute: ORACLE - Commit

33      16:45:50  SQL Prepare: ORACLE - SELECT X.YPMC00,X.YPGG00,X.CGDW00,X.GJDJ00,X.LSDJ00,X.JHCGSL
,D.KCSL00 AS KCSL00,D.KCSX00,D.KCXX00,
ROUND(X.JHCGSL*X.GJDJ00,2) AS C_GJJE,W.GHDWMC,R.JHBZRQ,R.QRRQ00,
X.SCCJZW,X.GMP000,D.ZBXH00
 from YK_CGJHMX X,YK_YPCGJH R,VW_YK_YPKCXX D,BM_YPGHDW W,BM_YPJX00 E
 WHERE  X.CGJHDH='025445'
 AND X.YPNM00=D.YPNM00
 AND X.CGJHDH=R.CGJHDH
 AND R.GHDWNM=W.GHDWNM(+)
 AND D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00
  ORDER BY X.GHDWNM,X.CGMXXH

34      16:45:50  SQL Execute: ORACLE - SELECT X.YPMC00,X.YPGG00,X.CGDW00,X.GJDJ00,X.LSDJ00,X.JHCGSL
,D.KCSL00 AS KCSL00,D.KCSX00,D.KCXX00,
ROUND(X.JHCGSL*X.GJDJ00,2) AS C_GJJE,W.GHDWMC,R.JHBZRQ,R.QRRQ00,
X.SCCJZW,X.GMP000,D.ZBXH00
 from YK_CGJHMX X,YK_YPCGJH R,VW_YK_YPKCXX D,BM_YPGHDW W,BM_YPJX00 E
 WHERE  X.CGJHDH='025445'
 AND X.YPNM00=D.YPNM00
 AND X.CGJHDH=R.CGJHDH
 AND R.GHDWNM=W.GHDWNM(+)
 AND D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00
  ORDER BY X.GHDWNM,X.CGMXXH

35      16:45:52  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

36      16:45:52  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

37      16:45:52  SQL Prepare: ORACLE - Commit

38      16:45:52  SQL Execute: ORACLE - Commit

39      16:45:52  SQL Prepare: 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=12
 and R.CZYBH0=Y.YGBH00(+) and R.GHDWNM=W.GHDWNM(+)
 and R.SFQR00='M'
 order by R.CGJHDH desc

40      16:45:52  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=12
 and R.CZYBH0=Y.YGBH00(+) and R.GHDWNM=W.GHDWNM(+)
 and R.SFQR00='M'
 order by R.CGJHDH desc

41      16:45:52  SQL Prepare: 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,to_char(C.JQYL00) JQYL00,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCSL00) 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) As KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 AND D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00
 AND C.CGJHDH=:1 
 union all 
select ' ' SHSL00,9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL,' ' BZ0000,' ' JQYL00,
 ' ' 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=:2
 )ORDER BY GHDWNM,CGMXXH

42      16:45:52  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,to_char(C.JQYL00) JQYL00,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCSL00) 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) As KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 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,' ' JQYL00,
 ' ' 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

43      16:45:53  SQL Prepare: 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,to_char(C.JQYL00) JQYL00,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCSL00) 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) As KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 AND D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00
 AND C.CGJHDH=:1 
 union all 
select ' ' SHSL00,9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL,' ' BZ0000,' ' JQYL00,
 ' ' 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=:2
 )ORDER BY GHDWNM,CGMXXH

44      16:45: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,to_char(C.JQYL00) JQYL00,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCSL00) 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) As KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 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,' ' JQYL00,
 ' ' 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

45      16:45:53  SQL Prepare: 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,to_char(C.JQYL00) JQYL00,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCSL00) 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) As KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 AND D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00
 AND C.CGJHDH=:1 
 union all 
select ' ' SHSL00,9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL,' ' BZ0000,' ' JQYL00,
 ' ' 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=:2
 )ORDER BY GHDWNM,CGMXXH

46      16:45: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,to_char(C.JQYL00) JQYL00,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCSL00) 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) As KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 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,' ' JQYL00,
 ' ' 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

47      16:45:53  SQL Prepare: 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,to_char(C.JQYL00) JQYL00,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCSL00) 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) As KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 AND D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00
 AND C.CGJHDH=:1 
 union all 
select ' ' SHSL00,9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL,' ' BZ0000,' ' JQYL00,
 ' ' 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=:2
 )ORDER BY GHDWNM,CGMXXH

48      16:45: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,to_char(C.JQYL00) JQYL00,D.YPTYM0,D.YPBM00,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
to_char(D.KCSL00) 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) As KCXX00,D.LBBH00,D.YLBH00,D.JXBH00,E.SXH000,to_char(D.YFZSL0) YFZSL0,D.YPMLBZ,c.ypnm00
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YPJX00 E 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 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,' ' JQYL00,
 ' ' 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

49      16:45:53  SQL Prepare: 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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

50      16:45:53  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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

51      16:46:03  SQL Prepare: 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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

52      16:46:03  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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

53      16:46:13  SQL Prepare: 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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

54      16:46:13  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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

55      16:46:23  SQL Prepare: 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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

56      16:46:23  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||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)