WORKLOAD REPOSITORY report for

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

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

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	19415	08-Dec-13 00:00:06	132	8.1
End Snap:	19439	09-Dec-13 00:00:10	116	7.3
Elapsed:		1,440.07 (mins)
DB Time:		2,966.45 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	9,728M	9,728M	Std Block Size:	8K
Shared Pool Size:	2,432M	2,432M	Log Buffer:	52,580K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.1	0.9	0.02	0.02
DB CPU(s):	0.7	0.3	0.01	0.01
Redo size:	45,195.6	20,684.8
Logical reads:	96,102.5	43,983.4
Block changes:	178.0	81.5
Physical reads:	2,505.9	1,146.9
Physical writes:	12.1	5.5
User calls:	133.1	60.9
Parses:	24.2	11.1
Hard parses:	1.0	0.5
W/A MB processed:	5,138,403.8	2,351,705.4
Logons:	0.3	0.1
Executes:	99.3	45.4
Rollbacks:	0.2	0.1
Transactions:	2.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.91	Redo NoWait %:	100.00
Buffer Hit %:	99.42	In-memory Sort %:	100.00
Library Hit %:	88.68	Soft Parse %:	95.78
Execute to Parse %:	75.59	Latch Hit %:	98.08
Parse CPU to Parse Elapsd %:	0.00	% Non-Parse CPU:	99.67

Shared Pool Statistics

	Begin	End
Memory Usage %:	65.04	66.12
% SQL with executions>1:	78.40	75.54
% Memory for SQL w/exec>1:	83.76	81.68

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.20	1.38	2.5	0.6	1.9	96.9

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
2.4	77.8	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	62,720.0	62,720.0
SGA use (MB):	20,224.0	20,224.0
PGA use (MB):	779.6	730.1
% Host Mem used for SGA+PGA:	33.49	33.49

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	54.38	24.89
Global Cache blocks served:	8.36	3.83
GCS/GES messages received:	75.39	34.50
GCS/GES messages sent:	193.22	88.43
DBWR Fusion writes:	0.52	0.24
Estd Interconnect traffic (KB)	554.40

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

