WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
	2716267329	1	1	26-Oct-13 12:10	11.1.0.7.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
1	AIX-Based Systems (64-bit)	32	16		61.25

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	19136	26-Nov-13 09:00:03	147	9.2
End Snap:	19145	26-Nov-13 18:00:25	164	11.1
Elapsed:		540.37 (mins)
DB Time:		4,567.15 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	13,376M	13,376M	Std Block Size:	8K
Shared Pool Size:	3,008M	3,008M	Log Buffer:	52,580K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	8.5	2.2	0.06	0.03
DB CPU(s):	1.5	0.4	0.01	0.01
Redo size:	157,287.4	39,981.8
Logical reads:	171,706.8	43,647.2
Block changes:	331.1	84.2
Physical reads:	1,489.4	378.6
Physical writes:	35.4	9.0
User calls:	247.6	62.9
Parses:	76.0	19.3
Hard parses:	1.0	0.3
W/A MB processed:	11,430,461.6	2,905,577.9
Logons:	0.3	0.1
Executes:	145.7	37.0
Rollbacks:	0.1	0.0
Transactions:	3.9

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.75	Redo NoWait %:	100.00
Buffer Hit %:	99.53	In-memory Sort %:	100.00
Library Hit %:	98.37	Soft Parse %:	98.69
Execute to Parse %:	47.84	Latch Hit %:	97.93
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	99.72

Shared Pool Statistics

	Begin	End
Memory Usage %:	75.54	74.98
% SQL with executions>1:	91.19	82.60
% Memory for SQL w/exec>1:	91.02	79.61

Top 5 Timed Foreground Events

Host CPU (CPUs: 32 Cores: 16 Sockets: )

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
2.10	0.84	4.9	0.8	10.3	94.2

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
4.9	84.6	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	62,720.0	62,720.0
SGA use (MB):	22,272.0	22,272.0
PGA use (MB):	845.1	920.6
% Host Mem used for SGA+PGA:	36.86	36.86

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	45.19	11.49
Global Cache blocks served:	129.57	32.94
GCS/GES messages received:	501.22	127.41
GCS/GES messages sent:	277.70	70.59
DBWR Fusion writes:	1.98	0.50
Estd Interconnect traffic (KB)	1,550.18

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	99.51
Buffer access - remote cache %:	0.03
Buffer access - disk %:	0.47

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.9
Avg global cache cr block receive time (ms):	0.7
Avg global cache current block receive time (ms):	1.0
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	1.6
Avg global cache cr block flush time (ms):	6.5
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.1
Avg global cache current block flush time (ms):	14.9

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	2,560.6
Avg message sent queue time on ksxp (ms):	0.8
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	43.23
% of indirect sent messages:	56.51
% of flow controlled messages:	0.27

Cluster Interconnect

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• init.ora Parameters

More RAC Statistics

• RAC Report Summary
• Global Enqueue Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats
• Interconnect Stats

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 274029s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 99.7% of Total DB time 274,028.96 (s)
• Total FG Wait Time: 224,508.87 (s) DB CPU time: 48,789.62 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%. Value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• SQL ordered by Cluster Wait Time
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• Total DB Time (s): 274,029
• Captured SQL account for 77.2% of Total
• Total DB Time (s): 274,029
• Captured PL/SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total is the CPU Time divided into the Total CPU Time times 100
• Total CPU Time (s): 48,790
• Captured SQL account for 58.0% of Total
• Total CPU Time (s): 48,790
• Captured PL/SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• Total Buffer Gets: 5,567,066,235
• Captured SQL account for 67.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 48,289,294
• Captured SQL account for 51.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 4,722,399
• Captured SQL account for 35.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 2,463,409
• Captured SQL account for 34.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

