SQL Id | SQL Text |
013afbjrk6cch | select count (*) as count from(select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 and t.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.certitype = :2 AND t.inpaymentdepartment = :3 AND t.customername like :4 AND t.inpaymentflag = :5 AND t.datasource = :6) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='005174' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:7 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) |
037cq8hnwpss1 | update MM_POLICY_LEGAL set amount=:1, bankcity=:2, bankname=:3, bankprovince=:4, batchid=:5, batchserialno=:6, bpstatus=:7, businessno=:8, businessstatus=:9, cardflag=:10, certificateno=:11, certificatetype=:12, certitype=:13, createdate=:14, currencycode=:15, custaccountname=:16, custaccountno=:17, custbankno=:18, custemail=:19, customercode=:20, customerkeyword=:21, customername=:22, datasource=:23, description=:24, errcode=:25, errmsg=:26, ifneedaudit=:27, ifpublic=:28, ifsupplement=:29, inpaymentdepartment=:30, inpaymentflag=:31, inpaymentmethod=:32, inpaymentsubcompany=:33, lastopcode=:34, lastopdate=:35, mergedseqbusiness=:36, mobilenumber=:37, opcode=:38, realamount=:39, receivedate=:40, rowversion=:41, segment1=:42, segment2=:43, seqbusiness=:44, splitedseqbusiness=:45, status=:46, summaryamount=:47, summaryno=:48, unitbankno=:49, usableno=:50 where id=:51 and rowversion=:52 |
0cn2wm9d7zq8d | SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING' |
0cxp0daqjf90v | select count(*) as col_0_0_ from MM_PLATFORMFILE_TD platformfi0_ where 1=1 and (exists (select 1 from MM_PLATFORMFILE_DETAIL_TD platformfi1_ where platformfi1_.platformfileid=platformfi0_.id and (platformfi1_.policyno in (:1)))) and (exists (select 1 from MM_BIZSUB_COVER_TD bizsub2_, MM_UNIT_TC unit3_ where unit3_.subcompany=bizsub2_.SUBCOMPANY and unit3_.unitcode=platformfi0_.unitcode and bizsub2_.OPCODE=:2)) and platformfi0_.opdate>=:3 and platformfi0_.opdate<=:4 |
0g023nsr9qtjq | select * from mm_policy_ti a where a.bpstatus = '1' and a.datasource = 'NEWGROUP' and rownum <= 20 |
0mswpdmwk6py5 | call mm_ats_pkg.mm_ats_to(:1) |
15w1t8qpdgg5k | select i.obj#, i.flags, u.name, o.name, o.type# from sys.obj$ o, sys.user$ u, sys.ind$ idx, sys.ind_online$ i where bitand(i.flags, 512) = 512 and o.obj#=idx.obj# and o.owner# = u.user# and idx.obj#=i.obj# |
1dma70nxa58bv |
select * from ( select * from (select '12' as businesstype, '' as baserealamount, '' as authorizedstate , '' as contractcode, p.agentcode, p.amount as amount, p.bankname, p.baseamount as baseamount, p.basecurrencycode, p.baseusedamount as baseusedamount, p.businessattr, p.canceldate, p.cancelflag, p.claimno, p.classescode, p.currencycode, p.custaccountno, p.custbankno, p.customercode, p.customername, p.applicantnamecn customernameen, p.customerpartyno, p.custseq, p.datasource, p.datatype, p.departmentcode, p.description, p.endorseno, p.fatherno, p.inpaymentbatchno, p.lastopdate, p.opcode, p.opdate, p.opstatus, p.policyno, p.risktype, p.subcompany, p.summaryno, p.createdate, p.unitcode, p.usedamount as usedamount, p.amount - p.usedamount as handledamount, p.baseamount - p.baseusedamount as handledbaseamount, '' as departmentname, 0 as baseleftamount, p.payableno as settlementno, p.usableno as usableno, p.payableseq, p.returnno, p.serialno, p.paytype, p.seqbusiness , p.paycode, p.billno, p.customerkeyword, p.ifsupplement , '' batchId, '' batchSummaryno, 0 batchAmount, '' AS actualcurrencycode, 0 AS actualexchangerate , p.confirmsequenceno , p.ifupload , 0 as seqinvply from mm_payablemoney_td p where 1=1 and p.inpaymentmethod != '04' and p.inpaymentflag = '0' and opstatus in ('0', '1') and subcompany = (:1) and datasource = (:2) and baseamount>0) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner = :3 and
biz.powergrade='5' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit)) ) where rownum <= :4 |
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# (+) |
24b5vhb41cuc9 | select count (*) as count from(select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 AND t.certitype = :1 AND t.inpaymentdepartment = :2 AND t.customername like :3 AND t.inpaymentflag = :4 AND t.datasource = :5) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='005174' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:6 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) |
2aur6mba52158 | declare
batchid_out number;
begin
-- Call the procedure
spcdms01.bfp_preposerls_pkg.do_extract(startopdate_in => date'2013-07-05',
endopdate_in => date'2013-07-08',
batchid_out => batchid_out);
end; |
2cx2pgddzwdsd | INSERT INTO BFP_POLICY_TI (SEQREPORTNO, SEQBUSINESS, BATCHID, DATASOURCE, POLICYNO, CLAIMNO, BUSINESSONE, BUSINESSTWO, CURRENCYCODE, AMOUNT, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, STATUS, CLASSESCODE, SUBCOMPANY, DEPARTMENTCODE, BUSINESSCHANNEL, AGENTCODE, AGENTNAME, OPDATE, HASPLAN, CERTITYPE, EMPLOYESTATUS, GRFLAG, PREMTYPE, RENEWALFLAG) VALUES (SEQ_DEFAULT.NEXTVAL, '', :B18 , 'RLS', :B17 , :B16 , :B15 , :B14 , 'RMB', :B13 , 'RLS', SYSDATE, SYSDATE, 'RLS', SYSDATE, '1', :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , NVL(:B5 , '1'), :B4 , :B3 , '101', :B2 , :B1 ) |
2pq0y22akqb16 | insert into MM_PLATFORMFILE_DETAIL_TD (amount, batchno, batchserialno, businessno, cardflag, certificateno, certificatetype, currencycode, currencyname, custaccountname, custaccountno, custbankarea, custbankcity, custbankcode, custbankprovince, customername, customertype, cvvcode, datasource, departmentcode, displayorder, fastflag, fundcategorycode, inpaymentflag, inpaymentid, ispublic, lastopcode, lastopdate, mmaccountid, mmaccountname, mmaccountno, mmbankcode, mmbankname, opcode, paydate, paytype, platformfileid, policyno, rowversion, settlementmode, subcompany, 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) |
2w1cp8mz1uvqb | SELECT (SELECT NEWCODE FROM MM_CODEMAPPING_TC WHERE CODETYPE = 'DEPARTMENTMAPPING' AND OLDCODE = :B1 ) ERLT FROM DUAL |
2w8hubg0rr78j |
select payablemon0_.payableno as payableno91_0_, payablemon0_.agentcode as agentcode91_0_, payablemon0_.agentnamecn as agentnam3_91_0_, payablemon0_.agentnameen as agentnam4_91_0_, payablemon0_.agentpartyno as agentpar5_91_0_, payablemon0_.amount as amount91_0_, payablemon0_.appisjapan as appisjapan91_0_, payablemon0_.applicantcode as applican8_91_0_, payablemon0_.applicantionpartyno as applican9_91_0_, payablemon0_.applicantnamecn as applica10_91_0_, payablemon0_.applicantnameen as applica11_91_0_, payablemon0_.bankarea as bankarea91_0_, payablemon0_.bankcity as bankcity91_0_, payablemon0_.bankname as bankname91_0_, payablemon0_.bankprovince as bankpro15_91_0_, payablemon0_.banktype as banktype91_0_, payablemon0_.baseamount as baseamount91_0_, payablemon0_.basecurrencycode as basecur18_91_0_, payablemon0_.baseusedamount as baseuse19_91_0_, payablemon0_.billcode as billcode91_0_, payablemon0_.billno as billno91_0_, payablemon0_.businessattr as busines22_91_0_, payablemon0_.businesschannel as busines23_91_0_, payablemon0_.canceldate as canceldate91_0_, payablemon0_.cancelflag as cancelflag91_0_, payablemon0_.cardflag as cardflag91_0_, payablemon0_.certificateno as certifi27_91_0_, payablemon0_.certificatetype as certifi28_91_0_, payablemon0_.certitype as certitype91_0_, payablemon0_.chargedescription as charged30_91_0_, payablemon0_.claimno as claimno91_0_, payablemon0_.classescode as classes32_91_0_, payablemon0_.classeskind as classes33_91_0_,
payablemon0_.confirmsequenceno as confirm34_91_0_, payablemon0_.contracttype as contrac35_91_0_, payablemon0_.createdate as createdate91_0_, payablemon0_.currencycode as currenc37_91_0_, payablemon0_.custaccountname as custacc38_91_0_, payablemon0_.custaccountnameen as custacc39_91_0_, payablemon0_.custaccountno as custacc40_91_0_, payablemon0_.custbankno as custbankno91_0_, payablemon0_.custemail as custemail91_0_, payablemon0_.custisjapan as custisj43_91_0_, payablemon0_.customercode as custome44_91_0_, payablemon0_.customerkeyword as custome45_91_0_, payablemon0_.customername as custome46_91_0_, payablemon0_.customernameen as custome47_91_0_, payablemon0_.customerpartyno as custome48_91_0_, payablemon0_.custseq as custseq91_0_, payablemon0_.datasource as datasource91_0_, payablemon0_.datatype as datatype91_0_, payablemon0_.departmentcode as departm52_91_0_, payablemon0_.description as descrip53_91_0_, payablemon0_.domestic as domestic91_0_, payablemon0_.endorseno as endorseno91_0_, payablemon0_.fatherno as fatherno91_0_, payablemon0_.hibernateversion as hiberna57_91_0_, payablemon0_.ifbillback as ifbillback91_0_, payablemon0_.ifeffect as ifeffect91_0_, payablemon0_.ifsupplement as ifsuppl60_91_0_, payablemon0_.ifupload as ifupload91_0_, payablemon0_.inpaymentbatchno as inpayme62_91_0_, payablemon0_.inpaymentflag as inpayme63_91_0_, payablemon0_.inpaymentmethod as inpayme64_91_0_, payablemon0_.insuranceterm as insuran65_91_0_, payablemon0_.
insuredcode as insured66_91_0_, payablemon0_.insuredname as insured67_91_0_, payablemon0_.insurednameen as insured68_91_0_, payablemon0_.insuredpartyno as insured69_91_0_, payablemon0_.ispaypublic as ispaypu70_91_0_, payablemon0_.lastopdate as lastopdate91_0_, payablemon0_.mobilenumber as mobilen72_91_0_, payablemon0_.offsetno as offsetno91_0_, payablemon0_.opcode as opcode91_0_, payablemon0_.opdate as opdate91_0_, payablemon0_.opstatus as opstatus91_0_, payablemon0_.payableseq as payableseq91_0_, payablemon0_.paytype as paytype91_0_, payablemon0_.plandate as plandate91_0_, payablemon0_.policyno as policyno91_0_, payablemon0_.porttype as porttype91_0_, payablemon0_.returnno as returnno91_0_, payablemon0_.risktype as risktype91_0_, payablemon0_.seqbusiness as seqbusi84_91_0_, payablemon0_.subcompany as subcompany91_0_, payablemon0_.summaryno as summaryno91_0_, payablemon0_.unitbankno as unitbankno91_0_, payablemon0_.unitcode as unitcode91_0_, payablemon0_.usableno as usableno91_0_, payablemon0_.usedamount as usedamount91_0_ from MM_PAYABLEMONEY_TD payablemon0_ where payablemon0_.payableno=:1 |
34zauv6342qp6 | SELECT /*+ driving_site(a) */A.DCPNO, A.INS_CODE SOURCELIB, A.DCFYP, A.DCPCO, TRIM(B.A54PLAN) A54PLAN, A.DCMODE, CASE WHEN DCRDOP > DCDUE THEN B.A54PRM ELSE 0 END AMT_1, CASE WHEN DCRDOP > DCDUE THEN 0 ELSE B.A54PRM END AMT_2 FROM RLS_LFPPREMS@BFR A, RLS_LFPPRMSD@BFR B WHERE A.DCPNO = B.A54PNO AND A.DCSEQ = B.A54SEQ AND A.DCRDOP > 0 AND B.A54PRM <> 0 AND GREATEST(A.DCRDOP, A.DCDUE) = :B1 |
36322yuy3rrj8 |
update MM_PAYABLEMONEY_TD set agentcode=:1, agentnamecn=:2, agentnameen=:3, agentpartyno=:4, amount=:5, appisjapan=:6, applicantcode=:7, applicantionpartyno=:8, applicantnamecn=:9, applicantnameen=:10, bankarea=:11, bankcity=:12, bankname=:13, bankprovince=:14, banktype=:15, baseamount=:16, basecurrencycode=:17, baseusedamount=:18, billcode=:19, billno=:20, businessattr=:21, businesschannel=:22, canceldate=:23, cancelflag=:24, cardflag=:25, certificateno=:26, certificatetype=:27, certitype=:28, chargedescription=:29, claimno=:30, classescode=:31, classeskind=:32, confirmsequenceno=:33, contracttype=:34, createdate=:35, currencycode=:36, custaccountname=:37, custaccountnameen=:38, custaccountno=:39, custbankno=:40, custemail=:41, custisjapan=:42, customercode=:43, customerkeyword=:44, customername=:45, customernameen=:46, customerpartyno=:47, custseq=:48, datasource=:49, datatype=:50, departmentcode=:51, description=:52, domestic=:53, endorseno=:54, fatherno=:55, hibernateversion=:56, ifbillback=:57, ifeffect=:58, ifsupplement=:59, ifupload=:60, inpaymentbatchno=:61, inpaymentflag=:62, inpaymentmethod=:63, insuranceterm=:64, insuredcode=:65, insuredname=:66, insurednameen=:67, insuredpartyno=:68, ispaypublic=:69, lastopdate=:70, mobilenumber=:71, offsetno=:72, opcode=:73, opdate=:74, opstatus=:75, payableseq=:76, paytype=:77, plandate=:78, policyno=:79, porttype=:80, returnno=:81, risktype=:82, s
eqbusiness=:83, subcompany=:84, summaryno=:85, unitbankno=:86, unitcode=:87, usableno=:88, usedamount=:89 where payableno=:90 and hibernateversion=:91 |
3972rvxu3knn3 | delete from sdo_geor_ddl__table$$ |
3b0zg76rm3p3n | SELECT MAX(A.INS_CODE) SOURCELIB, MAX(A.PAGT1) AGT1_NUM, MAX(A.PAGT2) AGT2_NUM, MAX(A.PPAGT1) PAGT1, MAX(A.PPAGT2) PAGT2 FROM RLS_TEMP_LFPPML A WHERE A.PNO = :B1 |
3bfdwkak8bwj3 | select * from ( select MM_POLICY_LEGAL.inpaymentdepartment as departmentcode, MM_POLICY_LEGAL.* , (select max(list.policyno) from MM_POLICYLIST_LEGAL list where list.seqbusiness= MM_POLICY_LEGAL.seqbusiness) policyno , (select max(list.classescode) from MM_POLICYLIST_LEGAL list where list.seqbusiness= MM_POLICY_LEGAL.seqbusiness) classescode , (select max(list.businesschannel) from MM_POLICYLIST_LEGAL list where list.seqbusiness= MM_POLICY_LEGAL.seqbusiness) businesschannel , log.modifybatchno from MM_POLICY_LEGAL, mm_legaldata_modify_log_td log where 1 = 1 and MM_POLICY_LEGAL.certitype <> '6' and MM_POLICY_LEGAL.seqbusiness = log.seqbusiness and log.modifydetail = 'auditpass' and log.modifytype = '3' and log.modifybatchno = :1 ) where rownum <= :2 |
3m8smr0v7v1m6 | INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13) |
3xgw35tqxsmvb | SELECT MAX(A.CONTRACTTYPE) FROM RLS_TEMP_LACONTRACT A WHERE A.AGENTCODE = :B2 || SUBSTR(:B1 , -6, 6) |
3zz7hdgcyzu08 | select count (*) as count from(select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 and t.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.inpaymentdepartment = :2 AND t.createdate >= :3 AND t.createdate <:4+1 AND t.ifsupplement = :5 AND t.inpaymentflag = :6) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='001974' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:7 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) |
49khugt43hffr |
select * from ( select platformfi0_.id as id108_, platformfi0_.accountno as accountno108_, platformfi0_.batchno as batchno108_, platformfi0_.createdate as createdate108_, platformfi0_.crsumamount as crsumamo5_108_, platformfi0_.crsumcount as crsumcount108_, platformfi0_.currencycode as currency7_108_, platformfi0_.detailcount as detailco8_108_, platformfi0_.downloadcounts as download9_108_, platformfi0_.drsumamount as drsumam10_108_, platformfi0_.drsumcount as drsumcount108_, platformfi0_.failamount as failamount108_, platformfi0_.failcount as failcount108_, platformfi0_.filename as filename108_, platformfi0_.filepath as filepath108_, platformfi0_.filestatus as filestatus108_, platformfi0_.hibernateversion as hiberna17_108_, platformfi0_.lastopcode as lastopcode108_, platformfi0_.lastopdate as lastopdate108_, platformfi0_.merchantno as merchantno108_, platformfi0_.mmaccountid as mmaccou21_108_, platformfi0_.modifydesc as modifydesc108_, platformfi0_.opcode as opcode108_, platformfi0_.opdate as opdate108_, platformfi0_.optime as optime108_, platformfi0_.outputdate as outputdate108_, platformfi0_.platformid as platformid108_, platformfi0_.successamount as success28_108_, platformfi0_.successcount as success29_108_, platformfi0_.sumamount as sumamount108_, platformfi0_.unitcode as unitcode108_ from MM_PLATFORMFILE_TD platformfi0_ where 1=1 and (exists (select 1 from MM_PLATFORMFILE_DETAIL_TD platformfi1_ where platformfi1_.platformfileid=platformfi0
_.id and (platformfi1_.policyno in (:1)))) and (exists (select 1 from MM_BIZSUB_COVER_TD bizsub2_, MM_UNIT_TC unit3_ where unit3_.subcompany=bizsub2_.SUBCOMPANY and unit3_.unitcode=platformfi0_.unitcode and bizsub2_.OPCODE=:2)) and platformfi0_.opdate>=:3 and platformfi0_.opdate<=:4 ) where rownum <= :5 |
4cc3vgpc8vvy7 |
select * from ( select platformfi0_.id as id26_, platformfi0_.accountno as accountno26_, platformfi0_.batchno as batchno26_, platformfi0_.createdate as createdate26_, platformfi0_.crsumamount as crsumamo5_26_, platformfi0_.crsumcount as crsumcount26_, platformfi0_.currencycode as currency7_26_, platformfi0_.detailcount as detailco8_26_, platformfi0_.downloadcounts as download9_26_, platformfi0_.drsumamount as drsumam10_26_, platformfi0_.drsumcount as drsumcount26_, platformfi0_.failamount as failamount26_, platformfi0_.failcount as failcount26_, platformfi0_.filename as filename26_, platformfi0_.filepath as filepath26_, platformfi0_.filestatus as filestatus26_, platformfi0_.hibernateversion as hiberna17_26_, platformfi0_.lastopcode as lastopcode26_, platformfi0_.lastopdate as lastopdate26_, platformfi0_.merchantno as merchantno26_, platformfi0_.mmaccountid as mmaccou21_26_, platformfi0_.modifydesc as modifydesc26_, platformfi0_.opcode as opcode26_, platformfi0_.opdate as opdate26_, platformfi0_.optime as optime26_, platformfi0_.outputdate as outputdate26_, platformfi0_.platformid as platformid26_, platformfi0_.successamount as success28_26_, platformfi0_.successcount as success29_26_, platformfi0_.sumamount as sumamount26_, platformfi0_.unitcode as unitcode26_ from MM_PLATFORMFILE_TD platformfi0_ where 1=1 and (exists (select 1 from MM_PLATFORMFILE_DETAIL_TD platformfi1_ where platformfi1_.platformfileid=platformfi0_.id and (platformfi1_.policyno
in (:1)))) and (exists (select 1 from MM_BIZSUB_COVER_TD bizsub2_, MM_UNIT_TC unit3_ where unit3_.subcompany=bizsub2_.SUBCOMPANY and unit3_.unitcode=platformfi0_.unitcode and bizsub2_.OPCODE=:2)) and platformfi0_.opdate>=:3 and platformfi0_.opdate<=:4 ) where rownum <= :5 |
4d68fvyqqhh90 | SELECT NVL(MAX(T.SIG), 1) SIG FROM RLS_TEMP_TABPLAN T WHERE T.PLAN = :B2 AND T.INS_CODE =SUBSTR(:B1 , 1, 1) |
4gkghaguz5avk |
INSERT INTO BFP_TMP_RISKSPLIT_TD(
POLICYNO, RISKCODE, SUBRISKCODE, SPLITTYPE, SPLITDATE, SPLITPREM, SUBPREMIUM, SUBQTY,
SUBRATE, IFMEDCOVER, INSUREDAGE, INSUREDGENDER, INSUREDCASTE, HOLDERAGE, HOLDERGENDER, COVERAGE,
MAINRISKCODE, MAINPREM, TOTALPREM, PERIODRATIO, SERIALNO)
VALUES(:POLICYNO, :RISKCODE, :SUBRISKCODE, :SPLITTYPE, :SPLITDATE, :SPLITPREM, :SUBPREMIUM, :SUBQTY,
:SUBRATE, :IFMEDCOVER, :INSUREDAGE, :INSUREDGENDER, :INSUREDCASTE, :HOLDERAGE, :HOLDERGENDER, :COVERAGE,
:MAINRISKCODE, :MAINPREM, :TOTALPREM, :PERIODRATIO, :SERIALNO) |
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 |
4q1rjpn3t0wc3 |
INSERT INTO BFP_TEMP_DCRD (SOURCELIB, DCRSEQ, DCRDOT, DCRDOS, DCRECP, DCRTYP, DCRDOP, DCREV, DCRBCQ, DCPAID, DCCY, DCRATE, DCTRAN, DCPCO, DCPNO, DCPCCY, DCPRAT, DCPN, DCDUE, DCFYP, DCMODE, DCPREM, DCMTH, DCDIFF, DCAGT1, DCAGT2, DCCOMM, DCLN, DCLNI, DCDVD, DCDVDI, DCFPD, DCFPDI, DCSDA1, DCSDC1, DCRAT1, DCSD1, DCSDA2, DCSDC2, DCRAT2, DCSD2, DCSDA3, DCSDC3, DCRAT3, DCSD3, DCSDA4, DCSDC4, DCRAT4, DCSD4, DCSDA5, DCSDC5, DCRAT5, DCSD5, DCPLAN, DCPLNN, DCTRMP, DCTRMC, DCILSP, DCTLSP, DCILSC, DCTLSC, DCSEQ2, DCXCLC, DCXCAM, DCRAL, DCMEXTR, DCMBNS, DCRSOUR, DCCSPL, DCPFX, DCPFT, DCPIL, DCPFL, DCRTYP_OLD, FLAG, OPDATE) SELECT /*+ driving_site(a) */A.INS_CODE SOURCELIB, A.DCRSEQ, A.DCRDOT, A.DCRDOS, A.DCRECP, CASE WHEN A.DCRTYP = '3' AND A.DCREV = 'R' AND B.DCPNO IS NOT NULL THEN B.DCRTYP ELSE A.DCRTYP END DCRTYP, A.DCRDOP, A.DCREV, A.DCRBCQ, A.DCPAID, A.DCCY, A.DCRATE, A.DCTRAN, A.DCPCO, A.DCPNO, A.DCPCCY, A.DCPRAT, A.DCPN# DCPN, A.DCDUE, A.DCFYP, A.DCMODE, A.DCPREM, A.DCMTH, A.DCDIFF, A.DCAGT1, A.DCAGT2, A.DCCOMM, A.DCLN, A.DCLNI, A.DCDVD, A.DCDVDI, A.DCFPD, A.DCFPDI, A.DCSDA1, A.DCSDC1, A.DCRAT1, A.DCSD1, A.DCSDA2, A.DCSDC2, A.DCRAT2, A.DCSD2, A.DCSDA3, A.DCSDC3, A.DCRAT3, A.DCSD3, A.DCSDA4, A.DCSDC4, A.DCRAT4, A.DCSD4, A.DCSDA5, A.DCSDC5, A.DCRAT5, A.DCSD5, TRIM(A.DCPLAN), A.DCPLNN, A.DCTRMP, A.DCTRMC, A.DCILSP, A.DCTLSP, A.DCILSC, A.DCTLSC, A.DCSEQ2, A.DCXCLC, A.DCXCAM, A.DCRAL, A.DCMEXTR, A.DCMB
NS, A.DCRSOUR, A.DCCSPL, A.DCPFX, A.DCPFT, A.DCPIL, A.DCPFL, A.DCRTYP DCRTYP_OLD, CASE WHEN A.DCREV = 'R' THEN -1 ELSE 1 END FLAG, TRUNC(SYSDATE) OPDATE FROM RLS_LFPDCRD@BFR A, (SELECT /*+ driving_site(c) */ DCPNO, DCRSEQ, MAX(DCRTYP) DCRTYP, MAX(DCREV) DCREV FROM RLS_LFPDCRD@BFR C WHERE (C.DCRTYP IN ('1', '2') AND C.DCREV = 'Q') OR (C.DCRTYP = '3' AND C.DCREV = 'X') GROUP BY DCPNO, DCRSEQ) B WHERE A.DCPNO = B.DCPNO(+) AND A.DCRSEQ = B.DCRSEQ(+) AND ((A.DCRDOT > :B2 AND A.DCRDOT <= :B1 ) OR (A.DCRDOP > :B2 AND A.DCRDOP <= :B1 ) OR (A.DCDUE > :B2 AND A.DCDUE <= :B1 ) ) |
4r8mvvus0asy2 | select count(1) from ( select '' USPBATCHNO, '' USPSERIALNO, '' MAKEDATE, '' MAKETIME, SEQBUSINESSLIST, SEQBUSINESS, SUBCOMPANY, DEPARTMENTCODE, POLICYNO, ENDORSENO, CLAIMNO, BIZNO, SERIALNO, DATATYPE, CURRENCYCODE, AMOUNT, CLASSESKIND, CLASSESCODE, STARTDATE, ENDDATE, SIGNDATE, INPUTDATE, PLANDATE, INSUREDCODE, INSUREDNAME, INSUREDNAMEEN, APPLICODE, APPLINAME, APPLINAMEEN, TRANSACTORCODE, UNDERWRITERCODE, AGENTCODE, AGENTNAME, BUSINESSCHANNEL, GRFLAG, HASPLAN, RENEWALFLAG, OFFSETNO, REALAMOUNT, SEGMENT1, SEGMENT2, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, ROWVERSION, BUSINESSSTATUS, BPSTATUS, STATUS, ERRMSG from MM_POLICYLIST_TI where SEQBUSINESS in (select SEQBUSINESS from MM_POLICY_TI where DATASOURCE = 'SRS') and BPSTATUS = '1' order by LASTOPDATE) rsc |
4s1wmpcjbbkny | select seq_default.nextval from dual |
5cw8v33s4kydh |
INSERT INTO RLS_TEMP_LFPACT( INS_CODE, ACPCO, ACPNO, ACPCCY, ACCCY, ACPLAN, ACTCD, ACEFF, ACDOT, ACTRNR, ACPAYR, ACDCR, ACNBDI, ACRB, ACTB, ACDVD, ACDVDI, ACMAE, ACLN, ACLNI, ACFPD, ACFPDI, ACFUND, ACFYP, ACPREM, ACTRMP, ACDIFF, ACBSUR, ACSUR, ACMAT, ACSIB, ACPCRG, ACCOI, ACPMF, ACIMF, ACRMF, ACAMF, ACAP, ACGC, ACSCRG, ACABAL, ACDCLM, ACPCHG, ACSD, ACAMT, ACAMTH, ACERAT, ACADMC, ACITM1, ACITM2, ACSCH, ACSCHI, ACCSF) SELECT /*+ driving_site(a) */INS_CODE, ACPCO, ACPNO, ACPCCY, ACCCY, TRIM(ACPLAN) ACPLAN, TRIM(ACTCD) ACTCD, ACEFF, ACDOT, ACTRNR, ACPAYR, ACDCR, ACNBDI, ACRB, ACTB, ACDVD, ACDVDI, ACMAE, ACLN, ACLNI, ACFPD, ACFPDI, ACFUND, ACFYP, ACPREM, ACTRMP, ACDIFF, ACBSUR, ACSUR, ACMAT, ACSIB, ACPCRG, ACCOI, ACPMF, ACIMF, ACRMF, ACAMF, ACAP, ACGC, ACSCRG, ACABAL, ACDCLM, ACPCHG, ACSD, ACAMT, ACAMTH, ACERAT, ACADMC, ACITM1, ACITM2, ACSCH, ACSCHI, ACCSF FROM RLS_LFPACT@BFR WHERE ACDOT > :B2 AND ACDOT <= :B1 UNION ALL SELECT INS_CODE, ACPCO, ACPNO, ACPCCY, ACCCY, TRIM(ACPLAN) ACPLAN, TRIM(ACTCD) ACTCD, ACEFF, ACDOT, ACTRNR, ACPAYR, ACDCR, ACNBDI, ACRB, ACTB, ACDVD, ACDVDI, ACMAE, ACLN, ACLNI, ACFPD, ACFPDI, ACFUND, ACFYP, ACPREM, ACTRMP, ACDIFF, ACBSUR, ACSUR, ACMAT, ACSIB, ACPCRG, ACCOI, ACPMF, ACIMF, ACRMF, ACAMF, ACAP, ACGC, ACSCRG, ACABAL, ACDCLM, ACPCHG, ACSD, ACAMT, ACAMTH, ACERAT, ACADMC, ACITM1, ACITM2, ACSCH, ACSCHI, ACCSF FROM RLS_LFPACTH@BFR WHERE ACDOT > :B2 AND ACDOT <= :B1
|
5p9h9gnj63k82 | select count(1) from ( select '' USPBATCHNO, '' USPSERIALNO, '' MAKEDATE, '' MAKETIME, SEQBUSINESSLIST, SEQBUSINESS, SUBCOMPANY, DEPARTMENTCODE, POLICYNO, ENDORSENO, CLAIMNO, BIZNO, SERIALNO, DATATYPE, CURRENCYCODE, AMOUNT, CLASSESKIND, CLASSESCODE, STARTDATE, ENDDATE, SIGNDATE, INPUTDATE, PLANDATE, INSUREDCODE, INSUREDNAME, INSUREDNAMEEN, APPLICODE, APPLINAME, APPLINAMEEN, TRANSACTORCODE, UNDERWRITERCODE, AGENTCODE, AGENTNAME, BUSINESSCHANNEL, GRFLAG, HASPLAN, RENEWALFLAG, OFFSETNO, REALAMOUNT, SEGMENT1, SEGMENT2, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, ROWVERSION, BUSINESSSTATUS, BPSTATUS, STATUS, ERRMSG from MM_POLICYLIST_TI where SEQBUSINESS in (select SEQBUSINESS from MM_POLICY_TI where DATASOURCE = 'GROUP') and BPSTATUS = '1' and SUBCOMPANY like '8601%' order by LASTOPDATE) rsc |
5u69w0v0tz51x |
select count (*) as count from(select * from (select '12' as businesstype, 0 as baserealamount, '' as contractcode, p.agentcode, p.amount, p.bankname, p.baseamount, p.basecurrencycode, p.baseusedamount, p.businessattr, p.canceldate, p.cancelflag, p.claimno, p.classescode, p.currencycode, p.custaccountno, p.custbankno, p.customercode, p.customername, p.customernameen, p.customerpartyno, p.custseq, p.datasource, p.datatype, p.departmentcode, p.description, p.endorseno, p.fatherno, p.inpaymentbatchno, p.lastopdate, p.opcode, p.opdate, p.opstatus, p.policyno, p.risktype, p.subcompany, p.summaryno, p.createdate, p.unitcode, p.usedamount, p.amount - p.usedamount as handledamount, p.baseamount - p.baseusedamount as handledbaseamount, '' as departmentname, p.bankprovince, p.bankcity, p.ifoldcustaccountno, p.banktype, p.ispaypublic, p.ifsupplement, '' as result, p.payableno as settlementno, p.payableseq, p.returnno, p.serialno, p.paytype, 0 as baseleftamount , 0 as seqinvply , null as platformid, p.billno, p.custaccountname, p.seqbusiness, p.inpaymentflag, p.ifbillback, p.unitbankno, p.mobilenumber, p.cardflag, p.certificatetype, p.certificateno, p.custemail, p.bankarea, p.certitype, p.inpaymentmethod, p.plandate , '' batchId, '' batchSummaryno, 0 batchAmount, '' AS actualcurrencycode, 0 AS actualexchangerate, p.confirmsequenceno, p.ifupload, '1' as authorizedstate from mm_payablemoney_td p where 1=1 and p.ifbillback='0' and p.basecurrencycode = (:1) and (p.opdate betwee
n (:2) and (:3)) and exists(select 1 from mm_payablemoney_list_td list where 1=1 and list.payableno= p.payableno and list.policyno in (:4) ) and (p.datatype not in ('402', '417', '418') or( p.datatype in('402', '417', '418') and not exists(select 1 from mm_policy_legal where seqbusiness=p.seqbusiness and status<>'2')))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner = :5 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) |
5yu6cdus56fvv | select * from ( select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 and t.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.createdate >= :2 AND t.createdate <:3+1) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='1698' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:4 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit)) ) where rownum <= :5 |
638s0n774w8zh | select count (*) as count from(select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 and t.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.inpaymentdepartment = :2) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='G3131' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:3 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) |
6ajkhukk78nsr | begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end; |
6cgrjhvx3qrvb |
select mmlegaldat_.id, mmlegaldat_.amount as amount55_, mmlegaldat_.bankcity as bankcity55_, mmlegaldat_.bankname as bankname55_, mmlegaldat_.bankprovince as bankprov5_55_, mmlegaldat_.batchid as batchid55_, mmlegaldat_.batchserialno as batchser7_55_, mmlegaldat_.bpstatus as bpstatus55_, mmlegaldat_.businessno as businessno55_, mmlegaldat_.businessstatus as busines10_55_, mmlegaldat_.cardflag as cardflag55_, mmlegaldat_.certificateno as certifi12_55_, mmlegaldat_.certificatetype as certifi13_55_, mmlegaldat_.certitype as certitype55_, mmlegaldat_.createdate as createdate55_, mmlegaldat_.currencycode as currenc16_55_, mmlegaldat_.custaccountname as custacc17_55_, mmlegaldat_.custaccountno as custacc18_55_, mmlegaldat_.custbankno as custbankno55_, mmlegaldat_.custemail as custemail55_, mmlegaldat_.customercode as custome21_55_, mmlegaldat_.customername as custome22_55_, mmlegaldat_.datasource as datasource55_, mmlegaldat_.description as descrip24_55_, mmlegaldat_.errcode as errcode55_, mmlegaldat_.errmsg as errmsg55_, mmlegaldat_.ifneedaudit as ifneeda27_55_, mmlegaldat_.ifpublic as ifpublic55_, mmlegaldat_.inpaymentflag as inpayme29_55_, mmlegaldat_.inpaymentmethod as inpayme30_55_, mmlegaldat_.lastopcode as lastopcode55_, mmlegaldat_.lastopdate as lastopdate55_, mmlegaldat_.mobilenumber as mobilen33_55_, mmlegaldat_.modifybatchno as modifyb34_55_, mmlegaldat_.modifycomment as modifyc35_55_, mmlegaldat_.modifydetail as modifyd36_55_, mmlegal
dat_.modifyopcode as modifyo37_55_, mmlegaldat_.modifyopdate as modifyo38_55_, mmlegaldat_.modifytype as modifytype55_, mmlegaldat_.opcode as opcode55_, mmlegaldat_.realamount as realamount55_, mmlegaldat_.receivedate as receive42_55_, mmlegaldat_.rowversion as rowversion55_, mmlegaldat_.segment1 as segment44_55_, mmlegaldat_.segment2 as segment45_55_, mmlegaldat_.seqbusiness as seqbusi46_55_, mmlegaldat_.status as status55_, mmlegaldat_.summaryamount as summary48_55_, mmlegaldat_.summaryno as summaryno55_, mmlegaldat_.unitbankno as unitbankno55_, mmlegaldat_.usableno as usableno55_ from MM_LEGALDATA_MODIFY_LOG_TD mmlegaldat_ where mmlegaldat_.id=:1 |
6mudrcg20gdzc | select count (*) as count from(select inpaymentid, unitcode, opdate, mmaccountid, accountno, currencycode, amount, basecurrencycode, baseamount, customername, customernameen, customerpartyno, agentcode, usedamount, auditstatus, dailyauditno, opcode, subcompany, coinpaymentid, description, coreason, receiptno, nvl((select s.authorizedstate from mm_settlementcancel_td s where s.listno = i.inpaymentid), 1) as authorizedstate from mm_inpayment_td i where saveflag = '0' and opstatus in ('Z') and subcompany = :1 and opdate between :2 and :3 and (opcode = :4 or :5 in (select p.businesscode from mm_permissions_td p where p.opcode = i.opcode)) ) |
6vx15dmj4s49k | insert into MM_INPAYMENT_TD (accountno, amount, auditstatus, baseamount, basecurrencycode, baseusedamount, cancelflag, checkdate, createdate, currencycode, custaccountno, custbankno, customerbankname, customercode, customername, gatherstatus, hibernateversion, ifprinted, incomemethod, inpaymentbatno, inpaymentmethod, lastopdate, mmaccountid, mmaccountname, mmbankname, opcode, opdate, operatedtimes, opstatus, platformid, rate, remittername, saveflag, subcompany, unitcode, usedamount, inpaymentflag, inpaymentid) 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, '1', :37) |
6wm3n4d7bnddg |
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l ,
DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B
Y source ASC, time_secs DESC, log_id ASC |
70png2sdd4c2y | INSERT INTO RLS_TEMP_LFPPML( INS_CODE, PNO, PAGT1, PAGT2, PPAGT1, PPAGT2, LPLAN, PEFF, PPTD, PCO, PSTU, PDOT) SELECT A.INS_CODE, A.PNO, TO_NUMBER(SUBSTR(A.PPAGT1, -6, 6)), TO_NUMBER(SUBSTR(A.PPAGT2, -6, 6)), A.PPAGT1, A.PPAGT2, TRIM(A.LPLAN), A.PEFF, A.PPTD, A.PCO, A.PSTU, A.PDOT FROM RLS_LFPPML@BFR A |
76q39ztcyk053 |
select platformfi0_.id as id99_, platformfi0_.amount as amount99_, platformfi0_.atsdealdate as atsdeald3_99_, platformfi0_.atsdealerrorinfo as atsdeale4_99_, platformfi0_.atsdealstate as atsdeals5_99_, platformfi0_.atsreturndate as atsretur6_99_, platformfi0_.atsreturninfo as atsretur7_99_, platformfi0_.atsreturnstate as atsretur8_99_, platformfi0_.bank_failtype as bank9_99_, platformfi0_.bank_payresultinfo as bank10_99_, platformfi0_.bankabstract as bankabs11_99_, platformfi0_.batchno as batchno99_, platformfi0_.batchserialno as batchse13_99_, platformfi0_.budgetitemcode as budgeti14_99_, platformfi0_.businessno as businessno99_, platformfi0_.cardflag as cardflag99_, platformfi0_.certificateno as certifi17_99_, platformfi0_.certificatetype as certifi18_99_, platformfi0_.checkbatchno as checkba19_99_, platformfi0_.checkno as checkno99_, platformfi0_.checktype as checktype99_, platformfi0_.createdate as createdate99_, platformfi0_.currencycode as currenc23_99_, platformfi0_.currencyname as currenc24_99_, platformfi0_.custaccountname as custacc25_99_, platformfi0_.custaccountno as custacc26_99_, platformfi0_.custbankarea as custban27_99_, platformfi0_.custbankcity as custban28_99_, platformfi0_.custbankcode as custban29_99_, platformfi0_.custbankname as custban30_99_, platformfi0_.custbankprovince as custban31_99_, platformfi0_.customername as custome32_99_, platformfi0_.customertype as custome33_99_, platformfi0_.custunitbankno as custuni34_99_
, platformfi0_.cvvcode as cvvcode99_, platformfi0_.cvvvaliddate as cvvvali36_99_, platformfi0_.datasource as datasource99_, platformfi0_.departmentcode as departm38_99_, platformfi0_.description as descrip39_99_, platformfi0_.displayorder as display40_99_, platformfi0_.failtype as failtype99_, platformfi0_.fastflag as fastflag99_, platformfi0_.fundcategorycode as fundcat43_99_, platformfi0_.fundsubcategorycode as fundsub44_99_, platformfi0_.inpaymentflag as inpayme45_99_, platformfi0_.inpaymentid as inpayme46_99_, platformfi0_.ispublic as ispublic99_, platformfi0_.lastopcode as lastopcode99_, platformfi0_.lastopdate as lastopdate99_, platformfi0_.memo as memo99_, platformfi0_.merchantno as merchantno99_, platformfi0_.mmaccountid as mmaccou52_99_, platformfi0_.mmaccountname as mmaccou53_99_, platformfi0_.mmaccountno as mmaccou54_99_, platformfi0_.mmbankcode as mmbankcode99_, platformfi0_.mmbankname as mmbankname99_, platformfi0_.mmentitycode as mmentit57_99_, platformfi0_.opcode as opcode99_, platformfi0_.paydate as paydate99_, platformfi0_.paymadedate as paymade60_99_, platformfi0_.payresultinfo as payresu61_99_, platformfi0_.paystate as paystate99_, platformfi0_.paytype as paytype99_, platformfi0_.platformfileid as platfor64_99_, platformfi0_.policyno as policyno99_, platformfi0_.purpose as purpose99_, platformfi0_.refundinfo as refundinfo99_, platformfi0_.refundstate as refunds68_99_, platformfi0_.refundtime as refundtime99_, platformfi0_
.rowversion as rowversion99_, platformfi0_.settlementmode as settlem71_99_, platformfi0_.sourcedealdate as sourced72_99_, platformfi0_.sourcedealerrorinfo as sourced73_99_, platformfi0_.sourcedealstate as sourced74_99_, platformfi0_.sourcerefunddealdate as sourcer75_99_, platformfi0_.sourcerefunddealerrorinfo as sourcer76_99_, platformfi0_.sourcerefunddealstate as sourcer77_99_, platformfi0_.subcompany as subcompany99_, platformfi0_.vendor_code as vendor79_99_ from MM_PLATFORMFILE_DETAIL_TD platformfi0_ where 1=1 and platformfi0_.inpaymentid=:1 |
7frqszzdu8sgg | select DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2 |
7h35uxf5uhmm1 | select sysdate from dual |
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# |
7nnxcwjxnr4ms | select * from ( select * from ( select bfp_voucherdetail_td.*, bfp_voucherdetail_td.segment2 as departmentcode from bfp_voucherdetail_td where 1=1 and bfp_voucherdetail_td.accountingDate >= :1 and bfp_voucherdetail_td.accountingDate < :2 and bfp_voucherdetail_td.currencyCode = :3 and bfp_voucherdetail_td.segment1 = :4 ) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:5 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit)) ) where rownum <= :6 |
803u6vwz0ah1p |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY'
)) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob
j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj#
and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
843z3698rn43r | SELECT nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1 |
8yd6ptfvhq140 | select nvl((select t.email from mm_user_tc t where t.opcode = t1.usercode), t1.usercode) emailaddress from mm_emailadvieslist_td t1 where t1.emailid = :1 |
963852n5aqasf | SELECT SUBCOMPANY FROM MM_DEPARTMENT_TC WHERE DEPARTMENTCODE = :B1 |
9gwrrr6ra2f9q | select sysdate CRTDATE from dual |
9yr92fn9nr1nq |
select * from ( select opcode as opcode, decode(ifsupplement, '1', createdate, '0', receivedate) as opdate, '数据接入' as type, id from mm_policy_legal where seqbusiness = :1 union all select modifyopcode as opcode, modifyopdate as opdate, to_char((select newcode from mm_codemapping_tc where codetype = 'MODIFYTYPE' and oldcode = l.modifytype and reference1 = l.modifydetail)) type, id from mm_legaldata_modify_log_td l where seqbusiness = :2 union all select opcode , createdate as opdate, '财务报盘' as type, t3.id from mm_platformfile_td t3 where exists (select 1 from mm_payablemoney_td t, mm_paymentin_events_td t1, mm_platformfile_detail_td t2 where t.seqbusiness = :3 and t.payableno = t1.newno and t1.oldno = t2.inpaymentid and t2.platformfileid = t3.id) union all select lastopcode as opcode , lastopdate as opdate, '银行回盘' as type, t3.id from mm_platformfile_td t3 where exists (select 1 from mm_payablemoney_td t, mm_paymentin_events_td t1, mm_platformfile_detail_td t2 where t.seqbusiness = :4 and t.payableno = t1.newno and t1.oldno = t2.inpaymentid and t2.lastopdate > t2.createdate and t2.platformfileid = t3.id) union all select opcode , createdate as opdate, '财务报盘' as type, t3.id from mm_platformfile_td t3 where exists (select 1 from mm_payablemoney_td t, mm_paymentin_events_td t1, mm_platformfile_detail_td t2 where t.seqbusiness = :5 and t.payableno = t1.oldno and t1.newno = t2.inpaymentid and t2.platformfileid = t3.id) union all select lastopcode as opcode , last
opdate as opdate
, '银行回盘' as type, t3.id from mm_platformfile_td t3 where exists (select 1 from mm_payablemoney_td t, mm_paymentin_events_td t1, mm_platformfile_detail_td t2 where t.seqbusiness = :6 and t.payableno = t1.oldno and t1.newno = t2.inpaymentid and t2.lastopdate > t2.createdate and t2.platformfileid = t3.id)) order by opdate |
a6u3yjca29nqc | declare
m_stmt varchar2(512);
begin
m_stmt:='delete from sdo_geor_ddl__table$$';
EXECUTE IMMEDIATE m_stmt;
EXCEPTION
WHEN OTHERS THEN
NULL;
end; |
a73024n0k9w46 | update MM_PAYMENTIN_EVENTS_TD set amount=:1, auditdate=:2, auditercode=:3, auditstatus=:4, baseamount=:5, basecurrencycode=:6, businesschannel=:7, businessone=:8, businesstwo=:9, checkdate=:10, checkercode=:11, claimno=:12, classescode=:13, confirmsequenceno=:14, createdate=:15, currencycode=:16, customercode=:17, customername=:18, dailyauditno=:19, datasource=:20, departmentcode=:21, departmentname=:22, description=:23, ebankingsequenceno=:24, endorseno=:25, fatherno=:26, fromunitcode=:27, hibernateversion=:28, ifprintinvoice=:29, ifupload=:30, inpaymentflag=:31, invoiceamount=:32, invoicecode=:33, invoicedunit=:34, issplitted=:35, lastopdate=:36, mmaccountid=:37, newno=:38, oldno=:39, opcode=:40, opcode2=:41, opdate=:42, opstatus=:43, payablelistno=:44, policyno=:45, receiveunit=:46, reference4=:47, returnno=:48, risktype=:49, sonno=:50, splitbatchid=:51, subcompany=:52, tosubcompany=:53, tounitcode=:54, tradebatno=:55 where listno=:56 and hibernateversion=:57 |
abntd984zc4xh |
select count (*) as count from(select * from (select '12' as businesstype, '' as baserealamount, '' as authorizedstate , '' as contractcode, p.agentcode, p.amount as amount, p.bankname, p.baseamount as baseamount, p.basecurrencycode, p.baseusedamount as baseusedamount, p.businessattr, p.canceldate, p.cancelflag, p.claimno, p.classescode, p.currencycode, p.custaccountno, p.custbankno, p.customercode, p.customername, p.applicantnamecn customernameen, p.customerpartyno, p.custseq, p.datasource, p.datatype, p.departmentcode, p.description, p.endorseno, p.fatherno, p.inpaymentbatchno, p.lastopdate, p.opcode, p.opdate, p.opstatus, p.policyno, p.risktype, p.subcompany, p.summaryno, p.createdate, p.unitcode, p.usedamount as usedamount, p.amount - p.usedamount as handledamount, p.baseamount - p.baseusedamount as handledbaseamount, '' as departmentname, 0 as baseleftamount, p.payableno as settlementno, p.usableno as usableno, p.payableseq, p.returnno, p.serialno, p.paytype, p.seqbusiness , p.paycode, p.billno, p.customerkeyword, p.ifsupplement , '' batchId, '' batchSummaryno, 0 batchAmount, '' AS actualcurrencycode, 0 AS actualexchangerate , p.confirmsequenceno , p.ifupload , 0 as seqinvply from mm_payablemoney_td p where 1=1 and p.inpaymentmethod != '04' and p.inpaymentflag = '0' and opstatus in ('0', '1') and subcompany = (:1) and datasource = (:2) and baseamount>0) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.own
er = :3 and biz.powergrade='5' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) |
ack02xpwc7z1b | SELECT A.ACPNO, B.INS_CODE SOURCELIB, B.PCO, B.PEFF, B.PPTD, A.ACPLAN, CASE WHEN A.ACTCD LIKE 'AW%' THEN 0 - A.ACLN ELSE 0 END AMT_636, CASE WHEN A.ACTCD LIKE 'AW%' THEN 0 - A.ACLN * 0.00005 ELSE 0 END AMT_637 FROM RLS_TEMP_LFPACT A, RLS_TEMP_LFPPML B WHERE A.ACPNO = B.PNO AND A.ACTCD LIKE 'AW%' AND EXISTS (SELECT 1 FROM RLS_LFPCHGH@BFR C WHERE C.CREF = A.ACTRNR AND TRIM(C.CTC) = 'L' UNION ALL SELECT 1 FROM RLS_LFPCHG@BFR C WHERE C.CREF = A.ACTRNR AND TRIM(C.CTC) = 'L') AND A.ACDOT = :B1 AND A.ACLN <> 0 |
akh9zqqkx3wj7 | select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1 |
asfsn2qvkj822 | select * from ( select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 and t.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.certitype = :2 AND t.inpaymentdepartment = :3 AND t.customername like :4 AND t.inpaymentflag = :5 AND t.datasource = :6) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='005174' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:7 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit)) ) where rownum <= :8 |
axxpjram6w68k | declare
batchid_out number;
begin
-- Call the procedure
spcdms01.bfp_preposerls_pkg.do_extract(startopdate_in => date'2013-07-06',
endopdate_in => date'2013-07-08',
batchid_out => batchid_out);
end; |
bd502nbh9abbs | select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
|
bhvyz9bgyrhb2 | SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1 |
bn4b3vjw2mj3u |
SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s
chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR
BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1 |
buwgykca9c3hn | SELECT TRIM(MAX(USOCL)) FROM (SELECT USOCL FROM RLS_LFPAPPUS@BFR WHERE USPNO = :B1 UNION ALL SELECT USOCL FROM RLS_LFPAPUSH@BFR WHERE USPNO = :B1 ) |
bvhrznagmf3m3 | update mm_payablemoney_list_td set hibernateversion=hibernateversion+1, lastopdate=sysdate, lastopcode=:1, realamount=:2, opstatus=:3, dcrmatchstatus=:4 where id=:5 |
c1vr2w9vja27p | select count (*) as count from(select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 and t.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.inpaymentdepartment = :2) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='1698' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:3 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) |
c8gnrhxma4tas | SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1 |
cbasm16fcz3c3 | select * from mm_policy_ti where datasource = 'NEWGROUP' and bpstatus in ('12', 'Z1', 'Z2') |
cbwszvzaby2r4 | insert into MM_PAYMENTIN_EVENTS_TD (amount, auditstatus, baseamount, basecurrencycode, businessone, businesstwo, classescode, currencycode, customername, datasource, departmentcode, departmentname, fromunitcode, hibernateversion, inpaymentflag, mmaccountid, newno, oldno, opcode, opcode2, opdate, opstatus, payablelistno, policyno, subcompany, tosubcompany, tounitcode, tradebatno, listno) 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) |
cndpkawm505jx | select count (*) as count from(select inpaymentid, unitcode, opdate, mmaccountid, accountno, currencycode, amount, basecurrencycode, baseamount, customername, customernameen, customerpartyno, agentcode, usedamount, auditstatus, dailyauditno, opcode, subcompany, coinpaymentid, description, coreason, nvl((select s.authorizedstate from mm_settlementcancel_td s where s.listno = i.inpaymentid), 1) as authorizedstate , receiptno from mm_inpayment_td i where saveflag = '0' and inpaymentflag='0' and opstatus in ('0', '1', '2') and subcompany = :1 and opdate between :2 and :3 and (opcode = :4 or :5 in (select p.businesscode from mm_permissions_td p where p.opcode = i.opcode)) and amount >= :6 and amount <= :7and not exists (select 1 from mm_platformfile_detail_td t1 where exists (select 1 from mm_platformfile_td t2 where exists (select 1 from mm_bankplatform_tc t3 where t3.ifdirect = '1' and t3.platformid = t2.platformid) and t2.id = t1.platformfileid) and t1.inpaymentid = i.inpaymentid)) |
cwt8b6a6t8a79 | insert into MM_PLATFORMFILE_DETAIL_TD (amount, batchno, batchserialno, businessno, cardflag, currencycode, currencyname, custaccountname, custaccountno, custbankarea, custbankcity, custbankcode, custbankname, custbankprovince, customername, customertype, cvvcode, datasource, departmentcode, displayorder, fastflag, fundcategorycode, inpaymentflag, inpaymentid, ispublic, lastopcode, lastopdate, mmaccountid, mmaccountname, mmaccountno, mmbankcode, mmbankname, opcode, paydate, paytype, platformfileid, policyno, rowversion, settlementmode, subcompany, 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) |
d38x404f54ybs | insert into MM_PAYMENTIN_EVENTS_TD (amount, auditstatus, baseamount, basecurrencycode, businessone, businesstwo, claimno, currencycode, customername, datasource, departmentcode, departmentname, endorseno, fromunitcode, hibernateversion, inpaymentflag, mmaccountid, newno, oldno, opcode, opcode2, opdate, opstatus, payablelistno, policyno, subcompany, tosubcompany, tounitcode, tradebatno, listno) 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) |
d8m9rbpwuz01x | select * from ( select inpaymentid, unitcode, opdate, mmaccountid, accountno, currencycode, amount, basecurrencycode, baseamount, customername, customernameen, customerpartyno, agentcode, usedamount, auditstatus, dailyauditno, opcode, subcompany, coinpaymentid, description, coreason, nvl((select s.authorizedstate from mm_settlementcancel_td s where s.listno = i.inpaymentid), 1) as authorizedstate , receiptno from mm_inpayment_td i where saveflag = '0' and inpaymentflag='0' and opstatus in ('0', '1', '2') and subcompany = :1 and opdate between :2 and :3 and (opcode = :4 or :5 in (select p.businesscode from mm_permissions_td p where p.opcode = i.opcode)) and amount >= :6 and amount <= :7and not exists (select 1 from mm_platformfile_detail_td t1 where exists (select 1 from mm_platformfile_td t2 where exists (select 1 from mm_bankplatform_tc t3 where t3.ifdirect = '1' and t3.platformid = t2.platformid) and t2.id = t1.platformfileid) and t1.inpaymentid = i.inpaymentid) ) where rownum <= :8 |
dfzk5b2bw668m |
select tbl_.batchid, tbl_.policyno, tbl_.seqreportno, tbl_.voucherno, tbl_.voucherType, tbl_.businessType, tbl_.entered_Dr, tbl_.entered_Cr, tbl_.segment4, tbl_.reportKind, tbl_.segment1, tbl_.segment2, tbl_.accountingDate, tbl_.segment3, tbl_.segment5, tbl_.segment6, tbl_.segment7, tbl_.segment8, tbl_.currencyCode, tbl_.businessNo, tbl_.accounted_Cr, tbl_.attribute3, tbl_.customerCode, tbl_.customerName, tbl_.description, tbl_.opdate, tbl_.status, tbl_.accounted_Dr, tbl_.jeLineNo, tbl_.segment9, tbl_.segment10, tbl_.segment11, tbl_.segment12, tbl_.segment13, tbl_.segment14, tbl_.segment15, tbl_.segment16, tbl_.segment17, tbl_.segment18, tbl_.segment19, tbl_.segment20 from (select * from ( select bfp_voucherdetail_td.*, bfp_voucherdetail_td.segment2 as departmentcode from bfp_voucherdetail_td where 1=1 and bfp_voucherdetail_td.accountingDate >= timestamp'2013-07-08 00:00:00' and bfp_voucherdetail_td.accountingDate < timestamp'2013-07-09 00:00:00' and bfp_voucherdetail_td.currencyCode = 'RMB' and bfp_voucherdetail_td.segment1 = 'SY' ) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner ='002869' and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) tbl_
|
f5yun5dynkskv |
select s.synonym_name as object_name, o.object_type
from all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
|
f64xbv6132vpj | INSERT INTO RLS_TEMP_LFPAPPL ( PNO, INS_CODE , PCO , LPLAN , PAGT1 , PAGT2 ) SELECT C.PNO, C.INS_CODE, C.PCO, TRIM(C.LPLAN) LPLAN, C.PAGT1, C.PAGT2 FROM RLS_LFPAPPL@BFR C UNION ALL SELECT D.PNO, D.INS_CODE , D.PCO, TRIM(D.LPLAN) LPLAN, D.PAGT1, D.PAGT2 FROM RLS_LFPAPPLH@BFR D |
fcsr3mt7jzznq | SELECT NVL(MAX(TRIM(AGTYP)), 'AD') AGTYP, MAX(AGNAME) FROM RAS_AGPCONT@BFR WHERE INS_CODE=:B2 AND AGAGC=:B1 |
fgbmcgrgqa1zx | update mm_policylist_legal set bpstatus = :1 , businessstatus = :2 , status = :3 , lastopcode = :4 , Lastopdate = :5 , errmsg = :6 where seqpolicy = :7 |
fnz13xnvkybtj | INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id, name_msg_code, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) |
fvwcc2yxafszu | update MM_POLICYLIST_LEGAL set agentcode=:1, agentname=:2, amount=:3, applicode=:4, appliname=:5, applinameen=:6, bizno=:7, bpstatus=:8, businesschannel=:9, businessstatus=:10, claimno=:11, classescode=:12, classeskind=:13, createdate=:14, currencycode=:15, datatype=:16, departmentcode=:17, enddate=:18, endorseno=:19, errmsg=:20, grflag=:21, hasplan=:22, inputdate=:23, insuredcode=:24, insuredname=:25, insurednameen=:26, lastopcode=:27, lastopdate=:28, offsetno=:29, opcode=:30, plandate=:31, policyno=:32, realamount=:33, receivedate=:34, renewalflag=:35, rowversion=:36, segment1=:37, segment2=:38, seqbusiness=:39, seqbusinesslist=:40, seqpolicy=:41, serialno=:42, signdate=:43, startdate=:44, status=:45, subcompany=:46, transactorcode=:47, underwritercode=:48 where id=:49 and rowversion=:50 |
fz0ya076jdvj1 | select count (*) as count from(select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 and t.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.createdate >= :2 AND t.createdate <:3+1) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='1698' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:4 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) |
g0thukcaqz0r2 |
select mmlegaldat_.id, mmlegaldat_.amount as amount1_, mmlegaldat_.bankcity as bankcity1_, mmlegaldat_.bankname as bankname1_, mmlegaldat_.bankprovince as bankprov5_1_, mmlegaldat_.batchid as batchid1_, mmlegaldat_.batchserialno as batchser7_1_, mmlegaldat_.bpstatus as bpstatus1_, mmlegaldat_.businessno as businessno1_, mmlegaldat_.businessstatus as busines10_1_, mmlegaldat_.cardflag as cardflag1_, mmlegaldat_.certificateno as certifi12_1_, mmlegaldat_.certificatetype as certifi13_1_, mmlegaldat_.certitype as certitype1_, mmlegaldat_.createdate as createdate1_, mmlegaldat_.currencycode as currenc16_1_, mmlegaldat_.custaccountname as custacc17_1_, mmlegaldat_.custaccountno as custacc18_1_, mmlegaldat_.custbankno as custbankno1_, mmlegaldat_.custemail as custemail1_, mmlegaldat_.customercode as custome21_1_, mmlegaldat_.customername as custome22_1_, mmlegaldat_.datasource as datasource1_, mmlegaldat_.description as descrip24_1_, mmlegaldat_.errcode as errcode1_, mmlegaldat_.errmsg as errmsg1_, mmlegaldat_.ifneedaudit as ifneeda27_1_, mmlegaldat_.ifpublic as ifpublic1_, mmlegaldat_.inpaymentflag as inpayme29_1_, mmlegaldat_.inpaymentmethod as inpayme30_1_, mmlegaldat_.lastopcode as lastopcode1_, mmlegaldat_.lastopdate as lastopdate1_, mmlegaldat_.mobilenumber as mobilen33_1_, mmlegaldat_.modifybatchno as modifyb34_1_, mmlegaldat_.modifycomment as modifyc35_1_, mmlegaldat_.modifydetail as modifyd36_1_, mmlegaldat_.modifyopcode as modifyo37_1_,
mmlegaldat_.modifyopdate as modifyo38_1_, mmlegaldat_.modifytype as modifytype1_, mmlegaldat_.opcode as opcode1_, mmlegaldat_.realamount as realamount1_, mmlegaldat_.receivedate as receive42_1_, mmlegaldat_.rowversion as rowversion1_, mmlegaldat_.segment1 as segment44_1_, mmlegaldat_.segment2 as segment45_1_, mmlegaldat_.seqbusiness as seqbusi46_1_, mmlegaldat_.status as status1_, mmlegaldat_.summaryamount as summary48_1_, mmlegaldat_.summaryno as summaryno1_, mmlegaldat_.unitbankno as unitbankno1_, mmlegaldat_.usableno as usableno1_ from MM_LEGALDATA_MODIFY_LOG_TD mmlegaldat_ where mmlegaldat_.id=:1 |
g4pqhxju85rdr | select count (*) as count from(select * from ( select bfp_voucherdetail_td.*, bfp_voucherdetail_td.segment2 as departmentcode from bfp_voucherdetail_td where 1=1 and bfp_voucherdetail_td.accountingDate >= :1 and bfp_voucherdetail_td.accountingDate < :2 and bfp_voucherdetail_td.currencyCode = :3 and bfp_voucherdetail_td.segment1 = :4 ) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:5 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit))) |
gbcsnmy9kqjm8 | insert into MM_PLATFORMFILE_DETAIL_TD (amount, batchno, batchserialno, businessno, cardflag, currencycode, currencyname, custaccountname, custaccountno, custbankarea, custbankcity, custbankcode, custbankprovince, customername, customertype, cvvcode, datasource, departmentcode, displayorder, fastflag, fundcategorycode, inpaymentflag, inpaymentid, ispublic, lastopcode, lastopdate, mmaccountid, mmaccountname, mmaccountno, mmbankcode, mmbankname, opcode, paydate, paytype, platformfileid, policyno, rowversion, settlementmode, subcompany, 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) |
gc8wdrc4ndxsb | insert into MM_PAYMENTIN_EVENTS_TD (amount, auditstatus, baseamount, basecurrencycode, businessone, businesstwo, currencycode, customercode, customername, datasource, departmentcode, departmentname, fromunitcode, hibernateversion, inpaymentflag, mmaccountid, newno, oldno, opcode, opcode2, opdate, opstatus, payablelistno, policyno, subcompany, tosubcompany, tounitcode, tradebatno, listno) 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) |
gdn3ysuyssf82 | SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1 |
gnbryh5283zcp | select * from ( select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 AND t.certitype = :1 AND t.inpaymentdepartment = :2 AND t.customername like :3 AND t.inpaymentflag = :4 AND t.datasource = :5) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='005174' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:6 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit)) ) where rownum <= :7 |
gtgdp28a44js0 | select * from MM_PAYABLEMONEY_LIST_TD where payableno = :1 order by amount, id |