1       08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444
2       08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37
3       08:39:03  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

4       08:39:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 444
5       08:39:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 37
6       08:39:03  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?

7       08:39:07  Log started for: 药库管理系统
8       08:39:07  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','3','appYP_YK.exe'||'+'||'药库管理系统','740','42004' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual

9       08:39:07  SQL Data In: ORACLE - Rows affected = 1
10      08:39:07  SQL Execute: ORACLE - Commit

11      08:39:07  SQL Data In: ORACLE - Rows affected = 0
12      08:39:07  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

13      08:39:08  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

14      08:39:08  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 

15      08:39:08  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

16      08:39:08  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','3','appYP_YK.exe'||'+'||'药库管理系统','1006','51140' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual

17      08:39:08  SQL Data In: ORACLE - Rows affected = 1
18      08:39:08  SQL Execute: ORACLE - Commit

19      08:39:08  SQL Data In: ORACLE - Rows affected = 0
20      08:39:08  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3'

21      08:39:08  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 

22      08:39:08  SQL Execute: ORACLE - Select SYSDATE from Dual

23      08:39:08  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

24      08:39:08  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

25      08:39:08  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3'

26      08:39:09  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

27      08:39:09  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

28      08:39:09  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('6')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY'))
 order by b.PLXH00,a.BH0000

29      08:39:10  Log started for: 门诊医生工作站分系统
30      08:40:13  Log started for: 药库管理系统
31      08:40:13  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','3','appYP_YK.exe'||'+'||'药库管理系统','1289','23030' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual

32      08:40:13  SQL Data In: ORACLE - Rows affected = 1
33      08:40:13  SQL Execute: ORACLE - Commit

34      08:40:13  SQL Data In: ORACLE - Rows affected = 0
35      08:40:13  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

36      08:40:13  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

37      08:40:13  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 

38      08:40:13  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

39      08:40:13  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','3','appYP_YK.exe'||'+'||'药库管理系统','1213','27176' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual

40      08:40:13  SQL Data In: ORACLE - Rows affected = 1
41      08:40:13  SQL Execute: ORACLE - Commit

42      08:40:13  SQL Data In: ORACLE - Rows affected = 0
43      08:40:13  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3'

44      08:40:13  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 

45      08:40:13  SQL Execute: ORACLE - Select SYSDATE from Dual

46      08:40:13  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

47      08:40:13  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

48      08:40:13  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3'

49      08:40:13  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

50      08:40:13  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

51      08:40:13  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('6')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY'))
 order by b.PLXH00,a.BH0000

52      08:40:23  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'ly'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'3' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='3' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 

53      08:40:24  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114

54      08:40:24  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

55      08:40:24  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

56      08:40:24  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

57      08:40:24  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

58      08:40:24  SQL Execute: ORACLE -  select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 
 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where  AUDSID= userenv('SESSIONID'))

59      08:40:27  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(4741498,1114,'wlzx-3','3',nvl('231707931',' '),'192.168.5.33#1213:27176@appYP_YK.exe+药库管理系统',12)

60      08:40:27  SQL Data In: ORACLE - Rows affected = 1
61      08:40:27  SQL Execute: ORACLE - Commit

62      08:40:27  SQL Data In: ORACLE - Rows affected = 0
63      08:40:27  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12

64      08:40:27  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

65      08:40:27  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

66      08:40:27  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33'

67      08:40:27  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

68      08:40:27  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
12 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

69      08:40:27  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

70      08:40:27  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'3'||',')>0 

71      08:40:28  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1114' and name00='SYSTEMSKIN'

72      08:40:28  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

73      08:40:28  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20150813'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='3')

74      08:40:28  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

75      08:40:28  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

76      08:40:28  SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12

77      08:40:28  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID'

78      08:40:28  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID'

79      08:40:28  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID'

80      08:40:28  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED'

81      08:40:28  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_triggers
 where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED'

82      08:40:28  SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%'

83      08:40:29  SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=1114

84      08:40:29  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 
1114= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='3'))) 

85      08:40:29  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00

86      08:40:29  SQL Execute: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='0 '))) 

87      08:40:29  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

88      08:40:29  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
1114= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='+ '))) 

89      08:40:29  SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 

90      08:40:29  SQL Execute: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX 
 WHERE YKBMBH=12
 AND KCSL00<KCXX00 

91      08:40:32  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

92      08:40:50  SQL Execute: ORACLE - select C.CGJHDH,C.YPNM00,C.YPMC00,C.YPGG00,C.CGDW00,C.ZHL000,C.BZ0000,
C.LSDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,C.CGCKSL,C.GHDWNM,C.CGMXXH,D.YPBM00,
C.JHCGSL,C.GJDJ00,D.KCSL00,D.KCSX00,D.KCXX00,D.ZBXH00,C.GHDWNM,D.PYSM00,
(select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC, 
(select YPTYM0 FROM BM_YD0000 WHERE YPNM00=C.YPNM00) AS YPTYM0,
(select ZBQMC0 FROM BM_YD0000 WHERE YPNM00=C.YPNM00) AS ZBQMC0
 from YK_CGJHMX C,VW_YK_YPKCXX D
 WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 AND CGJHDH='' ORDER BY C.GHDWNM,C.CGMXXH

93      08:46:35  SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=1114) and  (BMBH00=0 or  BMBH00=12)
 and DLXTMC='药库管理系统' and CTMC00='frmYK_CGJH' order by YGBH00 