• %Ela is Cluster Wait Time as percentage of SQL Elapsed Time
• %Total is Cluster Wait Time as percentage of Total Cluster Wait Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 20,228
• Captured Segments account for 90.9% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
03d55jtyrc4fd	select distinct yjxxb0_.ID as ID261_, yjxxb0_.DATAVERSION as DATAVERS2_261_, yjxxb0_.DXBH as DXBH261_, yjxxb0_.DXLX as DXLX261_, yjxxb0_.YJDW as YJDW261_, yjxxb0_.YJJZSJ as YJJZSJ261_, yjxxb0_.YJZQX as YJZQX261_, yjxxb0_.YJZQXDW as YJZQXDW261_, yjxxb0_.JSSJ as JSSJ261_, yjxxb0_.YJJSLX as YJJSLX261_, yjxxb0_.YJDQSJ as YJDQSJ261_, yjxxb0_.YJZT as YJZT261_, yjxxb0_.CQZT as CQZT261_, yjxxb0_.SCBJ as SCBJ261_, yjxxb0_.OPERATETIME as OPERATE15_261_, yjxxb0_.OPERATERCODE as OPERATE16_261_, yjxxb0_.DELFLAG as DELFLAG261_, yjxxb0_.ORGID as ORGID261_, yjxxb0_.CQDM as CQDM261_, yjxxb0_.CQMC as CQMC261_, yjxxb0_.AJBH as AJBH261_, yjxxb0_.ZBH as ZBH261_, yjxxb0_.CQID as CQID261_, yjxxb0_.YJTSXX as YJTSXX261_, yjxxb0_.CQTSXX as CQTSXX261_ from T_YJ_YJXXB yjxxb0_, T_AJ_BAZCYXX bazcyxx1_, T_AJ_BAZ baz2_ where yjxxb0_.ZBH=bazcyxx1_.ZBH and bazcyxx1_.ZBH=baz2_.ZBH and yjxxb0_.SCBJ='1' and bazcyxx1_.SFZAIB='1' and bazcyxx1_.BAMJZH=:1
04pb43q59faqj	SELECT COUNT(*) as CT from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.jbsj >= to_Date(:1 , 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2 , 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:3 or j.cbdw = :4 )
063ubyj5jwwya	insert into T_DOC_PARAVALUES (INSTANCEID, PARAID, GROUPID, PARACODE, PARAVALUE, CLOBVALUE, OPERATERCODE, OPERATETIME, DOCID, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
0cagshgb83ddh	SELECT COUNT(*) as CT from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.jbsj >= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:3 or j.cbdw = :4 ) and j.fynr like :5
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0hqh54x7zumja	select * from ( select * from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010554000000%') and wsqx.kjsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010554000000%') and wsqx.kjsj >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:6, 'yyyy-MM-dd hh24:mi') ) ) where rownum <= :7
0nxcvcgybact3	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) ) ) )
0ws5h5tu3cp8u	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.mbmc = :2 and wsqx.kjsj >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:4, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :5 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.gsdw in (select orgcode from t_sys_organization where tree path like '11000000000000.11010800000000.11010895000000%') and wsqx.mbmc = :6 and wsqx.kjsj >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:8, 'yyyy-MM-dd hh24:mi') )
16q8m01gqz13f	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.starttime >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.status = :4 union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :5 and wsqx.cqdx not in ('05', '06') and wsqx.starttime >= to_Date(:6, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.status = :8 )
17gdjk1wz7xd4	insert into T_SYS_AUDITRECORD ( ENTITYPRIMARYKEY, ID, IP, OPERATERID, OPERATIONTYPE, OPERATIONUSERLOGINID, RECORDTIME, SYSSIGN, TABLENAME) values (:1 , system_sequence.nextval, :2 , :3 , :4 , :5 , :6 , :7 , :8 )
19jz9jjuwy97c	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.username like :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :5 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.username like :6 and wsqx.starttime >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:8, 'yyyy-MM-dd hh24:mi') )
1a011r3hjt10c	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.ysc br, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) )
1bmvn6cx9yhy3	update T_SYS_NEWBUSINO set BUSINO = :1 where substr(BUSINO, :2, :3 ) = :4 and substr(BUSINO, :5 , :6) = :7 and BUSITABLENAME = :8
1f5vm39gzbru8	insert into T_SYS_AUDITRECORD ( ENTITYPRIMARYKEY, ID, IP, OPERATERID, OPERATIONTYPE, OPERATIONUSERLOGINID, RECORDTIME, SYSSIGN, TABLENAME) values (:1, system_sequence.nextval, :2, :3, :4, :5, :6, :7, :8)
1fzq2h38kugs4	insert into T_DOC_PARAVALUES (INSTANCEID, PARAID, GROUPID, PARACODE, PARAVALUE, CLOBVALUE, OPERATERCODE, OPERATETIME, DOCID, ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 )
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1h7b8aavd6brm	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '01' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.starttime >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '01' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.starttime >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:6, 'yyyy-MM-dd hh24:mi') )
1p3z35fv3kw9c	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.mbmc = :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :5 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_org anization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.mbmc = :6 and wsqx.starttime >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:8, 'yyyy-MM-dd hh24:mi') )
1ygd666vjk9mh	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.ysc br, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) )
26spzdkhaxd79	SELECT COUNT(*) as CT from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.jbsj >= to_Date(:1 , 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2 , 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:3 or j.cbdw = :4 ) and j.cbr like :5
2dy70kbt76tk2	SELECT COUNT(*) as CT from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.jbsj >= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:3 or j.cbdw = :4 )
2fvmbkq7stph5	SELECT COUNT(*) as CT from T_AJ_JJDJ j where j.jjlxbj='1' and j.cbrzh is null and j.sazt='1101' and j.cbdw = :1
2nk2p4h18rbwf	select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag, inst_id from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
305mr7dh7x0k9	select wsyzdy0_.ID as ID202_, wsyzdy0_.DATAVERSION as DATAVERS2_202_, wsyzdy0_.INSTANCEID as INSTANCEID202_, wsyzdy0_.DOCID as DOCID202_, wsyzdy0_.TEMPID as TEMPID202_, wsyzdy0_.GJZ as GJZ202_, wsyzdy0_.YZMC as YZMC202_, wsyzdy0_.QFZ as QFZ202_, wsyzdy0_.OPERATERCODE as OPERATER9_202_, wsyzdy0_.ORGID as ORGID202_, wsyzdy0_.OPERATETIME as OPERATE11_202_, wsyzdy0_.DELFLAG as DELFLAG202_ from T_DOC_WSYZDY wsyzdy0_ where wsyzdy0_.DOCID=:1
31qs8qca5fpca	select cast('01' as varchar(2))as lx , ajhj, id, ajzt from t_aj_xsajfaxx where ajbh = :1 and ajzt!='2904' union all select cast('02' as varchar(2))as lx, ajhj, id, ajzt from t_aj_xzajfaxx where ajbh = :2 and ajzt!='3210' union all select ssajlx as lx, '9999' as ajhj, id, ssajzt from t_aj_ssajxx where ssajbh = :3
38vp2757zqgsp	select * from t_doc_approvalrecord app inner join t_doc_processinstance ce on ce.id = app.instanceid where app.operatercode = :1 and (ce.instcode = :2 or (exists (select 1 from t_aj_xsajrydy dy where dy.ajbh = ce.instcode and dy.rybh = :3) or exists (select 1 from t_aj_xzajrydy dy where dy.ajbh = ce.instcode and dy.rybh = :4) or exists (select 1 from t_aj_ssajrydy dy where dy.ssajbh = ce.instcode and dy.rybh = :5)))
3b0f23j5r5a86	select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t where t.baseobject= :1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj#
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3p14m1fcpaxum	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '01' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010577000000%') and wsqx.kjsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:5, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.doc id and di.docstatus = '01' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010577000000%') and wsqx.kjsj >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:8, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:10, 'yyyy-MM-dd hh24:mi') )
3s1an65xqkvzp	SELECT COUNT(*) as CT FROM (SELECT SSAJBH , SSAJMC, SSAJLX, AJYS.YSZT, AJYS.ID FROM T_AJ_SSAJXX SS INNER JOIN T_AJ_AJYS AJYS ON SS.SSAJBH = AJYS.AJBH WHERE YSLB='1' AND YSZT NOT IN('2903', '3234', '4000', '5000', '6000', '7000') UNION ALL SELECT SSAJBH , SSAJMC, SSAJLX, '', '' FROM T_AJ_SSAJXX SS1 WHERE NOT EXISTS (SELECT 1 FROM T_AJ_AJYS AJYS1 WHERE AJYS1.AJBH=SS1.SSAJBH AND YSLB='1' AND YSZT NOT IN('2903', '3234', '4000', '5000', '6000', '7000'))) WHERE EXISTS (SELECT 1 FROM T_AJ_BAZ BAZ, T_AJ_BAZCYXX XX WHERE BAZ.AJBH = SSAJBH AND BAZ.ZBH = XX.ZBH AND BAZ.XJBS = '1' AND XX.SFZAIB = '1' AND XX.BAMJZH = :1)
3us5qaydnv9xt	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1 ) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.y scbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3 ) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) )
3wq38pu0y1pjz	SELECT COUNT(*) as CT FROM (select distinct xsajfaxx2_.AJBH as col_0_0_, xsajfaxx2_.AJMC as col_1_0_, xsajfaxx2_.ZABID as col_2_0_, xsajfaxx2_.CBDW as col_3_0_, xsajfaxx2_.AJHJ as col_4_0_, xsajfaxx2_.AJLXID as col_5_0_, max(processins0_.OPERATETIME) as col_6_0_ from T_DOC_PROCESSINSTANCE processins0_, T_DOC_PROCESSINSTANCEEX processins1_, T_AJ_XSAJFAXX xsajfaxx2_ where processins0_.ID=processins1_.PROCESSINSTANCEID and xsajfaxx2_.AJBH=processins1_.EXVALUE and processins1_.EXKEY='AJBH' and (processins0_.STATUS not in ('01' , '98' , '05')) and processins0_.WSKJZT<>'2' and not (exists (select 1 from T_DOC_PROCESSINSTANCEEX processins3_ where processins3_.EXKEY='SSAJBH' and processins3_.PROCESSINSTANCEID=processins0_.ID)) and xsajfaxx2_.AJZT<>'2904' and xsajfaxx2_.AJHJ=:1 and (processins0_.OWNERTYPE='01' and processins0_.OWNER=:2 or processins0_.OWNERTYPE='02' and processins0_.OWNORG='5588' and (processins0_.OWNPOSITION in ('P00024'))) group by xsajfaxx2_.AJBH , xsajfaxx2_.AJMC , xsajfaxx2_.ZABID , xsajfaxx2_.CBDW , xsajfaxx2_.AJHJ , xsajfaxx2_.AJLXID )
3wthgxcybh8yp	select * from ( select row_.*, rownum rownum_ from ( select j.jcjbh, j.id, j.barmc, j.badwmc, j.jbsj, j.fynr , j.ajlyid , j.sazt, j.cbr, (case when gl.cljg is null then j.cljg else gl.cljg end) cljg, j.bjlxid, gl.asjbh, j.jjlxbj, gl.clsj, gl.INSTID from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.jbsj >= to_Date(:1 , 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2 , 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:3 or j.cbdw = :4 ) and j.cbr like :5 order by j.jbsj desc ) row_ where rownum <= :6 ) where rownum_ > :7
3zhv1vck7a5m7	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.ysc br, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) )
49jsducyprcpt	select messagedet0_.ID as ID1_, messagedet0_.STATE as STATE1_, messagedet0_.RESENDSIZE as RESENDSIZE1_, messagedet0_.CHANNELNAME as CHANNELN4_1_, messagedet0_.SENDOBJECTKEY as SENDOBJE5_1_, messagedet0_.SENDDATE as SENDDATE1_, messagedet0_.SRCNODEID as SRCNODEID1_, messagedet0_.DESTNODEID as DESTNODEID1_ from T_MSG_MESSAGEDETAIL messagedet0_, T_MSG_NODE node1_, T_MSG_NODE node2_ where messagedet0_.SRCNODEID=node1_.ID and messagedet0_.DESTNODEID=node2_.ID and node1_.NODECODE=:1 and messagedet0_.STATE=:2 and (node2_.NODECODE in ('xcxt$8080$60:EB:69:8F:81:9A' , 'xcxt$8080$60:EB:69:8F:82:60' , 'xcxt$8080$60:EB:69:8F:82:9C' , 'xcxt$8080$60:EB:69:82:38:18' , 'xcxt$8080$60:EB:69:8F:84:0A' , 'xcxt$8080$60:EB:69:8F:81:B8' , 'xcxt$8080$60:EB:69:82:3B:42' , 'xcxt$8080$60:EB:69:8F:81:C4' , 'xcxt$8080$60:EB:69:8F:84:40' , 'uums$8080$60:EB:69:8F:83:62' , 'xcxt$8080$60:EB:69:8F:83:E0' , 'xcxt$8080$60:EB:69:8F:83:56'))
4b2754jcwn0q3	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) union all select xz.ajbh, xz.ajmc, decode(xz. yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 ) ) )
4c63bbwsptny6	select * from ( select xs.ajbh, xs.ajlxid, xs.ajmc, xs.zabid, xs.fakssj, xs.ajhj, xs.cbdw, xs.cbr, xs.yscbdw, xs.yscbr from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and xs.lrrq >= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and xs.lrrq <= to_Date(:2 , 'yyyy-MM-dd hh24:mi:ss') and exists (select 1 from t_aj_baz baz inner join t_aj_bazcyxx cy on cy.zbh = baz.zbh inner join t_sys_organization org on org.orgcode = cy.dwid where baz.ajbh = xs.ajbh and org.treepath like :3) ) where rownum <= :4
4fsj9h93j8z06	select * from ( select * from (select decode(jx.rybh, null, jx.ssajmc, (select ssajxx.ssajmc from t_aj_ssajxx ssajxx, t_ry_saryjbxx ry, t_aj_ssajrydy rydy where jx.rybh = ry.rybh and rydy.ryid = ry.ryid and ssajxx.ssajbh = rydy.ssajbh)) as ssajmc, jx.rybh, (select ry.ryxm from t_ry_saryjbxx ry where ry.rybh = jx.rybh) as ryxm, jx.cqlx, jx.cbjcyrq, jx.jcyjd, jx.bpbly, jx.bqsly, jx.bpzly, jx.pzzm, jx.qszm, jx.jdsj, decode(jx.rybh, null, (select u.username from t_aj_ssajxx ssaj, t_sys_user u where ssaj.ssajbh = jx.ssajbh and u.loginid = ssaj.cbrzh), (select us.username from t_sys_user us, t_aj_ssajxx ssajxx, t_ry_saryjbxx ry, t_aj_ssajrydy rydy where jx.rybh = ry.rybh and rydy.ryid = ry.ryid and us.loginid = ssajxx.cbrzh and ssajxx.ssajbh = rydy.ssajbh)) cbr, (select us.username from t_sys_user us, t_doc_docinstance dt, t_doc_template tp where dt.processinstanceid = jx.cqid and dt.templateid = tp.id and tp.templatecode in ('813', '814', '054', '057', '070', '833') and dt.kjrzh = us.loginid) as username, jx.id, jx.chly, jx.qtly, jx.gajgtqzm, (select ry.ryxmpym from t_ry_saryjbxx ry where ry.rybh = jx.rybh) as ryxmpym, jx.tydw, jx.sfytjdb, jx.jcjgyqczjssj, jx.pzrq, jx.lrrq, jx.operatetime, (select ssajxx.ssajbh from t_aj_ssajxx ssajxx, t_ry_saryjbxx ry, t_aj_ssajrydy rydy where jx.rybh = ry.rybh and rydy.ryid = ry.ryid and ssajxx.ssajbh = rydy.ssajbh) as ssajbh, (select organization.treepath from t_sys_org anization organization where organization.orgcode = jx.lrdwid) as treepath from t_ry_jcyyjxx jx where jx.jcyjd is not null) where 1=1 AND treepath like '11000000000000.11022200000000.11022208000000%' AND ryxm like '%???%' order by operatetime desc ) where rownum <= :1
4kgr7nfjjtp4n	insert into T_DOC_PROCESSINSTANCEEX (PROCESSINSTANCEID, EXKEY, EXVALUE, ID) values (:1, :2, :3, :4)
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4nrqyy0yaxw2m	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%????%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%????%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.y scbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%????%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%????%' ) ) ) )
54usa6tbss5gt	select wsyzdy0_.ID as ID206_, wsyzdy0_.DATAVERSION as DATAVERS2_206_, wsyzdy0_.INSTANCEID as INSTANCEID206_, wsyzdy0_.DOCID as DOCID206_, wsyzdy0_.TEMPID as TEMPID206_, wsyzdy0_.GJZ as GJZ206_, wsyzdy0_.YZMC as YZMC206_, wsyzdy0_.QFZ as QFZ206_, wsyzdy0_.OPERATERCODE as OPERATER9_206_, wsyzdy0_.ORGID as ORGID206_, wsyzdy0_.OPERATETIME as OPERATE11_206_, wsyzdy0_.DELFLAG as DELFLAG206_ from T_DOC_WSYZDY wsyzdy0_ where wsyzdy0_.DOCID=:1
56pkr52ytrku1	SELECT COUNT(*) as CT from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.jbsj >= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:3 or j.cbdw = :4 ) and j.cbr like :5
5fpp1bmppcusw	SELECT COUNT(*) as CT FROM (select distinct wtjl0_.ID as ID247_, wtjl0_.DATAVERSION as DATAVERS2_247_, wtjl0_.INSTANCEID as INSTANCEID247_, wtjl0_.AJBH as AJBH247_, wtjl0_.AJMC as AJMC247_, wtjl0_.AJLXID as AJLXID247_, wtjl0_.JCLXID as JCLXID247_, wtjl0_.ZXJCMC as ZXJCMC247_, wtjl0_.JCDWCJID as JCDWCJID247_, wtjl0_.ZFJCDWID as ZFJCDWID247_, wtjl0_.ZFJCDWMC as ZFJCDWMC247_, wtjl0_.ZFJCSJ as ZFJCSJ247_, wtjl0_.ZFJCMJZH as ZFJCMJZH247_, wtjl0_.ZFJCMJXM as ZFJCMJXM247_, wtjl0_.ZRHJID as ZRHJID247_, wtjl0_.ZRDWID as ZRDWID247_, wtjl0_.BAMJDWID as BAMJDWID247_, wtjl0_.BADWMC as BADWMC247_, wtjl0_.LRR as LRR247_, wtjl0_.LRRZH as LRRZH247_, wtjl0_.LRDWID as LRDWID247_, wtjl0_.LRRQ as LRRQ247_, wtjl0_.SFCQJCCSID as SFCQJCCSID247_, wtjl0_.DELFLAG as DELFLAG247_, wtjl0_.OPERATERCODE as OPERATE25_247_, wtjl0_.OPERATETIME as OPERATE26_247_, wtjl0_.ORGID as ORGID247_, wtjl0_.DQBAZBH as DQBAZBH247_, wtjl0_.SSAJLX as SSAJLX247_, wtjl0_.BJCDWID as BJCDWID247_, wtjl0_.BJCDWMC as BJCDWMC247_, wtjl0_.GLDXBH as GLDXBH247_, wtjl0_.SFZGID as SFZGID247_ from T_ZFJD_WTJL wtjl0_, T_ZFJD_LCWTDY lcwtdy1_ where wtjl0_.ID=lcwtdy1_.WTJLID and (wtjl0_.AJBH like :1))
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5nayh90r5kagx	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.kjsj >= to_Date(:2 , 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:3 , 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:4 , 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:5 , 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and wsqx.kjsj >= to_Date(:7 , 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:8 , 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:9 , 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:10 , 'yyyy-MM-dd hh24:mi') )
5pkhnyz04kynf	select count(*) as CT from t_ajgk_gkcqb cq where cq.spztid = '03' and exists(select org.id from t_sys_organization org where org.treepath like :1 and cq.cqdwid = org.orgcode)
5q6rv5v6st8h4	SELECT COUNT(*) as CT from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.ajlyid =:1 and j.jbsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:4 or j.cbdw = :5 )
5rwdyhd5kfgrk	SELECT COUNT(*) as CT FROM (select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11009500000000.11009512000000%') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11009500000000.11009512000000%') and wsqx.username like :2 and wsqx.cqdx = :3 and wsqx.starttime >= to_Date(:4, 'yyyy-MM-dd hh24:mi') )
5stvpmgu8kqn5	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.mbmc = :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.status = :5 union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.mbmc = :7 and wsqx.starttime >= to_Date(:8, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx. status = :10 )
5trm7vsx07rad	SELECT COUNT(*) as CT from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_aj_ajcl cl where cl.ajbh = xs.ajbh and cl.ajztid = :1 ) and xs.pcsgxid = :2 and exists (select 1 from t_aj_baz baz inner join t_aj_bazcyxx cy on cy.zbh = baz.zbh inner join t_sys_organization org on org.orgcode = cy.dwid where baz.ajbh = xs.ajbh and org.treepath like :3 ) and exists (select 1 from t_sys_organization org where org.orgcode = xs.lrdw and org.treepath like :4 )
5uwuvh35017d9	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.kjrname like :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :5 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.kjrname like :6 and wsqx.starttime >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:8, 'yyyy-MM-dd hh24:mi') )
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6cmu8kwz05qnr	select * from ( select j.jcjbh, j.id, j.barmc, j.badwmc, j.jbsj, j.fynr , j.ajlyid , j.sazt, j.cbr, (case when gl.cljg is null then j.cljg else gl.cljg end) cljg, j.bjlxid, gl.asjbh, j.jjlxbj, gl.clsj, gl.INSTID from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.jbsj >= to_Date(:1 , 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2 , 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:3 or j.cbdw = :4 ) order by j.jbsj desc ) where rownum <= :5
6cr9mqkcmsajc	SELECT COUNT(*) as CT from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and xs.lrrq >= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and xs.lrrq <= to_Date(:2 , 'yyyy-MM-dd hh24:mi:ss') and exists (select 1 from t_aj_baz baz inner join t_aj_bazcyxx cy on cy.zbh = baz.zbh inner join t_sys_organization org on org.orgcode = cy.dwid where baz.ajbh = xs.ajbh and org.treepath like :3)
6k2pj8dd32x1a	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.starttime >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and wsqx.starttime >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:6, 'yyyy-MM-dd hh24:mi') )
6mvfay19q3v4n	SELECT COUNT(CLIENT_INFO) FROM GV$SESSION WHERE USERNAME=:B2 AND CLIENT_INFO = :B1 GROUP BY CLIENT_INFO
6zdvk5sjzx0bf	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.kjsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:5, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and wsqx.kjsj >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:8, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:10, 'yyyy-MM-dd hh24:mi') )
7n2quq1dua0uf	select * from ( select * from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.starttime >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where t reepath like '11000000000000.11010800000000.11010895000000%') and wsqx.starttime >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:6, 'yyyy-MM-dd hh24:mi') ) ) where rownum <= :7
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7nuw4xwrnuwxq	select col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc
7p58hpqkfm985	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010883000000%') and wsqx.mbmc = :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.status = :5 union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010883000000%') and wsqx.mbmc = :7 and wsqx.starttime >= to_Date(:8, 'yyyy-MM-dd hh24:mi') an d wsqx.starttime<= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.status = :10 )
80jv8pa61btvq	SELECT COUNT(*) as CT FROM (select distinct wtjl0_.ID as ID245_, wtjl0_.DATAVERSION as DATAVERS2_245_, wtjl0_.INSTANCEID as INSTANCEID245_, wtjl0_.AJBH as AJBH245_, wtjl0_.AJMC as AJMC245_, wtjl0_.AJLXID as AJLXID245_, wtjl0_.JCLXID as JCLXID245_, wtjl0_.ZXJCMC as ZXJCMC245_, wtjl0_.JCDWCJID as JCDWCJID245_, wtjl0_.ZFJCDWID as ZFJCDWID245_, wtjl0_.ZFJCDWMC as ZFJCDWMC245_, wtjl0_.ZFJCSJ as ZFJCSJ245_, wtjl0_.ZFJCMJZH as ZFJCMJZH245_, wtjl0_.ZFJCMJXM as ZFJCMJXM245_, wtjl0_.ZRHJID as ZRHJID245_, wtjl0_.ZRDWID as ZRDWID245_, wtjl0_.BAMJDWID as BAMJDWID245_, wtjl0_.BADWMC as BADWMC245_, wtjl0_.LRR as LRR245_, wtjl0_.LRRZH as LRRZH245_, wtjl0_.LRDWID as LRDWID245_, wtjl0_.LRRQ as LRRQ245_, wtjl0_.SFCQJCCSID as SFCQJCCSID245_, wtjl0_.DELFLAG as DELFLAG245_, wtjl0_.OPERATERCODE as OPERATE25_245_, wtjl0_.OPERATETIME as OPERATE26_245_, wtjl0_.ORGID as ORGID245_, wtjl0_.DQBAZBH as DQBAZBH245_, wtjl0_.SSAJLX as SSAJLX245_, wtjl0_.BJCDWID as BJCDWID245_, wtjl0_.BJCDWMC as BJCDWMC245_, wtjl0_.GLDXBH as GLDXBH245_, wtjl0_.SFZGID as SFZGID245_ from T_ZFJD_WTJL wtjl0_, T_ZFJD_LCWTDY lcwtdy1_ where wtjl0_.ID=lcwtdy1_.WTJLID and (wtjl0_.AJBH like :1 ))
81zzs84239d3a	select count(1) from t_ajgk_dbxx aj where exists (select 1 from t_sys_organization o where o.treepath like :1 and aj.cbdwid = o.orgcode) and aj.cbrzh = :2 and aj.dbztid = '1' order by aj.scsj desc
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
84w14z52h3rg5	select * from ( select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1 ) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz .zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3 ) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) ) ) order by operatetime desc ) where rownum <= :5
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
89sp70q9xwr77	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1 ) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.y scbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3 ) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) )
8f1sjvfxuup9w	select t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null
8k0s9js3u63hh	SELECT COUNT(*) as CT FROM (select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11009500000000.11009512000000%') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11009500000000.11009512000000%') and wsqx.username like :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') )
8mgavwb3k1bxz	insert into T_DOC_DOCOPERATIONRECORD (DOCINSTANCEID, OPERATETYPE, OPERATION, OPERATERCODE, OPERATETIME, PROID, CZRDW, OPERATERIP, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9)
8pcw01qaa9b0f	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.starttime >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.starttime >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:6, 'yyyy-MM-dd hh24:mi' ) )
8sqtb3scv1a6d	SELECT to_char(SYSTIMESTAMP, 'yyyy-mm-dd hh24:mi:SS.FF3') FROM DUAL
927dq7xmj4bky	SELECT COUNT(*) as CT from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.barmc like :1 and j.jbsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:4 or j.cbdw = :5 )
93un0t1pddwfx	select wsyzdy0_.ID as ID203_, wsyzdy0_.DATAVERSION as DATAVERS2_203_, wsyzdy0_.INSTANCEID as INSTANCEID203_, wsyzdy0_.DOCID as DOCID203_, wsyzdy0_.TEMPID as TEMPID203_, wsyzdy0_.GJZ as GJZ203_, wsyzdy0_.YZMC as YZMC203_, wsyzdy0_.QFZ as QFZ203_, wsyzdy0_.OPERATERCODE as OPERATER9_203_, wsyzdy0_.ORGID as ORGID203_, wsyzdy0_.OPERATETIME as OPERATE11_203_, wsyzdy0_.DELFLAG as DELFLAG203_ from T_DOC_WSYZDY wsyzdy0_ where wsyzdy0_.DOCID=:1
98bq94ay7ub60	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010554000000%') and wsqx.kjsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010554000000%') and wsqx.kjsj >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:6, 'yyyy-MM-dd hh24:mi') )
99qa3zyarxvms	insert into plan_table (statement_id, timestamp, operation, options, object_node, object_owner, object_name, object_instance, object_type, search_columns, id, parent_id, position, other, optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml ) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
9d39pz72s6mgs	explain plan set statement_id = 'xcxt' for select null from dual
9mhnmf6sjgkd9	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.mbmc = :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :5 and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.mbmc = :6 and wsqx.starttime >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.starttim e<= to_Date(:8, 'yyyy-MM-dd hh24:mi') )
9mjkv1ars6wmw	select d.ID, d.DOCSTATUS, d.TEMPLATEID, t.TEMPLATENAME, t.HTML, d.DOCURL, t.TEMPLATECODE, d.CJSQ as CREATEDATE, '' , '' , t.isfltk, '' as XM, d.wordbytes from T_DOC_DOCINSTANCE d, T_DOC_TEMPLATE t where d.TEMPLATEID = t.ID and t.TEMPLATETYPE = :1 and d.PROCESSINSTANCEID = :2 and d.DOCTYPE = :3
a1xgxtssv5rrp	select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
a4nsb6fq5b41b	select user0_.ID as ID37_6_, user0_.USERNAME as USERNAME37_6_, user0_.LOGINID as LOGINID37_6_, user0_.PASSWD as PASSWD37_6_, user0_.INITIALPASSWD as INITIALP5_37_6_, user0_.REVERSIBLEPASSWD as REVERSIB6_37_6_, user0_.USERTYPE as USERTYPE37_6_, user0_.LOCKEDTIME as LOCKEDTIME37_6_, user0_.UNLOCKEDTIME as UNLOCKED9_37_6_, user0_.QUESTIONCONTENT as QUESTIO10_37_6_, user0_.QUESTIONANSWER as QUESTIO11_37_6_, user0_.STATUS as STATUS37_6_, user0_.SPELLCODE as SPELLCODE37_6_, user0_.DISPLAYORDER as DISPLAY14_37_6_, user0_.DESCN as DESCN37_6_, user0_.DELFLAG as DELFLAG37_6_, user0_.OPERATERCODE as OPERATE17_37_6_, user0_.OPERATETIME as OPERATE18_37_6_, user0_.USERINFOID as USERINFOID37_6_, user0_.ORGID as ORGID37_6_, user0_.MANAGERORGID as MANAGER21_37_6_, user0_.MAJORPOSITIONID as MAJORPO22_37_6_, userinfo1_.ID as ID38_0_, userinfo1_.USERNAME as USERNAME38_0_, userinfo1_.USERCODE as USERCODE38_0_, userinfo1_.GENDER as GENDER38_0_, userinfo1_.PERSONTYPE as PERSONTYPE38_0_, userinfo1_.IDCARD as IDCARD38_0_, userinfo1_.SPELLCODE as SPELLCODE38_0_, userinfo1_.DUTYLEVEL as DUTYLEVEL38_0_, userinfo1_.FORMERNAME as FORMERNAME38_0_, userinfo1_.NATIVEPLACE as NATIVEP10_38_0_, userinfo1_.BIRTHDAY as BIRTHDAY38_0_, userinfo1_.POLITICALSTATUS as POLITIC12_38_0_, userinfo1_.ADDRESS as ADDRESS38_0_, userinfo1_.POSTCODE as POSTCODE38_0_, userinfo1_.OFFICEPHONE as OFFICEP15_38_0_, userinfo1_.MOBILEPHONE as MOBILEP16_38_0_, userinfo1_.HOMEPHONE as HOMEPHONE38_0_, userinfo1_.FAX as FAX38_0_, userinfo1_.EMAIL as EMAIL38_0_, userinfo1_.DISPLAYORDER as DISPLAY20_38_0_, userinfo1_.DESCN as DESCN38_0_, userinfo1_.DELFLAG as DELFLAG38_0_, userinfo1_.OPERATERCODE as OPERATE23_38_0_, userinfo1_.OPERATETIME as OPERATE24_38_0_, userinfo1_.ORGID as ORGID38_0_, userinfo1_.MAJORPOSITIONID as MAJORPO26_38_0_, organizati2_.ID as ID20_1_, organizati2_.QZMC as QZMC20_1_, organizati2_.QZH as QZH20_1_, organizati2_.ORGNAME as ORGNAME20_1_, organizati2_.ORGCODE as ORGCODE20_1_, organizati2_.ORGABBRNAME as ORGABBRN6_20_1_, organizati2_.INNERCODE as INNERCODE20_1_, organizati2_.ORGTYPE as ORGTYPE20_1_, organizati2_.ORGLEVEL as ORGLEVEL20_1_, organizati2_.VIRTUALFLAG as VIRTUAL10_20_1_, organizati2_.UNITFLAG as UNITFLAG20_1_, organizati2_.BUSIFLAG as BUSIFLAG20_1_, organizati2_.DIRECTLYUNDERFLAG as DIRECTL13_20_1_, organizati2_.BUSIAREA as BUSIAREA20_1_, organizati2_.ADDRESS as ADDRESS20_1_, organizati2_.POSTCODE as POSTCODE20_1_, organizati2_.TELEPHONE as TELEPHONE20_1_, organizati2_.TELEGRAPHONE as TELEGRA18_20_1_, organizati2_.FAX as FAX20_1_, organizati2_.EMAIL as EMAIL20_1_, organizati2_.MANAGERID as MANAGERID20_1_, organizati2_.MANAGERNAME as MANAGER22_20_1_, organizati2_.TREEPATH as TREEPATH20_1_, organizati2_.STATUS as STATUS20_1_, organizati2_.DISPLAYORDER as DISPLAY25_20_1_, organizati2_.UNITID as UNITID20_1_, organizati2_.ALIASNAME as ALIASNAME20_1_, organizati2_.DESCN as DESCN20_1_, organizati2_.DELFLAG as D ELFLAG20_1_, organizati2_.OPERATERCODE as OPERATE30_20_1_, organizati2_.OPERATETIME as OPERATE31_20_1_, organizati2_.PARENTID as PARENTID20_1_, position3_.ID as ID26_2_, position3_.POSITIONNAME as POSITION2_26_2_, position3_.POSITIONCODE as POSITION3_26_2_, position3_.POSITIONTYPE as POSITION4_26_2_, position3_.POSITIONLEVEL as POSITION5_26_2_, position3_.DISPLAYORDER as DISPLAYO6_26_2_, position3_.DESCN as DESCN26_2_, position3_.DELFLAG as DELFLAG26_2_, position3_.OPERATERCODE as OPERATER9_26_2_, position3_.OPERATETIME as OPERATE10_26_2_, organizati4_.ID as ID20_3_, organizati4_.QZMC as QZMC20_3_, organizati4_.QZH as QZH20_3_, organizati4_.ORGNAME as ORGNAME20_3_, organizati4_.ORGCODE as ORGCODE20_3_, organizati4_.ORGABBRNAME as ORGABBRN6_20_3_, organizati4_.INNERCODE as INNERCODE20_3_, organizati4_.ORGTYPE as ORGTYPE20_3_, organizati4_.ORGLEVEL as ORGLEVEL20_3_, organizati4_.VIRTUALFLAG as VIRTUAL10_20_3_, organizati4_.UNITFLAG as UNITFLAG20_3_, organizati4_.BUSIFLAG as BUSIFLAG20_3_, organizati4_.DIRECTLYUNDERFLAG as DIRECTL13_20_3_, organizati4_.BUSIAREA as BUSIAREA20_3_, organizati4_.ADDRESS as ADDRESS20_3_, organizati4_.POSTCODE as POSTCODE20_3_, organizati4_.TELEPHONE as TELEPHONE20_3_, organizati4_.TELEGRAPHONE as TELEGRA18_20_3_, organizati4_.FAX as FAX20_3_, organizati4_.EMAIL as EMAIL20_3_, organizati4_.MANAGERID as MANAGERID20_3_, organizati4_.MANAGERNAME as MANAGER22_20_3_, organizati4_.TREEPATH as TREEPATH20_3_, organizati4_. STATUS as STATUS20_3_, organizati4_.DISPLAYORDER as DISPLAY25_20_3_, organizati4_.UNITID as UNITID20_3_, organizati4_.ALIASNAME as ALIASNAME20_3_, organizati4_.DESCN as DESCN20_3_, organizati4_.DELFLAG as DELFLAG20_3_, organizati4_.OPERATERCODE as OPERATE30_20_3_, organizati4_.OPERATETIME as OPERATE31_20_3_, organizati4_.PARENTID as PARENTID20_3_, organizati5_.ID as ID20_4_, organizati5_.QZMC as QZMC20_4_, organizati5_.QZH as QZH20_4_, organizati5_.ORGNAME as ORGNAME20_4_, organizati5_.ORGCODE as ORGCODE20_4_, organizati5_.ORGABBRNAME as ORGABBRN6_20_4_, organizati5_.INNERCODE as INNERCODE20_4_, organizati5_.ORGTYPE as ORGTYPE20_4_, organizati5_.ORGLEVEL as ORGLEVEL20_4_, organizati5_.VIRTUALFLAG as VIRTUAL10_20_4_, organizati5_.UNITFLAG as UNITFLAG20_4_, organizati5_.BUSIFLAG as BUSIFLAG20_4_, organizati5_.DIRECTLYUNDERFLAG as DIRECTL13_20_4_, organizati5_.BUSIAREA as BUSIAREA20_4_, organizati5_.ADDRESS as ADDRESS20_4_, organizati5_.POSTCODE as POSTCODE20_4_, organizati5_.TELEPHONE as TELEPHONE20_4_, organizati5_.TELEGRAPHONE as TELEGRA18_20_4_, organizati5_.FAX as FAX20_4_, organizati5_.EMAIL as EMAIL20_4_, organizati5_.MANAGERID as MANAGERID20_4_, organizati5_.MANAGERNAME as MANAGER22_20_4_, organizati5_.TREEPATH as TREEPATH20_4_, organizati5_.STATUS as STATUS20_4_, organizati5_.DISPLAYORDER as DISPLAY25_20_4_, organizati5_.UNITID as UNITID20_4_, organizati5_.ALIASNAME as ALIASNAME20_4_, organizati5_.DESCN as DESCN20_4_, organizati5_.DE LFLAG as DELFLAG20_4_, organizati5_.OPERATERCODE as OPERATE30_20_4_, organizati5_.OPERATETIME as OPERATE31_20_4_, organizati5_.PARENTID as PARENTID20_4_, position6_.ID as ID26_5_, position6_.POSITIONNAME as POSITION2_26_5_, position6_.POSITIONCODE as POSITION3_26_5_, position6_.POSITIONTYPE as POSITION4_26_5_, position6_.POSITIONLEVEL as POSITION5_26_5_, position6_.DISPLAYORDER as DISPLAYO6_26_5_, position6_.DESCN as DESCN26_5_, position6_.DELFLAG as DELFLAG26_5_, position6_.OPERATERCODE as OPERATER9_26_5_, position6_.OPERATETIME as OPERATE10_26_5_ from T_SYS_USER user0_ left outer join T_SYS_USERINFO userinfo1_ on user0_.USERINFOID=userinfo1_.ID left outer join T_SYS_ORGANIZATION organizati2_ on userinfo1_.ORGID=organizati2_.ID left outer join T_SYS_POSITION position3_ on userinfo1_.MAJORPOSITIONID=position3_.ID left outer join T_SYS_ORGANIZATION organizati4_ on user0_.ORGID=organizati4_.ID left outer join T_SYS_ORGANIZATION organizati5_ on user0_.MANAGERORGID=organizati5_.ID left outer join T_SYS_POSITION position6_ on user0_.MAJORPOSITIONID=position6_.ID where user0_.ID=:1
a6j557zy695dg	select * from ( select * from ( select distinct xsajfaxx.ajbh, xsajfaxx.ajmc, xsajfaxx.zabid, xsajfaxx.cbdw, xsajfaxx.ajhj, xsajfaxx.ajlxid , max(PROCESSINSTANCE.operatetime) as operatetime from T_DOC_PROCESSINSTANCE PROCESSINSTANCE inner join T_DOC_PROCESSINSTANCEEX PROCESSINSTANCEEX on PROCESSINSTANCE.Id = PROCESSINSTANCEEX.PROCESSINSTANCEID inner join t_aj_xsajfaxx xsajfaxx on xsajfaxx.ajbh = PROCESSINSTANCEEX.Exvalue and PROCESSINSTANCEEX.EXKEY = 'AJBH' where PROCESSINSTANCE.ownertype = '03' and xsajfaxx.ajzt!='2904' and PROCESSINSTANCE.status = '02' and PROCESSINSTANCE.id not in (select ex.processInstanceid from T_DOC_PROCESSINSTANCEEX ex where ex.exkey = 'SSAJBH' and ex.processInstanceid = PROCESSINSTANCEEX.PROCESSINSTANCEID ) and PROCESSINSTANCE.Ownorg in (SELECT a.id FROM t_sys_organization a, t_sys_organization b , t_sys_organization c WHERE b.orgcode = :1 and a.orgcode like :2 and c.orgcode like :3 and a.busiarea <> '700' and ((b.directlyunderflag='0' and a.orglevel = 3 ) or ( b.directlyunderflag='1' and b.busiarea = '400' and c.busiarea<>'400' and c.orglevel = 2 and a.orglevel = 3 ) or ( b.directlyunderflag='1' and b.busiarea != '400' and a.orglevel = 2 ) or ( b.directlyunderflag='1' and b.busiarea = '400' and c.busiarea='400' and a.orglevel = 2 ) )) group by xsajfaxx.ajbh, xsajfaxx.ajmc, xsajfaxx.zabid, xsajfaxx.cbdw, xsajfaxx.ajhj, xsajfaxx.ajlxid ) order by operatetime desc ) where rownum <= :4
a73wbv1yu8x5c	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
aaf9ptqwap0nc	select LoginId, UserName from t_sys_user where orgid = :1
abq7md1cz6hnk	update T_DZJZ_FJ set DATAVERSION=:1, FILEDESC=:2, FILETYPE=:3, CLUPTIME=:4, FILESIZE=:5, PX=:6, FILERELATIONID=:7, FJ=:8, OPERATETIME=:9, OPERATERCODE=:10, DELFLAG=:11, ORGID=:12, FILENAME=:13, FTPPATH=:14 where ID=:15 and DATAVERSION=:16
acwz5t51du5bj	update T_RY_JJRYXX set DATAVERSION=:1, JCJBH=:2, RYLX=:3, XM=:4, XBID=:5, NL=:6, SFZH=:7, DH=:8, GZDW=:9, JZDID=:10, JZDXZ=:11, HJDID=:12, HJDXZ=:13, GJID=:14, SWSFID=:15, ZJLXID=:16, ZJHM=:17, XMPYM=:18, OPERATERCODE=:19, OPERATETIME=:20, DELFLAG=:21, ORGID=:22, TSSF=:23, RYBH=:24, CSRQ=:25, JJID=:26 where ID=:27 and DATAVERSION=:28
akuc4h1uj3vm6	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.ysc br, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) )
an65gk41j72n4	SELECT COUNT(*) as CT FROM (select distinct x.id, x.ajbh, x.zabid, x.pcsgxid, x.fakssj, x.jyaq, x.ajmc from T_AJ_XSAJFAXX x inner join t_aj_baz baz on baz.ajbh = x.ajbh left join t_aj_ssajzcrdajdy dy on dy.ajbh = x.ajbh left join T_AJ_XSAJRYDY d on x.id=d.ajid left join T_RY_SARYJBXX j on d.rybh=j.rybh where x.ajzt <> '2904' and j.ryxm like '%??%' and baz.xjbs='1' and exists (select 1 from t_sys_organization org where org.orgcode = baz.ssdw and org.treepath like :1) )
at03p1t9wka6h	select * from ( select * from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010883000000%') and wsqx.mbmc = :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.status = :5 union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010883000000%') and wsqx.mbmc = :7 and wsqx.starttime >= to_Date(:8, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.status = :10 ) ) where rownum <= :11
av9qg79p2h2nu	SELECT COUNT(*) as CT from ( select distinct xsajfaxx.ajbh, xsajfaxx.ajmc, xsajfaxx.zabid, xsajfaxx.cbdw, xsajfaxx.ajhj, xsajfaxx.ajlxid , max(PROCESSINSTANCE.operatetime) as operatetime from T_DOC_PROCESSINSTANCE PROCESSINSTANCE inner join T_DOC_PROCESSINSTANCEEX PROCESSINSTANCEEX on PROCESSINSTANCE.Id = PROCESSINSTANCEEX.PROCESSINSTANCEID inner join t_aj_xsajfaxx xsajfaxx on xsajfaxx.ajbh = PROCESSINSTANCEEX.Exvalue and PROCESSINSTANCEEX.EXKEY = 'AJBH' where PROCESSINSTANCE.ownertype = '03' and xsajfaxx.ajzt!='2904' and PROCESSINSTANCE.status = '02' and PROCESSINSTANCE.id not in (select ex.processInstanceid from T_DOC_PROCESSINSTANCEEX ex where ex.exkey = 'SSAJBH' and ex.processInstanceid = PROCESSINSTANCEEX.PROCESSINSTANCEID ) and PROCESSINSTANCE.Ownorg in (SELECT a.id FROM t_sys_organization a, t_sys_organization b , t_sys_organization c WHERE b.orgcode = :1 and a.orgcode like :2 and c.orgcode like :3 and a.busiarea <> '700' and ((b.directlyunderflag='0' and a.orglevel = 3 ) or ( b.directlyunderflag='1' and b.busiarea = '400' and c.busiarea<>'400' and c.orglevel = 2 and a.orglevel = 3 ) or ( b.directlyunderflag='1' and b.busiarea != '400' and a.orglevel = 2 ) or ( b.directlyunderflag='1' and b.busiarea = '400' and c.busiarea='400' and a.orglevel = 2 ) )) group by xsajfaxx.ajbh, xsajfaxx.ajmc, xsajfaxx.zabid, xsajfaxx.cbdw, xsajfaxx.ajhj, xsajfaxx.ajlxid )
b6qkb2dh75u7x	select count(1) from t_dc_bbxx bbxx where bbxx.cssj is null and bbxx.bbmjzh = :1
b6qtrn4pqycjc	select x.id rid, x.resourcename, x.resourcecode, x.resourcetype, x.classname, x.methodname, x.realid, x.realresource, y.id mid, y.modulename, y.modulecode, y.modulecontent from t_sys_resource x, t_sys_module y where x.moduleid=y.id(+) and x.id in (select resourceid from t_sys_permission_resource where permissionid in (select permissionid from t_sys_role_permission where roleid in (select roleid from t_sys_user_role where userid=(select id from t_sys_user where loginid=:1) union select roleid from t_sys_role_group where groupid in (select groupid from t_sys_user_group where userid=(select id from t_sys_user where loginid=:2))))) and x.resourcetype=:3 order by x.resourcetype, y.modulecode
b6zcgxw77633w	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000%') and wsqx.mbmc = :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.status = :5 union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000%') and wsqx.mbmc = :7 and wsqx.starttime >= to_Date(:8, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= t o_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.status = :10 )
b8q51c4k3q03n	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.ysc br, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) )
b9ru873rhupjk	select wsyzdy0_.ID as ID197_, wsyzdy0_.DATAVERSION as DATAVERS2_197_, wsyzdy0_.INSTANCEID as INSTANCEID197_, wsyzdy0_.DOCID as DOCID197_, wsyzdy0_.TEMPID as TEMPID197_, wsyzdy0_.GJZ as GJZ197_, wsyzdy0_.YZMC as YZMC197_, wsyzdy0_.QFZ as QFZ197_, wsyzdy0_.OPERATERCODE as OPERATER9_197_, wsyzdy0_.ORGID as ORGID197_, wsyzdy0_.OPERATETIME as OPERATE11_197_, wsyzdy0_.DELFLAG as DELFLAG197_ from T_DOC_WSYZDY wsyzdy0_ where wsyzdy0_.DOCID=:1
ba2my4bz5bkac	select distinct w.rybh, w.xm, w.xbid, w.csrq, w.zzm, w.zay, w.dqty, w.SAZT, p.FEATURENAME from T_RY_WFFZRYXX w inner join T_DOC_PROCESSINSTANCE p on p.id=w.dqty where ((w.sczt <> '00' and w.sczt <> '08') or w.sczt is null) and w.sazt='01' and p.status='01' and ( exists ( select 1 from T_AJ_XSAJRYDY xs1 inner join T_AJ_XSAJFAXX xs2 on xs1.ajbh = xs2.ajbh inner join T_AJ_BAZ baz on baz.ajbh = xs1.ajbh inner join T_AJ_BAZCYXX bazcyxx on baz.zbh = bazcyxx.zbh where xs2.ajzt <> '2904' and baz.xjbs = '1' and bazcyxx.sfzaib = '1' and bazcyxx.bamjzh = :1 and xs1.rybh = w.rybh ) or exists( select 1 from T_AJ_XZAJRYDY xz1 inner join T_AJ_XZAJFAXX xz2 on xz1.ajbh = xz2.ajbh inner join T_AJ_BAZ baz on baz.ajbh = xz1.ajbh inner join T_AJ_BAZCYXX bazcyxx on baz.zbh = bazcyxx.zbh where xz2.ajzt <> '3210' and baz.xjbs = '1' and bazcyxx.sfzaib = '1' and bazcyxx.bamjzh = :2 and xz1.rybh = w.rybh ) ) and not exists(select 1 From t_doc_processinstance a where a.instcode = w.rybh and a.status='02' and a.INSTANCETYPE='02') order by w.xm desc
bb7txdb9wvf64	select count(*) as CT from (select distinct xz.id, xz.ajbh, xz.ajmc, xz.ajlxid, '', xm, xz.zabid, ys.ysdw, ys.ysrq, '2' ajflg, xz.operatetime from t_aj_xzajfaxx xz left join t_aj_xzajrydy dy on xz.id = dy.ajid and xz.ajzt = '3233' left join t_ry_wffzryxx ry on ry.id = dy.ryid and dy.rylx = '05' inner join t_aj_ajys ys on xz.id = ys.ajid and ys.yszt = '3233' where 1 = 1 and ys.swdw = :1)
bhjbdkfcmc9gw	update T_AJ_JJDJ set DATAVERSION=:1, JCJBH=:2, AJLYID=:3, JBSJ=:4, JBDWID=:5, JBR=:6, ASJFSSJ=:7, ASJJSSJ=:8, ASJFSDDID=:9, ASJFSXZ=:10, FYNR=:11, SSPCSID=:12, BJLXID=:13, FXSJ=:14, AJLBID=:15, CZYJ=:16, CZJGID=:17, CZDWID=:18, CZR=:19, CZPZR=:20, ASJLXID=:21, JTCZQK=:22, JZSYRS=:23, JZQZRS=:24, LZSCRS=:25, JJBGFNRS=:26, JJBGETRS=:27, JHXXRS=:28, SWRS=:29, SSRS=:30, JTSGZJJJSSJE=:31, CDJDCCC=:32, CDCZCS=:33, CDJLRS=:34, SARYGJID=:35, QHGXID=:36, XYRS=:37, LRDWID=:38, LRR=:39, LRRQ=:40, DELFLAG=:41, OPERATETIME=:42, OPERATERCODE=:43, ORGID=:44, JJLXBJ=:45, BJSJ=:46, LRRZH=:47, YJJSDW=:48, YJYY=:49, YJCBR=:50, YJPZR=:51, FXXS=:52, JBDH=:53, BJDH=:54, CJRY=:55, BLMJXM=:56, BLMJZH=:57, BADW=:58, SAJE=:59, SAZH=:60, SFSW=:61, TDAJLX=:62, CPH=:63, JBJB=:64, LDPS=:65, LHDW=:66, YWH=:67, ZBDW=:68, DBDW=:69, JBDW=:70, DBLDXM=:71, DBLDZH=:72, DBRZH=:73, DBRXM=:74, ZJSJ=:75, CBDW=:76, CBR=:77, CBRZH=:78, CLJG=:79, CZFS=:80, SAZT=:81, JJCL=:82, JBRZH=:83, CZRZH=:84, CZPZRZH=:85, YJCBRZH=:86, YJPZRZH=:87, HBDW=:88, HBRZH=:89, HBRXM=:90, YJBS=:91, YJJSRQ=:92, YJRQ=:93, YJDW=:94, ZJLX=:95, BARMC=:96, BADWMC=:97, JJCLCSFLG=:98, INSTID=:99, SFYCLID=:100 where ID=:101 and DATAVERSION=:102
bpggz1tjg1v4a	SELECT COUNT(*) as CT FROM (select distinct wtjl0_.ID as ID251_, wtjl0_.DATAVERSION as DATAVERS2_251_, wtjl0_.INSTANCEID as INSTANCEID251_, wtjl0_.AJBH as AJBH251_, wtjl0_.AJMC as AJMC251_, wtjl0_.AJLXID as AJLXID251_, wtjl0_.JCLXID as JCLXID251_, wtjl0_.ZXJCMC as ZXJCMC251_, wtjl0_.JCDWCJID as JCDWCJID251_, wtjl0_.ZFJCDWID as ZFJCDWID251_, wtjl0_.ZFJCDWMC as ZFJCDWMC251_, wtjl0_.ZFJCSJ as ZFJCSJ251_, wtjl0_.ZFJCMJZH as ZFJCMJZH251_, wtjl0_.ZFJCMJXM as ZFJCMJXM251_, wtjl0_.ZRHJID as ZRHJID251_, wtjl0_.ZRDWID as ZRDWID251_, wtjl0_.BAMJDWID as BAMJDWID251_, wtjl0_.BADWMC as BADWMC251_, wtjl0_.LRR as LRR251_, wtjl0_.LRRZH as LRRZH251_, wtjl0_.LRDWID as LRDWID251_, wtjl0_.LRRQ as LRRQ251_, wtjl0_.SFCQJCCSID as SFCQJCCSID251_, wtjl0_.DELFLAG as DELFLAG251_, wtjl0_.OPERATERCODE as OPERATE25_251_, wtjl0_.OPERATETIME as OPERATE26_251_, wtjl0_.ORGID as ORGID251_, wtjl0_.DQBAZBH as DQBAZBH251_, wtjl0_.SSAJLX as SSAJLX251_, wtjl0_.BJCDWID as BJCDWID251_, wtjl0_.BJCDWMC as BJCDWMC251_, wtjl0_.GLDXBH as GLDXBH251_, wtjl0_.SFZGID as SFZGID251_ from T_ZFJD_WTJL wtjl0_, T_ZFJD_LCWTDY lcwtdy1_ where wtjl0_.ID=lcwtdy1_.WTJLID and (wtjl0_.AJBH like :1))
bsa0wjtftg3uw	select file# from file$ where ts#=:1
bttvha3h8s87p	SELECT COUNT(*) as CT from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and xs.fakssj >= to_Date(:1 , 'yyyy-MM-dd hh24:mi:ss') and xs.fakssj <= to_Date(:2 , 'yyyy-MM-dd hh24:mi:ss') and exists (select 1 from t_aj_baz baz inner join t_aj_bazcyxx cy on cy.zbh = baz.zbh inner join t_sys_organization org on org.orgcode = cy.dwid where baz.ajbh = xs.ajbh and org.treepath like :3 )
bwk3jpza9qfjp	select wsyzdy0_.ID as ID185_, wsyzdy0_.DATAVERSION as DATAVERS2_185_, wsyzdy0_.INSTANCEID as INSTANCEID185_, wsyzdy0_.DOCID as DOCID185_, wsyzdy0_.TEMPID as TEMPID185_, wsyzdy0_.GJZ as GJZ185_, wsyzdy0_.YZMC as YZMC185_, wsyzdy0_.QFZ as QFZ185_, wsyzdy0_.OPERATERCODE as OPERATER9_185_, wsyzdy0_.ORGID as ORGID185_, wsyzdy0_.OPERATETIME as OPERATE11_185_, wsyzdy0_.DELFLAG as DELFLAG185_ from T_DOC_WSYZDY wsyzdy0_ where wsyzdy0_.DOCID=:1
bycq6swyv3bj1	select this_.ID as ID37_6_, this_.USERNAME as USERNAME37_6_, this_.LOGINID as LOGINID37_6_, this_.PASSWD as PASSWD37_6_, this_.INITIALPASSWD as INITIALP5_37_6_, this_.REVERSIBLEPASSWD as REVERSIB6_37_6_, this_.USERTYPE as USERTYPE37_6_, this_.LOCKEDTIME as LOCKEDTIME37_6_, this_.UNLOCKEDTIME as UNLOCKED9_37_6_, this_.QUESTIONCONTENT as QUESTIO10_37_6_, this_.QUESTIONANSWER as QUESTIO11_37_6_, this_.STATUS as STATUS37_6_, this_.SPELLCODE as SPELLCODE37_6_, this_.DISPLAYORDER as DISPLAY14_37_6_, this_.DESCN as DESCN37_6_, this_.DELFLAG as DELFLAG37_6_, this_.OPERATERCODE as OPERATE17_37_6_, this_.OPERATETIME as OPERATE18_37_6_, this_.USERINFOID as USERINFOID37_6_, this_.ORGID as ORGID37_6_, this_.MANAGERORGID as MANAGER21_37_6_, this_.MAJORPOSITIONID as MAJORPO22_37_6_, userinfo2_.ID as ID38_0_, userinfo2_.USERNAME as USERNAME38_0_, userinfo2_.USERCODE as USERCODE38_0_, userinfo2_.GENDER as GENDER38_0_, userinfo2_.PERSONTYPE as PERSONTYPE38_0_, userinfo2_.IDCARD as IDCARD38_0_, userinfo2_.SPELLCODE as SPELLCODE38_0_, userinfo2_.DUTYLEVEL as DUTYLEVEL38_0_, userinfo2_.FORMERNAME as FORMERNAME38_0_, userinfo2_.NATIVEPLACE as NATIVEP10_38_0_, userinfo2_.BIRTHDAY as BIRTHDAY38_0_, userinfo2_.POLITICALSTATUS as POLITIC12_38_0_, userinfo2_.ADDRESS as ADDRESS38_0_, userinfo2_.POSTCODE as POSTCODE38_0_, userinfo2_.OFFICEPHONE as OFFICEP15_38_0_, userinfo2_.MOBILEPHONE as MOBILEP16_38_0_, userinfo2_.HOMEPHONE as HOMEPHONE38_0_, userinfo2_.FAX as FA X38_0_, userinfo2_.EMAIL as EMAIL38_0_, userinfo2_.DISPLAYORDER as DISPLAY20_38_0_, userinfo2_.DESCN as DESCN38_0_, userinfo2_.DELFLAG as DELFLAG38_0_, userinfo2_.OPERATERCODE as OPERATE23_38_0_, userinfo2_.OPERATETIME as OPERATE24_38_0_, userinfo2_.ORGID as ORGID38_0_, userinfo2_.MAJORPOSITIONID as MAJORPO26_38_0_, organizati3_.ID as ID20_1_, organizati3_.QZMC as QZMC20_1_, organizati3_.QZH as QZH20_1_, organizati3_.ORGNAME as ORGNAME20_1_, organizati3_.ORGCODE as ORGCODE20_1_, organizati3_.ORGABBRNAME as ORGABBRN6_20_1_, organizati3_.INNERCODE as INNERCODE20_1_, organizati3_.ORGTYPE as ORGTYPE20_1_, organizati3_.ORGLEVEL as ORGLEVEL20_1_, organizati3_.VIRTUALFLAG as VIRTUAL10_20_1_, organizati3_.UNITFLAG as UNITFLAG20_1_, organizati3_.BUSIFLAG as BUSIFLAG20_1_, organizati3_.DIRECTLYUNDERFLAG as DIRECTL13_20_1_, organizati3_.BUSIAREA as BUSIAREA20_1_, organizati3_.ADDRESS as ADDRESS20_1_, organizati3_.POSTCODE as POSTCODE20_1_, organizati3_.TELEPHONE as TELEPHONE20_1_, organizati3_.TELEGRAPHONE as TELEGRA18_20_1_, organizati3_.FAX as FAX20_1_, organizati3_.EMAIL as EMAIL20_1_, organizati3_.MANAGERID as MANAGERID20_1_, organizati3_.MANAGERNAME as MANAGER22_20_1_, organizati3_.TREEPATH as TREEPATH20_1_, organizati3_.STATUS as STATUS20_1_, organizati3_.DISPLAYORDER as DISPLAY25_20_1_, organizati3_.UNITID as UNITID20_1_, organizati3_.ALIASNAME as ALIASNAME20_1_, organizati3_.DESCN as DESCN20_1_, organizati3_.DELFLAG as DELFLAG20_1_, organiza ti3_.OPERATERCODE as OPERATE30_20_1_, organizati3_.OPERATETIME as OPERATE31_20_1_, organizati3_.PARENTID as PARENTID20_1_, position4_.ID as ID26_2_, position4_.POSITIONNAME as POSITION2_26_2_, position4_.POSITIONCODE as POSITION3_26_2_, position4_.POSITIONTYPE as POSITION4_26_2_, position4_.POSITIONLEVEL as POSITION5_26_2_, position4_.DISPLAYORDER as DISPLAYO6_26_2_, position4_.DESCN as DESCN26_2_, position4_.DELFLAG as DELFLAG26_2_, position4_.OPERATERCODE as OPERATER9_26_2_, position4_.OPERATETIME as OPERATE10_26_2_, organizati5_.ID as ID20_3_, organizati5_.QZMC as QZMC20_3_, organizati5_.QZH as QZH20_3_, organizati5_.ORGNAME as ORGNAME20_3_, organizati5_.ORGCODE as ORGCODE20_3_, organizati5_.ORGABBRNAME as ORGABBRN6_20_3_, organizati5_.INNERCODE as INNERCODE20_3_, organizati5_.ORGTYPE as ORGTYPE20_3_, organizati5_.ORGLEVEL as ORGLEVEL20_3_, organizati5_.VIRTUALFLAG as VIRTUAL10_20_3_, organizati5_.UNITFLAG as UNITFLAG20_3_, organizati5_.BUSIFLAG as BUSIFLAG20_3_, organizati5_.DIRECTLYUNDERFLAG as DIRECTL13_20_3_, organizati5_.BUSIAREA as BUSIAREA20_3_, organizati5_.ADDRESS as ADDRESS20_3_, organizati5_.POSTCODE as POSTCODE20_3_, organizati5_.TELEPHONE as TELEPHONE20_3_, organizati5_.TELEGRAPHONE as TELEGRA18_20_3_, organizati5_.FAX as FAX20_3_, organizati5_.EMAIL as EMAIL20_3_, organizati5_.MANAGERID as MANAGERID20_3_, organizati5_.MANAGERNAME as MANAGER22_20_3_, organizati5_.TREEPATH as TREEPATH20_3_, organizati5_.STATUS as STATUS20_3_, organizati5_.DISPLAYORDER as DISPLAY25_20_3_, organizati5_.UNITID as UNITID20_3_, organizati5_.ALIASNAME as ALIASNAME20_3_, organizati5_.DESCN as DESCN20_3_, organizati5_.DELFLAG as DELFLAG20_3_, organizati5_.OPERATERCODE as OPERATE30_20_3_, organizati5_.OPERATETIME as OPERATE31_20_3_, organizati5_.PARENTID as PARENTID20_3_, organizati6_.ID as ID20_4_, organizati6_.QZMC as QZMC20_4_, organizati6_.QZH as QZH20_4_, organizati6_.ORGNAME as ORGNAME20_4_, organizati6_.ORGCODE as ORGCODE20_4_, organizati6_.ORGABBRNAME as ORGABBRN6_20_4_, organizati6_.INNERCODE as INNERCODE20_4_, organizati6_.ORGTYPE as ORGTYPE20_4_, organizati6_.ORGLEVEL as ORGLEVEL20_4_, organizati6_.VIRTUALFLAG as VIRTUAL10_20_4_, organizati6_.UNITFLAG as UNITFLAG20_4_, organizati6_.BUSIFLAG as BUSIFLAG20_4_, organizati6_.DIRECTLYUNDERFLAG as DIRECTL13_20_4_, organizati6_.BUSIAREA as BUSIAREA20_4_, organizati6_.ADDRESS as ADDRESS20_4_, organizati6_.POSTCODE as POSTCODE20_4_, organizati6_.TELEPHONE as TELEPHONE20_4_, organizati6_.TELEGRAPHONE as TELEGRA18_20_4_, organizati6_.FAX as FAX20_4_, organizati6_.EMAIL as EMAIL20_4_, organizati6_.MANAGERID as MANAGERID20_4_, organizati6_.MANAGERNAME as MANAGER22_20_4_, organizati6_.TREEPATH as TREEPATH20_4_, organizati6_.STATUS as STATUS20_4_, organizati6_.DISPLAYORDER as DISPLAY25_20_4_, organizati6_.UNITID as UNITID20_4_, organizati6_.ALIASNAME as ALIASNAME20_4_, organizati6_.DESCN as DESCN20_4_, organizati6_.DELFLAG as DELFLAG20_4_, organizati6_.OPERATERCODE as OPERATE30_20_4_, organizati6_.OPERATETIME as OPERATE31_20_4_, organizati6_.PARENTID as PARENTID20_4_, position7_.ID as ID26_5_, position7_.POSITIONNAME as POSITION2_26_5_, position7_.POSITIONCODE as POSITION3_26_5_, position7_.POSITIONTYPE as POSITION4_26_5_, position7_.POSITIONLEVEL as POSITION5_26_5_, position7_.DISPLAYORDER as DISPLAYO6_26_5_, position7_.DESCN as DESCN26_5_, position7_.DELFLAG as DELFLAG26_5_, position7_.OPERATERCODE as OPERATER9_26_5_, position7_.OPERATETIME as OPERATE10_26_5_ from T_SYS_USER this_ left outer join T_SYS_USERINFO userinfo2_ on this_.USERINFOID=userinfo2_.ID left outer join T_SYS_ORGANIZATION organizati3_ on userinfo2_.ORGID=organizati3_.ID left outer join T_SYS_POSITION position4_ on userinfo2_.MAJORPOSITIONID=position4_.ID left outer join T_SYS_ORGANIZATION organizati5_ on this_.ORGID=organizati5_.ID left outer join T_SYS_ORGANIZATION organizati6_ on this_.MANAGERORGID=organizati6_.ID left outer join T_SYS_POSITION position7_ on this_.MAJORPOSITIONID=position7_.ID where this_.LOGINID=:1
c114w7un6a1p0	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010100000000.11010115000000%') and wsqx.starttime >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where tree path like '11000000000000.11010100000000.11010115000000%') and wsqx.starttime >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:6, 'yyyy-MM-dd hh24:mi') )
c2xqwj779augx	SELECT COUNT(*) as CT from t_ry_wffzryxx w inner join t_ry_saryjbxx s on w.rybh=s.rybh inner join t_aj_xzajfaxx x on x.ajbh=s.ajbh where w.ssajlx = '02' and w.rybh like :1 and w.xbid= :2 and exists(select 1 from t_doc_processinstance ce where ce.status='99' and ce.instcode=w.rybh and ce.processcode in ('CQXZJL', 'CQXZJLBCFK', 'JXPWSPB', 'CQFK', 'CQBYCF', 'CQJLBGS', 'CQJCBGS', 'CQQBHSBGS', 'CQDBBGS', 'CQJG', 'CQJSJZBGS', 'CQCHBGS', 'CQCHSPB'))
c7ccjdyj6d9zg	select * from ( select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) order by operatetime desc ) where rownum <= :5
c82grr33a4fkt	select * from ( select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) order by operatetime desc ) where rownum <= :5
cfyvvt5uswdtc	SELECT COUNT(*) as CT from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.barmc like :1 and j.jbsj >= to_Date(:2 , 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:3 , 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:4 or j.cbdw = :5 )
cjd2u4na08gyx	SELECT COUNT(*) as CT FROM (select distinct wtjl0_.ID as ID248_, wtjl0_.DATAVERSION as DATAVERS2_248_, wtjl0_.INSTANCEID as INSTANCEID248_, wtjl0_.AJBH as AJBH248_, wtjl0_.AJMC as AJMC248_, wtjl0_.AJLXID as AJLXID248_, wtjl0_.JCLXID as JCLXID248_, wtjl0_.ZXJCMC as ZXJCMC248_, wtjl0_.JCDWCJID as JCDWCJID248_, wtjl0_.ZFJCDWID as ZFJCDWID248_, wtjl0_.ZFJCDWMC as ZFJCDWMC248_, wtjl0_.ZFJCSJ as ZFJCSJ248_, wtjl0_.ZFJCMJZH as ZFJCMJZH248_, wtjl0_.ZFJCMJXM as ZFJCMJXM248_, wtjl0_.ZRHJID as ZRHJID248_, wtjl0_.ZRDWID as ZRDWID248_, wtjl0_.BAMJDWID as BAMJDWID248_, wtjl0_.BADWMC as BADWMC248_, wtjl0_.LRR as LRR248_, wtjl0_.LRRZH as LRRZH248_, wtjl0_.LRDWID as LRDWID248_, wtjl0_.LRRQ as LRRQ248_, wtjl0_.SFCQJCCSID as SFCQJCCSID248_, wtjl0_.DELFLAG as DELFLAG248_, wtjl0_.OPERATERCODE as OPERATE25_248_, wtjl0_.OPERATETIME as OPERATE26_248_, wtjl0_.ORGID as ORGID248_, wtjl0_.DQBAZBH as DQBAZBH248_, wtjl0_.SSAJLX as SSAJLX248_, wtjl0_.BJCDWID as BJCDWID248_, wtjl0_.BJCDWMC as BJCDWMC248_, wtjl0_.GLDXBH as GLDXBH248_, wtjl0_.SFZGID as SFZGID248_ from T_ZFJD_WTJL wtjl0_, T_ZFJD_LCWTDY lcwtdy1_ where wtjl0_.ID=lcwtdy1_.WTJLID and (wtjl0_.AJBH like :1))
cpz6u0qgb76s7	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1 ) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr , null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3 ) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) ) ) )
ctq5vx3dp12ns	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus in ('02', '03', '04', '05') ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010577000000%') and wsqx.kjsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:5, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di w here di.id = wsqx.docid and di.docstatus in ('02', '03', '04', '05') ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010577000000%') and wsqx.kjsj >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:8, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:10, 'yyyy-MM-dd hh24:mi') )
cu86a4hc34r0u	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.starttime >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.starttime >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:6, 'yyyy-MM-dd hh24:mi') )
cwu035m3pkksd	select position1_.ID as ID26_, position1_.POSITIONNAME as POSITION2_26_, position1_.POSITIONCODE as POSITION3_26_, position1_.POSITIONTYPE as POSITION4_26_, position1_.POSITIONLEVEL as POSITION5_26_, position1_.DISPLAYORDER as DISPLAYO6_26_, position1_.DESCN as DESCN26_, position1_.DELFLAG as DELFLAG26_, position1_.OPERATERCODE as OPERATER9_26_, position1_.OPERATETIME as OPERATE10_26_ from T_SYS_USER user0_ inner join T_SYS_POSITION position1_ on user0_.MAJORPOSITIONID=position1_.ID where user0_.LOGINID=:1
cxrfnxaw0j27m	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.mbmc = :2 and wsqx.kjsj >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:4, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :5 and wsqx.cqdx not in ('05', '06') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.mbmc = :6 and wsqx.kjsj >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:8, 'yyyy-MM-dd hh 24:mi') )
cy6yd36bj51tc	select * from ( select j.jcjbh, j.id, j.barmc, j.badwmc, j.jbsj, j.fynr , j.ajlyid , j.sazt, j.cbr, (case when gl.cljg is null then j.cljg else gl.cljg end) cljg, j.bjlxid, gl.asjbh, j.jjlxbj, gl.clsj, gl.INSTID from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.jbsj >= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:3 or j.cbdw = :4 ) order by j.jbsj desc ) where rownum <= :5
d5apn1u65txgu	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010543000000%') and wsqx.starttime >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010543000000%') and wsqx.starttime >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:6, 'yyyy-MM-dd hh24:mi') )
d6x5a98yqhf2r	update T_AJ_JJDJ set DATAVERSION=:1 , JCJBH=:2 , AJLYID=:3 , JBSJ=:4 , JBDWID=:5 , JBR=:6 , ASJFSSJ=:7 , ASJJSSJ=:8 , ASJFSDDID=:9 , ASJFSXZ=:10 , FYNR=:11 , SSPCSID=:12 , BJLXID=:13 , FXSJ=:14 , AJLBID=:15 , CZYJ=:16 , CZJGID=:17 , CZDWID=:18 , CZR=:19 , CZPZR=:20 , ASJLXID=:21 , JTCZQK=:22 , JZSYRS=:23 , JZQZRS=:24 , LZSCRS=:25 , JJBGFNRS=:26 , JJBGETRS=:27 , JHXXRS=:28 , SWRS=:29 , SSRS=:30 , JTSGZJJJSSJE=:31 , CDJDCCC=:32 , CDCZCS=:33 , CDJLRS=:34 , SARYGJID=:35 , QHGXID=:36 , XYRS=:37 , LRDWID=:38 , LRR=:39 , LRRQ=:40 , DELFLAG=:41 , OPERATETIME=:42 , OPERATERCODE=:43 , ORGID=:44 , JJLXBJ=:45 , BJSJ=:46 , LRRZH=:47 , YJJSDW=:48 , YJYY=:49 , YJCBR=:50 , YJPZR=:51 , FXXS=:52 , JBDH=:53 , BJDH=:54 , CJRY=:55 , BLMJXM=:56 , BLMJZH=:57 , BADW=:58 , SAJE=:59 , SAZH=:60 , SFSW=:61 , TDAJLX=:62 , CPH=:63 , JBJB=:64 , LDPS=:65 , LHDW=:66 , YWH=:67 , ZBDW=:68 , DBDW=:69 , JBDW=:70 , DBLDXM=:71 , DBLDZH=:72 , DBRZH=:73 , DBRXM=:74 , ZJSJ=:75 , CBDW=:76 , CBR=:77 , CBRZH=:78 , CLJG=:79 , CZFS=:80 , SAZT=:81 , JJCL=:82 , JBRZH=:83 , CZRZH=:84 , CZPZRZH=:85 , YJCBRZH=:86 , YJPZRZH=:87 , HBDW=:88 , HBRZH=:89 , HBRXM=:90 , YJBS=:91 , YJJSRQ=:92 , YJRQ=:93 , YJDW=:94 , ZJLX=:95 , BARMC=:96 , BADWMC=:97 , JJCLCSFLG=:98 , INSTID=:99 , SFYCLID=:100 where ID=:101 and DATAVERSION=:102
dcj65grydpwbj	insert into T_DOC_WSYZDY (DATAVERSION, INSTANCEID, DOCID, TEMPID, GJZ, YZMC, QFZ, OPERATERCODE, ORGID, OPERATETIME, DELFLAG, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
dnrh7cvzm15ww	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1 ) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr , null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3 ) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%?%' ) ) ) )
dqbhc9r7gz0a5	SELECT DECODE(COUNT(CLIENT_INFO), 0, 'down', 'up') FROM GV$SESSION WHERE CLIENT_INFO = :B1
dwypdxsjg4juq	select /*+ index_ss(obj$ i_obj2) */ obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
f015a8zk9z8n3	select max(docnumber0_.DOCSEQ) as col_0_0_ from T_DOC_DOCNUMBER docnumber0_ where docnumber0_.TEMPLATEID=:1 and (docnumber0_.AUTHORITYCODE=:2 or docnumber0_.AUTHORITYCODE is null) and docnumber0_.YEARCODE=:3
f1z56yaqygprh	select * from ( select row_.*, rownum rownum_ from ( select * from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010554000000%') and wsqx.kjsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and wsqx.gsdw in (select orgcode from t_sys_organization where treepath like '11000000000000.11010500000000.11010554000000%') and wsqx.kjsj >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:6, 'yyyy-MM-dd hh24:mi ') ) ) row_ where rownum <= :7) where rownum_ > :8
f3g84j69n0tjh	select col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc
f60z338yacgab	SELECT COUNT(*) as CT FROM (select distinct jj.jcjbh, '' as dxmc, jj.badw, jj.cbr, jj.asjlxid, jj.id, jj.jjlxbj, jj.lrrq from t_aj_jjdj jj where 1=1 and (jj.jbrzh=:1 or jj.cbrzh=:2)and exists (select 1 from t_ry_jjryxx trj where trj.jcjbh=jj.jcjbh and trj.xm like :3) )
f7nj6dhzuhzft	select * from ( select row_.*, rownum rownum_ from ( select * from ( select distinct xsajfaxx.ajbh, xsajfaxx.ajmc, xsajfaxx.zabid, xsajfaxx.cbdw, xsajfaxx.ajhj, xsajfaxx.ajlxid , max(PROCESSINSTANCE.operatetime) as operatetime from T_DOC_PROCESSINSTANCE PROCESSINSTANCE inner join T_DOC_PROCESSINSTANCEEX PROCESSINSTANCEEX on PROCESSINSTANCE.Id = PROCESSINSTANCEEX.PROCESSINSTANCEID inner join t_aj_xsajfaxx xsajfaxx on xsajfaxx.ajbh = PROCESSINSTANCEEX.Exvalue and PROCESSINSTANCEEX.EXKEY = 'AJBH' where PROCESSINSTANCE.ownertype = '03' and xsajfaxx.ajzt!='2904' and PROCESSINSTANCE.status = '02' and PROCESSINSTANCE.id not in (select ex.processInstanceid from T_DOC_PROCESSINSTANCEEX ex where ex.exkey = 'SSAJBH' and ex.processInstanceid = PROCESSINSTANCEEX.PROCESSINSTANCEID ) and PROCESSINSTANCE.Ownorg in (SELECT a.id FROM t_sys_organization a, t_sys_organization b , t_sys_organization c WHERE b.orgcode = :1 and a.orgcode like :2 and c.orgcode like :3 and a.busiarea <> '700' and ((b.directlyunderflag='0' and a.orglevel = 3 ) or ( b.directlyunderflag='1' and b.busiarea = '400' and c.busiarea<>'400' and c.orglevel = 2 and a.orglevel = 3 ) or ( b.directlyunderflag='1' and b.busiarea != '400' and a.orglevel = 2 ) or ( b.directlyunderflag='1' and b.busiarea = '400' and c.busiarea='400' and a.orglevel = 2 ) )) group by xsajfaxx.ajbh, xsajfaxx.ajmc, xsajfaxx.zabid, xsajfaxx.cbdw, xsajfaxx.ajhj, xsajfaxx.ajlxid ) order by operatetim e desc ) row_ where rownum <= :4) where rownum_ > :5
f8pavn1bvsj7t	select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
fawgwfjzcbdzn	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1 ) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%??%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%??%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.ysc br, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3 ) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%??%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%??%' ) ) ) )
fnbzzfm49d7qh	SELECT COUNT(*) as CT from T_AJ_JJDJ j where j.jjlxbj is null and j.sazt in ('1100', '2110', '2120', '3140', '3150') and j.cljg !='02' and j.blmjzh = :1
fw5dncbpz9atf	SELECT COUNT(*) as CT from T_AJ_JJDJ j where j.jjlxbj is null and j.sazt in ('1100', '2110', '2120', '3140', '3150') and j.cljg !='02' and j.blmjzh = :1
fzj55hwumfpbp	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010883000000%') and wsqx.mbmc = :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.status = :5 union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010883000000%') and wsqx.mbmc = :7 and wsqx.starttime >= to_Date(:8, 'yyyy-MM-dd hh24:m i') and wsqx.starttime<= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.status = :10 )
g24n1mx0kfuwu	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where treepath like '11000000000000.11010800000000.11010895000000%') and wsqx.starttime >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:3, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :4 and wsqx.cqdx not in ('05', '06') and exists (select 1 from t_doc_docinstance di where di.id = wsqx.docid and di.docstatus = '00' ) and wsqx.loginorgcode in (select orgcode from t_sys_organization where tree path like '11000000000000.11010800000000.11010895000000%') and wsqx.starttime >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:6, 'yyyy-MM-dd hh24:mi') )
g3xxadnnbau2q	SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.ysc br, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) )
gxx2cdsqacrn9	SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.username like :2 and wsqx.starttime >= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:4, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :5 and wsqx.cqdx not in ('05', '06') and wsqx.username like :6 and wsqx.starttime >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:8, 'yyyy-MM-dd hh24:mi') )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats