| SQL Id | SQL Text |
|---|
| 04pb43q59faqj | SELECT COUNT(*) as CT from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.jbsj >= to_Date(:1 , 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:2 , 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:3 or j.cbdw = :4 ) |
| 063ubyj5jwwya | insert into T_DOC_PARAVALUES (INSTANCEID, PARAID, GROUPID, PARACODE, PARAVALUE, CLOBVALUE, OPERATERCODE, OPERATETIME, DOCID, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) |
| 0g88bzkpwa6um | SELECT processinstanceid, gsdw, templateid, docstatus FROM t_doc_docinstance WHERE templateid IN ('402881bf3087d80f01308810854e0035', '402881bf3087d80f0130882dfcf20045') AND operatetime>=:1 AND operatetime<:2 |
| 0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 0yqxf10sf9ua4 | SELECT COUNT(*) as CT FROM (select distinct ce.id , wf.rybh, wf.xm, to_char(wf.csrq, 'yyyy-mm-dd'), wf.xbid, wf.zzm, wf.zay, ce.featureName, ce.username, ce.loginorgname, to_char(ce.starttime, 'yyyy-mm-dd hh24:mi:ss') , jcy.id as jcyid , jcy.jcyjd, wf.sczt, ce.wskjzt , ce.operatetime from t_ry_wffzryxx wf inner join t_doc_processinstance ce on ce.id = wf.dqty inner join t_doc_processinstanceex ex on ex.exvalue = wf.rybh and ex.exkey='RYBH' left join t_ry_jcyyjxx jcy on jcy.rybh = wf.rybh and ce.id=jcy.cqid where ce.status = '99' and ((ce.processcode in ('CQSFBGS', 'LDJYCPBG', 'LDJYSWZXCPB') and ce.wskjzt <> '2') or (ce.processcode in ('CQDBBGS', 'CQQBHSBGS', 'CQJSJZBGS') and (wf.sczt = '05' or ce.wskjzt <> '2'))) and( ( ce.processcode = 'CQDBBGS' and jcy.jcyjd is not null and jcy.tydw = :1 ) or ( ce.processcode in ('CQQBHSBGS', 'CQJSJZBGS', 'CQSFBGS', 'LDJYCPBG', 'LDJYSWZXCPB') and ce.loginorgcode = :2 ) ) ) |
| 102bzpsqnr5fy | select count(*) from (select distinct(SSAJBH), SSAJMC, ID from (select s.SSAJBH, s.SSAJMC, s.ID from T_AJ_SSAJXX s inner join T_AJ_SSAJRYDY s1 on s.SSAJBH=s1.SSAJBH inner join T_RY_WFFZRYXX w on s1.RYBH=w.RYBH inner join T_AJ_BAZ baz on baz.ajbh=s.ssajbh where 1=1 and w.XM like :1 and exists (select 1 from t_sys_organization org where org.orgcode = baz.ssdw and org.treepath like :2 ) )) |
| 14gjtydbsprrs | select distinct sj.sjbh, sj.id, jb.sjlxid, sj.sgdjid, sj.bljgid, sj.zjjjss, to_char(sj.lrrq, 'yyyy-MM-dd HH24:mm:ss'), sj.lrdwid, sj.lrr, jb.zhbs from t_sj_aqzrsg sj inner join t_sj_sjjbxx jb on jb.sjbh=sj.sjbh left join t_sj_sjrydy dy on dy.sjbh=sj.sjbh and dy.rylx in ('02', '12') where jb.sjlxid='11' and jb.sjlyflg is null and ( (sj.operatetime >= :1 and sj.operatetime <= :2) or (dy.operatetime >= :3 and dy.operatetime <= :4)) |
| 17gdjk1wz7xd4 | insert into T_SYS_AUDITRECORD ( ENTITYPRIMARYKEY, ID, IP, OPERATERID, OPERATIONTYPE, OPERATIONUSERLOGINID, RECORDTIME, SYSSIGN, TABLENAME) values (:1 , system_sequence.nextval, :2 , :3 , :4 , :5 , :6 , :7 , :8 ) |
| 1bmvn6cx9yhy3 | update T_SYS_NEWBUSINO set BUSINO = :1 where substr(BUSINO, :2, :3 ) = :4 and substr(BUSINO, :5 , :6) = :7 and BUSITABLENAME = :8 |
| 1f5vm39gzbru8 | insert into T_SYS_AUDITRECORD ( ENTITYPRIMARYKEY, ID, IP, OPERATERID, OPERATIONTYPE, OPERATIONUSERLOGINID, RECORDTIME, SYSSIGN, TABLENAME) values (:1, system_sequence.nextval, :2, :3, :4, :5, :6, :7, :8) |
| 1fzq2h38kugs4 | insert into T_DOC_PARAVALUES (INSTANCEID, PARAID, GROUPID, PARACODE, PARAVALUE, CLOBVALUE, OPERATERCODE, OPERATETIME, DOCID, ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ) |
| 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 |
| 1g5u7m7m9hzm3 |
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 '%?%' ) ) ) ) |
| 1gu8t96d0bdmu | select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) |
| 1jnymwp1qayvn | select node0_.ID as ID2_, node0_.JOINTIME as JOINTIME2_, node0_.CRASHTIME as CRASHTIME2_, node0_.LASTONLINETIME as LASTONLI4_2_, node0_.APPSYSCODE as APPSYSCODE2_, node0_.NODECODE as NODECODE2_, node0_.STATE as STATE2_ from T_MSG_NODE node0_ where node0_.STATE=:1 and node0_.LASTONLINETIME<:2 |
| 1k72pttp8ymkc | select roles0_.USERID as USERID1_, roles0_.ROLEID as ROLEID1_, role1_.ID as ID32_0_, role1_.ROLENAME as ROLENAME32_0_, role1_.ROLECODE as ROLECODE32_0_, role1_.ROLESEQ as ROLESEQ32_0_, role1_.LINKROLESEQ as LINKROLE5_32_0_, role1_.ROLETYPE as ROLETYPE32_0_, role1_.ROLEATTR as ROLEATTR32_0_, role1_.ROLELEVEL as ROLELEVEL32_0_, role1_.CREATORID as CREATORID32_0_, role1_.CREATORORGID as CREATOR10_32_0_, role1_.TREEPATH as TREEPATH32_0_, role1_.DISPLAYORDER as DISPLAY12_32_0_, role1_.DESCN as DESCN32_0_, role1_.DELFLAG as DELFLAG32_0_, role1_.OPERATERCODE as OPERATE15_32_0_, role1_.OPERATETIME as OPERATE16_32_0_ from T_SYS_USER_ROLE roles0_ left outer join T_SYS_ROLE role1_ on roles0_.ROLEID=role1_.ID where roles0_.USERID=:1 |
| 1v3xhckdx2bks |
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 '%???%' ) ) ) ) |
| 1wb10sa7xmfza | select * from ( select j.jcjbh, j.id, j.barmc, j.badwmc, j.jbsj, j.fynr , j.ajlyid , j.sazt, j.cbr, (case when gl.cljg is null then j.cljg else gl.cljg end) cljg, j.bjlxid, gl.asjbh, j.jjlxbj, gl.clsj, gl.INSTID from T_AJ_JJDJ j left join T_AJ_JJAJGLXX gl on j.id = gl.jjid where j.SFYCLID = '1' and j.ajlyid =:1 and j.jbsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and j.jbsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi:ss') and (j.jbdwid =:4 or j.cbdw = :5 ) order by j.jbsj desc ) where rownum <= :6 |
| 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) ) |
| 1x940bsj4a9dd |
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 |
| 1z5swa0st2vx0 | select cl.gldxbh from t_dzjz_cl cl where cl.jnclid=:1 |
| 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 ) ) |
| 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 |
| 2d10pszrnryjv | 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 j.jcjbh like :3 and exists (select 1 from t_ry_jjryxx ry where ry.jcjbh = j.jcjbh and ry.rylx = :4) ) |
| 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 ) |
| 2q93zsrvbdw48 | select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee# |
| 2sk72pua5yxf0 |
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 ) an
d 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 ) ) |
| 2wyjpxjtb5ry5 |
SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1 ) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.y
scbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3 ) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) ) |
| 36a1kc80dqaw6 | select * from ( select docid, tid, pid, dxbh, cqty, wsmc, cqr, cqdw, cqtime, docstatus, doctype, id, docurl, templatetype, html from (select docins.id docid, docins.templateid tid, docins.processinstanceid pid, pro.instcode dxbh, pro.processcode cqty, (case when tem.templatetype = '02' then tem.templatename else(select b.processname from t_doc_busiprocess b where b.id = pro.processid)end) wsmc, pro.username cqr, pro.loginorgname cqdw, pro.starttime cqtime, docins.docstatus, docins.doctype, pro.id, docins.docUrl, tem.templatetype templatetype, tem.html html from t_doc_docinstance docins, t_doc_processinstance pro, t_doc_template tem where docins.processinstanceid = pro.id and docins.docstatus in ('02', '03') and tem.id = docins.templateid and docins.orgid in (select o.orgcode from t_sys_organization o where o.treepath like :1)) where 1=1 order by cqtime desc ) where rownum <= :2 |
| 38vp2757zqgsp | select * from t_doc_approvalrecord app inner join t_doc_processinstance ce on ce.id = app.instanceid where app.operatercode = :1 and (ce.instcode = :2 or (exists (select 1 from t_aj_xsajrydy dy where dy.ajbh = ce.instcode and dy.rybh = :3) or exists (select 1 from t_aj_xzajrydy dy where dy.ajbh = ce.instcode and dy.rybh = :4) or exists (select 1 from t_aj_ssajrydy dy where dy.ssajbh = ce.instcode and dy.rybh = :5))) |
| 3sxvgjrht9560 | select * 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 j.jcjbh like :3 order by j.jbsj desc ) where rownum <= :4 |
| 45aj6ah0vah3m |
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_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and (ce.status = '99' or (ce.status = '98' and ce.processcode in ('WCBHHB', 'CXBHHB', 'WCBYLAFY', 'WCBYLAFH', 'CXBYLAFY', 'CXBYLAFH'))) and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :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 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 (ce.status = '99' or (ce.status = '98' and ce.processcode = 'CQTZSPB')) and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :2 ) and exists (select 1 from t_aj_xzajr
ydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) orde) |
| 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 |
| 4hunra4jb06u8 |
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 '%???%' ) ) ) ) |
| 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 |
| 4pdjmykw87rpu |
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 '%?%' ) )) )
|
| 4ux3j614h6tka | SELECT COUNT(*) as CT FROM (select distinct xs.ajbh, xs.ajmc, xs.cbdw, xs.cbr, '' as id, '' as bllx, xs.zabid from t_doc_wsqx qx inner join t_aj_xsajfaxx xs on qx.asjbh = xs.ajbh where qx.treepath like '11000000000000.11010200000000.11010214000000.11010214120000%' and xs.ajzt != '2904' and xs.ajmc like :1) |
| 51rsr55czhjty | SELECT COUNT(*) as CT from t_aj_xzajfaxx xz where 1=1 and xz.ajzt <> '3210' and xz.ajlxid = :1 and xz.slsj>= to_Date(:2, 'yyyy-MM-dd hh24:mi:ss') and xz.slsj <= to_Date(:3, '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 = xz.ajbh and org.treepath like '11000000000000.11010900000000%') |
| 52df6ngwqbjxb | select * from ( select distinct xs.ajbh, xs.ajmc, xs.cbdw, xs.cbr, '' as id, '' as bllx, xs.zabid from t_doc_wsqx qx inner join t_aj_xsajfaxx xs on qx.asjbh = xs.ajbh where qx.treepath like '11000000000000.11010200000000.11010214000000.11010214120000%' and xs.ajzt != '2904' and xs.ajmc like :1 ) where rownum <= :2 |
| 5mwjj2bk5k1q6 | SELECT COUNT(*) as CT FROM (select distinct s.SSAJBH, s.SSAJMC, s.cbdw, s.cbrzh, s.SSAJLX, s.OPERATETIME from T_AJ_SSAJXX s where 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 (ce.status = '99' or (ce.status = '98' and ce.processcode in ('CQTZSPB', 'LDJYSWZXCPB', 'LDJYCPBG', 'WCBHHB', 'CXBHHB') )) and ex.exkey IN ('AJBH', 'SSAJBH') and ex.exvalue = s.ssajbh and app.operatercode = :1 ) and exists (select 1 from t_aj_ssajrydy rydy inner join t_ry_wffzryxx wfry on rydy.rybh = wfry.rybh where rydy.ssajbh =s.ssajbh and wfry.xm like '%???%' ) ) |
| 5n1fs4m2n2y0r | select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1 |
| 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) |
| 5tvhd2n9an2ht |
SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.username like :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 wsqx.username like :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') ) |
| 5vrw3bsnmarcc | select *
from (select row_.*, rownum rownum_
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 = 'CQDBBGS'
and ex.exkey = 'RYBH'
and p.endauditime >= to_date('2013-11-01', 'yyyy-mm-dd hh24:mi:ss')
and p.endauditime <= to_date('2013-11-30', 'yyyy-mm-dd hh24:mi:ss')) row_
where rownum <= 10)
where rownum_ > 5
|
| 678wkpfz8gj15 | select * from ( select row_.*, rownum rownum_ 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') ) row_ where rownum <= :4) where rownum_ > :5 |
| 6aq34nj2zb2n7 | select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# |
| 6dm1cncay96bd |
SELECT COUNT(*) as CT FROM (select distinct ajbh, ajmc, cbdw, cbr, ajlx, operatetime from (select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xs.ajbh and bazcyxx.bamjzh = :1 ) and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xs.ajbh, xs.ajmc, decode(xs.yscbdw, null, xs.cbdw, xs.yscbdw) as cbdw, decode(xs.yscbr, null, xs.cbr, xs.yscbr) as cbr, cast('01' as varchar2(2)) as ajlx, xs.operatetime from t_aj_xsajfaxx xs where xs.ajzt <> '2904' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and ce.status = '99' and ex.exkey = 'AJBH' and ex.exvalue = xs.ajbh and app.operatercode = :2 and exists (select 1 from t_aj_xsajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xs.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.y
scbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from T_AJ_Baz baz, T_AJ_Bazcyxx bazcyxx where baz.zbh = bazcyxx.zbh and baz.ajbh = xz.ajbh and bazcyxx.bamjzh = :3 ) and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) union all select xz.ajbh, xz.ajmc, decode(xz.yscbdw, null, xz.cbdw, xz.yscbdw), decode(xz.yscbr, null, xz.zbmj, xz.yscbr), cast('02' as varchar2(2)) as ajlx, xz.operatetime from t_aj_xzajfaxx xz where xz.ajzt <> '3210' and exists (select 1 from t_doc_processinstance ce, t_doc_processinstanceex ex, t_doc_approvalrecord app where ce.id = ex.processinstanceid and ce.id = app.instanceid and app.approvalstage in ('01', '02', '06') and (ce.status = '99' or ce.status = '98' and ce.processcode = 'CQTZSPB') and ex.exkey = 'AJBH' and ex.exvalue = xz.ajbh and app.operatercode = :4 and exists (select 1 from t_aj_xzajrydy rydy inner join t_ry_saryjbxx ryxx on rydy.rybh = ryxx.rybh where xz.ajbh = rydy.ajbh and ryxx.ryxm like '%???%' ) ) ) ) |
| 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 6hryrjqknhcxy | SELECT COUNT(*) as CT FROM (select distinct x.id, x.ajbh, x.zabid, x.pcsgxid, x.fakssj, x.jyaq, x.ajmc from T_AJ_XZAJFAXX x inner join t_aj_baz baz on baz.ajbh = x.ajbh left join t_aj_ssajzcrdajdy dy on dy.ajbh = x.ajbh where x.ajzt <> '3210' and x.ajmc like :1 and exists (select 1 from t_sys_organization org where org.orgcode = baz.ssdw and org.treepath like :2 ) ) |
| 6j0dx3u6zxhqn |
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 '%?%' ) ) ) ) |
| 6mvfay19q3v4n | SELECT COUNT(CLIENT_INFO) FROM GV$SESSION WHERE USERNAME=:B2 AND CLIENT_INFO = :B1 GROUP BY CLIENT_INFO |
| 6pgr2c9ap71hz |
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 '%???%' ) ) ) ) |
| 71gw0sn0x70ww | 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') 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 :2 and wsqx.cqdx not in ('05', '06') ) |
| 74r56hrgv1zsb | SELECT COUNT(*) as CT from t_aj_xsajfaxx aj , t_ry_wffzryxx wf , t_aj_xsajrydy dy, t_ry_ryclxx cl where 1=1 and aj.ajbh = dy.ajbh and wf.rybh = dy.rybh and wf.rybh = cl.rybh and aj.ajzt <> '2904' and cl.cljd not in ('101', '102', '103', '104', '105', '201', '202', '203') and wf.zjhm like :1 and wf.zjzlid = :2 |
| 76t7yz2zc3agj |
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 |
| 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 |
| 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# |
| 7nuw4xwrnuwxq | select col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc |
| 7wp82bt4z1u1p | select *
from (select row_.*, rownum rownum_
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 = 'CQDBBGS'
and ex.exkey = 'RYBH'
and p.endauditime >= to_date('2013-09-01', 'yyyy-mm-dd hh24:mi:ss')
and p.endauditime <= to_date('2013-09-30', 'yyyy-mm-dd hh24:mi:ss')) row_
where rownum <= 100)
---where rownum_ > 100
|
| 80jv8pa61btvq | SELECT COUNT(*) as CT FROM (select distinct wtjl0_.ID as ID245_, wtjl0_.DATAVERSION as DATAVERS2_245_, wtjl0_.INSTANCEID as INSTANCEID245_, wtjl0_.AJBH as AJBH245_, wtjl0_.AJMC as AJMC245_, wtjl0_.AJLXID as AJLXID245_, wtjl0_.JCLXID as JCLXID245_, wtjl0_.ZXJCMC as ZXJCMC245_, wtjl0_.JCDWCJID as JCDWCJID245_, wtjl0_.ZFJCDWID as ZFJCDWID245_, wtjl0_.ZFJCDWMC as ZFJCDWMC245_, wtjl0_.ZFJCSJ as ZFJCSJ245_, wtjl0_.ZFJCMJZH as ZFJCMJZH245_, wtjl0_.ZFJCMJXM as ZFJCMJXM245_, wtjl0_.ZRHJID as ZRHJID245_, wtjl0_.ZRDWID as ZRDWID245_, wtjl0_.BAMJDWID as BAMJDWID245_, wtjl0_.BADWMC as BADWMC245_, wtjl0_.LRR as LRR245_, wtjl0_.LRRZH as LRRZH245_, wtjl0_.LRDWID as LRDWID245_, wtjl0_.LRRQ as LRRQ245_, wtjl0_.SFCQJCCSID as SFCQJCCSID245_, wtjl0_.DELFLAG as DELFLAG245_, wtjl0_.OPERATERCODE as OPERATE25_245_, wtjl0_.OPERATETIME as OPERATE26_245_, wtjl0_.ORGID as ORGID245_, wtjl0_.DQBAZBH as DQBAZBH245_, wtjl0_.SSAJLX as SSAJLX245_, wtjl0_.BJCDWID as BJCDWID245_, wtjl0_.BJCDWMC as BJCDWMC245_, wtjl0_.GLDXBH as GLDXBH245_, wtjl0_.SFZGID as SFZGID245_ from T_ZFJD_WTJL wtjl0_, T_ZFJD_LCWTDY lcwtdy1_ where wtjl0_.ID=lcwtdy1_.WTJLID and (wtjl0_.AJBH like :1 )) |
| 81zzs84239d3a | select count(1) from t_ajgk_dbxx aj where exists (select 1 from t_sys_organization o where o.treepath like :1 and aj.cbdwid = o.orgcode) and aj.cbrzh = :2 and aj.dbztid = '1' order by aj.scsj desc |
| 83taa7kaw59c1 | select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol# |
| 87gaftwrm2h68 | select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1 |
| 89b1uuwdxpc7h |
SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and wsqx.kjsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:5, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqxhis wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and wsqx.kjsj >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:8, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:10, 'yyyy-MM-dd hh24:mi') )
|
| 89umf66sq7u3m | 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 |
| 8an252w64g4dn | select * from ( select distinct xs.ajbh, xs.ajmc, xs.cbdw, xs.cbr, '' as id, '' as bllx, xs.zabid from t_doc_wsqx qx inner join t_aj_xsajfaxx xs on qx.asjbh = xs.ajbh where qx.treepath like '11000000000000.11010600000000.11010665000000%' and xs.ajzt != '2904' and xs.ajmc like :1 ) where rownum <= :2 |
| 8f1sjvfxuup9w | select t.*, o.*, m.comments
from sys.all_tables t,
sys.all_tab_comments m,
sys.all_objects o
where t.owner = :object_owner
and t.table_name = :object_name
and m.owner (+) = :object_owner
and m.table_name (+) = :object_name
and o.owner (+) = :object_owner
and o.object_name (+) = :object_name
and :object_type is not null
and :sub_object is null
|
| 8h0gb4knma8rg | 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 = 'CQDBBGS'
and ex.exkey = 'RYBH'
and p.endauditime >= to_date('2013-09-01', 'yyyy-mm-dd hh24:mi:ss')
and p.endauditime <= to_date('2013-09-30 23:59:59', 'yyyy-mm-dd hh24:mi:ss'))
where rownum <= 20
|
| 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 |
| 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 ) |
| 9j3zsccc5r27b |
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 '%??%' ) ) ) ) |
| 9mjkv1ars6wmw | select d.ID, d.DOCSTATUS, d.TEMPLATEID, t.TEMPLATENAME, t.HTML, d.DOCURL, t.TEMPLATECODE, d.CJSQ as CREATEDATE, '' , '' , t.isfltk, '' as XM, d.wordbytes from T_DOC_DOCINSTANCE d, T_DOC_TEMPLATE t where d.TEMPLATEID = t.ID and t.TEMPLATETYPE = :1 and d.PROCESSINSTANCEID = :2 and d.DOCTYPE = :3 |
| 9nf03da55umw5 |
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 |
| 9q41xj42auqyd | SELECT COUNT(*) as CT from t_aj_xzajfaxx xz where 1=1 and xz.ajzt <> '3210' and xz.ajlxid = :1 and xz.ajmc like :2 and exists (select 1 from t_aj_baz baz inner join t_aj_bazcyxx cy on cy.zbh = baz.zbh inner join t_sys_organization org on org.orgcode = cy.dwid where baz.ajbh = xz.ajbh and org.treepath like '11000000000000.11022400000000%') |
| a1xgxtssv5rrp | select sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts# |
| a4nsb6fq5b41b |
select user0_.ID as ID37_6_, user0_.USERNAME as USERNAME37_6_, user0_.LOGINID as LOGINID37_6_, user0_.PASSWD as PASSWD37_6_, user0_.INITIALPASSWD as INITIALP5_37_6_, user0_.REVERSIBLEPASSWD as REVERSIB6_37_6_, user0_.USERTYPE as USERTYPE37_6_, user0_.LOCKEDTIME as LOCKEDTIME37_6_, user0_.UNLOCKEDTIME as UNLOCKED9_37_6_, user0_.QUESTIONCONTENT as QUESTIO10_37_6_, user0_.QUESTIONANSWER as QUESTIO11_37_6_, user0_.STATUS as STATUS37_6_, user0_.SPELLCODE as SPELLCODE37_6_, user0_.DISPLAYORDER as DISPLAY14_37_6_, user0_.DESCN as DESCN37_6_, user0_.DELFLAG as DELFLAG37_6_, user0_.OPERATERCODE as OPERATE17_37_6_, user0_.OPERATETIME as OPERATE18_37_6_, user0_.USERINFOID as USERINFOID37_6_, user0_.ORGID as ORGID37_6_, user0_.MANAGERORGID as MANAGER21_37_6_, user0_.MAJORPOSITIONID as MAJORPO22_37_6_, userinfo1_.ID as ID38_0_, userinfo1_.USERNAME as USERNAME38_0_, userinfo1_.USERCODE as USERCODE38_0_, userinfo1_.GENDER as GENDER38_0_, userinfo1_.PERSONTYPE as PERSONTYPE38_0_, userinfo1_.IDCARD as IDCARD38_0_, userinfo1_.SPELLCODE as SPELLCODE38_0_, userinfo1_.DUTYLEVEL as DUTYLEVEL38_0_, userinfo1_.FORMERNAME as FORMERNAME38_0_, userinfo1_.NATIVEPLACE as NATIVEP10_38_0_, userinfo1_.BIRTHDAY as BIRTHDAY38_0_, userinfo1_.POLITICALSTATUS as POLITIC12_38_0_, userinfo1_.ADDRESS as ADDRESS38_0_, userinfo1_.POSTCODE as POSTCODE38_0_, userinfo1_.OFFICEPHONE as OFFICEP15_38_0_, userinfo1_.MOBILEPHONE as MOBILEP16_38_0_, userinfo1_.HOMEPHONE as HOMEPHONE38_0_,
userinfo1_.FAX as FAX38_0_, userinfo1_.EMAIL as EMAIL38_0_, userinfo1_.DISPLAYORDER as DISPLAY20_38_0_, userinfo1_.DESCN as DESCN38_0_, userinfo1_.DELFLAG as DELFLAG38_0_, userinfo1_.OPERATERCODE as OPERATE23_38_0_, userinfo1_.OPERATETIME as OPERATE24_38_0_, userinfo1_.ORGID as ORGID38_0_, userinfo1_.MAJORPOSITIONID as MAJORPO26_38_0_, organizati2_.ID as ID20_1_, organizati2_.QZMC as QZMC20_1_, organizati2_.QZH as QZH20_1_, organizati2_.ORGNAME as ORGNAME20_1_, organizati2_.ORGCODE as ORGCODE20_1_, organizati2_.ORGABBRNAME as ORGABBRN6_20_1_, organizati2_.INNERCODE as INNERCODE20_1_, organizati2_.ORGTYPE as ORGTYPE20_1_, organizati2_.ORGLEVEL as ORGLEVEL20_1_, organizati2_.VIRTUALFLAG as VIRTUAL10_20_1_, organizati2_.UNITFLAG as UNITFLAG20_1_, organizati2_.BUSIFLAG as BUSIFLAG20_1_, organizati2_.DIRECTLYUNDERFLAG as DIRECTL13_20_1_, organizati2_.BUSIAREA as BUSIAREA20_1_, organizati2_.ADDRESS as ADDRESS20_1_, organizati2_.POSTCODE as POSTCODE20_1_, organizati2_.TELEPHONE as TELEPHONE20_1_, organizati2_.TELEGRAPHONE as TELEGRA18_20_1_, organizati2_.FAX as FAX20_1_, organizati2_.EMAIL as EMAIL20_1_, organizati2_.MANAGERID as MANAGERID20_1_, organizati2_.MANAGERNAME as MANAGER22_20_1_, organizati2_.TREEPATH as TREEPATH20_1_, organizati2_.STATUS as STATUS20_1_, organizati2_.DISPLAYORDER as DISPLAY25_20_1_, organizati2_.UNITID as UNITID20_1_, organizati2_.ALIASNAME as ALIASNAME20_1_, organizati2_.DESCN as DESCN20_1_, organizati2_.DELFLAG as D
ELFLAG20_1_, organizati2_.OPERATERCODE as OPERATE30_20_1_, organizati2_.OPERATETIME as OPERATE31_20_1_, organizati2_.PARENTID as PARENTID20_1_, position3_.ID as ID26_2_, position3_.POSITIONNAME as POSITION2_26_2_, position3_.POSITIONCODE as POSITION3_26_2_, position3_.POSITIONTYPE as POSITION4_26_2_, position3_.POSITIONLEVEL as POSITION5_26_2_, position3_.DISPLAYORDER as DISPLAYO6_26_2_, position3_.DESCN as DESCN26_2_, position3_.DELFLAG as DELFLAG26_2_, position3_.OPERATERCODE as OPERATER9_26_2_, position3_.OPERATETIME as OPERATE10_26_2_, organizati4_.ID as ID20_3_, organizati4_.QZMC as QZMC20_3_, organizati4_.QZH as QZH20_3_, organizati4_.ORGNAME as ORGNAME20_3_, organizati4_.ORGCODE as ORGCODE20_3_, organizati4_.ORGABBRNAME as ORGABBRN6_20_3_, organizati4_.INNERCODE as INNERCODE20_3_, organizati4_.ORGTYPE as ORGTYPE20_3_, organizati4_.ORGLEVEL as ORGLEVEL20_3_, organizati4_.VIRTUALFLAG as VIRTUAL10_20_3_, organizati4_.UNITFLAG as UNITFLAG20_3_, organizati4_.BUSIFLAG as BUSIFLAG20_3_, organizati4_.DIRECTLYUNDERFLAG as DIRECTL13_20_3_, organizati4_.BUSIAREA as BUSIAREA20_3_, organizati4_.ADDRESS as ADDRESS20_3_, organizati4_.POSTCODE as POSTCODE20_3_, organizati4_.TELEPHONE as TELEPHONE20_3_, organizati4_.TELEGRAPHONE as TELEGRA18_20_3_, organizati4_.FAX as FAX20_3_, organizati4_.EMAIL as EMAIL20_3_, organizati4_.MANAGERID as MANAGERID20_3_, organizati4_.MANAGERNAME as MANAGER22_20_3_, organizati4_.TREEPATH as TREEPATH20_3_, organizati4_.
STATUS as STATUS20_3_, organizati4_.DISPLAYORDER as DISPLAY25_20_3_, organizati4_.UNITID as UNITID20_3_, organizati4_.ALIASNAME as ALIASNAME20_3_, organizati4_.DESCN as DESCN20_3_, organizati4_.DELFLAG as DELFLAG20_3_, organizati4_.OPERATERCODE as OPERATE30_20_3_, organizati4_.OPERATETIME as OPERATE31_20_3_, organizati4_.PARENTID as PARENTID20_3_, organizati5_.ID as ID20_4_, organizati5_.QZMC as QZMC20_4_, organizati5_.QZH as QZH20_4_, organizati5_.ORGNAME as ORGNAME20_4_, organizati5_.ORGCODE as ORGCODE20_4_, organizati5_.ORGABBRNAME as ORGABBRN6_20_4_, organizati5_.INNERCODE as INNERCODE20_4_, organizati5_.ORGTYPE as ORGTYPE20_4_, organizati5_.ORGLEVEL as ORGLEVEL20_4_, organizati5_.VIRTUALFLAG as VIRTUAL10_20_4_, organizati5_.UNITFLAG as UNITFLAG20_4_, organizati5_.BUSIFLAG as BUSIFLAG20_4_, organizati5_.DIRECTLYUNDERFLAG as DIRECTL13_20_4_, organizati5_.BUSIAREA as BUSIAREA20_4_, organizati5_.ADDRESS as ADDRESS20_4_, organizati5_.POSTCODE as POSTCODE20_4_, organizati5_.TELEPHONE as TELEPHONE20_4_, organizati5_.TELEGRAPHONE as TELEGRA18_20_4_, organizati5_.FAX as FAX20_4_, organizati5_.EMAIL as EMAIL20_4_, organizati5_.MANAGERID as MANAGERID20_4_, organizati5_.MANAGERNAME as MANAGER22_20_4_, organizati5_.TREEPATH as TREEPATH20_4_, organizati5_.STATUS as STATUS20_4_, organizati5_.DISPLAYORDER as DISPLAY25_20_4_, organizati5_.UNITID as UNITID20_4_, organizati5_.ALIASNAME as ALIASNAME20_4_, organizati5_.DESCN as DESCN20_4_, organizati5_.DE
LFLAG as DELFLAG20_4_, organizati5_.OPERATERCODE as OPERATE30_20_4_, organizati5_.OPERATETIME as OPERATE31_20_4_, organizati5_.PARENTID as PARENTID20_4_, position6_.ID as ID26_5_, position6_.POSITIONNAME as POSITION2_26_5_, position6_.POSITIONCODE as POSITION3_26_5_, position6_.POSITIONTYPE as POSITION4_26_5_, position6_.POSITIONLEVEL as POSITION5_26_5_, position6_.DISPLAYORDER as DISPLAYO6_26_5_, position6_.DESCN as DESCN26_5_, position6_.DELFLAG as DELFLAG26_5_, position6_.OPERATERCODE as OPERATER9_26_5_, position6_.OPERATETIME as OPERATE10_26_5_ from T_SYS_USER user0_ left outer join T_SYS_USERINFO userinfo1_ on user0_.USERINFOID=userinfo1_.ID left outer join T_SYS_ORGANIZATION organizati2_ on userinfo1_.ORGID=organizati2_.ID left outer join T_SYS_POSITION position3_ on userinfo1_.MAJORPOSITIONID=position3_.ID left outer join T_SYS_ORGANIZATION organizati4_ on user0_.ORGID=organizati4_.ID left outer join T_SYS_ORGANIZATION organizati5_ on user0_.MANAGERORGID=organizati5_.ID left outer join T_SYS_POSITION position6_ on user0_.MAJORPOSITIONID=position6_.ID where user0_.ID=:1 |
| a6j557zy695dg |
select * from ( select * from ( select distinct xsajfaxx.ajbh, xsajfaxx.ajmc, xsajfaxx.zabid, xsajfaxx.cbdw, xsajfaxx.ajhj, xsajfaxx.ajlxid , max(PROCESSINSTANCE.operatetime) as operatetime from T_DOC_PROCESSINSTANCE PROCESSINSTANCE inner join T_DOC_PROCESSINSTANCEEX PROCESSINSTANCEEX on PROCESSINSTANCE.Id = PROCESSINSTANCEEX.PROCESSINSTANCEID inner join t_aj_xsajfaxx xsajfaxx on xsajfaxx.ajbh = PROCESSINSTANCEEX.Exvalue and PROCESSINSTANCEEX.EXKEY = 'AJBH' where PROCESSINSTANCE.ownertype = '03' and xsajfaxx.ajzt!='2904' and PROCESSINSTANCE.status = '02' and PROCESSINSTANCE.id not in (select ex.processInstanceid from T_DOC_PROCESSINSTANCEEX ex where ex.exkey = 'SSAJBH' and ex.processInstanceid = PROCESSINSTANCEEX.PROCESSINSTANCEID ) and PROCESSINSTANCE.Ownorg in (SELECT a.id FROM t_sys_organization a, t_sys_organization b , t_sys_organization c WHERE b.orgcode = :1 and a.orgcode like :2 and c.orgcode like :3 and a.busiarea <> '700' and ((b.directlyunderflag='0' and a.orglevel = 3 ) or ( b.directlyunderflag='1' and b.busiarea = '400' and c.busiarea<>'400' and c.orglevel = 2 and a.orglevel = 3 ) or ( b.directlyunderflag='1' and b.busiarea != '400' and a.orglevel = 2 ) or ( b.directlyunderflag='1' and b.busiarea = '400' and c.busiarea='400' and a.orglevel = 2 ) )) group by xsajfaxx.ajbh, xsajfaxx.ajmc, xsajfaxx.zabid, xsajfaxx.cbdw, xsajfaxx.ajhj, xsajfaxx.ajlxid ) order by operatetime desc ) where rownum <= :4
|
| a73wbv1yu8x5c | select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1 |
| a9hb1kr2hyffj |
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
|
| a9r5cghp8udny |
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 '%?%' ) ) ) ) |
| aaf9ptqwap0nc | select LoginId, UserName from t_sys_user where orgid = :1 |
| aaytnkmkkyt0p | SELECT COUNT(*) as CT from t_ry_saryjbxx ry where ry.rylx in ('04', '05') |
| acwz5t51du5bj | update T_RY_JJRYXX set DATAVERSION=:1, JCJBH=:2, RYLX=:3, XM=:4, XBID=:5, NL=:6, SFZH=:7, DH=:8, GZDW=:9, JZDID=:10, JZDXZ=:11, HJDID=:12, HJDXZ=:13, GJID=:14, SWSFID=:15, ZJLXID=:16, ZJHM=:17, XMPYM=:18, OPERATERCODE=:19, OPERATETIME=:20, DELFLAG=:21, ORGID=:22, TSSF=:23, RYBH=:24, CSRQ=:25, JJID=:26 where ID=:27 and DATAVERSION=:28 |
| af2sb9qgg4cf7 | select messagedet0_.ID as ID1_, messagedet0_.STATE as STATE1_, messagedet0_.RESENDSIZE as RESENDSIZE1_, messagedet0_.CHANNELNAME as CHANNELN4_1_, messagedet0_.SENDOBJECTKEY as SENDOBJE5_1_, messagedet0_.SENDDATE as SENDDATE1_, messagedet0_.SRCNODEID as SRCNODEID1_, messagedet0_.DESTNODEID as DESTNODEID1_ from T_MSG_MESSAGEDETAIL messagedet0_, T_MSG_NODE node1_, T_MSG_NODE node2_ where messagedet0_.SRCNODEID=node1_.ID and messagedet0_.DESTNODEID=node2_.ID and node1_.NODECODE=:1 and messagedet0_.STATE=:2 and (node2_.NODECODE in ('XCXT$8080$60:EB:69:8F:81:9A' , 'XCXT$8080$60:EB:69:8F:82:60' , 'XCXT$8080$60:EB:69:8F:82:9C' , 'XCXT$8080$60:EB:69:82:38:18' , 'XCXT$8080$60:EB:69:8F:84:0A' , 'XCXT$8080$60:EB:69:8F:81:B8' , 'XCXT$8080$60:EB:69:8F:84:88' , 'XCXT$8080$60:EB:69:82:3B:42' , 'XCXT$8080$60:EB:69:8F:81:C4' , 'XCXT$8080$60:EB:69:8F:84:40' , 'uums$8080$60:EB:69:8F:83:62' , 'XCXT$8080$60:EB:69:8F:83:E0' , 'XCXT$8080$60:EB:69:8F:83:56')) |
| 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 )
|
| avbs6u99k5ggm | insert into T_DZJZ_FJ (DATAVERSION, FILEDESC, FILETYPE, CLUPTIME, FILESIZE, PX, FILERELATIONID, FJ, OPERATETIME, OPERATERCODE, DELFLAG, ORGID, FILENAME, FTPPATH, ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 ) |
| b35d4ty7kkh0g |
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 '%?%' ) ) ) ) |
| b6qkb2dh75u7x | select count(1) from t_dc_bbxx bbxx where bbxx.cssj is null and bbxx.bbmjzh = :1 |
| b6qtrn4pqycjc | select x.id rid, x.resourcename, x.resourcecode, x.resourcetype, x.classname, x.methodname, x.realid, x.realresource, y.id mid, y.modulename, y.modulecode, y.modulecontent from t_sys_resource x, t_sys_module y where x.moduleid=y.id(+) and x.id in (select resourceid from t_sys_permission_resource where permissionid in (select permissionid from t_sys_role_permission where roleid in (select roleid from t_sys_user_role where userid=(select id from t_sys_user where loginid=:1) union select roleid from t_sys_role_group where groupid in (select groupid from t_sys_user_group where userid=(select id from t_sys_user where loginid=:2))))) and x.resourcetype=:3 order by x.resourcetype, y.modulecode |
| b6x7r0m21108m | SELECT COUNT(*) as CT FROM (select distinct xs.ajbh, xs.ajmc, xs.cbdw, xs.cbr, '' as id, '' as bllx, xs.zabid from t_doc_wsqx qx inner join t_aj_xsajfaxx xs on qx.asjbh = xs.ajbh where qx.treepath like '11000000000000.11022100000000.11022144000000%' and xs.ajzt != '2904' and xs.ajbh like :1) |
| ba2my4bz5bkac | select distinct w.rybh, w.xm, w.xbid, w.csrq, w.zzm, w.zay, w.dqty, w.SAZT, p.FEATURENAME from T_RY_WFFZRYXX w inner join T_DOC_PROCESSINSTANCE p on p.id=w.dqty where ((w.sczt <> '00' and w.sczt <> '08') or w.sczt is null) and w.sazt='01' and p.status='01' and ( exists ( select 1 from T_AJ_XSAJRYDY xs1 inner join T_AJ_XSAJFAXX xs2 on xs1.ajbh = xs2.ajbh inner join T_AJ_BAZ baz on baz.ajbh = xs1.ajbh inner join T_AJ_BAZCYXX bazcyxx on baz.zbh = bazcyxx.zbh where xs2.ajzt <> '2904' and baz.xjbs = '1' and bazcyxx.sfzaib = '1' and bazcyxx.bamjzh = :1 and xs1.rybh = w.rybh ) or exists( select 1 from T_AJ_XZAJRYDY xz1 inner join T_AJ_XZAJFAXX xz2 on xz1.ajbh = xz2.ajbh inner join T_AJ_BAZ baz on baz.ajbh = xz1.ajbh inner join T_AJ_BAZCYXX bazcyxx on baz.zbh = bazcyxx.zbh where xz2.ajzt <> '3210' and baz.xjbs = '1' and bazcyxx.sfzaib = '1' and bazcyxx.bamjzh = :2 and xz1.rybh = w.rybh ) ) and not exists(select 1 From t_doc_processinstance a where a.instcode = w.rybh and a.status='02' and a.INSTANCETYPE='02') order by w.xm desc |
| baqagyab0xkuk | SELECT COUNT(*) as CT from t_aj_xzajfaxx xz where 1=1 and xz.ajzt <> '3210' and xz.slsj>= to_Date(:1, 'yyyy-MM-dd hh24:mi:ss') and xz.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 = xz.ajbh and org.treepath like '11000000000000.11010900000000%') |
| bb7txdb9wvf64 | select count(*) as CT from (select distinct xz.id, xz.ajbh, xz.ajmc, xz.ajlxid, '', xm, xz.zabid, ys.ysdw, ys.ysrq, '2' ajflg, xz.operatetime
from t_aj_xzajfaxx xz left join t_aj_xzajrydy dy on xz.id = dy.ajid and xz.ajzt = '3233'
left join t_ry_wffzryxx ry on ry.id = dy.ryid and dy.rylx = '05' inner join t_aj_ajys ys on xz.id = ys.ajid and ys.yszt = '3233'
where 1 = 1 and ys.swdw = :1) |
| bd1fv4qh3kmza |
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 '%?%' ) ) ) ) |
| bgxj7k14bn8b9 | select * 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) order by j.jbsj desc ) where rownum <= :4 |
| bh5fd8zfx9s5j |
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 '%???%' ) )) )
|
| 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 |
| bkgut04j15ssg |
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 '%?%' ) )) )
|
| bkmqqbhuzcqzy | select messagedet0_.ID as ID1_, messagedet0_.STATE as STATE1_, messagedet0_.RESENDSIZE as RESENDSIZE1_, messagedet0_.CHANNELNAME as CHANNELN4_1_, messagedet0_.SENDOBJECTKEY as SENDOBJE5_1_, messagedet0_.SENDDATE as SENDDATE1_, messagedet0_.SRCNODEID as SRCNODEID1_, messagedet0_.DESTNODEID as DESTNODEID1_ from T_MSG_MESSAGEDETAIL messagedet0_, T_MSG_NODE node1_, T_MSG_NODE node2_ where messagedet0_.SRCNODEID=node1_.ID and messagedet0_.DESTNODEID=node2_.ID and node1_.NODECODE=:1 and messagedet0_.STATE=:2 and (node2_.NODECODE in ('XCXT$8080$60:EB:69:8F:81:9A' , 'XCXT$8080$60:EB:69:8F:82:60' , 'XCXT$8080$60:EB:69:8F:82:9C' , 'XCXT$8080$60:EB:69:82:38:18' , 'XCXT$8080$60:EB:69:8F:84:0A' , 'XCXT$8080$60:EB:69:8F:81:B8' , 'XCXT$8080$60:EB:69:8F:84:88' , 'XCXT$8080$60:EB:69:82:3B:42' , 'XCXT$8080$60:EB:69:8F:81:C4' , 'XCXT$8080$60:EB:69:8F:84:40' , 'uums$8080$60:EB:69:8F:83:62' , 'XCXT$8080$60:EB:69:8F:83:E0' , 'XCXT$8080$60:EB:69:8F:83:56')) |
| bpggz1tjg1v4a | SELECT COUNT(*) as CT FROM (select distinct wtjl0_.ID as ID251_, wtjl0_.DATAVERSION as DATAVERS2_251_, wtjl0_.INSTANCEID as INSTANCEID251_, wtjl0_.AJBH as AJBH251_, wtjl0_.AJMC as AJMC251_, wtjl0_.AJLXID as AJLXID251_, wtjl0_.JCLXID as JCLXID251_, wtjl0_.ZXJCMC as ZXJCMC251_, wtjl0_.JCDWCJID as JCDWCJID251_, wtjl0_.ZFJCDWID as ZFJCDWID251_, wtjl0_.ZFJCDWMC as ZFJCDWMC251_, wtjl0_.ZFJCSJ as ZFJCSJ251_, wtjl0_.ZFJCMJZH as ZFJCMJZH251_, wtjl0_.ZFJCMJXM as ZFJCMJXM251_, wtjl0_.ZRHJID as ZRHJID251_, wtjl0_.ZRDWID as ZRDWID251_, wtjl0_.BAMJDWID as BAMJDWID251_, wtjl0_.BADWMC as BADWMC251_, wtjl0_.LRR as LRR251_, wtjl0_.LRRZH as LRRZH251_, wtjl0_.LRDWID as LRDWID251_, wtjl0_.LRRQ as LRRQ251_, wtjl0_.SFCQJCCSID as SFCQJCCSID251_, wtjl0_.DELFLAG as DELFLAG251_, wtjl0_.OPERATERCODE as OPERATE25_251_, wtjl0_.OPERATETIME as OPERATE26_251_, wtjl0_.ORGID as ORGID251_, wtjl0_.DQBAZBH as DQBAZBH251_, wtjl0_.SSAJLX as SSAJLX251_, wtjl0_.BJCDWID as BJCDWID251_, wtjl0_.BJCDWMC as BJCDWMC251_, wtjl0_.GLDXBH as GLDXBH251_, wtjl0_.SFZGID as SFZGID251_ from T_ZFJD_WTJL wtjl0_, T_ZFJD_LCWTDY lcwtdy1_ where wtjl0_.ID=lcwtdy1_.WTJLID and (wtjl0_.AJBH like :1)) |
| bsa0wjtftg3uw | select file# from file$ where ts#=:1 |
| bvstq79s2n59f | 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 |
| bwhhtfd6mxsag |
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 '%???%' ) ) ) ) |
| 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 |
| c3jsha3g0bpuz |
SELECT COUNT(*) as CT from ( select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '1' and wsqx.treepath like :1 and (wsqx.status = '99' or (wsqx.status = '98' and wsqx.processcode in ('CQTZSPB', 'LDJYCPBG', 'LDJYSWZXCPB'))) and wsqx.cqdx not in ('05', '06') and ( wsqx.asjbh in ('A1102225100002013120001') or ( wsqx.asjbh = 'J11022251000020131200089' and wsqx.proid = '8a88845542b6aae80142bcd804b643ad') ) and wsqx.kjsj >= to_Date(:2, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:3, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:4, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:5, 'yyyy-MM-dd hh24:mi') union all select distinct wsqx.docid , wsqx.asjbh, wsqx.dxbh, wsqx.cqdx, wsqx.wslx, wsqx.mbmc, wsqx.status, wsqx.processcode, wsqx.starttime, wsqx.loginorgcode , wsqx.username, wsqx.owner , wsqx.ender , wsqx.proid , wsqx.temid, wsqx.dxmc , wsqx.cqlx from t_doc_wsqx wsqx where wsqx.cqlx = '2' and wsqx.treepath like :6 and wsqx.cqdx not in ('05', '06') and ( wsqx.asjbh in ('A1102225100002013120001') or ( wsqx.asjbh = 'J11022251000020131200089' and wsqx.proid = '8a88845542b6aae80142bcd804b643ad') )
and wsqx.kjsj >= to_Date(:7, 'yyyy-MM-dd hh24:mi') and wsqx.kjsj <= to_Date(:8, 'yyyy-MM-dd hh24:mi') and wsqx.starttime >= to_Date(:9, 'yyyy-MM-dd hh24:mi') and wsqx.starttime<= to_Date(:10, 'yyyy-MM-dd hh24:mi') ) |
| cj5t41zw4hy8w | select subscripti0_.ADDRESSID as ADDRESSID1_, subscripti0_.ID as ID1_, subscripti0_.ID as ID3_0_, subscripti0_.RESOURCEID as RESOURCEID3_0_, subscripti0_.STATUS as STATUS3_0_, subscripti0_.SUBTYPE as SUBTYPE3_0_, subscripti0_.SUBTIME as SUBTIME3_0_, subscripti0_.EXPIRETIME as EXPIRETIME3_0_, subscripti0_.ADDRESSID as ADDRESSID3_0_ from T_MSG_SUBSCRIPTION subscripti0_ where subscripti0_.ADDRESSID=:1 |
| 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 |
| d4crckprmz0ga |
insert into T_RY_WFFZRYXX (DATAVERSION, 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, DELFLAG, 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, TZ, XH, AZDW, CYM, HYZK, JKZK, HJDPCS, QTLXFS, MSNZH, QQHM, YXDZ, SAWZWZ, WYZH, FLWSBH, SFFLG, SLBJ, QTMXTZ, ZY, JTQK, XDDQ, XDDD, XDQY, XDCS, DPLY, LRRDH, LRRSH, SFMYCF, CZQK, XSDJ, MPFS, DSFS, MJ, YWMPQK, MPDX, LRRZH, SSAJLX, JJRYID, ZZM, QTZM, ZAY, QTAY, QTZJZL, QTZJHM, SCZT, SFCZCQZ, SAZT, DQTY, ZYZT, SGSX, SGXX, SDLX, SJLYFLG, ESCAPE, SFYQK, SFGRAZID, NJ, CYRDJL, ZWX, YWPYX, YWPYM, ZWMZ, SFQRHBC, QHR, Q
HLB, QHDXLB, RSSHCD, SAQK, ZJXY, LHSF, FWCS, DWLXDH, YQDW, SAYY, CLQK, DWSDPCS, SJYHZ, ZHJDDW, SGSFQRSF, SGSFTS, JWZZ, JWLXDH, TDDD, LHCS, JTGJ, LJRQ, LJQZZ, YWWFJL, YWJSB, TDFS, LJMD, DCLHXXMS, JNDZSSJJQ, CQTLSY, CQTLTS, TZSLGQC, TZSLGSJ, LHRQ, RJDD, JLXKHM, WGRJLSY, QZZZL, SBBFLG, JGRSRQ, JGCSRQ, CSYYMS, 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, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178,
:179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190, :191, :192, :193, :194, :195, :196, :197, :198, :199, :200, :201, :202, :203, :204, :205, :206, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221, :222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232) |
| d88d24rkb8s97 | SELECT COUNT(*) as CT FROM (select distinct xs.ajbh, xs.ajmc, xs.cbdw, xs.cbr, '' as id, '' as bllx, xs.zabid from t_doc_wsqx qx inner join t_aj_xsajfaxx xs on qx.asjbh = xs.ajbh where qx.treepath like '11000000000000.11010600000000.11010665000000%' and xs.ajzt != '2904' and xs.ajmc like :1) |
| dh4zpzwh48zzf |
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 |
| dqbhc9r7gz0a5 | SELECT DECODE(COUNT(CLIENT_INFO), 0, 'down', 'up') FROM GV$SESSION WHERE CLIENT_INFO = :B1 |
| dwypdxsjg4juq | select /*+ index_ss(obj$ i_obj2) */ obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null |
| f015a8zk9z8n3 | select max(docnumber0_.DOCSEQ) as col_0_0_ from T_DOC_DOCNUMBER docnumber0_ where docnumber0_.TEMPLATEID=:1 and (docnumber0_.AUTHORITYCODE=:2 or docnumber0_.AUTHORITYCODE is null) and docnumber0_.YEARCODE=:3 |
| f1q6xncbh8zut | select * from ( select distinct xs.ajbh, xs.ajmc, xs.cbdw, xs.cbr, '' as id, '' as bllx, xs.zabid from t_doc_wsqx qx inner join t_aj_xsajfaxx xs on qx.asjbh = xs.ajbh where qx.treepath like '11000000000000.11022100000000.11022144000000%' and xs.ajzt != '2904' and xs.ajbh like :1 ) where rownum <= :2 |
| 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) ) |
| f8pavn1bvsj7t | select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1 |
| fds5q2x4rtzw3 |
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 |
| fnbzzfm49d7qh | SELECT COUNT(*) as CT from T_AJ_JJDJ j where j.jjlxbj is null and j.sazt in ('1100', '2110', '2120', '3140', '3150') and j.cljg !='02' and j.blmjzh = :1 |
| fw5dncbpz9atf | SELECT COUNT(*) as CT from T_AJ_JJDJ j where j.jjlxbj is null and j.sazt in ('1100', '2110', '2120', '3140', '3150') and j.cljg !='02' and j.blmjzh = :1 |
| g3am9h0f0kznt | select distinct yjxxb0_.ID as ID265_, yjxxb0_.DATAVERSION as DATAVERS2_265_, yjxxb0_.DXBH as DXBH265_, yjxxb0_.DXLX as DXLX265_, yjxxb0_.YJDW as YJDW265_, yjxxb0_.YJJZSJ as YJJZSJ265_, yjxxb0_.YJZQX as YJZQX265_, yjxxb0_.YJZQXDW as YJZQXDW265_, yjxxb0_.JSSJ as JSSJ265_, yjxxb0_.YJJSLX as YJJSLX265_, yjxxb0_.YJDQSJ as YJDQSJ265_, yjxxb0_.YJZT as YJZT265_, yjxxb0_.CQZT as CQZT265_, yjxxb0_.SCBJ as SCBJ265_, yjxxb0_.OPERATETIME as OPERATE15_265_, yjxxb0_.OPERATERCODE as OPERATE16_265_, yjxxb0_.DELFLAG as DELFLAG265_, yjxxb0_.ORGID as ORGID265_, yjxxb0_.CQDM as CQDM265_, yjxxb0_.CQMC as CQMC265_, yjxxb0_.AJBH as AJBH265_, yjxxb0_.ZBH as ZBH265_, yjxxb0_.CQID as CQID265_, yjxxb0_.YJTSXX as YJTSXX265_, yjxxb0_.CQTSXX as CQTSXX265_ 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 |
| g52tkw7uq1zy4 | 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 j.jcjbh like :3 ) |
| g60fsq3y7fytb | SELECT COUNT(*) as CT from (select docins.id docid, docins.templateid tid, docins.processinstanceid pid, pro.instcode dxbh, pro.processcode cqty, (case when tem.templatetype = '02' then tem.templatename else(select b.processname from t_doc_busiprocess b where b.id = pro.processid)end) wsmc, pro.username cqr, pro.loginorgname cqdw, pro.starttime cqtime, docins.docstatus, docins.doctype, pro.id, docins.docUrl, tem.templatetype templatetype, tem.html html from t_doc_docinstance docins, t_doc_processinstance pro, t_doc_template tem where docins.processinstanceid = pro.id and docins.docstatus in ('02', '03') and tem.id = docins.templateid and docins.orgid in (select o.orgcode from t_sys_organization o where o.treepath like :1)) where 1=1 |
| gcfm2ppws8y4w | 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 ) ) |
| 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 |