Buffer access - local cache %:	99.37
Buffer access - remote cache %:	0.06
Buffer access - disk %:	0.58

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.6
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.0
Avg global cache cr block flush time (ms):	4.3
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 %:	1.6
Avg global cache current block flush time (ms):	2.7

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.6
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	39.03
% of indirect sent messages:	60.60
% of flow controlled messages:	0.37

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): 177986.9s
• 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.4% of Total DB time 177,986.92 (s)
• Total FG Wait Time: 112,524.21 (s) DB CPU time: 64,366.02 (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): 177,987
• Captured SQL account for 81.3% of Total
• Total DB Time (s): 177,987
• 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): 64,366
• Captured SQL account for 81.2% of Total
• Total CPU Time (s): 64,366
• 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: 8,303,633,779
• Captured SQL account for 87.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 216,519,363
• Captured SQL account for 89.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 8,575,999
• Captured SQL account for 27.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 2,093,794
• Captured SQL account for 45.9% 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): 7,336
• Captured Segments account for 80.7% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
05rff3mapgk7u	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 xs.ajmc like :2 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 = :3 ) and xs.ajmc like :4 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 = :5) and xz. ajmc like :6 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 = :7 ) and xz.ajmc like :8 ) )
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)
0n4au49czfqra	update BJCICBB.T_INFO_CRIMINALBASEINFOR@BJCIC tardata set (PEOPLENO, NAME, SEXID, BIRTHDAY, AGE, NICKNAME, EDUCATIONLEVELID, STATUSID, SPECIALSTATUSID, POLITICALAPPEARANCEID, RACEID, NATIONALITYID, HOUSINGREASONID, DEPARTMENT, DUTYID, REGISTEREDADDRESSID, DETAILADDRESS, JAILNO, PRESENTADDRESSID, PRESENTDETAILADDRESS, HOUSINGPOLICESID, ABODETYPEID, DEADREASONID, DEADDATE, CRIMINALTYPEID, CRIMINALSITUATIONID, ISILLPREGNANTID, GATHERREASONID, ISDRUGGERID, STATUREUPPERLIMIT, STATURELOWERLIMIT, PERSONIDENTIFIERID, ACCENTID, BLOODTYPEID, BODILYFORMID, COMPLEXIONID, HAIRSTYLEID, FACESTYLEID, EYEBOWID, EYEID, MOUTHID, NOSEID, LIPID, TOOTHID, CHINID, BEARDID, EARID, ATTIRECHARACTERID, CASETOOLID, CASEMETHODID, CASECHARACTERF, SUPPLYMETHOD, CASETOOLF, SPECIALITYID, CASEREASONID, FINGERPOINTCODE, DISPOSALMETHODID, DISPOSALAREAID, FLEEAREA, DISPOSALDETAILAREA, FIRSTFEAKOUTTIME, FEAKOUTDEGREE, COSTINSTANCE, FEAKOUTINSTANCE, FEAKOUTREASONID, FEAKOUTTYPEID, POSIONSORTID, RESUMETIMES, RESUMEINTERVALID, FEAKOUTRESULTID, MAININCOMEFORMID, FEAKOUTPLACE, SUSPICIONNO, FEAKOUTENVIRONMENTID, DNANO, ECONOMYSTATUS, MOBILE, TEL, RESUME, REMARK, ENGLISHNAME, PAPERKINDID, PAPERNUMBER, VISAKINDID, VISADEADTIMES, ENTERPORTID, ENTERTIME, SUBJECTPOLICESID, VISADEADTIMEE, DELFLAG, OPERATETIME, OPERATERID, CHOOSEPARTID, CHOOSEOBJECTID, CHOOSELACATIONID, CASECHARACTERID, OTHERPART, NATIVEPLACEID, ISTRANSFER, CASEDIFLABOR, ISTEMPREGID, TEMPREGNUM, TEMPREGDEPID, RECORDEPTID, RECORDER, RECORDDATE, FRIMPEOPLENO, P HOTOID, STATUSOUTID, NAMESPELL, JINGDU, WEIDU, RMK1, RMK2, RMK3, RMK4, RMK5, LJLGLS, RYZT, SQ, ARRESTDATE, ARRESTDEPARTMENTID, DATALEVEL, ISSECRECY, WORKTYPEID, LJSJ, CID) = (select RYBH, SUBSTRB(XM, 1, 52), XBID, to_char(CSRQ, 'yyyymmdd'), NL, BM, BJCICBB.transCode@BJCIC('WHCD', JYCDID), SFID, BJCICBB.transCode@BJCIC('TSSF', TSSFID), BJCICBB.transCode@BJCIC('ZZMM', ZZMMID), MZID, GJID, BJCICBB.transCode@BJCIC('JLYY', JLYYID), GZDW, BJCICBB.transCode@BJCIC('ZW', ZWID), HJDID, HJDXZ, RSBH, ZZDID, ZZDXZ, BJCICBB.transCode@BJCIC('SSPCS', JZDSSPCSID), JSLXID, SWYYID, to_char(SWRQ, 'yyyymmdd'), AFLXID, AFZKID, SFBCY, CJYYID, SFXD, SGSX, SGXX, RYBS, KYID, XXID, BJCICBB.transCode@BJCIC('TMTZ', TXID), BJCICBB.transCode@BJCIC('TMTZ', FSID), BJCICBB.transCode@BJCIC('TMTZ', FXID), BJCICBB.transCode@BJCIC('TMTZ', NXID), BJCICBB.transCode@BJCIC('TMTZ', MID), BJCICBB.transCode@BJCIC('TMTZ', YID), BJCICBB.transCode@BJCIC('TMTZ', ZID), BJCICBB.transCode@BJCIC('TMTZ', BID), BJCICBB.transCode@BJCIC('TMTZ', CID), BJCICBB.transCode@BJCIC('TMTZ', YAID), BJCICBB.transCode@BJCIC('TMTZ', XBAID), BJCICBB.transCode@BJCIC('TMTZ', HXID), BJCICBB.transCode@BJCIC('TMTZ', ERID), BJCICBB.transCode@BJCIC('TMTZ', QTTMTZID), ZAGJID, BJCICBB.transCode@BJCIC('ZASD', ZASDID), ZATD1, BCSD, ZAGJ1, TSZCID, ZAYYID, ZWM, XZFFID, XZQYID, LCQY, XZDQXZ, to_char(to_date(SCXDSJ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), DYCD, HFQK, XSQK, XDYYID, XDFSID, DPZLID, FXCS, FXJGID, XSHGID, ZYJJLYID, XSDD, XYBH, XSHJID, DNAID, JJZK, SJ1, ZJ2, JL, BZ, YWM, BJCICBB.transCode@BJCIC('ZJZL', QTZJZL), QTZJHM, QZZLID, to_char(to_date(QZYXQKS, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmdd'), RJKAID, to_char(to_date(RJSJ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('SSPCS', SSPCS), to_char(to_date(QZYXQJZ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmdd'), 'U', CAST(OPERATETIME AS DATE), BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), SUBSTRB(XZBWID, 1, 20), XZDXID, BJCICBB.transCode@BJCIC('XZCS', XZCSID), ZATDID, QTBW, JGID, SFYJ, ZAFG, SFBLZZZ, ZZZHM, BJCICBB.transCode@BJCIC('ZZJG', ZZZBLDWID), BJCICBB.transCode@BJCIC('ZZJG', LRDWID), SUBSTRB(LRR, 1, 32), to_char(LRRQ, 'yyyymmdd'), case when RDRYBH is null then 'R' else RDRYBH end, FILEID, SWSFID, SUBSTRB(XMPYM, 1, 32), JD, WD, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5, LJLGLS, RYZT, SQ, to_char(JHRQ, 'yyyymmdd'), BJCICBB.transCode@BJCIC('ZZJG', JHDWID), BJCICBB.transCode@BJCIC('BMJB', BMJB), SFBM, ZAFGID, LJSJ, case when ZJZLID='111' then ZJHM else '' end from (select wfry.*, flmap.FILEID from T_RY_WFFZRYXX wfry left join T_TB_UPLOADFILESMAP flmap on wfry.ZPID=flmap.DATAID) srcdata where srcdata.RYBH = tardata.PEOPLENO) where exists(select 1 from BJCICBB.T_TB_TBHC@BJCIC tbhc where tbhc.TABMAPID='WFFZRYXXTAB0001' and tbhc.DELFLAG='U' and tbhc.BUSINO0 = tardata.PEOPLENO)
0njuzwx3kctc8	insert into BJCICBB.T_INFO_COIN@BJCIC(ID, GOODSID, GOODSNO, GOODSNAME, CLASSID, COINTYPEID, COINVALUEID, SUM, VALUE, COPEID, COPETIME, REMARK, DELFLAG, OPERATETIME, OPERATERID, ORGID, CASENO, CASEID, RECORDEPTID, RECORDDATE, RECORDER, RECORDERNO) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, -1, WPBH, WPMC, WPFLID, BZID, MZID, ZS, JZ, WPCLID, to_char(CLSJ, 'yyyymmddhh24mi'), BZ, 'A', CAST(OPERATETIME AS DATE), BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), BJCICBB.transCode@BJCIC('ORGID', ORGID), AJBH, -1, BJCICBB.transCode@BJCIC('ZZJG', LRDW), to_char(LRRQ, 'yyyymmdd'), SUBSTRB(LRR, 1, 32), BJCICBB.transCode@BJCIC('ZZYZH', LRRZH) from T_WP_HBXX srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='HBXXTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
0t59avy4jt8cp	SELECT * FROM H_SJ_JFBL WHERE operatetime >=:1 and delflag='D'
0zgzx646gx1zr	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 '%???%' ) ) ) )
15kztv7pmduxv	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)
1g05cyddhjh93	select * from ( select j.jcjbh, j.id, j.barmc, j.badwmc, j.jbsj, j.fynr , j.ajlyid , j.sazt, j.cbrzh, j.cljg, j.bjlxid, j.jbr, j.cbr, j.blmjzh, j.jjlxbj, j.instid 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.jbsj >= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and j.blmjzh =:3 order by j.jbsj desc ) where rownum <= :4
1n9rx4st6xwmf	insert into BJCICBB.T_INFO_PUNISHMENTINFOR@BJCIC(ID, PEOPLENO, OPERATETIME, DELFLAG, ORGID, SHAREID, TIME, TREATMENTDEPARTMENTID, IDTYPE, TREATMENTFORMID, EXPLANAION) select ORADATAID, RYBH, CAST(OPERATETIME AS DATE), 'A', BJCICBB.transCode@BJCIC('ORGID', ORGID), -1, to_char(PZSJ, 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('ZZJG', ZXDW), 'crim', BJCICBB.transCode@BJCIC('RYCLFS', CLJD), SUBSTRB(JTQK, 1, 1000) from (select rycl.*, tbhc.ORADATAID from T_RY_RYCLXX rycl left join T_TB_TBHC tbhc on rycl.ID=tbhc.DATAID) srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='RYCLXXTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
1nqzd7xqqn3v7	SELECT * FROM H_AJ_JJDJ WHERE operatetime >=:1 and delflag='D' order by operatetime asc
1pnmwm33adsay	insert into T_DOC_WSQX (DATAVERSION, ASJBH, DXBH, DXLX, PROID, DOCID, TEMID, CQLX, CQDX, WSLX, CZLX, DWID, TREEPATH, GDID, OPERATERCODE, OPERATETIME, DELFLAG, ORGID, DOCNUMBERCODE, DOCNUM, DXMC, MBCODE, MBMC, PROCESSCODE, STATUS, OWNER, STARTTIME, ENDER, ENDTIME, FEATURENAME, USERNAME, LOGINORGCODE, LOGINORGNAME, GSDW, KJRNAME, KJSJ, TEMPLATEATTR, RELATIONTYPE, ID) 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, :37, :38, :39)
1qg27cput4c46	SELECT * FROM T_DOC_DOCNUMBER WHERE operatetime >=:1 order by operatetime asc
1whqjdyh7b383	select 'T_AJBL_BLGL' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_AJBL_BLGL union select 'T_AJ_XSAJPAXX' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_AJ_XSAJPAXX union select 'T_AJ_XSAJRYDY' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_AJ_XSAJRYDY union select 'T_AJ_XZAJFAXX' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_AJ_XZAJFAXX union select 'T_AJ_XZAJRYDY' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_AJ_XZAJRYDY union select 'T_DC_BADD' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_DC_BADD union select 'T_DC_BBXX' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_DC_BBXX union select 'T_RY_RYZPDY' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_RY_RYZPDY union select 'T_RY_SATHSD' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_RY_SATHSD union select 'T_RY_SATXL' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_RY_SATXL union select 'T_RY_WFFZRYXX' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_RY_WFFZRYXX union select 'T_RY_ZHXX' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_RY_ZHXX union select 'T_SJ_DSWP' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_SJ_DS WP union select 'T_SJ_JSWP' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_SJ_JSWP union select 'T_SJ_JSWPBL' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_SJ_JSWPBL union select 'T_SJ_QY' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_SJ_QY union select 'T_SJ_QYSJBL' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_SJ_QYSJBL union select 'T_SJ_SJZPDYB' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_SJ_SJZPDYB union select 'T_SJ_SZRY' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_SJ_SZRY union select 'T_WP_QTWP' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_WP_QTWP union select 'T_WP_SDWPXX' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_WP_SDWPXX union select 'T_WP_WPJBXX' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_WP_WPJBXX union select 'T_WP_ZDWPXX' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_WP_ZDWPXX union select 'T_WP_ZDXX' as src_tablename , max(operatetime) as src_maxtime, sysdate as src_sjc from T_WP_ZDXX
1wy8ya7qb538s	SELECT COUNT(*) as CT FROM (select distinct j.jcjbh, j.barmc, j.ajlyid, j.jbsj, j.cbr, j.fynr, j.cbdw, j.asjlxid, j.id, j.jjlxbj from T_AJ_JJDJ j where ((j.sazt='2200' and j.cljg='03') or (j.sazt='1102' and j.cljg='06') or (j.sazt='2200' and j.cljg='05') or (j.sazt='3200' and j.cljg='04') or j.sazt='1101' or j.cljg in('02', '07') or (j.sazt='3110' and j.cljg='04') or (j.sazt='3120' and j.cljg='04')) and (j.jbdwid =:1 or j.cbdw = :2 ) and exists (select 1 from t_ry_jjryxx ry where ry.jcjbh = j.jcjbh and ry.rylx = :3) )
1x96k9p3bby9m	select count(1) as recordCount, max(operateTime) lastUpTime from T_CODE_MAP srcdata0 where operateTime > :1 and operateTime <= :2
1yj7jcwch3a8c	insert into BJCICBB.T_INFO_CASETREATMENT@BJCIC(ID, TREATMENTTIME, CASETREATMENTID, CASESTATUSID, TREATMENTDEPTID, TREATMENTER, APPROVALER, RECEIVEDEPTID, OPINION, DELFLAG, ORGID, OPERATERID, OPERATETIME, CASID, CASNO, CLASSTYPE, REASONID, ORDERR, OPERATERNAME) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, to_char(CLYJSJ, 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('AJCL', AJCLID), BJCICBB.transCode@BJCIC('AJHJ', AJHJ), BJCICBB.transCode@BJCIC('ZZJG', CLDWID), CLR, PZR, BJCICBB.transCode@BJCIC('ZZJG', JSDWID), CLYJYY, 'A', BJCICBB.transCode@BJCIC('ORGID', ORGID), BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), CAST(OPERATETIME AS DATE), -1, AJBH, BJCICBB.transCode@BJCIC('AJCLGLLX', AJHJ), BJCICBB.transCode@BJCIC('BLYY', BLYY), CAST(CLSX AS VARCHAR2(10)), ' ' from T_AJ_AJCL srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='AJCLTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
1zryzr08mjswb	select count(*) from (select distinct(ssajbh), ssajmc, ssajlx, ssr, ssdw, ssrq, OPERATETIME from (select s.ssajbh, s.ssajmc, s.ssajlx, s.ssr, s.ssdw, s.ssrq, s.OPERATETIME from T_AJ_SSAJXX s inner join T_AJ_SSAJRYDY ry on s.ssajbh=ry.ssajbh inner join T_RY_WFFZRYXX w on ry.rybh=w.rybh inner join T_DOC_PROCESSINSTANCE p on p.id=w.dqty inner join T_SYS_ORGANIZATION o on o.id=p.OWNORG where w.sczt='09' and p.OWNERTYPE='03' and o.TREEPATH=SUBSTR(:1, 0, LENGTH(o.TREEPATH)) ) )
20pvcq79u8ht6	SELECT COUNT(*) as CT FROM (select distinct j.jcjbh, j.barmc, j.ajlyid, j.jbsj, j.cbr, j.fynr, j.cbdw, j.asjlxid, j.id, j.jjlxbj from T_AJ_JJDJ j where ((j.sazt='2200' and j.cljg='03') or (j.sazt='1102' and j.cljg='06') or (j.sazt='2200' and j.cljg='05') or (j.sazt='3200' and j.cljg='04') or j.sazt='1101' or j.cljg in('02', '07') or (j.sazt='3110' and j.cljg='04') or (j.sazt='3120' and j.cljg='04')) and (j.jbdwid =:1 or j.cbdw = :2 ) )
2105wfcbjs16v	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 '%??%' ) ) ) )
21fp9pbyxaaah	select this_.ID as ID2_1_, this_.JOINTIME as JOINTIME2_1_, this_.CRASHTIME as CRASHTIME2_1_, this_.LASTONLINETIME as LASTONLI4_2_1_, this_.APPSYSCODE as APPSYSCODE2_1_, this_.NODECODE as NODECODE2_1_, this_.STATE as STATE2_1_, addresses2_.CACHESYNCNODEID as CACHESYN5_3_, addresses2_.ID as ID3_, addresses2_.CHANNELNAME as CHANNELN4_3_, addresses2_.ID as ID0_0_, addresses2_.MOSTBIT as MOSTBIT0_0_, addresses2_.LEASTBIT as LEASTBIT0_0_, addresses2_.CHANNELNAME as CHANNELN4_0_0_, addresses2_.CACHESYNCNODEID as CACHESYN5_0_0_ from T_MSG_NODE this_ left outer join T_MSG_ADDRESS addresses2_ on this_.ID=addresses2_.CACHESYNCNODEID where this_.NODECODE=:1
2cdp1tnnjb8xf	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 '%???%' ) ) ) )
2d99avpjbtwzp	select this_.ID as ID48_0_, this_.DATAVERSION as DATAVERS2_48_0_, this_.RYID as RYID48_0_, this_.SJID as SJID48_0_, this_.SJBH as SJBH48_0_, this_.RYLX as RYLX48_0_, this_.RYBH as RYBH48_0_, this_.OPERATETIME as OPERATET8_48_0_, this_.DELFLAG as DELFLAG48_0_, this_.OPERATERCODE as OPERATE10_48_0_, this_.ORGID as ORGID48_0_ from T_SJ_SJRYDY this_ where this_.SJBH=:1
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 )
2jcm9aa6nfw31	SELECT COUNT(*) as CT FROM (select distinct ssajbh, ssajmc, ssajlx, ssr, ssdw, ssrq, status, wskjzt, ly, zcdb, xbzt , operatetime from ((select ss.ssajbh, ss.ssajmc, ss.ssajlx, ss.ssr, ss.ssdw, to_char(ss.ssrq, 'yyyy-mm-dd hh24:mi:ss') ssrq, '' as status, '' as wskjzt, 'r' as ly, ce.zcdb, ce.xbzt , max(ce.operatetime) as operatetime from t_doc_processinstance ce, t_doc_processinstanceex ex, t_aj_ssajxx ss, t_aj_ssajrydy dy, t_ry_wffzryxx wf where ce.operatetime < sysdate and ce.operatetime >= sysdate-3 and ce.id = wf.dqty and wf.sczt <> '02' and ce.id = ex.processinstanceid and ce.instancetype in ( '02', '01') and dy.ssajbh = ss.ssajbh and dy.rybh = wf.rybh and ( (ce.status = '02' and ( (ce.ownertype = '01' and ce.owner = :1) or (ce.ownertype = '02' and ce.ownorg = '7259' and ce.ownposition in ('P00008') ) ) ) or (ce.status = '99' and ((ce.ownertype <> '03' and ( (ce.ownertype = '01' and ce.owner = :2) or (ce.ownertype = '02' and ce.ownorg = '7259' and ce.ownposition in ('P00008') ) ) and ( (wf.sazt != '02' and wf.sczt = '05' and ce.wskjzt !='2') or ( wf.sazt = '02' and wf.sczt = '05' and exists (select 1 from t_doc_busiprocess bus where bus.issongan = '1' and ce.processid=bus.id ) and wf.afzkid in ('91', '92', '99') )) ) or (ce.ownertype = '03' and ce.lastactor = :3 and wf.sczt = '09')) ) or ((ce.status = '98' or ce.status = '05') and ( (ce.ownertype = '01' and ce.owner = :4) or (ce.ownertype = '02' and ce.ownorg = '7259' and ce .ownposition in ('P00008') ) ) and ( (ex.exkey!='busiArea' and ce.processcode in ('LDJYCPBG', 'LDJYSWZXCPB', 'CQTZSPB') and ce.wskjzt !='2' and ce.owner = :5) or (ex.exkey='busiArea' and ex.exvalue='400')) )) and ce.zcdb <> '1' group by ss.ssajbh, ss.ssajmc, ss.ssajlx, ss.ssr, ss.ssdw, ss.ssrq, ce.zcdb, ce.xbzt) union (select ss.ssajbh, ss.ssajmc, ss.ssajlx, ss.ssr, ss.ssdw, to_char(ss.ssrq, 'yyyy-mm-dd hh24:mi:ss') ssrq, ce.status, ce.wskjzt, 'a' as ly, ce.zcdb, ce.xbzt , max(ce.operatetime) as operatetime from t_doc_processinstance ce, t_doc_processinstanceex ex, t_aj_ssajxx ss left join t_aj_ssajrydy dy on dy.ssajbh=ss.ssajbh left join t_ry_wffzryxx wf on wf.rybh=dy.rybh where ce.operatetime < sysdate and ce.operatetime >= sysdate-3 and ce.id = ex.processinstanceid and ex.exkey = 'AJBH' and ex.exvalue = ss.ssajbh and ((ce.processcode in ('CQYSAJSPB', 'CQYSAJBGS', 'CQHBBHHB', 'BCZCBGS', 'CQFY', 'HBBHFY', 'WCBHHB', 'CXBHHB') and (ce.status = '02' or (ce.status = '99' and ce.wskjzt != '2'))) or (ce.processcode in ('WCBHHB', 'CXBHHB') and (ce.status = '98' and ce.wskjzt != '2'))) and ( (ce.ownertype = '01' and ce.owner = :6) or (ce.ownertype = '02' and ce.ownorg = '7259' and ce.ownposition in ('P00008') ) ) and ce.zcdb <> '1' group by ss.ssajbh, ss.ssajmc, ss.ssajlx, ss.ssr, ss.ssdw, ss.ssrq, ce.status, ce.wskjzt, ce.zcdb, ce.xbzt ) ) )
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))
2um9fccnkdymu	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 in ('02', '03', '04', '05') ) 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') and wsqx.starttime >= to_Date(:5, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:6, '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 :7 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.mbmc = :8 and wsqx.kjsj >= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:10, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:11, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:12, 'yyyy-MM-dd hh24:mi') )
32f7su0a5y64b	select xsajfaxx0_.ID as ID131_, xsajfaxx0_.DATAVERSION as DATAVERS2_131_, xsajfaxx0_.AJBH as AJBH131_, xsajfaxx0_.AJMC as AJMC131_, xsajfaxx0_.ZABID as ZABID131_, xsajfaxx0_.BCABID as BCABID131_, xsajfaxx0_.AJLXID as AJLXID131_, xsajfaxx0_.SGLXID as SGLXID131_, xsajfaxx0_.SAJBID as SAJBID131_, xsajfaxx0_.ZABSID as ZABSID131_, xsajfaxx0_.ZABS as ZABS131_, xsajfaxx0_.PCSGXID as PCSGXID131_, xsajfaxx0_.ZRQDID as ZRQDID131_, xsajfaxx0_.GSDZ as GSDZ131_, xsajfaxx0_.JQ as JQ131_, xsajfaxx0_.FADDID as FADDID131_, xsajfaxx0_.FADDXZ as FADDXZ131_, xsajfaxx0_.FAKSSJ as FAKSSJ131_, xsajfaxx0_.FAJSSJ as FAJSSJ131_, xsajfaxx0_.FAQYID as FAQYID131_, xsajfaxx0_.FAZ as FAZ131_, xsajfaxx0_.FASJXQ as FASJXQ131_, xsajfaxx0_.FXSJ as FXSJ131_, xsajfaxx0_.FXXSID as FXXSID131_, xsajfaxx0_.XCLXID as XCLXID131_, xsajfaxx0_.JBLXID as JBLXID131_, xsajfaxx0_.JBRZH as JBRZH131_, xsajfaxx0_.JBR as JBR131_, xsajfaxx0_.JBDWID as JBDWID131_, xsajfaxx0_.LASJ as LASJ131_, xsajfaxx0_.LADW as LADW131_, xsajfaxx0_.LAZJZJE as LAZJZJE131_, xsajfaxx0_.LRDW as LRDW131_, xsajfaxx0_.LRRZH as LRRZH131_, xsajfaxx0_.LRR as LRR131_, xsajfaxx0_.LRRQ as LRRQ131_, xsajfaxx0_.AJLYID as AJLYID131_, xsajfaxx0_.JYAQ as JYAQ131_, xsajfaxx0_.JYAQGJZ as JYAQGJZ131_, xsajfaxx0_.SLSJ as SLSJ131_, xsajfaxx0_.SLRZH as SLRZH131_, xsajfaxx0_.SLR as SLR131_, xsajfaxx0_.SLFSID as SLFSID131_, xsajfaxx0_.SLBMID as SLBMID131_, xsajfaxx0_.XBBMID as XBBMID131_, xsajfaxx0_.CLSJ as CLSJ131_, xsajfaxx0_ .CLDW as CLDW131_, xsajfaxx0_.SJCLF as SJCLF131_, xsajfaxx0_.SSZJZJE as SSZJZJE131_, xsajfaxx0_.SAXS as SAXS131_, xsajfaxx0_.ZATDID as ZATDID131_, xsajfaxx0_.BCZATD as BCZATD131_, xsajfaxx0_.ZAGJID as ZAGJID131_, xsajfaxx0_.BCZAGJ as BCZAGJ131_, xsajfaxx0_.SSSDID as SSSDID131_, xsajfaxx0_.BCSSSD as BCSSSD131_, xsajfaxx0_.YBSDID as YBSDID131_, xsajfaxx0_.WZSDID as WZSDID131_, xsajfaxx0_.PQLXID as PQLXID131_, xsajfaxx0_.CCDMID as CCDMID131_, xsajfaxx0_.GSJDID as GSJDID131_, xsajfaxx0_.WBDWID as WBDWID131_, xsajfaxx0_.NBDWID as NBDWID131_, xsajfaxx0_.DBJBID as DBJBID131_, xsajfaxx0_.DBQK as DBQK131_, xsajfaxx0_.JZBZ as JZBZ131_, xsajfaxx0_.YSDW as YSDW131_, xsajfaxx0_.AJCL as AJCL131_, xsajfaxx0_.AJZT as AJZT131_, xsajfaxx0_.JTTQID as JTTQID131_, xsajfaxx0_.TQID as TQID131_, xsajfaxx0_.JHID as JHID131_, xsajfaxx0_.SJID as SJID131_, xsajfaxx0_.RQID as RQID131_, xsajfaxx0_.GJZARS as GJZARS131_, xsajfaxx0_.SFJTZA as SFJTZA131_, xsajfaxx0_.QHQXID as QHQXID131_, xsajfaxx0_.XZCS as XZCS131_, xsajfaxx0_.BCXZCS as BCXZCS131_, xsajfaxx0_.XZBW as XZBW131_, xsajfaxx0_.BCXZBW as BCXZBW131_, xsajfaxx0_.FZZTLXID as FZZTLXID131_, xsajfaxx0_.SWSJGJDQID as SWSJGJDQID131_, xsajfaxx0_.SXRTZMS as SXRTZMS131_, xsajfaxx0_.SFCZF as SFCZF131_, xsajfaxx0_.JD as JD131_, xsajfaxx0_.WD as WD131_, xsajfaxx0_.DQBS as DQBS131_, xsajfaxx0_.BMJB as BMJB131_, xsajfaxx0_.SFBM as SFBM131_, xsajfaxx0_.SQID as SQID131_, xsajfaxx0_.XCLXJTID as XCLXJTID131_, xsajfaxx0_.GJS SGX as GJSSGX131_, xsajfaxx0_.GJQYDM as GJQYDM131_, xsajfaxx0_.SCZ as SCZ131_, xsajfaxx0_.FXZ as FXZ131_, xsajfaxx0_.BZ as BZ131_, xsajfaxx0_.OPERATERCODE as OPERATE98_131_, xsajfaxx0_.OPERATETIME as OPERATE99_131_, xsajfaxx0_.DELFLAG as DELFLAG131_, xsajfaxx0_.ORGID as ORGID131_, xsajfaxx0_.AJDJ as AJDJ131_, xsajfaxx0_.AJGX as AJGX131_, xsajfaxx0_.CBR as CBR131_, xsajfaxx0_.CBRZH as CBRZH131_, xsajfaxx0_.CBDW as CBDW131_, xsajfaxx0_.XBMJ as XBMJ131_, xsajfaxx0_.ZADDXZ as ZADDXZ131_, xsajfaxx0_.AJXZ as AJXZ131_, xsajfaxx0_.LASZ as LASZ131_, xsajfaxx0_.ZAFS as ZAFS131_, xsajfaxx0_.ZAQK as ZAQK131_, xsajfaxx0_.CXID as CXID131_, xsajfaxx0_.JZGLLBQ as JZGLLBQ131_, xsajfaxx0_.JZYWLBQ as JZYWLBQ131_, xsajfaxx0_.SXWZ as SXWZ131_, xsajfaxx0_.SXZH2 as SXZH117_131_, xsajfaxx0_.ZHDSD2 as ZHDSD118_131_, xsajfaxx0_.ZHGSD2 as ZHGSD119_131_, xsajfaxx0_.SXDH2 as SXDH120_131_, xsajfaxx0_.DHGSD2 as DHGSD121_131_, xsajfaxx0_.SXZH as SXZH131_, xsajfaxx0_.ZHDSD as ZHDSD131_, xsajfaxx0_.ZHGSD as ZHGSD131_, xsajfaxx0_.SXDH as SXDH131_, xsajfaxx0_.DHGSD as DHGSD131_, xsajfaxx0_.SXZH3 as SXZH127_131_, xsajfaxx0_.ZHDSD3 as ZHDSD128_131_, xsajfaxx0_.ZHGSD3 as ZHGSD129_131_, xsajfaxx0_.SXDH3 as SXDH130_131_, xsajfaxx0_.DHGSD3 as DHGSD131_131_, xsajfaxx0_.AQSJGJDQ as AQSJGJDQ131_, xsajfaxx0_.SFNWGJAJ as SFNWGJAJ131_, xsajfaxx0_.GJDX as GJDX131_, xsajfaxx0_.ZHAQ as ZHAQ131_, xsajfaxx0_.AJHJ as AJHJ131_, xsajfaxx0_.SAZT as SAZT131_, xsajfaxx0_.SFCZCQZ as SFCZCQZ 131_, xsajfaxx0_.TSAJLX as TSAJLX131_, xsajfaxx0_.SJLYFLG as SJLYFLG131_, xsajfaxx0_.SFXBAJ as SFXBAJ131_, xsajfaxx0_.SFSDAJ as SFSDAJ131_, xsajfaxx0_.cbrlxxx as cbrlxxx131_, xsajfaxx0_.JHZJZ as JHZJZ131_, xsajfaxx0_.YSCBR as YSCBR131_, xsajfaxx0_.YSCBRZH as YSCBRZH131_, xsajfaxx0_.YSXBMJ as YSXBMJ131_, xsajfaxx0_.YSCBDW as YSCBDW131_, xsajfaxx0_.GKZTID as GKZTID131_, xsajfaxx0_.SFHSH as SFHSH131_, xsajfaxx0_.SFWZFD as SFWZFD131_, xsajfaxx0_.jdzl as jdzl131_, xsajfaxx0_.JCDFS as JCDFS131_, xsajfaxx0_.FYFS as FYFS131_ from T_AJ_XSAJFAXX xsajfaxx0_ where xsajfaxx0_.AJZT<>'2904' and xsajfaxx0_.AJBH=:1
39gdx9an0azvy	select approvalre0_.ID as ID207_0_, approvalre0_.INSTANCEID as INSTANCEID207_0_, approvalre0_.OPERATIONTYPE as OPERATIO3_207_0_, approvalre0_.OPERATION as OPERATION207_0_, approvalre0_.OPINION as OPINION207_0_, approvalre0_.APPROVALSTAGE as APPROVAL6_207_0_, approvalre0_.AUDITOR as AUDITOR207_0_, approvalre0_.AUDITTIME as AUDITTIME207_0_, approvalre0_.TARGETORG as TARGETORG207_0_, approvalre0_.TARGETPOSITION as TARGETP10_207_0_, approvalre0_.TARGET as TARGET207_0_, approvalre0_.TARGETTYPE as TARGETTYPE207_0_, approvalre0_.NODE as NODE207_0_, approvalre0_.OPERATERCODE as OPERATE14_207_0_, approvalre0_.OPERATETIME as OPERATE15_207_0_, approvalre0_.DELFLAG as DELFLAG207_0_, approvalre0_.ORGID as ORGID207_0_, approvalre0_.ISMOBILEDEVICE as ISMOBIL18_207_0_, approvalre0_.SPRZW as SPRZW207_0_, approvalre0_.OPERATERIP as OPERATERIP207_0_ from T_DOC_APPROVALRECORD approvalre0_ where approvalre0_.ID=:1
3a90b9fnt4t66	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 '%???%' ) ) ) )
3ag4uvvtjx0q1	SELECT SYS_GUID(), 'WFFZRYXXTAB1001', ROWNUM, "A1"."DATAID", NULL, "A1"."RYBH", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "A1"."OPERATETIME", 'A', NULL, 0 FROM (SELECT "A3"."ID" "DATAID", "A3"."RYBH" "RYBH", "A3"."OPERATETIME" "OPERATETIME" FROM "T_RY_WFFZRYXX" "A3", "T_TB_UPLOADFILESMAP" "A2" WHERE "A3"."OPERATETIME">:1 AND "A3"."OPERATETIME"<=:2 AND LENGTHB("A3"."RYBH")=23 AND SUBSTRB("A3"."RYBH", 14, 4)>='2012' AND "A3"."SSAJLX"='01' AND "A3"."ZPID"="A2"."DATAID"(+) AND :3<:4 AND :5>:6 ORDER BY "A3"."OPERATETIME") "A1"
3bapzwvgaxu59	select count(1) from t_doc_processinstance p where p.status in ('99', '98', '05') and p.processcode in ('CQXZJL', 'CQXZJLBCFK') and p.endauditime >= to_date(:1, 'yyyy-mm-dd hh24:mi:ss') and p.endauditime <= to_date(:2, 'yyyy-mm-dd hh24:mi:ss') and p.LOGINORGCODE like :3
3kaq4aprc1c98	SELECT "AJBH", "AJMC", "ZABID", "BCABID", "AJLXID", "SGLXID", "SAJBID", "ZABSID", "ZABS", "PCSGXID", "ZRQDID", "GSDZ", "JQ", "FADDID", "FADDXZ", "FAKSSJ", "FAJSSJ", "FAQYID", "FAZ", "FASJXQ", "FXSJ", "FXXSID", "XCLXID", "JBR", "JBDWID", "LASJ", "LADW", "LAZJZJE", "LRDW", "LRRZH", "LRR", "LRRQ", "AJLYID", "JYAQ", "JYAQGJZ", "SLSJ", "SLR", "SLFSID", "SLBMID", "XBBMID", "CLSJ", "CLDW", "SJCLF", "SSZJZJE", "SAXS", "ZATDID", "BCZATD", "ZAGJID", "BCZAGJ", "SSSDID", "BCSSSD", "YBSDID", "WZSDID", "PQLXID", "CCDMID", "GSJDID", "WBDWID", "NBDWID", "DBJBID", "DBQK", "JZBZ", "YSDW", "AJCL", "JTTQID", "TQID", "JHID", "SJID", "RQID", "GJZARS", "SFJTZA", "QHQXID", "XZCS", "BCXZCS", "XZBW", "BCXZBW", "FZZTLXID", "SWSJGJDQID", "SXRTZMS", "SFCZF", "JD", "WD", "DQBS", "BMJB", "SFBM", "SQID", "XCLXJTID", "GJSSGX", "GJQYDM", "SCZ", "FXZ", "BZ", "OPERATERCODE", "OPERATETIME", "SXWZ", "SXZH", "ZHDSD", "ZHGSD", "SXDH", "DHGSD", "AJHJ" FROM "T_AJ_XSAJFAXX" "A3" WHERE "AJBH"=:1
3kx8tfmsm2bz7	select * from ( select wsgd0_.ID as ID207_, wsgd0_.DATAVERSION as DATAVERS2_207_, wsgd0_.ASJBH as ASJBH207_, wsgd0_.DXBH as DXBH207_, wsgd0_.DXLX as DXLX207_, wsgd0_.PROID as PROID207_, wsgd0_.DOCID as DOCID207_, wsgd0_.CQLX as CQLX207_, wsgd0_.CQDX as CQDX207_, wsgd0_.CZLX as CZLX207_, wsgd0_.DWID as DWID207_, wsgd0_.TREEPATH as TREEPATH207_, wsgd0_.OPERATERCODE as OPERATE13_207_, wsgd0_.OPERATETIME as OPERATE14_207_, wsgd0_.DELFLAG as DELFLAG207_, wsgd0_.ORGID as ORGID207_ from T_DOC_WSGD wsgd0_ order by operatetime desc ) where rownum <= :1
3mtcrbaxyu7dk	select count(1) as recordCount, max(operateTime) lastUpTime from T_RY_WFFZRYXX srcdata0 where operateTime > :1 and operateTime <= :2 and exists(select 1 from T_AJ_XSAJRYDY srcdata1 where srcdata0.RYBH = srcdata1.RYBH and exists(select 1 from T_AJ_XSAJFAXX srcdata2 where ZABID in ('020703', '020704') and LRRQ>=DATE'2012-07-01' and srcdata1.AJBH = srcdata2.AJBH))
3ut20b3zk0r30	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 '%??%' ) ) ) )
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 ) ) )
4c2js8mp2j5kv	select * from ( select ry.id, ry.rybh, ry.xm, ry.xbid, ry.nl, ry.hjdid, ry.sfyqk, ry.ssajlx, ry.zzm, ry.zay, p.status spjg, p.loginorgname cqdw, p.endauditime pzrq from t_doc_processinstance p inner join t_doc_processinstanceex ex on ex.processinstanceid = p.id inner join t_ry_wffzryxx ry on ry.rybh = ex.exvalue where p.status in ('99', '98', '05') and p.instancetype = '02' and p.processcode = :1 and ex.exkey = 'RYBH' and p.endauditime >= to_date(:2, 'yyyy-mm-dd hh24:mi:ss') and p.endauditime <= to_date(:3, 'yyyy-mm-dd hh24:mi:ss') ) where rownum <= :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
4q554u5ds8pb5	SELECT COUNT(*) as CT FROM (select distinct xz.ajbh, xz.ajmc, xz.cbdw, xz.zbmj, '' as id, '' as bllx, xz.zabid from t_aj_xzajfaxx xz inner join t_doc_wsqx qx on xz.ajbh = qx.asjbh where qx.treepath like '11000000000000.11010800000000.11010850000000%' and xz.ajzt !='3210' )
4u5n85s3u1cgq	select * from ( select ry.rybh, ry.ryxm, ry.rylx, ry.ryzjzl, ry.ryzlhm from t_ry_saryjbxx ry where ry.rylx in ('04', '05') and ry.rybh like :1 ) where rownum <= :2
4um6skz42bnu8	update BJCICBB.T_INFO_CRMNLCS@BJCIC tardata set (REPORTER, REPTSEXID, REPTAGE, REPTIDCARD, REPTTEL, REPTDEPT, REPTLIVID, REPTLIVADDR) = (select SUBSTRB(RYXM, 1, 30), RYXBID, RYNL, case when RYZJZL='111' then SUBSTRB(RYZLHM, 1, 25) else '' end, SUBSTRB(DH, 1, 32), GZDW, BJCICBB.transCode@BJCIC('XZQH', JZDID), SUBSTRB(JZDXZ, 1, 100) from (select sary.ID, sary.AJBH, sary.RYBH, sary.RYXM, sary.RYXBID, sary.RYNL, sary.RYZJZL, sary.RYZLHM, jjry.DH, jjry.GZDW, jjry.JZDID, jjry.JZDXZ, sary.OPERATETIME from T_RY_SARYJBXX sary, T_RY_JJRYXX jjry where sary.RYLX='01' and sary.RYBH=jjry.RYBH) srcdata where srcdata.AJBH = tardata.CASNO and exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='SARYJBXXTAB0001' and tbhc.DELFLAG='U' and tbhc.DATAID=srcdata.ID)) where exists(select 1 from BJCICBB.T_TB_TBHC@BJCIC tbhc where tbhc.TABMAPID='SARYJBXXTAB0001' and tbhc.DELFLAG='U' and tbhc.BUSINO0 = tardata.CASNO)
54rnm81qaxdqb	insert into BJCICBB.T_INFO_OTHERS@BJCIC(ID, GOODSID, GOODSNO, GOODSNAME, CLASSID, NAMEID, PLACE, TYPE, STANDARD, STYLE, COLORID, QUALITYID, QUANTITY, WEIGHT, VALUE, IDENTIFYNO, DELFLAG, OPERATETIME, OPERATERID, ORGID, COPETHINGID, BRAND, TRAIT, COPETIME, CASENO, CASEID, CAPTUREUNIT, CAPTUREDATE, DIVISIONONE, IDENTIFIERONE, DIVISIONTWO, IDENTIFIERTWO, DIVISIONTHREE, IDENTIFIERTHREE, REMARK, RECORDEPTID, RECORDER, RECORDDATE, RECORDERNO, AFFILINO) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, -1, WPBH, PMID, WPFLID, PMID, CD, XH, GG, YS, YSID, CSID, SL, ZL, JZ, WYBSH, 'A', CAST(OPERATETIME AS DATE), BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), BJCICBB.transCode@BJCIC('ORGID', ORGID), WPCLID, PP, TZ, to_char(CLSJ, 'yyyymmddhh24mi'), AJBH, -1, BJCICBB.transCode@BJCIC('ZZJG', JHDW), to_char(JHRQ, 'yyyymmdd'), BJMC1, BJBS1, BJMC2, BJBS2, BJMC3, BJBS3, case when BZ is null then WPMC else WPMC||', '||BZ end, BJCICBB.transCode@BJCIC('ZZJG', LRDW), SUBSTRB(LRR, 1, 32), to_char(LRRQ, 'yyyymmdd'), BJCICBB.transCode@BJCIC('ZZYZH', LRRZH), RDBH from T_WP_QTWP srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='QTWPTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
5mpb1jskj5wk2	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
5n9f14qhj6ah6	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.jbsj >= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and j.blmjzh =:3
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)
5t53hsftu6kg8	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
5trph27vnk67b	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 '%???%' ) ) ) )
61pc1yjkra6x2	insert into BJCICBB.T_INFO_VIOLATEDPEOPLE@BJCIC(ID, VIOLATEDNO, NAME, SEXID, AGE, NATIONALITYID, RACEID, STATUSID, CID, BIRTHDAY, HOUSINGREASONID, ISILLPREGNANTID, TEL, SPECIALSTATUSID, INJURYDEGREEID, INJURYFORMID, INJURYSTARTTIME, INJURYENDTIME, REGISTEREDADDRESSID, DETAILADDRESS, APPEARANCECHARACTER, PRESENTADDRESSID, PRESENTDETAILADDRESS, ATTIRECHARACTERID, COMPANY, DAMAGESPOTID, DAMAGEQUANTITYID, WOUNDMETHOD, CASUALTYREASONID, DESTRUCTIONCORPSE, WOUNDTOOLID, ALIAS, DELFLAG, OPERATETIME, OPERATERID, ORGID, RECORDDATE, RECORDER, NAMESPELL, DATALEVEL, ISSECRECY, LJSJ, RECORDEPTID) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, BQHRBH, SUBSTRB(XM, 1, 30), XBID, NL, GJID, MZID, SFID, case when ZJLX='111' then ZJHM else '' end, to_char(CSRQ, 'yyyymmdd'), BJCICBB.transCode@BJCIC('JLYY', JZYYID), SFBCYID, DH, BJCICBB.transCode@BJCIC('TSSF', TSSFID), SHCDID, SHXSID, to_char(SWSJQ, 'yyyymmddhh24mi'), to_char(SWSJZ, 'yyyymmddhh24mi'), HKSZDID, SUBSTRB(HKCZDXZ, 1, 80), YZTZ, XZDID, XZDXZ, BJCICBB.transCode@BJCIC('TMTZ', TMTZID), GZDW, SSBW, SSSL, ZSSD, ZSYYID, SUBSTRB(HHSTQK, 1, 100), ZSGJID, BM, 'A', CAST(OPERATETIME AS DATE), BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), BJCICBB.transCode@BJCIC('ORGID', ORGID), to_char(LRRQ, 'yyyymmdd'), LRR, SUBSTRB(XMPY, 1, 32), BMJB, SFBM, LJSJID, BJCICBB.transCode@BJCIC('ZZJG', LRDWID) from T_RY_AJBQHRXX srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='AJBQHRXXTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
63qda8fzt22ax	SELECT COUNT(*) as CT from t_aj_xzajfaxx aj where 1=1 and aj.ajzt <> '3210' and aj.slsj >= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and aj.slsj <= 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 = aj.ajbh and org.treepath like :3)
6gajtph8ypzuw	select node0_.NODECODE as col_0_0_ from T_MSG_NODE node0_ where node0_.STATE=:1
6kanqz0f6uhpv	select * from ( select row_.*, rownum rownum_ from ( select 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_ order by yjxxb0_.OPERATETIME ) row_ where rownum <= :1) where rownum_ > :2
6nnux2pfntt05	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 '%?%' ) )) order by operatetime desc ) where rownum <= :3
6nspnbg357amt	insert into BJCICBB.T_INFO_GOODSBASEINFO@BJCIC(ID, GOODSNO, GOODSNAME, GOODSTYPEID, DELFLAG, OPERATETIME, OPERATERID, ORGID, FLAG, CASENO, CASEID, GOODSVALUES, GOODSID, CLASSID, CASETYPE, RMK1, RMK2, DATALEVEL, ISSECRECY, PHOTOID) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, WPBH, SUBSTRB(WPMC, 1, 40), BJCICBB.transCode@BJCIC('WPZL', WPZLID), 'A', CAST(OPERATETIME AS DATE), BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), BJCICBB.transCode@BJCIC('ORGID', ORGID), AJJDBJ, AJBH, -1, WPJZ, -1, WPFLID, BJCICBB.transCode@BJCIC('WPXXAJLX', AJLX), BYZD1, BYZD2, BMJB, SFBM, FILEID from (select wp.*, flmap.FILEID from T_WP_WPJBXX wp left join T_TB_UPLOADFILESMAP flmap on wp.ZPID=flmap.DATAID) srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='WPJBXXTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
6q0xjavcf566c	SELECT id, TEMPLATEID, PROCESSINSTANCEID, DOCSTATUS, DELFLAG, ORGID, OPERATERCODE, OPERATETIME, RELATIONTYPE FROM T_DOC_DOCINSTANCE WHERE operatetime >=:1 order by operatetime asc
7f4fa1zfub225	insert into T_AJGK_DBXX (DATAVERSION, AJBH, AJID, DBZTID, NEWFLAG, ASJLXID, AJZTID, AJCLID, AJMC, JYAQ, CBR, CBRZH, CBDWID, SLSJ, SCSJ, CQID, BZ, CBZBH, CBZID, OPERATERCODE, OPERATETIME, DELFLAG, ORGID, ID) 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)
7ffbqycmf17tw	insert into BJCICBB.T_INFO_SUSPECTPEOINFOR@BJCIC(ID, SUPECTPEOPLENO, NAME, SEXID, BIRTHDAY, AGE, ALIAS, NATIONALITYID, EDUCATIONLEVELID, STATUSID, SPECIALSTATUSID, PLITICALSTATUSID, RACEID, HOUSINGREASONID, DEPARTMENTID, REGISTEREDADDRESSID, DETAILADDRESS, PRESENTADDRESSID, PRESENTDETAILADDRESS, ABODETYPEID, DEADREASONID, DEADDATE, CRIMINALTYPEID, CRIMINALSITUATIONID, ISILLPREGNANTID, GATHERREASONID, ISDRUGGERID, ACCENTID, BLOODTYPEID, BODILYFORMID, COMPLEXIONID, HAIRSTYLEID, FACESTYLEID, EYEBOWID, EYEID, MOUTHID, NOSEID, LIPID, TOOTHID, CHINID, BEARDID, EARID, ATTIRECHARACTERID, CASETOOLID, CASEMETHODID, SPECIALITYID, CASEREASONID, FINGERPOINTCODE, DISPOSALMETHODID, DISPOSALAREAID, FLEEAREAID, FIRSTCASETIME, FEAKOUTDEGREE, COSTINSTANCE, FEAKOUTREASONID, FEAKOUTTYPEID, POSIONSORTID, RESUMETIMES, RESUMEINTERVALID, FEAKOUTRESULTID, MAININCOMEFORMID, FEAKOUTPLACEID, FEAKOUTINSTANCEID, ENGLISHNAME, PAPERKINDID, PAPERNUMBER, VISAKINDID, VISADEADTIMES, ENTERPORTID, ENTERTIME, SUBJECTPOLICESID, VISADEADTIMEE, DELFLAG, OPERATETIME, OPERATERID, ORGID, CHOOSEPARTID, CHOOSEOBJECTID, CHOOOSELOCATIONID, CASECHARACTERID, NATIVEPLACEID, RECORDEPTID, RECORDER, RECORDDATE, PHOTOID, JINGDU, WEIDU, ARRESTTIME, STATUREUPPERLIMIT, STATURELOWERLIMIT, CID) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, REPLACE(RYBH, 'R', 'X'), SUBSTRB(XM, 1, 52), case when XBID is null then '9' else XBID end, to_char(CSRQ, 'yyyymmdd'), NL, BM, GJID, BJCICBB.transCode@BJCIC('WHCD', JYCDID), SFID, BJCICBB.transCode @BJCIC('TSSF', TSSFID), BJCICBB.transCode@BJCIC('ZZMM', ZZMMID), MZID, BJCICBB.transCode@BJCIC('JLYY', JLYYID), GZDW, HJDID, SUBSTRB(HJDXZ, 1, 64), ZZDID, ZZDXZ, JSLXID, SWYYID, to_char(SWRQ, 'yyyymmdd'), AFLXID, AFZKID, SFBCY, CJYYID, SFXD, KYID, XXID, BJCICBB.transCode@BJCIC('TMTZ', TXID), BJCICBB.transCode@BJCIC('TMTZ', FSID), BJCICBB.transCode@BJCIC('TMTZ', FXID), BJCICBB.transCode@BJCIC('TMTZ', NXID), BJCICBB.transCode@BJCIC('TMTZ', MID), BJCICBB.transCode@BJCIC('TMTZ', YID), BJCICBB.transCode@BJCIC('TMTZ', ZID), BJCICBB.transCode@BJCIC('TMTZ', BID), BJCICBB.transCode@BJCIC('TMTZ', CID), BJCICBB.transCode@BJCIC('TMTZ', YAID), BJCICBB.transCode@BJCIC('TMTZ', XBAID), BJCICBB.transCode@BJCIC('TMTZ', HXID), BJCICBB.transCode@BJCIC('TMTZ', ERID), BJCICBB.transCode@BJCIC('TMTZ', QTTMTZID), ZAGJID, BJCICBB.transCode@BJCIC('ZASD', ZASDID), TSZCID, ZAYYID, SUBSTRB(ZWM, 1, 32), XZFFID, XZQYID, SUBSTRB(LCQY, 1, 100), to_char(to_date(SCXDSJ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), DYCD, SUBSTRB(HFQK, 1, 64), XDYYID, XDFSID, DPZLID, FXCS, FXJGID, XSHGID, ZYJJLYID, XSDD, XSHJID, YWM, BJCICBB.transCode@BJCIC('ZJZL', QTZJZL), QTZJHM, QZZLID, to_char(to_date(QZYXQKS, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), RJKAID, to_char(to_date(RJSJ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('ZZJG', SSPCS), to_char(to_date(QZYXQJZ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), 'A', CAST(OPERATETIME AS DATE), BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), BJCICBB.tra nsCode@BJCIC('ORGID', ORGID), SUBSTRB(XZBWID, 1, 20), XZDXID, BJCICBB.transCode@BJCIC('XZCS', XZCSID), ZATDID, JGID, BJCICBB.transCode@BJCIC('ZZJG', LRDWID), SUBSTRB(LRR, 1, 20), to_char(LRRQ, 'yyyymmdd'), FILEID, JD, WD, to_char(JHRQ, 'yyyymmdd'), SGSX, SGXX, case when ZJZLID='111' then ZJHM else '' end from (select wfry.*, flmap.FILEID from T_RY_WFFZRYXX wfry left join T_TB_UPLOADFILESMAP flmap on wfry.ZPID=flmap.DATAID) srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='WFFZRYXXTAB1001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
7frqszzdu8sgg	select DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
7pd3wqnmntb81	insert into BJCICBB.T_INFO_CASETOPEOPLE@BJCIC(ID, PEOPLEID, CASEID, CASENO, PEOPLETYPE, PEOPLENO, OPERATETIME, DELFLAG) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, -1, -1, AJBH, BJCICBB.transCode@BJCIC('RYLX', RYLX), RYBH, BJCICBB.BJCICSYSDATE@BJCIC, 'A' from T_AJ_XSAJRYDY srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='XSAJRYDYTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
7qu0ccx5x7g01	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 '%?%' ) ) ) )
7vtvy8b3shx1y	SELECT COUNT(*) as CT from t_sj_sjjbxx sj where sj.zhbs='4001' and (sj.sjlyflg<>'YQSJDR' or sj.sjlyflg is null) and sj.lrdwid = :1
81j8hc7qyg1h8	SELECT COUNT(*) as CT from T_YJ_YJXXB yjxxb0_
82cwpzfp3xg4c	SELECT COUNT(*) as CT from t_aj_xzajfaxx xz where 1=1 and xz.ajzt <> '3210' 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 = xz.ajbh and org.treepath like '11000000000000.11010800000000%')
83r84uaanrpa5	update T_DOC_PROCESSINSTANCE set DATAVERSION=:1, STATUS=:2, OWNORG=:3, OWNPOSITION=:4, OWNER=:5, OWNERTYPE=:6, OPERATERCODE=:7, OPERATETIME=:8, DELFLAG=:9, ORGID=:10 where ID=:11 and DATAVERSION=:12
8888g4qgzt1kb	update XCXT_history.H_DOC_WSGD set delFlag='D' , operateTime= :1 , operaterCode= :2 where id=:3 and dataversion=:4
8c6c12f9k43mm	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.z bmj, 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
8cwnfzhhh7f9j	insert into BJCICBB.T_INFO_CRMNLCS@BJCIC(ID, CASNO, CASNAME, CASCLSIFID, CASTYPID, CASLEVLID, ADHOCID, PLICESTAID, DUTYTEMID, BELOGRUP, OCRPLACID, CASADDR, CASBEGNTM, CASENDTM, OCRAREAID, CASEWEEKID, DAYOFWEEK, DICOVRYTM, DICRFOMID, LOCLTYPID, RECEIVER, RECEDEPTID, RECORDEPTID, RECORDERNO, RECORDER, RECORDDATE, CASDETAIL, KEYWORDS, ACCEPTTIME, ACCEPTOR, ACCDEPID, HELPDEPID, LOSSTOTL, CASCLUE, CIMFEATURID, CIMFEATUR, CIMTOOLID, CIMTOOL, DOMEANSID, DOMEANS, PREMEANSID, CAMOUMEANSID, PICKTYPID, VEHICODEID, BELOSTRTID, CULDEPTID, INNDEPTID, CASESTATUSID, WEATHERID, CHANCEID, TIMEID, DATEID, COUNT, ISGROUPID, VIOLATIONID, LOCATION, PARTID, PART, ACCOUTS, ZHGSD, ACCOUTORGID, SUSTEL, SUSTELAREAID, SUSDISCRP, ISLETID, JINGDU, WEIDU, DQBS, SCZ, FXZ, REMARK, ORGID, OPERATETIME, DELFLAG, CASSIGNID, PLICEAREID, LOCATIONID, COMMUNITYID, OPERATERID, ACCMODEID, SUSNET, CASETREATMENTID) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, AJBH, AJMC, BJCICBB.transCode@BJCIC('AJLB', XSAJZABID), BJCICBB.transCode@BJCIC('AJLX', AJLXID), SAJBID, BJCICBB.transCode@BJCIC('ZABS', ZABSID), BJCICBB.transCode@BJCIC('SSPCS', PCSGXID), ZRQDID, GSDZ, FADDID, SUBSTRB(FADDXZ, 1, 100), to_char(FAKSSJ, 'yyyymmddhh24mi'), to_char(FAJSSJ, 'yyyymmddhh24mi'), FAQYID, FAZ, FASJXQ, to_char(FXSJ, 'yyyymmddhh24mi'), FXXS, XCLX, SUBSTRB(JBR, 1, 30), BJCICBB.transCode@BJCIC('ZZJG', JBDWID), BJCICBB.transCode@BJCIC('ZZJG', LRDWID), BJCICBB.transCode@BJCIC('ZZYZH', LRRZH), SUBSTRB(LRR, 1, 32), to_char(LRRQ, 'yyyymmdd'), JYA Q, JYAQGJZ, to_char(SLSJ, 'yyyymmddhh24mi'), SUBSTRB(SLR, 1, 30), BJCICBB.transCode@BJCIC('ZZJG', SLBMID), BJCICBB.transCode@BJCIC('ZZJG', XBBMID), SSZJZ, SAXS, ZATDID, BCZATD, ZAGJID, BCZAGJ, BJCICBB.transCode@BJCIC('ZASD', SSSDID), BCSSSD, BJCICBB.transCode@BJCIC('ZASD', YBSDID), BJCICBB.transCode@BJCIC('ZASD', WZSDID), PQLXID, CCDMID, GSJDID, WBDWID, NBDWID, BJCICBB.transCode@BJCIC('AJHJ', AJHJ), TQID, JHID, SJID, RQID, GJZARS, SFJTZA, QHGXID, BCXZCS, XZBWID, BCXZBW, SXZH, ZHDSD, ZHGSD, SXDH, DHGSD, SXRTZMS, SFCZF, JD, WD, DQBS, SCZ, FXZ, BZ, BJCICBB.transCode@BJCIC('ORGID', ORGID), CAST(OPERATETIME AS DATE), 'A', BJCICBB.transCode@BJCIC('ZABS', ZABSID), FADDSSJQ, BJCICBB.transCode@BJCIC('SLXZZAXZCSD', FSCSID), FADDSSSQ, BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), BJCICBB.transCode@BJCIC('SLXZAJLY', AJLYID), SXWZ, '11' from (select xzfa.ID, slxz.AJBH, xzfa.AJMC, slxz.XSAJZABID, xzfa.AJLXID, slxz.SAJBID, xzfa.ZABSID, xzfa.PCSGXID, slxz.ZRQDID, slxz.GSDZ, xzfa.FADDID, xzfa.FADDXZ, xzfa.FAKSSJ, xzfa.FAJSSJ, xzfa.FAQYID, slxz.FAZ, slxz.FASJXQ, xzfa.FXSJ, xzfa.FXXS, xzfa.XCLX, xzfa.JBR, xzfa.JBDWID, xzfa.LRDWID, xzfa.LRRZH, xzfa.LRR, xzfa.LRRQ, xzfa.JYAQ, slxz.JYAQGJZ, xzfa.SLSJ, xzfa.SLR, slxz.SLBMID, slxz.XBBMID, xzfa.SSZJZ, slxz.SAXS, slxz.ZATDID, slxz.BCZATD, slxz.ZAGJID, slxz.BCZAGJ, slxz.SSSDID, slxz.BCSSSD, slxz.YBSDID, slxz.WZSDID, slxz.PQLXID, slxz.CCDMID, slxz.GSJDID, slxz.WBDWID, slxz.NBDWID, xzfa.AJHJ, slxz.TQID, slxz.JHID, slxz.SJID, slxz.RQID, slxz.GJZARS, slx z.SFJTZA, xzfa.QHGXID, slxz.BCXZCS, xzfa.XZBWID, slxz.BCXZBW, slxz.SXZH, slxz.ZHDSD, slxz.ZHGSD, slxz.SXDH, slxz.DHGSD, slxz.SXRTZMS, slxz.SFCZF, xzfa.JD, xzfa.WD, slxz.DQBS, xzfa.SCZ, xzfa.FXZ, slxz.BZ, slxz.ORGID, slxz.OPERATETIME, slxz.DELFLAG, xzfa.FADDSSSQ, xzfa.FSCSID, xzfa.FADDSSJQ, xzfa.OPERATERCODE, xzfa.AJLYID, slxz.SXWZ, xzfa.AJCLID from T_AJ_XZAJFAXX xzfa left join T_AJ_SLXZAJFAXX slxz on xzfa.AJBH = slxz.AJBH where xzfa.AJXZ in ('010302500', '010302600', '010302800', '010405900', '010405901', '010405902', '010405903', '010405904', '010406000', '010406001', '010406002', '010406003', '010406004', '010406100', '010406200', '010406300', '010406400', '010406401', '010406402', '010406500', '010406501', '010406502', '010406503', '010406600', '010406601', '010406602', '010406603', '010406604', '010405800')) srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='XZAJFAXXTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
8fb4axtuaaad5	select org.orgcode from t_sys_organization org where org.orgname=:1
8j533gtmyb86d	update T_MSG_NODE set LASTONLINETIME=:1 where ID=:2
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)
8sqtb3scv1a6d	SELECT to_char(SYSTIMESTAMP, 'yyyy-mm-dd hh24:mi:SS.FF3') FROM DUAL
8udz5ub7qx338	select * from ( select row_.*, rownum rownum_ from ( select gdb0_.ID as ID264_, gdb0_.DATAVERSION as DATAVERS2_264_, gdb0_.DXID as DXID264_, gdb0_.DXBH as DXBH264_, gdb0_.DXLX as DXLX264_, gdb0_.CQID as CQID264_, gdb0_.CQMC as CQMC264_, gdb0_.SPTGSJ as SPTGSJ264_, gdb0_.GDZT as GDZT264_, gdb0_.SJHQZT as SJHQZT264_, gdb0_.GDCLSJ as GDCLSJ264_, gdb0_.OPERATETIME as OPERATE12_264_, gdb0_.OPERATERCODE as OPERATE13_264_, gdb0_.DELFLAG as DELFLAG264_, gdb0_.ORGID as ORGID264_, gdb0_.CQDM as CQDM264_, gdb0_.AJBH as AJBH264_, gdb0_.ZBH as ZBH264_ from T_YJ_GDB gdb0_ order by gdb0_.OPERATETIME ) row_ where rownum <= :1) where rownum_ > :2
8xu69m0xmuacn	select count(1) from T_JK_JJ110 where zt='1' and jjxh =:1 and pcsjqgsdw = :2
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 )
943h3m6b178br	select count(1) as recordCount, max(operateTime) lastUpTime from (select rycl.*, tbhc.ORADATAID from T_RY_RYCLXX rycl left join T_TB_TBHC tbhc on rycl.ID=tbhc.DATAID) srcdata0 where operateTime > :1 and operateTime <= :2 and exists(select 1 from T_RY_WFFZRYXX srcdata1 where srcdata0.RYBH = srcdata1.RYBH and exists(select 1 from T_AJ_XSAJRYDY srcdata2 where srcdata1.RYBH = srcdata2.RYBH and exists(select 1 from T_AJ_XSAJFAXX srcdata3 where ZABID in ('020703', '020704') and LRRQ>=DATE'2012-07-01' and srcdata2.AJBH = srcdata3.AJBH)))
96f65g29r1r4f	delete from T_DOC_WSGD where ID=:1 and DATAVERSION=:2
9azk33sd90pmh	SELECT /*+ OPAQUE_TRANSFORM */ "ID", "RYBH", "XM", "XBID", "CSRQ", "NL", "BM", "JYCDID", "SFID", "TSSFID", "ZZMMID", "MZID", "GJID", "JLYYID", "GZDW", "ZWID", "HJDID", "HJDXZ", "RSBH", "ZZDID", "ZZDXZ", "JZDSSPCSID", "JSLXID", "SWYYID", "SWRQ", "AFLXID", "AFZKID", "SFBCY", "CJYYID", "SFXD", "RYBS", "KYID", "XXID", "TXID", "FSID", "FXID", "NXID", "MID", "YID", "ZID", "BID", "CID", "YAID", "XBAID", "HXID", "ERID", "QTTMTZID", "ZAGJID", "ZASDID", "ZATD1", "BCSD", "ZAGJ1", "TSZCID", "ZAYYID", "ZWM", "XZFFID", "XZQYID", "LCQY", "XZDQXZ", "SCXDSJ", "DYCD", "HFQK", "XSQK", "XDYYID", "XDFSID", "DPZLID", "FXCS", "FXJGID", "XSHGID", "ZYJJLYID", "XSDD", "XYBH", "XSHJID", "DNAID", "JJZK", "SJ1", "ZJ2", "JL", "BZ", "YWM", "ZJZLID", "ZJHM", "QZZLID", "QZYXQKS", "RJKAID", "RJSJ", "SSPCS", "QZYXQJZ", "OPERATETIME", "OPERATERCODE", "ORGID", "XZBWID", "XZDXID", "XZCSID", "ZATDID", "QTBW", "JGID", "SFYJ", "ZAFG", "SFBLZZZ", "ZZZHM", "ZZZBLDWID", "LRDWID", "LRR", "LRRQ", "ZPID", "SWSFID", "RDRYBH", "XMPYM", "JD", "BYZD1", "WD", "BYZD2", "BYZD3", "BYZD4", "BYZD5", "LJLGLS", "RYZT", "SQ", "JHRQ", "JHDWID", "BMJB", "SFBM", "ZAFGID", "LJSJ", "QTZJZL", "QTZJHM", "SGSX", "SGXX" FROM "T_RY_WFFZRYXX" "A3" WHERE "OPERATETIME"<=:1
9f5x49jjrwf0f	insert into BJCICBB.T_BUSI_PEOPLEINFOTOPHOTO@BJCIC(ID, PEOPLENO, PEOPLEID, PHOTOID, PEOPLETYPE) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, REPLACE(RYBH, 'R', 'X'), -1, FILEID, BJCICBB.transCode@BJCIC('ZPDYRYLX', RYLX) from (select zpdy.*, flmap.FILEID from T_RY_RYZPDY zpdy left join T_TB_UPLOADFILESMAP flmap on zpdy.ZHID=flmap.DATAID where zpdy.RYLX='04') srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='RYZPDYTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
9jzja4nwmcuwn	select node0_.ID as ID39_, node0_.JOINTIME as JOINTIME39_, node0_.CRASHTIME as CRASHTIME39_, node0_.LASTONLINETIME as LASTONLI4_39_, node0_.APPSYSCODE as APPSYSCODE39_, node0_.NODECODE as NODECODE39_, node0_.STATE as STATE39_ from T_MSG_NODE node0_ where node0_.STATE=:1 and node0_.LASTONLINETIME<:2
9st2z0vw4hnt2	SELECT * FROM H_ZZ_SADWXX WHERE operatetime >=:1 and delflag='D'
9u3fanj798ahv	insert into T_TB_UPLOADFILESMAP(ID, DATAID, FILEID, FILENAME, UPLOADTIME) select sys_guid(), ID, BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, FILENAME, UPLOADTIME from T_SYS_UPLOADFILEINFO srcdata where not exists(select 1 from T_TB_UPLOADFILESMAP flmap where flmap.DATAID=srcdata.ID and flmap.UPLOADTIME>=:1) and srcdata.UPLOADTIME>=:2
9vd35ntyc7jpz	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 '%??%' ) ) ) )
9wjzwadrtqzg8	select count(1) as recordCount, max(operateTime) lastUpTime from T_RY_AJBQHRXX srcdata0 where operateTime > :1 and operateTime <= :2
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
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
ajzy5vgzt5ucz	select fieldmaps0_.TABMAPID as TABMAPID1_, fieldmaps0_.ID as ID1_, fieldmaps0_.ID as ID37_0_, fieldmaps0_.TABMAPID as TABMAPID37_0_, fieldmaps0_.SRCTABNAME as SRCTABNAME37_0_, fieldmaps0_.SRCFIELDNAME as SRCFIELD4_37_0_, fieldmaps0_.SRCFIELDDESC as SRCFIELD5_37_0_, fieldmaps0_.TARGETTABNAME as TARGETTA6_37_0_, fieldmaps0_.TARGETFIELDNAME as TARGETFI7_37_0_, fieldmaps0_.TARGETFIELDDESC as TARGETFI8_37_0_, fieldmaps0_.ENABLED as ENABLED37_0_, fieldmaps0_.DISPLAYORDER as DISPLAY10_37_0_, fieldmaps0_.CODEMAPNAME as CODEMAP11_37_0_, fieldmaps0_.FUNEXP as FUNEXP37_0_, fieldmaps0_.UPDATEFLAG as UPDATEFLAG37_0_, fieldmaps0_.BUSIIDFLAG as BUSIIDFLAG37_0_, fieldmaps0_.OPERATERCODE as OPERATE15_37_0_, fieldmaps0_.OPERATETIME as OPERATE16_37_0_, fieldmaps0_.DELFLAG as DELFLAG37_0_, fieldmaps0_.ORGID as ORGID37_0_ from T_FIELD_MAP fieldmaps0_ where fieldmaps0_.TABMAPID=:1 order by fieldmaps0_.displayorder
at0nqzstprp3k	insert into BJCICBB.T_INFO_CRIMINALBASEINFOR@BJCIC(ID, PEOPLENO, NAME, SEXID, BIRTHDAY, AGE, NICKNAME, EDUCATIONLEVELID, STATUSID, SPECIALSTATUSID, POLITICALAPPEARANCEID, RACEID, NATIONALITYID, HOUSINGREASONID, DEPARTMENT, DUTYID, REGISTEREDADDRESSID, DETAILADDRESS, JAILNO, PRESENTADDRESSID, PRESENTDETAILADDRESS, HOUSINGPOLICESID, ABODETYPEID, DEADREASONID, DEADDATE, CRIMINALTYPEID, CRIMINALSITUATIONID, ISILLPREGNANTID, GATHERREASONID, ISDRUGGERID, STATUREUPPERLIMIT, STATURELOWERLIMIT, PERSONIDENTIFIERID, ACCENTID, BLOODTYPEID, BODILYFORMID, COMPLEXIONID, HAIRSTYLEID, FACESTYLEID, EYEBOWID, EYEID, MOUTHID, NOSEID, LIPID, TOOTHID, CHINID, BEARDID, EARID, ATTIRECHARACTERID, CASETOOLID, CASEMETHODID, CASECHARACTERF, SUPPLYMETHOD, CASETOOLF, SPECIALITYID, CASEREASONID, FINGERPOINTCODE, DISPOSALMETHODID, DISPOSALAREAID, FLEEAREA, DISPOSALDETAILAREA, FIRSTFEAKOUTTIME, FEAKOUTDEGREE, COSTINSTANCE, FEAKOUTINSTANCE, FEAKOUTREASONID, FEAKOUTTYPEID, POSIONSORTID, RESUMETIMES, RESUMEINTERVALID, FEAKOUTRESULTID, MAININCOMEFORMID, FEAKOUTPLACE, SUSPICIONNO, FEAKOUTENVIRONMENTID, DNANO, ECONOMYSTATUS, MOBILE, TEL, RESUME, REMARK, ENGLISHNAME, PAPERKINDID, PAPERNUMBER, VISAKINDID, VISADEADTIMES, ENTERPORTID, ENTERTIME, SUBJECTPOLICESID, VISADEADTIMEE, DELFLAG, OPERATETIME, OPERATERID, ORGID, CHOOSEPARTID, CHOOSEOBJECTID, CHOOSELACATIONID, CASECHARACTERID, OTHERPART, NATIVEPLACEID, ISTRANSFER, CASEDIFLABOR, ISTEMPREGID, TEMPREGNUM, TEMPREGDEPID, RECORDEPTID, RECORDER, RECORDDATE, FRIMPEOPLENO , PHOTOID, STATUSOUTID, NAMESPELL, JINGDU, WEIDU, RMK1, RMK2, RMK3, RMK4, RMK5, LJLGLS, RYZT, SQ, ARRESTDATE, ARRESTDEPARTMENTID, DATALEVEL, ISSECRECY, WORKTYPEID, LJSJ, CID) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, RYBH, SUBSTRB(XM, 1, 52), XBID, to_char(CSRQ, 'yyyymmdd'), NL, BM, BJCICBB.transCode@BJCIC('WHCD', JYCDID), SFID, BJCICBB.transCode@BJCIC('TSSF', TSSFID), BJCICBB.transCode@BJCIC('ZZMM', ZZMMID), MZID, GJID, BJCICBB.transCode@BJCIC('JLYY', JLYYID), GZDW, BJCICBB.transCode@BJCIC('ZW', ZWID), HJDID, HJDXZ, RSBH, ZZDID, ZZDXZ, BJCICBB.transCode@BJCIC('SSPCS', JZDSSPCSID), JSLXID, SWYYID, to_char(SWRQ, 'yyyymmdd'), AFLXID, AFZKID, SFBCY, CJYYID, SFXD, SGSX, SGXX, RYBS, KYID, XXID, BJCICBB.transCode@BJCIC('TMTZ', TXID), BJCICBB.transCode@BJCIC('TMTZ', FSID), BJCICBB.transCode@BJCIC('TMTZ', FXID), BJCICBB.transCode@BJCIC('TMTZ', NXID), BJCICBB.transCode@BJCIC('TMTZ', MID), BJCICBB.transCode@BJCIC('TMTZ', YID), BJCICBB.transCode@BJCIC('TMTZ', ZID), BJCICBB.transCode@BJCIC('TMTZ', BID), BJCICBB.transCode@BJCIC('TMTZ', CID), BJCICBB.transCode@BJCIC('TMTZ', YAID), BJCICBB.transCode@BJCIC('TMTZ', XBAID), BJCICBB.transCode@BJCIC('TMTZ', HXID), BJCICBB.transCode@BJCIC('TMTZ', ERID), BJCICBB.transCode@BJCIC('TMTZ', QTTMTZID), ZAGJID, BJCICBB.transCode@BJCIC('ZASD', ZASDID), ZATD1, BCSD, ZAGJ1, TSZCID, ZAYYID, ZWM, XZFFID, XZQYID, LCQY, XZDQXZ, to_char(to_date(SCXDSJ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), DYCD, HFQK, XSQK, XDYYID, XDFSID, DPZLID, FXCS, FXJGID, XSH GID, ZYJJLYID, XSDD, XYBH, XSHJID, DNAID, JJZK, SJ1, ZJ2, JL, BZ, YWM, BJCICBB.transCode@BJCIC('ZJZL', QTZJZL), QTZJHM, QZZLID, to_char(to_date(QZYXQKS, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmdd'), RJKAID, to_char(to_date(RJSJ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('SSPCS', SSPCS), to_char(to_date(QZYXQJZ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmdd'), 'A', CAST(OPERATETIME AS DATE), BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), BJCICBB.transCode@BJCIC('ORGID', ORGID), SUBSTRB(XZBWID, 1, 20), XZDXID, BJCICBB.transCode@BJCIC('XZCS', XZCSID), ZATDID, QTBW, JGID, SFYJ, ZAFG, SFBLZZZ, ZZZHM, BJCICBB.transCode@BJCIC('ZZJG', ZZZBLDWID), BJCICBB.transCode@BJCIC('ZZJG', LRDWID), SUBSTRB(LRR, 1, 32), to_char(LRRQ, 'yyyymmdd'), case when RDRYBH is null then 'R' else RDRYBH end, FILEID, SWSFID, SUBSTRB(XMPYM, 1, 32), JD, WD, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5, LJLGLS, RYZT, SQ, to_char(JHRQ, 'yyyymmdd'), BJCICBB.transCode@BJCIC('ZZJG', JHDWID), BJCICBB.transCode@BJCIC('BMJB', BMJB), SFBM, ZAFGID, LJSJ, case when ZJZLID='111' then ZJHM else '' end from (select wfry.*, flmap.FILEID from T_RY_WFFZRYXX wfry left join T_TB_UPLOADFILESMAP flmap on wfry.ZPID=flmap.DATAID) srcdata where exists(select 1 from T_TB_TBHC tbhc where tbhc.TABMAPID='WFFZRYXXTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
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 )
b0nfcn4da4srd	select count(1) as recordCount, max(operateTime) lastUpTime from (select zhxx.*, tbhc.ORADATAID from T_RY_ZHXX zhxx left join T_TB_TBHC tbhc on zhxx.ID=tbhc.DATAID) srcdata0 where operateTime > :1 and operateTime <= :2
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
bavfcfp0ndkg7	insert into BJCICBB.T_INFO_CRMNLCS@BJCIC(ID, CASNO, CASNAME, CASCLSIFID, PLSCLSIFID, CASTYPID, ACCITYPID, CASLEVLID, CASSIGNID, ADHOCID, PLICESTAID, DUTYTEMID, BELOGRUP, PLICEAREID, OCRPLACID, CASADDR, CASBEGNTM, CASENDTM, OCRAREAID, CASEWEEKID, DAYOFWEEK, DICOVRYTM, DICRFOMID, LOCLTYPID, RECEIVER, RECEDEPTID, REGISTTM, REGISTDEPID, REGISTTOTL, RECORDEPTID, RECORDERNO, RECORDER, RECORDDATE, CASSOURCEID, CASDETAIL, KEYWORDS, ACCEPTTIME, ACCEPTOR, ACCMODEID, ACCDEPID, HELPDEPID, TREATMENTTIME, TREATMENTDEPTID, DATATREATDEPT, LOSSTOTL, CASCLUE, CIMFEATURID, CIMFEATUR, CIMTOOLID, CIMTOOL, DOMEANSID, DOMEANS, PREMEANSID, CAMOUMEANSID, PICKTYPID, VEHICODEID, BELOSTRTID, CULDEPTID, INNDEPTID, LEVELID, CIRCUMSS, REMOVEFLG, TRANSFERDEP, CASESTATUSID, TRAWEATHERID, WEATHERID, CHANCEID, TIMEID, DATEID, COUNT, ISGROUPID, VIOLATIONID, LOCATIONID, LOCATION, PARTID, PART, CRITYPID, ISREFERNATIONID, ACCOUTS, ZHGSD, ACCOUTORGID, SUSTEL, SUSTELAREAID, SUSDISCRP, ISLETID, JINGDU, WEIDU, DQBS, DATALEVEL, ISSECRECY, COMMUNITYID, TRALOCLTYPID, SSGS, QYDM, SCZ, FXZ, SUSNET, REMARK, OPERATERID, ORGID, OPERATETIME, DELFLAG, CASETREATMENTID) select BJCICBB.HIBERNATE_SEQUENCE.NEXTVAL@BJCIC, AJBH, AJMC, BJCICBB.transCode@BJCIC('AJLB', ZABID), BJCICBB.transCode@BJCIC('AJLB', BCABID), BJCICBB.transCode@BJCIC('AJLX', AJLXID), SGLXID, SAJBID, BJCICBB.transCode@BJCIC('ZABS', ZABSID), ZABS, BJCICBB.transCode@BJCIC('SSPCS', PCSGXID), ZRQDID, GSDZ, JQ, FADDID, SUBSTRB(FADDXZ, 1, 100), to_char(FAKSSJ, 'yyyymmddh h24mi'), to_char(FAJSSJ, 'yyyymmddhh24mi'), FAQYID, FAZ, FASJXQ, to_char(FXSJ, 'yyyymmddhh24mi'), FXXSID, XCLXID, SUBSTRB(JBR, 1, 30), BJCICBB.transCode@BJCIC('ZZJG', JBDWID), to_char(LASJ, 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('ZZJG', LADW), LAZJZJE, BJCICBB.transCode@BJCIC('ZZJG', LRDW), BJCICBB.transCode@BJCIC('ZZYZH', LRRZH), SUBSTRB(LRR, 1, 32), to_char(LRRQ, 'yyyymmdd'), AJLYID, JYAQ, JYAQGJZ, to_char(SLSJ, 'yyyymmddhh24mi'), SUBSTRB(SLR, 1, 30), SLFSID, BJCICBB.transCode@BJCIC('ZZJG', SLBMID), BJCICBB.transCode@BJCIC('ZZJG', XBBMID), to_char(CLSJ, 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('ZZJG', CLDW), BJCICBB.transCode@BJCIC('ZZJG', SJCLF), SSZJZJE, SAXS, ZATDID, BCZATD, ZAGJID, BCZAGJ, BJCICBB.transCode@BJCIC('ZASD', SSSDID), BCSSSD, BJCICBB.transCode@BJCIC('ZASD', YBSDID), BJCICBB.transCode@BJCIC('ZASD', WZSDID), PQLXID, CCDMID, GSJDID, WBDWID, NBDWID, BJCICBB.transCode@BJCIC('DBJB_JZ', DBJBID), DBQK, JZBZ, BJCICBB.transCode@BJCIC('ZZJG', YSDW), BJCICBB.transCode@BJCIC('AJHJ', AJHJ), JTTQID, TQID, JHID, SJID, RQID, GJZARS, SFJTZA, QHQXID, BJCICBB.transCode@BJCIC('XZCS', XZCS), BCXZCS, XZBW, BCXZBW, FZZTLXID, SWSJGJDQID, SXZH, ZHDSD, ZHGSD, SXDH, DHGSD, SXRTZMS, SFCZF, JD, WD, DQBS, BMJB, SFBM, SQID, XCLXJTID, GJSSGX, GJQYDM, SCZ, FXZ, SXWZ, BZ, BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), BJCICBB.transCode@BJCIC('ORGID', ORGID), CAST(OPERATETIME AS DATE), 'A', BJCICBB.transCode@BJCIC('AJCL', AJCL) from T_AJ_XSAJFAXX srcdata where exists(select 1 from T_TB_ TBHC tbhc where tbhc.TABMAPID='XSAJFAXXTAB0001' and tbhc.DELFLAG='A' and tbhc.DATAID=srcdata.ID) and OperateTime<=:1
bdgynrscjb0yx	update BJCICBB.T_INFO_CRMNLCS@BJCIC tardata set (CASNO, CASNAME, CASCLSIFID, PLSCLSIFID, CASTYPID, ACCITYPID, CASLEVLID, CASSIGNID, ADHOCID, PLICESTAID, DUTYTEMID, BELOGRUP, PLICEAREID, OCRPLACID, CASADDR, CASBEGNTM, CASENDTM, OCRAREAID, CASEWEEKID, DAYOFWEEK, DICOVRYTM, DICRFOMID, LOCLTYPID, RECEIVER, RECEDEPTID, REGISTTM, REGISTDEPID, REGISTTOTL, RECORDEPTID, RECORDERNO, RECORDER, RECORDDATE, CASSOURCEID, CASDETAIL, KEYWORDS, ACCEPTTIME, ACCEPTOR, ACCMODEID, ACCDEPID, HELPDEPID, TREATMENTTIME, TREATMENTDEPTID, DATATREATDEPT, LOSSTOTL, CASCLUE, CIMFEATURID, CIMFEATUR, CIMTOOLID, CIMTOOL, DOMEANSID, DOMEANS, PREMEANSID, CAMOUMEANSID, PICKTYPID, VEHICODEID, BELOSTRTID, CULDEPTID, INNDEPTID, LEVELID, CIRCUMSS, REMOVEFLG, TRANSFERDEP, CASESTATUSID, TRAWEATHERID, WEATHERID, CHANCEID, TIMEID, DATEID, COUNT, ISGROUPID, VIOLATIONID, LOCATIONID, LOCATION, PARTID, PART, CRITYPID, ISREFERNATIONID, ACCOUTS, ZHGSD, ACCOUTORGID, SUSTEL, SUSTELAREAID, SUSDISCRP, ISLETID, JINGDU, WEIDU, DQBS, DATALEVEL, ISSECRECY, COMMUNITYID, TRALOCLTYPID, SSGS, QYDM, SCZ, FXZ, SUSNET, REMARK, OPERATERID, OPERATETIME, DELFLAG, CASETREATMENTID) = (select AJBH, AJMC, BJCICBB.transCode@BJCIC('AJLB', ZABID), BJCICBB.transCode@BJCIC('AJLB', BCABID), BJCICBB.transCode@BJCIC('AJLX', AJLXID), SGLXID, SAJBID, BJCICBB.transCode@BJCIC('ZABS', ZABSID), ZABS, BJCICBB.transCode@BJCIC('SSPCS', PCSGXID), ZRQDID, GSDZ, JQ, FADDID, SUBSTRB(FADDXZ, 1, 100), to_char(FAKSSJ, 'yyyymmddhh24mi'), to_char(FAJSSJ, 'yyyymmddhh24mi') , FAQYID, FAZ, FASJXQ, to_char(FXSJ, 'yyyymmddhh24mi'), FXXSID, XCLXID, SUBSTRB(JBR, 1, 30), BJCICBB.transCode@BJCIC('ZZJG', JBDWID), to_char(LASJ, 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('ZZJG', LADW), LAZJZJE, BJCICBB.transCode@BJCIC('ZZJG', LRDW), BJCICBB.transCode@BJCIC('ZZYZH', LRRZH), SUBSTRB(LRR, 1, 32), to_char(LRRQ, 'yyyymmdd'), AJLYID, JYAQ, JYAQGJZ, to_char(SLSJ, 'yyyymmddhh24mi'), SUBSTRB(SLR, 1, 30), SLFSID, BJCICBB.transCode@BJCIC('ZZJG', SLBMID), BJCICBB.transCode@BJCIC('ZZJG', XBBMID), to_char(CLSJ, 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('ZZJG', CLDW), BJCICBB.transCode@BJCIC('ZZJG', SJCLF), SSZJZJE, SAXS, ZATDID, BCZATD, ZAGJID, BCZAGJ, BJCICBB.transCode@BJCIC('ZASD', SSSDID), BCSSSD, BJCICBB.transCode@BJCIC('ZASD', YBSDID), BJCICBB.transCode@BJCIC('ZASD', WZSDID), PQLXID, CCDMID, GSJDID, WBDWID, NBDWID, BJCICBB.transCode@BJCIC('DBJB_JZ', DBJBID), DBQK, JZBZ, BJCICBB.transCode@BJCIC('ZZJG', YSDW), BJCICBB.transCode@BJCIC('AJHJ', AJHJ), JTTQID, TQID, JHID, SJID, RQID, GJZARS, SFJTZA, QHQXID, BJCICBB.transCode@BJCIC('XZCS', XZCS), BCXZCS, XZBW, BCXZBW, FZZTLXID, SWSJGJDQID, SXZH, ZHDSD, ZHGSD, SXDH, DHGSD, SXRTZMS, SFCZF, JD, WD, DQBS, BMJB, SFBM, SQID, XCLXJTID, GJSSGX, GJQYDM, SCZ, FXZ, SXWZ, BZ, BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), CAST(OPERATETIME AS DATE), 'U', BJCICBB.transCode@BJCIC('AJCL', AJCL) from T_AJ_XSAJFAXX srcdata where srcdata.AJBH = tardata.CASNO) where exists(select 1 from BJCICBB.T_TB_TBHC@BJCIC tbhc where tbhc.TABMAPID='XS AJFAXXTAB0001' and tbhc.DELFLAG='U' and tbhc.BUSINO0 = tardata.CASNO)
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
bms0qcxdx0cpw	select distinct yjxxb0_.ID as ID264_, yjxxb0_.DATAVERSION as DATAVERS2_264_, yjxxb0_.DXBH as DXBH264_, yjxxb0_.DXLX as DXLX264_, yjxxb0_.YJDW as YJDW264_, yjxxb0_.YJJZSJ as YJJZSJ264_, yjxxb0_.YJZQX as YJZQX264_, yjxxb0_.YJZQXDW as YJZQXDW264_, yjxxb0_.JSSJ as JSSJ264_, yjxxb0_.YJJSLX as YJJSLX264_, yjxxb0_.YJDQSJ as YJDQSJ264_, yjxxb0_.YJZT as YJZT264_, yjxxb0_.CQZT as CQZT264_, yjxxb0_.SCBJ as SCBJ264_, yjxxb0_.OPERATETIME as OPERATE15_264_, yjxxb0_.OPERATERCODE as OPERATE16_264_, yjxxb0_.DELFLAG as DELFLAG264_, yjxxb0_.ORGID as ORGID264_, yjxxb0_.CQDM as CQDM264_, yjxxb0_.CQMC as CQMC264_, yjxxb0_.AJBH as AJBH264_, yjxxb0_.ZBH as ZBH264_, yjxxb0_.CQID as CQID264_, yjxxb0_.YJTSXX as YJTSXX264_, yjxxb0_.CQTSXX as CQTSXX264_ 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
bpzccf32g7t5f	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
btfp8cm1k9vmr	select 'update t_doc_wsqxhis set mbmc = ''' ||(select templatename from t_doc_template where id = qx.temid) || ' '', mbcode = ''' || (select templatecode from t_doc_template where id = qx.temid) ||''', templateattr =''' || (select templateattr from t_doc_template where id = qx.temid) ||''' , status = '''|| ce.status || ''', processcode = ''' || ce.processcode || ''', username = '''|| ce.username || ''' , loginorgcode = '''|| ce.loginorgcode || ''', loginorgname = '''|| ce.loginorgname || ''', relationtype = '''|| d.relationtype || ''', owner = '''|| (select username from t_sys_user where id = ce.owner) || ''', featurename='''|| ce.featurename || ''', ender = '''|| (select username from t_sys_user where id = ce.ender) ||''', gsdw = '''|| d.gsdw ||''', starttime = '|| decode(ce.starttime, null, 'null', 'to_date(''' || to_char(ce.starttime, 'yyyy-mm-dd hh24:mi:ss') || ''', ''yyyy-mm-dd hh24:mi:ss'') ') ||', endtime = ' || decode(ce.endtime, null, 'null', 'to_date(''' || to_char(ce.endtime, 'yyyy-mm-dd hh24:mi:ss') || ''', ''yyyy-mm-dd hh24:mi:ss'') ') || ', kjsj = ' ||decode(d.kjsj, null, 'null', 'to_date(''' || to_char(d.kjsj, 'yyyy-mm-dd hh24:mi:ss') || ''', ''yyyy-mm-dd hh24:mi:ss'') ') || ', kjrname = '''||(select u.username from t_sys_user u where u.loginid = d.kjrzh) ||''' where id = '''|| qx.id ||'''' from t_doc_wsqxhis qx left join t_doc_processinstance ce on qx.proid = ce.id left join t_doc_docinstance d on d.id = qx.docid where templateattr is null and rownum < :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
c0vv5taj40hpr	select YJJZSJ from T_YJ_YJSJB yjsjb, T_YJ_GDB gdb where yjsjb.CQID=gdb.CQID AND (yjsjb.wsmc!='???????' or yjsjb.wsmc is null) and gdb.ID=:1
c5wun4tb4tdpj	SELECT * FROM H_AJ_XZAJFAXX where operatetime >= :1 and delflag='D' and operatetime >= TO_DATE('2012-01-01 20:00:00', 'yyyy-mm-dd hh24:mi:ss')
cdh5vuc69gwdc	insert into t_doc_wsqxhis select * from t_doc_wsqx where id = :1
ch6pxvzf2y208	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 '%??%' ) ) ) )
cjc6nwx9t0678	select distinct a.rolecode from t_sys_role a, (select distinct roleid from ((select a1.roleid from t_sys_user_role a1 where a1.userid=(select b1.id from t_sys_user b1 where b1.loginid=:1) union all select a2.roleid from t_sys_role_group a2 where a2.groupid in (select b2.groupid from t_sys_user_group b2 where b2.userid=(select b1.id from t_sys_user b1 where b1.loginid=:2))))) b where a.id=b.roleid
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
cu0xjy8zztrkc	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 '%?%' ) ) ) )
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
cz2g5dcy0ntu6	insert into T_AJ_AJCL (DATAVERSION, CLYJSJ, AJCLID, AJZTID, CLDWID, CLR, AJHJ, PZR, JSDWID, CLYJYY, AJID, AJBH, GLLX, BLYY, CLSX, CLRZH, PZRZH, ASJLX, XZAJCLLX, OPERATERCODE, OPERATETIME, DELFLAG, ORGID, CBZID, CBZBH, CQID, SJLYFLG, ID) 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)
d6y7mtpgvv67u	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 '%??%' ) ) ) )
dbpg2986dujvh	select this_.ID as ID97_0_, this_.DATAVERSION as DATAVERS2_97_0_, this_.NEWFLAG as NEWFLAG97_0_, this_.AJID as AJID97_0_, this_.AJBH as AJBH97_0_, this_.AJMC as AJMC97_0_, this_.ASJLXID as ASJLXID97_0_, this_.AJZTID as AJZTID97_0_, this_.AJLSZTDESC as AJLSZTDESC97_0_, this_.AJCLID as AJCLID97_0_, this_.SLSJ as SLSJ97_0_, this_.GKRQ as GKRQ97_0_, this_.CXRQ as CXRQ97_0_, this_.BAMJ as BAMJ97_0_, this_.BAMJZH as BAMJZH97_0_, this_.BAMJJH as BAMJJH97_0_, this_.BADWID as BADWID97_0_, this_.BADW as BADW97_0_, this_.BADWLYDH as BADWLYDH97_0_, this_.AJJZQKID as AJJZQKID97_0_, this_.AJJZQKDESC as AJJZQKDESC97_0_, this_.XYRCZQKID as XYRCZQKID97_0_, this_.XYRCZQKDESC as XYRCZQK23_97_0_, this_.ZKZWCLQKID as ZKZWCLQKID97_0_, this_.ZKZWCLQKDESC as ZKZWCLQ25_97_0_, this_.JDDH as JDDH97_0_, this_.GKZTID as GKZTID97_0_, this_.FBZTID as FBZTID97_0_, this_.FBSJ as FBSJ97_0_, this_.SPZTID as SPZTID97_0_, this_.CQID as CQID97_0_, this_.CQLXID as CQLXID97_0_, this_.CQYJ as CQYJ97_0_, this_.CQR as CQR97_0_, this_.CQRZH as CQRZH97_0_, this_.CQDWID as CQDWID97_0_, this_.CQRQ as CQRQ97_0_, this_.SPID as SPID97_0_, this_.SPR as SPR97_0_, this_.SPRZH as SPRZH97_0_, this_.SPDWID as SPDWID97_0_, this_.SPRQ as SPRQ97_0_, this_.SPYJ as SPYJ97_0_, this_.PJJDID as PJJDID97_0_, this_.BZ as BZ97_0_, this_.CBZBH as CBZBH97_0_, this_.CBZID as CBZID97_0_, this_.DELFLAG as DELFLAG97_0_, this_.OPERATERCODE as OPERATE49_97_0_, this_.OPERATETIME as OPERATE50_97_0_, th is_.ORGID as ORGID97_0_ from T_AJGK_AJJBXX this_ where this_.AJBH=:1 and this_.NEWFLAG=:2
dh4w5164pthaq	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 '%???%' ) ) ) )
dttu6p04xka4a	update BJCICBB.T_INFO_SUSPECTPEOINFOR@BJCIC tardata set (SUPECTPEOPLENO, NAME, SEXID, BIRTHDAY, AGE, ALIAS, NATIONALITYID, EDUCATIONLEVELID, STATUSID, SPECIALSTATUSID, PLITICALSTATUSID, RACEID, HOUSINGREASONID, DEPARTMENTID, REGISTEREDADDRESSID, DETAILADDRESS, PRESENTADDRESSID, PRESENTDETAILADDRESS, ABODETYPEID, DEADREASONID, DEADDATE, CRIMINALTYPEID, CRIMINALSITUATIONID, ISILLPREGNANTID, GATHERREASONID, ISDRUGGERID, ACCENTID, BLOODTYPEID, BODILYFORMID, COMPLEXIONID, HAIRSTYLEID, FACESTYLEID, EYEBOWID, EYEID, MOUTHID, NOSEID, LIPID, TOOTHID, CHINID, BEARDID, EARID, ATTIRECHARACTERID, CASETOOLID, CASEMETHODID, SPECIALITYID, CASEREASONID, FINGERPOINTCODE, DISPOSALMETHODID, DISPOSALAREAID, FLEEAREAID, FIRSTCASETIME, FEAKOUTDEGREE, COSTINSTANCE, FEAKOUTREASONID, FEAKOUTTYPEID, POSIONSORTID, RESUMETIMES, RESUMEINTERVALID, FEAKOUTRESULTID, MAININCOMEFORMID, FEAKOUTPLACEID, FEAKOUTINSTANCEID, ENGLISHNAME, PAPERKINDID, PAPERNUMBER, VISAKINDID, VISADEADTIMES, ENTERPORTID, ENTERTIME, SUBJECTPOLICESID, VISADEADTIMEE, DELFLAG, OPERATETIME, OPERATERID, CHOOSEPARTID, CHOOSEOBJECTID, CHOOOSELOCATIONID, CASECHARACTERID, NATIVEPLACEID, RECORDEPTID, RECORDER, RECORDDATE, PHOTOID, JINGDU, WEIDU, ARRESTTIME, STATUREUPPERLIMIT, STATURELOWERLIMIT, CID) = (select REPLACE(RYBH, 'R', 'X'), SUBSTRB(XM, 1, 52), case when XBID is null then '9' else XBID end, to_char(CSRQ, 'yyyymmdd'), NL, BM, GJID, BJCICBB.transCode@BJCIC('WHCD', JYCDID), SFID, BJCICBB.transCode@BJCIC('TSSF', TSSFID), BJCICBB.transCode@ BJCIC('ZZMM', ZZMMID), MZID, BJCICBB.transCode@BJCIC('JLYY', JLYYID), GZDW, HJDID, SUBSTRB(HJDXZ, 1, 64), ZZDID, ZZDXZ, JSLXID, SWYYID, to_char(SWRQ, 'yyyymmdd'), AFLXID, AFZKID, SFBCY, CJYYID, SFXD, KYID, XXID, BJCICBB.transCode@BJCIC('TMTZ', TXID), BJCICBB.transCode@BJCIC('TMTZ', FSID), BJCICBB.transCode@BJCIC('TMTZ', FXID), BJCICBB.transCode@BJCIC('TMTZ', NXID), BJCICBB.transCode@BJCIC('TMTZ', MID), BJCICBB.transCode@BJCIC('TMTZ', YID), BJCICBB.transCode@BJCIC('TMTZ', ZID), BJCICBB.transCode@BJCIC('TMTZ', BID), BJCICBB.transCode@BJCIC('TMTZ', CID), BJCICBB.transCode@BJCIC('TMTZ', YAID), BJCICBB.transCode@BJCIC('TMTZ', XBAID), BJCICBB.transCode@BJCIC('TMTZ', HXID), BJCICBB.transCode@BJCIC('TMTZ', ERID), BJCICBB.transCode@BJCIC('TMTZ', QTTMTZID), ZAGJID, BJCICBB.transCode@BJCIC('ZASD', ZASDID), TSZCID, ZAYYID, SUBSTRB(ZWM, 1, 32), XZFFID, XZQYID, SUBSTRB(LCQY, 1, 100), to_char(to_date(SCXDSJ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), DYCD, SUBSTRB(HFQK, 1, 64), XDYYID, XDFSID, DPZLID, FXCS, FXJGID, XSHGID, ZYJJLYID, XSDD, XSHJID, YWM, BJCICBB.transCode@BJCIC('ZJZL', QTZJZL), QTZJHM, QZZLID, to_char(to_date(QZYXQKS, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), RJKAID, to_char(to_date(RJSJ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), BJCICBB.transCode@BJCIC('ZZJG', SSPCS), to_char(to_date(QZYXQJZ, 'yyyy-mm-dd hh24:mi:ss'), 'yyyymmddhh24mi'), 'U', CAST(OPERATETIME AS DATE), BJCICBB.transCode@BJCIC('ZZYID', OPERATERCODE), SUBSTRB(XZBWID, 1, 20), XZDXID, BJCICBB.transCode@BJC IC('XZCS', XZCSID), ZATDID, JGID, BJCICBB.transCode@BJCIC('ZZJG', LRDWID), SUBSTRB(LRR, 1, 20), to_char(LRRQ, 'yyyymmdd'), FILEID, JD, WD, to_char(JHRQ, 'yyyymmdd'), SGSX, SGXX, case when ZJZLID='111' then ZJHM else '' end from (select wfry.*, flmap.FILEID from T_RY_WFFZRYXX wfry left join T_TB_UPLOADFILESMAP flmap on wfry.ZPID=flmap.DATAID) srcdata where REPLACE(srcdata.RYBH, 'R', 'X') = tardata.SUPECTPEOPLENO) where exists(select 1 from BJCICBB.T_TB_TBHC@BJCIC tbhc where tbhc.TABMAPID='WFFZRYXXTAB1001' and tbhc.DELFLAG='U' and REPLACE(tbhc.BUSINO0, 'R', 'X') = tardata.SUPECTPEOPLENO)
f1k8f81r364tu	select 'update t_doc_wsqx set mbmc = ''' ||(select templatename from t_doc_template where id = qx.temid) || ' '', mbcode = ''' || (select templatecode from t_doc_template where id = qx.temid) ||''', templateattr =''' || (select templateattr from t_doc_template where id = qx.temid) ||''' , status = '''|| ce.status || ''', processcode = ''' || ce.processcode || ''', username = '''|| ce.username || ''' , loginorgcode = '''|| ce.loginorgcode || ''', loginorgname = '''|| ce.loginorgname || ''', relationtype = '''|| d.relationtype || ''', owner = '''|| (select username from t_sys_user where id = ce.owner) || ''', featurename='''|| ce.featurename || ''', ender = '''|| (select username from t_sys_user where id = ce.ender) ||''', gsdw = '''|| d.gsdw ||''', starttime = '|| decode(ce.starttime, null, 'null', 'to_date(''' || to_char(ce.starttime, 'yyyy-mm-dd hh24:mi:ss') || ''', ''yyyy-mm-dd hh24:mi:ss'') ') ||', endtime = ' || decode(ce.endtime, null, 'null', 'to_date(''' || to_char(ce.endtime, 'yyyy-mm-dd hh24:mi:ss') || ''', ''yyyy-mm-dd hh24:mi:ss'') ') || ', kjsj = ' ||decode(d.kjsj, null, 'null', 'to_date(''' || to_char(d.kjsj, 'yyyy-mm-dd hh24:mi:ss') || ''', ''yyyy-mm-dd hh24:mi:ss'') ') || ', kjrname = '''||(select u.username from t_sys_user u where u.loginid = d.kjrzh) ||''' where id = '''|| qx.id ||'''' from t_doc_wsqx qx left join t_doc_processinstance ce on qx.proid = ce.id left join t_doc_docinstance d on d.id = qx.docid where templateattr is nu ll and rownum < :1
f2y8xja2m3pc6	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') or processins0_.STATUS='98' and (processins0_.PROCESSCODE in ('WCBHHB' , 'CXBHHB' , 'WCBYLAFY' , 'CXBYLAFY' , 'WCBYLAFH' , 'CXBYLAFH'))) 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 (processins0_.OWNERTYPE='01' and processins0_.OWNER=:1 or processins0_.OWNERTYPE='02' and processins0_.OWNORG='4965' and (processins0_.OWNPOSITION in ('P00024'))) group by xsajfaxx2_.AJBH , xsajfaxx2_.AJMC , xsajfaxx2_.ZABID , xsajfaxx2_.CBDW , xsajfaxx2_.AJHJ , xsajfaxx2_.AJLXID )
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) )
fg6cwbc586jr9	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
ft46jny9un0rh	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 '%?%' ) ) ) )
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
fx150d10dr1r7	insert into T_AJBL_XWBL (DATAVERSION, AJLXID, XWCS, BLGSID, RYLXID, KSSJ, JSSJ, XWDD, BXWR, XBID, NL, XZZ, GZDW, BLNR, DAFSID, DASJ, DELFLAG, OPERATERCODE, OPERATETIME, ORGID, HJDZ, ZJLXID, ZJHM, LXDH, LRDWID, LRR, LRRQ, LRRZH, BAJC1XM, BAJC1DW, BAJC1ZW, BAJC2XM, BAJC2DW, BAJC2ZW, CSRQ, SYSJ, BAJC1ZH, BAJC2ZH, XGBLKSSJ, XGBLJSSJ, XGQBLID, MZID, GJID, WHCD, ZZMMID, CYM, sfrddb, BADW, QTDD, ZZDW, BADDID, ID) 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, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52)
fzs2qx64tj6t3	select count(*) as col_0_0_ from T_AJ_XZAJFAXX xzajfaxx0_ where (xzajfaxx0_.SAZT='01' or xzajfaxx0_.SAZT='02') and (xzajfaxx0_.AJBH in (select baz1_.AJBH from T_AJ_BAZ baz1_, T_AJ_BAZCYXX bazcyxx2_ where baz1_.ZBH=bazcyxx2_.ZBH and baz1_.XJBS='1' and bazcyxx2_.SFZAIB='1' and bazcyxx2_.BAMJZH=:1)) and (xzajfaxx0_.AJZT not in ('3210' , '3220' , '3231' , '3232' , '3233')) and (xzajfaxx0_.ajhj='3200' or xzajfaxx0_.ajhj='3300')
g82brgsvjagqn	insert into XCXT_history.H_DOC_WSGD (select * from T_DOC_WSGD where id = :1)
g9pujb3q6jj3w	select * from ( select ry.id, ry.rybh, ry.xm, ry.xbid, ry.nl, ry.hjdid, ry.sfyqk, ry.ssajlx, ry.zzm, ry.zay, p.status spjg, p.loginorgname cqdw, p.endauditime pzrq from t_doc_processinstance p inner join t_doc_processinstanceex ex on ex.processinstanceid = p.id inner join t_ry_wffzryxx ry on ry.rybh = ex.exvalue where p.status in ('99', '98', '05') and p.processcode in ('QSYJS', 'BPBFY', 'BPBFH', 'BQSFY', 'BQSFH') and p.processcode = :1 and ex.exkey = 'RYBH' and p.endauditime >= to_date(:2, 'yyyy-mm-dd hh24:mi:ss') and p.endauditime <= to_date(:3, 'yyyy-mm-dd hh24:mi:ss') ) where rownum <= :4
gfpx0qdgdhgtm	update t_ajgk_ryjbxx set fbztid = '02', fbsj=:1 where fbztid = '01' and operatetime<:2
gn2376b8hgsnu	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') or processins0_.STATUS='98' and (processins0_.PROCESSCODE in ('WCBHHB' , 'CXBHHB' , 'WCBYLAFY' , 'CXBYLAFY' , 'WCBYLAFH' , 'CXBYLAFH'))) 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 )
gn7cfwdrtghx7	select * from ( select j.jcjbh, j.id, j.barmc , j.badwmc , j.jbsj, j.fynr , j.ajlyid , j.sazt, j.cbrzh, j.cljg, j.bjlxid, j.jbr, j.cbr, j.blmjzh, j.czfs, j.jjlxbj, j.instid from T_AJ_JJDJ j where ((j.sazt = '2130' and j.jjlxbj is null) or (j.jjlxbj ='1' and j.sazt in('1101', '2130') and j.yjcbr is not null and j.czfs='01')) 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.blmjzh =:3 order by j.jbsj desc ) where rownum <= :4
grnvkc6sp3uvb	select this_.ID as ID78_0_, this_.DATAVERSION as DATAVERS2_78_0_, this_.JJID as JJID78_0_, this_.ASJBH as ASJBH78_0_, this_.JJBH as JJBH78_0_, this_.ASJLX as ASJLX78_0_, this_.ASJID as ASJID78_0_, this_.OPERATERCODE as OPERATER8_78_0_, this_.OPERATETIME as OPERATET9_78_0_, this_.DELFLAG as DELFLAG78_0_, this_.ORGID as ORGID78_0_, this_.CLJG as CLJG78_0_, this_.CLSJ as CLSJ78_0_, this_.CLDW as CLDW78_0_, this_.CLR as CLR78_0_, this_.JJCLCSFLG as JJCLCSFLG78_0_, this_.INSTID as INSTID78_0_ from T_AJ_JJAJGLXX this_ where this_.ASJBH=:1
gtymnbpt8cy14	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 '%???%' ) ) ) )
guw1c79wpdus0	update t_ajgk_ajjbxx set fbztid = '02', fbsj=:1 where fbztid = '01' and operatetime<:2

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