1       10:09:12  Log started for: SQL Navigator for Oracle
2       10:13:02  Log started for: 健康体检系统
3       10:13:02  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','921','45108' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual

4       10:13:02  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','921','45108' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual

5       10:13:02  SQL Data In: ORACLE - Rows affected = 1
6       10:13:02  SQL Prepare: ORACLE - Commit

7       10:13:02  SQL Execute: ORACLE - Commit

8       10:13:02  SQL Data In: ORACLE - Rows affected = 0
9       10:13:02  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

10      10:13:02  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

11      10:13:02  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

12      10:13:02  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

13      10:13:02  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 

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

15      10:13:02  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

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

17      10:13:02  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','1119','54874' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual

18      10:13:02  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','1119','54874' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual

19      10:13:02  SQL Data In: ORACLE - Rows affected = 1
20      10:13:02  SQL Prepare: ORACLE - Commit

21      10:13:02  SQL Execute: ORACLE - Commit

22      10:13:02  SQL Data In: ORACLE - Rows affected = 0
23      10:13:02  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T'

24      10:13:02  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T'

25      10:13:02  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 

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

27      10:13:02  SQL Prepare: ORACLE - Select SYSDATE from Dual

28      10:13:02  SQL Execute: ORACLE - Select SYSDATE from Dual

29      10:13:02  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

30      10:13:02  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

31      10:13:02  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

32      10:13:02  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

33      10:13:02  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T'

34      10:13:02  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T'

35      10:13:02  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

36      10:13:02  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

37      10:13:02  SQL Prepare: 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

38      10:13:02  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

39      10:13:02  SQL Prepare: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T'
 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 ('0','1','2','3','4','5','6','7','8','9')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY'))
 order by b.PLXH00,a.BH0000

40      10:13:02  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T'
 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 ('0','1','2','3','4','5','6','7','8','9')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY'))
 order by b.PLXH00,a.BH0000

41      10:13:02  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'ly'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'T' 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='T' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 

42      10:13:02  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'ly'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'T' 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='T' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 

43      10:13:02  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114

44      10:13:02  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114

45      10:13:02  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

46      10:13:02  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

47      10:13:02  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

48      10:13:02  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

49      10:13:02  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

50      10:13:02  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

51      10:13:02  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

52      10:13:02  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

53      10:13:02  SQL Prepare: 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'))

54      10:13:02  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'))

55      10:13:07  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(4852074,1114,'wlzx-3','T',nvl('232553374',' '),'192.168.5.33#1119:54874@MedicalExa.exe+健康体检系统',125)

56      10:13:07  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(4852074,1114,'wlzx-3','T',nvl('232553374',' '),'192.168.5.33#1119:54874@MedicalExa.exe+健康体检系统',125)

57      10:13:07  SQL Data In: ORACLE - Rows affected = 1
58      10:13:07  SQL Prepare: ORACLE - Commit

59      10:13:07  SQL Execute: ORACLE - Commit

60      10:13:07  SQL Data In: ORACLE - Rows affected = 0
61      10:13:07  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125

62      10:13:07  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125

63      10:13:07  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

64      10:13:07  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

65      10:13:07  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

66      10:13:07  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

67      10:13:07  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33'

68      10:13:07  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33'

69      10:13:07  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

70      10:13:07  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

71      10:13:07  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
125 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

72      10:13:07  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
125 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

73      10:13:07  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

74      10:13:07  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

75      10:13:07  SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 

76      10:13:07  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 

77      10:13:09  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1114' and name00='SYSTEMSKIN'

78      10:13:09  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1114' and name00='SYSTEMSKIN'

79      10:13:09  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

80      10:13:09  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

81      10:13:09  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20151103'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='T')

82      10:13:09  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20151103'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='T')

83      10:13:09  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

84      10:13:09  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

85      10:13:09  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

86      10:13:09  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

87      10:13:09  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 
1114= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='T'))) 

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

89      10:13:09  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||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

90      10:13:09  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||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

91      10:13:09  SQL Prepare: 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 '))) 

92      10:13:09  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 '))) 

93      10:13:09  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

94      10:13:09  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

95      10:13:09  SQL Prepare: 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='+ '))) 

96      10:13:09  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='+ '))) 

97      10:13:09  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID'

98      10:13:09  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID'

99      10:13:09  SQL Prepare: ORACLE - select Trigger_Name from all_triggers
 where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%'

100     10:13:09  SQL Execute: ORACLE - select Trigger_Name from all_triggers
 where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%'

101     10:13:09  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '1114'

102     10:13:09  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '1114'

103     10:13:09  SQL Prepare: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%'

104     10:13:09  SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%'

105     10:13:09  SQL Prepare: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID','YS_PACSTWBGWZ','XT_PACSCJDM','YS_PACSTXLLWZ')

106     10:13:09  SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID','YS_PACSTWBGWZ','XT_PACSCJDM','YS_PACSTXLLWZ')

107     10:13:09  SQL Prepare: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00')

108     10:13:09  SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00')

109     10:14:27  SQL Prepare: ORACLE - select MC0000 from BM_TYZD00
 where ZDMC00='单位性质'

110     10:14:27  SQL Execute: ORACLE - select MC0000 from BM_TYZD00
 where ZDMC00='单位性质'

111     10:15:13  SQL Prepare: ORACLE - select rownum,DWID00,DWMC00,ZJE,ZHJE,ZKE,SJJE,JMJE00,RS0000 from 
(select distinct DWID00 , DWMC00,
(select NVL(SUM(ZJE000),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') ZJE ,
(select NVL(SUM(ZHJE00),0) from VW_TJ_YJ_YW0000_DW C where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND C.DWID00||'A' = A.DWID00||'A') ZHJE ,
(select NVL(SUM(ZKE000),0) from VW_TJ_YJ_YW0000_DW D where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND D.DWID00||'A' = A.DWID00||'A') ZKE 
,(
(select NVL(SUM(ZHJE00),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') + 
(select NVL(SUM(FJF000),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') + 
(SELECT NVL(sum(BB.HJJE00),0) FROM SF_BRFY00 AA,SF_FYMX00 BB ,BM_TYDWB0 CC 
 WHERE AA.brid00 = CC.BRID00 
 AND AA.DJH000 = BB.DJH000 AND BB.CZRQ00 >= '20151028' AND BB.CZRQ00 <= '20151028' AND xmbh00 = '2917' 
AND CC.DWID00||'A' = A.DWID00||'A' )) SJJE,
(SELECT NVL(sum(BB.HJJE00),0) FROM SF_BRFY00 AA,SF_FYMX00 BB ,BM_TYDWB0 CC 
 WHERE AA.brid00 = CC.BRID00 
 AND AA.DJH000 = BB.DJH000 AND BB.CZRQ00 >= '20151028' AND BB.CZRQ00 <= '20151028' AND xmbh00 = '2917' 
AND CC.DWID00||'A' = A.DWID00||'A') JMJE00 
,(SELECT COUNT(DISTINCT(BRID00)) from VW_TJ_YJ_YW0000_DW E where (kdrq00 >='20151028' and kdrq00 <='20151028') 
AND E.dwid00||'A' = A.DWID00||'A'  AND XMZT00||'A' IN ('2A','3A','4A')  GROUP BY DWID00 ) RS0000
from VW_TJ_YJ_YW0000_DW A where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')   
AND A.dwid00||'A' <> '0A' 
AND not exists (SELECT 'y' FROM TJ_YJDJH0 T WHERE cxdjh0= A.yjdjh0) 
AND (A.cxdjh0 = 0 or A.cxdjh0 is NULL)  ) 

112     10:15:13  SQL Execute: ORACLE - select rownum,DWID00,DWMC00,ZJE,ZHJE,ZKE,SJJE,JMJE00,RS0000 from 
(select distinct DWID00 , DWMC00,
(select NVL(SUM(ZJE000),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') ZJE ,
(select NVL(SUM(ZHJE00),0) from VW_TJ_YJ_YW0000_DW C where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND C.DWID00||'A' = A.DWID00||'A') ZHJE ,
(select NVL(SUM(ZKE000),0) from VW_TJ_YJ_YW0000_DW D where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND D.DWID00||'A' = A.DWID00||'A') ZKE 
,(
(select NVL(SUM(ZHJE00),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') + 
(select NVL(SUM(FJF000),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') + 
(SELECT NVL(sum(BB.HJJE00),0) FROM SF_BRFY00 AA,SF_FYMX00 BB ,BM_TYDWB0 CC 
 WHERE AA.brid00 = CC.BRID00 
 AND AA.DJH000 = BB.DJH000 AND BB.CZRQ00 >= '20151028' AND BB.CZRQ00 <= '20151028' AND xmbh00 = '2917' 
AND CC.DWID00||'A' = A.DWID00||'A' )) SJJE,
(SELECT NVL(sum(BB.HJJE00),0) FROM SF_BRFY00 AA,SF_FYMX00 BB ,BM_TYDWB0 CC 
 WHERE AA.brid00 = CC.BRID00 
 AND AA.DJH000 = BB.DJH000 AND BB.CZRQ00 >= '20151028' AND BB.CZRQ00 <= '20151028' AND xmbh00 = '2917' 
AND CC.DWID00||'A' = A.DWID00||'A') JMJE00 
,(SELECT COUNT(DISTINCT(BRID00)) from VW_TJ_YJ_YW0000_DW E where (kdrq00 >='20151028' and kdrq00 <='20151028') 
AND E.dwid00||'A' = A.DWID00||'A'  AND XMZT00||'A' IN ('2A','3A','4A')  GROUP BY DWID00 ) RS0000
from VW_TJ_YJ_YW0000_DW A where (kdrq00 >='20151028' and kdrq00 <='20151028')  AND XMZT00||'A' IN ('2A','3A','4A')   
AND A.dwid00||'A' <> '0A' 
AND not exists (SELECT 'y' FROM TJ_YJDJH0 T WHERE cxdjh0= A.yjdjh0) 
AND (A.cxdjh0 = 0 or A.cxdjh0 is NULL)  ) 

113     10:15:16  SQL Prepare: ORACLE - SELECT zyhghh, brid00, (SELECT BRXM00 FROM VW_TJ_BRXXB0 WHERE GHID00 = B.ZYGHID AND ROWNUM = 1) BRXM00,(SELECT BRXB00 FROM VW_TJ_BRXXB0 WHERE GHID00 = B.ZYGHID AND ROWNUM = 1) BRXB00,zje000, zhje00, zke000, ssje00, fjf000 FROM ( SELECT ZYGHID, zyhghh, brid00,  NVL (SUM (zje000), 0) zje000,   NVL (SUM (zhje00), 0) zhje00, NVL (SUM (zke000), 0) zke000, 0 ssje00, NVL(SUM (fjf000), 0) fjf000    FROM VW_TJ_YJ_YW0000_DW a    WHERE (kdrq00 >='20151028' and kdrq00 <='20151028')      AND xmzt00 || 'A' IN ('2A', '3A', '4A')      AND dwid00 || 'A' = '803A'      AND not exists (SELECT 'y' FROM TJ_YJDJH0 T WHERE cxdjh0= A.yjdjh0) 
     AND ((A.cxdjh0=0) or (A.cxdjh0 is NULL)) 
GROUP BY ZYGHID, zyhghh, brid00) B 

114     10:15:16  SQL Execute: ORACLE - SELECT zyhghh, brid00, (SELECT BRXM00 FROM VW_TJ_BRXXB0 WHERE GHID00 = B.ZYGHID AND ROWNUM = 1) BRXM00,(SELECT BRXB00 FROM VW_TJ_BRXXB0 WHERE GHID00 = B.ZYGHID AND ROWNUM = 1) BRXB00,zje000, zhje00, zke000, ssje00, fjf000 FROM ( SELECT ZYGHID, zyhghh, brid00,  NVL (SUM (zje000), 0) zje000,   NVL (SUM (zhje00), 0) zhje00, NVL (SUM (zke000), 0) zke000, 0 ssje00, NVL(SUM (fjf000), 0) fjf000    FROM VW_TJ_YJ_YW0000_DW a    WHERE (kdrq00 >='20151028' and kdrq00 <='20151028')      AND xmzt00 || 'A' IN ('2A', '3A', '4A')      AND dwid00 || 'A' = '803A'      AND not exists (SELECT 'y' FROM TJ_YJDJH0 T WHERE cxdjh0= A.yjdjh0) 
     AND ((A.cxdjh0=0) or (A.cxdjh0 is NULL)) 
GROUP BY ZYGHID, zyhghh, brid00) B 

115     10:17:10  SQL Prepare: ORACLE - select rownum,DWID00,DWMC00,ZJE,ZHJE,ZKE,SJJE,JMJE00,RS0000 from 
(select distinct DWID00 , DWMC00,
(select NVL(SUM(ZJE000),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') ZJE ,
(select NVL(SUM(ZHJE00),0) from VW_TJ_YJ_YW0000_DW C where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND C.DWID00||'A' = A.DWID00||'A') ZHJE ,
(select NVL(SUM(ZKE000),0) from VW_TJ_YJ_YW0000_DW D where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND D.DWID00||'A' = A.DWID00||'A') ZKE 
,(
(select NVL(SUM(ZHJE00),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') + 
(select NVL(SUM(FJF000),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') + 
(SELECT NVL(sum(BB.HJJE00),0) FROM SF_BRFY00 AA,SF_FYMX00 BB ,BM_TYDWB0 CC 
 WHERE AA.brid00 = CC.BRID00 
 AND AA.DJH000 = BB.DJH000 AND BB.CZRQ00 >= '20151029' AND BB.CZRQ00 <= '20151029' AND xmbh00 = '2917' 
AND CC.DWID00||'A' = A.DWID00||'A' )) SJJE,
(SELECT NVL(sum(BB.HJJE00),0) FROM SF_BRFY00 AA,SF_FYMX00 BB ,BM_TYDWB0 CC 
 WHERE AA.brid00 = CC.BRID00 
 AND AA.DJH000 = BB.DJH000 AND BB.CZRQ00 >= '20151029' AND BB.CZRQ00 <= '20151029' AND xmbh00 = '2917' 
AND CC.DWID00||'A' = A.DWID00||'A') JMJE00 
,(SELECT COUNT(DISTINCT(BRID00)) from VW_TJ_YJ_YW0000_DW E where (kdrq00 >='20151029' and kdrq00 <='20151029') 
AND E.dwid00||'A' = A.DWID00||'A'  AND XMZT00||'A' IN ('2A','3A','4A')  GROUP BY DWID00 ) RS0000
from VW_TJ_YJ_YW0000_DW A where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')   
AND A.dwid00||'A' <> '0A' 
AND not exists (SELECT 'y' FROM TJ_YJDJH0 T WHERE cxdjh0= A.yjdjh0) 
AND (A.cxdjh0 = 0 or A.cxdjh0 is NULL)  ) 

116     10:17:10  SQL Execute: ORACLE - select rownum,DWID00,DWMC00,ZJE,ZHJE,ZKE,SJJE,JMJE00,RS0000 from 
(select distinct DWID00 , DWMC00,
(select NVL(SUM(ZJE000),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') ZJE ,
(select NVL(SUM(ZHJE00),0) from VW_TJ_YJ_YW0000_DW C where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND C.DWID00||'A' = A.DWID00||'A') ZHJE ,
(select NVL(SUM(ZKE000),0) from VW_TJ_YJ_YW0000_DW D where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND D.DWID00||'A' = A.DWID00||'A') ZKE 
,(
(select NVL(SUM(ZHJE00),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') + 
(select NVL(SUM(FJF000),0) from VW_TJ_YJ_YW0000_DW B where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')  AND B.DWID00||'A' = A.DWID00||'A') + 
(SELECT NVL(sum(BB.HJJE00),0) FROM SF_BRFY00 AA,SF_FYMX00 BB ,BM_TYDWB0 CC 
 WHERE AA.brid00 = CC.BRID00 
 AND AA.DJH000 = BB.DJH000 AND BB.CZRQ00 >= '20151029' AND BB.CZRQ00 <= '20151029' AND xmbh00 = '2917' 
AND CC.DWID00||'A' = A.DWID00||'A' )) SJJE,
(SELECT NVL(sum(BB.HJJE00),0) FROM SF_BRFY00 AA,SF_FYMX00 BB ,BM_TYDWB0 CC 
 WHERE AA.brid00 = CC.BRID00 
 AND AA.DJH000 = BB.DJH000 AND BB.CZRQ00 >= '20151029' AND BB.CZRQ00 <= '20151029' AND xmbh00 = '2917' 
AND CC.DWID00||'A' = A.DWID00||'A') JMJE00 
,(SELECT COUNT(DISTINCT(BRID00)) from VW_TJ_YJ_YW0000_DW E where (kdrq00 >='20151029' and kdrq00 <='20151029') 
AND E.dwid00||'A' = A.DWID00||'A'  AND XMZT00||'A' IN ('2A','3A','4A')  GROUP BY DWID00 ) RS0000
from VW_TJ_YJ_YW0000_DW A where (kdrq00 >='20151029' and kdrq00 <='20151029')  AND XMZT00||'A' IN ('2A','3A','4A')   
AND A.dwid00||'A' <> '0A' 
AND not exists (SELECT 'y' FROM TJ_YJDJH0 T WHERE cxdjh0= A.yjdjh0) 
AND (A.cxdjh0 = 0 or A.cxdjh0 is NULL)  ) 

117     10:17:13  SQL Prepare: ORACLE - SELECT zyhghh, brid00, (SELECT BRXM00 FROM VW_TJ_BRXXB0 WHERE GHID00 = B.ZYGHID AND ROWNUM = 1) BRXM00,(SELECT BRXB00 FROM VW_TJ_BRXXB0 WHERE GHID00 = B.ZYGHID AND ROWNUM = 1) BRXB00,zje000, zhje00, zke000, ssje00, fjf000 FROM ( SELECT ZYGHID, zyhghh, brid00,  NVL (SUM (zje000), 0) zje000,   NVL (SUM (zhje00), 0) zhje00, NVL (SUM (zke000), 0) zke000, 0 ssje00, NVL(SUM (fjf000), 0) fjf000    FROM VW_TJ_YJ_YW0000_DW a    WHERE (kdrq00 >='20151029' and kdrq00 <='20151029')      AND xmzt00 || 'A' IN ('2A', '3A', '4A')      AND dwid00 || 'A' = '803A'      AND not exists (SELECT 'y' FROM TJ_YJDJH0 T WHERE cxdjh0= A.yjdjh0) 
     AND ((A.cxdjh0=0) or (A.cxdjh0 is NULL)) 
GROUP BY ZYGHID, zyhghh, brid00) B 

118     10:17:13  SQL Execute: ORACLE - SELECT zyhghh, brid00, (SELECT BRXM00 FROM VW_TJ_BRXXB0 WHERE GHID00 = B.ZYGHID AND ROWNUM = 1) BRXM00,(SELECT BRXB00 FROM VW_TJ_BRXXB0 WHERE GHID00 = B.ZYGHID AND ROWNUM = 1) BRXB00,zje000, zhje00, zke000, ssje00, fjf000 FROM ( SELECT ZYGHID, zyhghh, brid00,  NVL (SUM (zje000), 0) zje000,   NVL (SUM (zhje00), 0) zhje00, NVL (SUM (zke000), 0) zke000, 0 ssje00, NVL(SUM (fjf000), 0) fjf000    FROM VW_TJ_YJ_YW0000_DW a    WHERE (kdrq00 >='20151029' and kdrq00 <='20151029')      AND xmzt00 || 'A' IN ('2A', '3A', '4A')      AND dwid00 || 'A' = '803A'      AND not exists (SELECT 'y' FROM TJ_YJDJH0 T WHERE cxdjh0= A.yjdjh0) 
     AND ((A.cxdjh0=0) or (A.cxdjh0 is NULL)) 
GROUP BY ZYGHID, zyhghh, brid00) B