94      08:46:35  SQL Execute: ORACLE - select C.CGJHDH,C.YPNM00,C.YPMC00,C.YPGG00,C.CGDW00,C.ZHL000,C.BZ0000,
C.LSDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,C.CGCKSL,nvl(C.GHDWNM,1) GHDWNM,nvl(C.CGMXXH,1) CGMXXH,D.YPBM00,
C.JHCGSL,C.GJDJ00,D.KCSL00,D.KCSX00,D.KCXX00,D.ZBXH00,D.PYSM00,
(select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC, 
E.YPTYM0,E.ZBQMC0,D.YFZSL0,
(select MAX(JZRQ00) ZHCKRQ FROM YK_YPMXZ0 WHERE YKBMBH=D.YKBMBH
 AND YPNM00=C.YPNM00 AND JZXZ00='C') ZHCKRQ,E.SFZBYP,
 (DECODE('N','N',0,
 (SELECT Round(Sum(Nvl(FCSL00*ZHL000/K2J000,0)),3) FROM VW_YK_YFYPSYL WHERE YPNM00=C.YPNM00 AND JZRQ00 BETWEEN '20150806' AND '20150813' GROUP BY YPNM00))) YFSYL0,E.YPMLBZ 
 from YK_CGJHMX C,VW_YK_YPKCXX D,BM_YD0000 E 
 WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12
 AND CGJHDH='' AND C.YPNM00=E.YPNM00 
  ORDER BY GHDWNM,CGMXXH

95      08:48:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000
96      08:48:24  SQL Execute: ORACLE - SELECT R.CGJHDH,Y.ZWXM00,R.JHBZRQ,W.GHDWMC,R.BZ0000
FROM YK_YPCGJH R,BM_YGBM00 Y,BM_YPGHDW W
WHERE R.YKBMBH=?
  AND R.SFQR00='N'
  AND R.CZYBH0=Y.YGBH00(+) 
  AND R.GHDWNM=W.GHDWNM(+)
ORDER BY R.CGJHDH DESC

97      08:48:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
98      08:48:24  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
99      08:48:24  SQL Execute: ORACLE - select * from(
select 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.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 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

100     08:48:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
101     08:48:24  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
102     08:48:24  SQL Execute: ORACLE - select * from(
select 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.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 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

103     08:48:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
104     08:48:40  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
105     08:48:40  SQL Execute: ORACLE - select * from(
select 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.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 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

106     08:48:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
107     08:48:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
108     08:48:43  SQL Execute: ORACLE - select * from(
select 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.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 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

109     08:48:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
110     08:48:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
111     08:48:45  SQL Execute: ORACLE - select * from(
select 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.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 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

112     08:48:55  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
113     08:48:55  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
114     08:48:55  SQL Execute: ORACLE - select * from(
select 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.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 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

115     08:48:56  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
116     08:48:56  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
117     08:48:56  SQL Execute: ORACLE - select * from(
select 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.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 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

118     08:48:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
119     08:48:58  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
120     08:48:58  SQL Execute: ORACLE - select * from(
select 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.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 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

121     08:49:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
122     08:49:22  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
123     08:49:22  SQL Execute: ORACLE - select * from(
select 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.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 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

124     08:49:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
125     08:49:54  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
126     08:49:54  SQL Execute: ORACLE - select * from(
select 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.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 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

127     08:49:55  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
128     08:49:55  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
129     08:49:55  SQL Execute: ORACLE - select * from(
select 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.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 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

130     08:49:57  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
131     08:49:57  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
132     08:49:57  SQL Execute: ORACLE - select * from(
select 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.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 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

133     08:49:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
134     08:49:58  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
135     08:49:58  SQL Execute: ORACLE - select * from(
select 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.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 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

136     08:50:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
137     08:50:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
138     08:50:02  SQL Execute: ORACLE - select * from(
select 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.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 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

139     08:50:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
140     08:50:05  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
141     08:50:05  SQL Execute: ORACLE - select * from(
select 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.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 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

142     08:56:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
143     08:56:35  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
144     08:56:35  SQL Execute: ORACLE - select * from(
select 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.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 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

145     08:56:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
146     08:56:36  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
147     08:56:36  SQL Execute: ORACLE - select * from(
select 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.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 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

148     08:56:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
149     08:56:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
150     08:56:38  SQL Execute: ORACLE - select * from(
select 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.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 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

151     08:56:39  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
152     08:56:39  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
153     08:56:39  SQL Execute: ORACLE - select * from(
select 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.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 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

154     08:56:41  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
155     08:56:41  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
156     08:56:41  SQL Execute: ORACLE - select * from(
select 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.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 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

157     08:56:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
158     08:56:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
159     08:56:42  SQL Execute: ORACLE - select * from(
select 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.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 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

160     08:56:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
161     08:56:44  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
162     08:56:44  SQL Execute: ORACLE - select * from(
select 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.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 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

163     08:56:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
164     08:56:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
165     08:56:45  SQL Execute: ORACLE - select * from(
select 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.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 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

166     08:56:49  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
167     08:56:49  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
168     08:56:49  SQL Execute: ORACLE - select * from(
select 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.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 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

169     08:56:50  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
170     08:56:50  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
171     08:56:50  SQL Execute: ORACLE - select * from(
select 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.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 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

172     08:56:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
173     08:56:53  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
174     08:56:53  SQL Execute: ORACLE - select * from(
select 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.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 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

175     08:56:54  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
176     08:56:54  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
177     08:56:54  SQL Execute: ORACLE - select * from(
select 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.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 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

178     08:56:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
179     08:56:59  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
180     08:56:59  SQL Execute: ORACLE - select * from(
select 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.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 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

181     08:57:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
182     08:57:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
183     08:57:03  SQL Execute: ORACLE - select * from(
select 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.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 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

184     08:57:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
185     08:57:04  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020780
186     08:57:04  SQL Execute: ORACLE - select * from(
select 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.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 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

187     08:57:21  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
188     08:57:21  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 020779
189     08:57:21  SQL Execute: ORACLE - select * from(
select 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.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 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