| SQL Id | SQL Text |
|---|
| 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' |
| 0g023nsr9qtjq | select * from mm_policy_ti a where a.bpstatus = '1' and a.datasource = 'NEWGROUP' and rownum <= 20 |
| 0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 0zz0a65tg0d1a | select * from (select c.applyno, c.taskcode, t.tasktype, c.Param, c.sqlstr, b.opcode, (case when t.taskcode='common_download' then c.fieldname else t.fieldname end) as fieldname from mm_querycontrol_td c, mm_querytaskcode_tc t, mm_queryapply_td b where c.status = '1' and c.taskcode = t.taskcode and c.applyno = b.q_c_applyno) where rownum <= 30 |
| 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# (+) |
| 1k5c5twx2xr01 | insert into sys.scheduler$_job_run_details (log_id, log_date, req_start_date, start_date, run_duration, instance_id, session_id, slave_pid, cpu_used, error#, additional_info) values (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7, numtodsinterval(:8/100, 'second'), :9, :10) |
| 1ng6v39qb5hxg | /*
The name + type results of these queries will be used by the Code Assistant
if the "Describe Context" option is enabled. After typing 3 or more characters
the Code Assistant will show a list of matching names.
Separate multiple queries with semi-colons and use the :schema bind variable
to restrict names to the currently connected user.
In case of an error the query results will be omitted. No error message will
be displayed.
Place this file in the PL/SQL Developer installation directory for all users,
or in the "%APPDATA%\PLSQL Developer" directory for a specific user.
*/
select object_name, object_type
from sys.all_objects o
where o.owner = :schema
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
|
| 26djmqa9kmk6z | SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number |
| 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 ) |
| 2wrf9q66bhg88 | SELECT /*+ driving_site(a) */ A.PNO, A.INS_CODE SOURCELIB, A.PCO, TRIM(B.C1PLAN) C1PLAN, A.PMODE, B.C1PREM, A.PEFF, A.PPTD FROM RLS_LFPPML@BFR A, RLS_CAPPOLPRM@BFR B WHERE A.PNO = B.C1PNO AND A.PSTU = '1' AND B.C1PREM <> 0 AND A.PEFF <> A.PPTD AND (((A.PPTD - :B1 ) * (ADD_MONTHS(TO_DATE(A.PPTD, 'yyyy-mm-dd'), 1) - :B2 ) * (ADD_MONTHS(TO_DATE(A.PPTD, 'yyyy-mm-dd'), 2) - :B2 ) = 0 AND A.PMODE = 'M') OR (A.PMODE <> 'M' AND A.PPTD = :B1 )) AND ( A.LPLAN =B.C1PLAN OR EXISTS (SELECT 1 FROM RLS_LFPRIDR@BFR WHERE PNO = B.C1PNO AND RPLAN = B.C1PLAN AND RSTU IS NULL )) AND EXISTS (SELECT 1 FROM BFP_CLASSESCODE_TC WHERE IFUL = 'N' AND CLASSESCODE = TRIM(B.C1PLAN)) |
| 31n26us0tmayx | SELECT T.SEGMENT8_LOW, T.SEGMENT9_LOW, T.SEGMENT10_LOW, T.SEGMENT11_LOW, T.SEGMENT12_LOW, T.SEGMENT13_LOW, T.SEGMENT14_LOW, T.SEGMENT15_LOW, T.SEGMENT16_LOW, T.SEGMENT17_LOW FROM BFP_RULES_TD T WHERE T.BATCH_ID = '630' AND T.FLEX_VALIDATION_RULE_NAME = 'ALL_VOUCHER_TCODE' AND T.ENABLED_FLAG = 'Y' AND T.SEGMENT1_LOW = :B2 AND T.SEGMENT4_LOW = :B1 |
| 31w9fsmunh1rx | 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.datasource = :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 ='002734' ))) 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))) |
| 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 |
| 350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
| 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$$ |
| 3d844nhux431y | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN BFP_JOBVOUCHER_PKG.jobREportAndMirror(i_jobName =>'700' ); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 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) |
| 3mvb01r7xwy14 | SELECT COUNT(*) / 2000 FROM MM_POLICY_TI WHERE STATUS = '1' |
| 3wr2mysfyh36n | select null from sys.all_mviews
where owner = :object_owner
and mview_name = :object_name
|
| 3xgw35tqxsmvb | SELECT MAX(A.CONTRACTTYPE) FROM RLS_TEMP_LACONTRACT A WHERE A.AGENTCODE = :B2 || SUBSTR(:B1 , -6, 6) |
| 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) |
| 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 |
| 52pf5dda6qnjg | INSERT INTO BFP_TMP_MIRRORDETAIL( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, MODIFYDESC, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, BUSINESSCHANNEL, STARTDATE, ENDDATE, SIGNDATE, DATATYPE) SELECT NULL, NULL, NULL , C.SUBCOMPANY, V.SEGMENT2, V.CURRENCYCODE, V.ENTERED_DR, V.ENTERED_CR, 0, V.ACCOUNTINGDATE, V.CUSTOMERNAME, '0' , V.POLICYNO, NULL, C.UNITCODE, NULL, NULL, V.SEGMENT5, (SELECT EC.CLASSESCODENAME FROM BFP_CLASSESCODE_TC EC WHERE EC.CLASSESCODE =V.SEGMENT5 ) CLASSESCODENAME, (SELECT UC.UNITNAME FROM MM_UNIT_TC UC WHERE UC.UNITCODE = C.UNITCODE AND UC.IFVALID = '1') UNITNAME, (SELECT DC.DEPARTMENTNAME FROM MM_DEPARTMENT_TC DC WHERE DC.DEPARTMENTCODE = V.SEGMENT2 AND DC.IFVALID = '1') DEPARTMENTNAME, NULL, NULL, NULL, NULL, 'TERM' FROM MM_UNIT_TC C, BFP_VOUCHERDETAIL_TD V WHERE V.SEGMENT1 = C.UNITCODE AND C.SUBCOMPANY = :B3 AND C.IFVALID = '1' AND V.SEGMENT4 IN (SELECT P.NEWCODE FROM MM_CODEMAPPING_TC P WHERE P.OLDCODE = :B4 AND P.IFVALID = '1' AND P.CODETYPE = 'MIRRORMAPPING') AND TRUNC(V.ACCOUNTINGDATE) BETWEEN :B2 + 1 AND :B1 |
| 61tn3mam0vq0b |
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.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_MEMB
ERS 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.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.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.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.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
|
| 63u3rctccppxb | DELETE FROM BFP_MIRRORDETAIL_TD WHERE MIRRORID = :B1 |
| 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 |
| 6g8xxwfvnrh76 | SELECT T.* FROM ATS_PAY_TRANSACTIONS T WHERE T.ATS_RETURNSTATE = '2' AND (SOURCE_DEALSTATE = '1' OR (REFUND_STATE = '2' AND SOURCE_REFUNDDEALSTATE = '1')) |
| 6mq1v48177hdu | SELECT /*+ driving_site(a) */ A.DCPNO, A.INS_CODE SOURCELIB, A.DCPCO, TRIM(A.DCPLAN) DCPLAN, DCPREM - DCDVD - DCDVDI - DCFPD AMT_D, A.DCDVD DCDVD, A.DCDVDI DCDVDI, A.DCFPD DCFPD, TRIM(A.DCFYP) DCFYP FROM RLS_LFPPREMS@BFR A WHERE A.DCRDOP = :B1 |
| 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 |
| 77fbpzq5a3jyj | SELECT T.SEGMENT8_LOW, T.SEGMENT9_LOW, T.SEGMENT10_LOW, T.SEGMENT11_LOW, T.SEGMENT12_LOW, T.SEGMENT13_LOW, T.SEGMENT14_LOW, T.SEGMENT15_LOW, T.SEGMENT16_LOW, T.SEGMENT17_LOW FROM BFP_RULES_TD T WHERE T.BATCH_ID ='630' AND T.FLEX_VALIDATION_RULE_NAME ='ALL_VOUCHER_TCODE' AND T.SEGMENT1_LOW = :B2 AND T.SEGMENT4_LOW = :B1 |
| 7aw21806wpgzp | select null from all_synonyms where 1=0
|
| 7bn2adzszradf | SELECT A.ACPNO, A.INS_CODE SOURCELIB, A.ACPCO, A.ACPLAN, CASE WHEN A.ACTCD IN ('LA', 'PC', 'FP', 'D2') THEN 0- A.ACFPD ELSE 0 END ACFPD, CASE WHEN A.ACTCD IN ('LA', 'D2') THEN 0- A.ACDVD ELSE 0 END ACDVD, CASE WHEN A.ACTCD IN ('LA', 'D2') THEN 0- A.ACDVDI ELSE 0 END ACDVDI, CASE WHEN A.ACTCD = 'LA' THEN 0- A.ACLN ELSE 0 END ACLN, CASE WHEN A.ACTCD = 'LA' THEN 0- A.ACLNI ELSE 0 END ACLNI, CASE WHEN A.ACTCD = 'LA' THEN 0- A.ACMAE ELSE 0 END ACMAE FROM (SELECT ACPNO, INS_CODE, ACPCO, ACPLAN, ACTCD, ACFPD, ACDVD, ACDVDI, ACLN, ACLNI, ACMAE, ACDOT FROM RLS_TEMP_LFPACT WHERE ACTCD IN ('LA', 'PC', 'FP', 'D2') ) A WHERE EXISTS (SELECT 1 FROM ( SELECT DCPNO, DCACT, DCDOT FROM RLS_LFPPREM@BFR UNION ALL SELECT DCPNO, DCACT, DCDOT FROM RLS_LFPPREMH@BFR ) B WHERE TRIM(B.DCPNO) = TRIM(A.ACPNO) AND TRIM(B.DCACT) = A.ACTCD AND B.DCDOT = A.ACDOT) AND A.ACDOT=:B1 |
| 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# |
| 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 |
| 8c21hbhf1t608 | SELECT A.M2PNO, A.INS_CODE SOURCELIB, A.M2PCO, B.ACPLAN, SUM(DECODE(TRIM(M2TCOD), 'TUC', A.M2AMTF, 'TUP', A.M2AMTF, 'LSC', A.M2AMTF, 'LSP', A.M2AMTF, 'CNL', -1*A.M2AMTF)) AMT652 FROM RLS_LFPUFTDH@BFR A, (SELECT ACPNO, MAX(ACPLAN) ACPLAN FROM RLS_TEMP_LFPACT WHERE ACTCD IN ('Z1', 'Z2', 'Z3', 'Z4') AND ACDOT = :B1 GROUP BY ACPNO) B WHERE A.M2TCOD IN ('CNL', 'TUC', 'TUP', 'LSC', 'LSP') AND A.M2PNO = B.ACPNO GROUP BY A.M2PNO, A.INS_CODE, A.M2PCO, B.ACPLAN |
| 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
|
| 8p409rzcjjbat | SELECT DECODE(VALUE, 'UNUSED', NULL, TO_NUMBER(VALUE)) FROM WRI$_ADV_PARAMETERS WHERE TASK_ID = :B1 AND NAME = 'START_SNAPSHOT' |
| 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 |
| 92yv7gw4g8b94 | SELECT decode(es.name, 'cache', 0, 'dlm', 1, 'ipq', 2, 3) as client_id, (es.bytes_sent - bs.bytes_sent) as bytes FROM WRH$_IC_CLIENT_STATS es , WRH$_IC_CLIENT_STATS bs WHERE es.dbid = :dbid AND es.snap_id = :eid AND bs.dbid = :dbid AND bs.instance_number = es.instance_number AND bs.snap_id = :bid AND es.name = bs.name |
| 9qhrn5fx6h095 | INSERT INTO BFP_TMP_MIRRORDETAIL( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, MODIFYDESC, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, BUSINESSCHANNEL, STARTDATE, ENDDATE, SIGNDATE, DATATYPE) SELECT NULL, NULL, NULL , C.SUBCOMPANY, V.SEGMENT2, V.CURRENCYCODE, V.ENTERED_CR, V.ENTERED_DR, 0, V.ACCOUNTINGDATE, V.CUSTOMERNAME, '0' , V.POLICYNO, NULL, C.UNITCODE, NULL, NULL, NULL, NULL, (SELECT UC.UNITNAME FROM MM_UNIT_TC UC WHERE UC.UNITCODE = C.UNITCODE AND UC.IFVALID = '1') UNITNAME, (SELECT DC.DEPARTMENTNAME FROM MM_DEPARTMENT_TC DC WHERE DC.DEPARTMENTCODE = V.SEGMENT2 AND DC.IFVALID = '1') DEPARTMENTNAME, NULL, NULL, NULL, NULL, 'TERM' FROM MM_UNIT_TC C, BFP_VOUCHERDETAIL_TD V WHERE V.SEGMENT1 = C.UNITCODE AND C.SUBCOMPANY = :B3 AND C.IFVALID = '1' AND V.SEGMENT4 IN (SELECT P.NEWCODE FROM MM_CODEMAPPING_TC P WHERE P.OLDCODE = :B4 AND P.IFVALID = '1' AND P.CODETYPE = 'MIRRORMAPPING') AND TRUNC(V.ACCOUNTINGDATE) BETWEEN :B2 + 1 AND :B1 |
| 9tgj4g8y4rwy8 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
| 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 |
| a34r71rnhycqh | SELECT SEQ_VOUCHER.NEXTVAL FROM DUAL |
| 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 |
| 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 |
| 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 |
| ahkzgdb62gjk8 | DELETE FROM BFP_RISKSPLIT_TD A WHERE TRUNC(A.SPLITDATE) = :B1 |
| ajymgnp1qnruw | select o.name, o.owner# from obj$ o, type$ t where o.oid$ = t.tvoid and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007 |
| 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 |
| b7w2w7mhjk05u | INSERT INTO BFP_POLICY_TI (SEQREPORTNO, SEQBUSINESS, BATCHID, DATASOURCE, POLICYNO, CLAIMNO, BUSINESSONE, BUSINESSTWO, CURRENCYCODE, AMOUNT, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, STATUS, CLASSESCODE, SUBCOMPANY, DEPARTMENTCODE, OPDATE, HASPLAN, CERTITYPE, EMPLOYESTATUS, GRFLAG, RENEWALFLAG, PREMTYPE, BUSINESSCHANNEL, AGENTCODE , AGENTNAME) SELECT SEQ_DEFAULT.NEXTVAL, SEQBUSINESS, :B3 , DATASOURCE, POLICYNO, CLAIMNO, '01302', '667', CURRENCYCODE, 0 - AMOUNT, OPCODE, SYSDATE CREATEDATE, SYSDATE RECEIVEDATE, LASTOPCODE, SYSDATE LASTOPDATE, '1' STATUS, CLASSESCODE, SUBCOMPANY, DEPARTMENTCODE, :B2 , HASPLAN, CERTITYPE, EMPLOYESTATUS, '101', '0', PREMTYPE, BUSINESSCHANNEL, AGENTCODE , AGENTNAME FROM BFP_POLICY_TI WHERE BUSINESSONE = '01204' AND BUSINESSTWO ='642' AND POLICYNO = :B1 |
| bfst4kkjb9bzn | insert into sys.scheduler$_event_log (log_id, log_date, type#, name, owner, operation, status, user_name, client_id, guid, dbid, additional_info, destination, class_id) values (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7, :8, :9, NULL, :10, :11, :12) |
| bhvyz9bgyrhb2 | SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1 |
| bszs56at7vx1b | UPDATE BFP_VOUCHERDETAIL_TD SET VOUCHERNO = :B23 || :B28 , JELINENO = :B27 WHERE ACCOUNTINGDATE = :B26 AND CURRENCYCODE = :B25 AND VOUCHERTYPE = :B24 AND SEGMENT1 = :B23 AND SEGMENT2 = :B22 AND NVL(SEGMENT3, 'NLL') = NVL(:B21 , 'NLL') AND SEGMENT4 = :B20 AND NVL(SEGMENT5, 'NLL') = NVL(:B19 , 'NLL') AND NVL(SEGMENT6, 'NLL') = NVL(:B18 , 'NLL') AND NVL(SEGMENT7, 'NLL') = NVL(:B17 , 'NLL') AND NVL(SEGMENT8, 'NLL') = NVL(:B16 , 'NLL') AND NVL(SEGMENT9, 'NLL') = NVL(:B15 , 'NLL') AND NVL(SEGMENT10, 'NLL') = NVL(:B14 , 'NLL') AND NVL(SEGMENT11, 'NLL') = NVL(:B13 , 'NLL') AND NVL(SEGMENT12, 'NLL') = NVL(:B12 , 'NLL') AND NVL(SEGMENT13, 'NLL') = NVL(:B11 , 'NLL') AND NVL(SEGMENT14, 'NLL') = NVL(:B10 , 'NLL') AND NVL(SEGMENT15, 'NLL') = NVL(:B9 , 'NLL') AND NVL(SEGMENT16, 'NLL') = NVL(:B8 , 'NLL') AND NVL(SEGMENT17, 'NLL') = NVL(:B7 , 'NLL') AND (SEGMENT19 = :B6 OR SEGMENT19 IS NULL) AND (SEGMENT20 = :B5 OR SEGMENT20 IS NULL) AND IFSUPPLEMENT = :B4 AND DECODE(0.00, :B3 , ENTERED_DR, :B2 , ENTERED_CR) = 0.00 AND STATUS IN ('0', '7') AND BATCHID = :B1 |
| bu5x9yrrd2vvu | UPDATE SYS.WRI$_ADV_PARAMETERS A SET A.VALUE = :B1 , A.FLAGS = :B4 WHERE A.TASK_ID = :B3 AND A.NAME = :B2 AND A.VALUE <> :B1 |
| 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 ) |
| buxhp761775fs |
INSERT INTO BFP_MIRRORDETAIL_TD ( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, ACCOUNTDATE, BUSINESSCHANNEL, POLICYNO, UNITCODE, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, TIMESTAMP, HIBERNATEVERSION) SELECT SEQ_LISTNO.NEXTVAL, (SELECT MIRRORID FROM BFP_MIRROR_TD WHERE MIRRORDATE=T.ACCOUNTDATE AND SUBCOMPANY=T.SUBCOMPANY AND MIRRORTYPE=:B4 AND TYPE=:B5 ) MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, ACCOUNTDATE, BUSINESSCHANNEL, POLICYNO, UNITCODE, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, TIMESTAMP, HIBERNATEVERSION FROM( SELECT SEGMENT4 ERPACCOUNTCODE, B.SUBCOMPANY, A.SEGMENT2 DEPARTMENTCODE, A.CURRENCYCODE, A.SEGMENT6 BUSINESSCHANNEL, SUM(CASE WHEN :B4 ='201' THEN ENTERED_CR - ENTERED_DR ELSE ENTERED_DR - ENTERED_CR END) AMOUNT, TRUNC(A.ACCOUNTINGDATE) ACCOUNTDATE, MAX(B.UNITCODE) UNITCODE, A.SEGMENT5 CLASSESCODE, A.POLICYNO, (SELECT MAX(EC.ERPCLASSESNAME) FROM BFP_ERPCLASSES_TC EC WHERE EC.ERPCLASSESCODE =A.SEGMENT5 AND EC.ENABLEDFLAG = '1') CLASSESCODENAME, MAX(B.UNITNAME) UNITNAME, (SELECT MAX(DC.DEPARTMENTNAME) FROM MM_DEPARTMENT_TC DC WHERE DC.DEPARTMENTCODE = A.SEGMENT2 AND DC.IFVALID = '1') DEPARTMENTNAME, SYSDATE TIMESTAMP, '1' HIBERNATEVERSION FROM BFP_VOUCHERDETAIL_TD A, MM_UNIT_TC B WHERE A.SEGMENT1=B.UNITCODE AND A.ACCOUNTINGDATE>=:B3 AND A.ACCOUNTINGDATE<:B2 +1 AND B.SUBCOMPANY=:B1 AND A.SEGMENT4 IN (SELECT NEWCODE FROM MM_CO
DEMAPPING_TC WHERE CODETYPE ='MIRRORMAPPING' AND OLDCODE =:B4 ) GROUP BY TRUNC(A.ACCOUNTINGDATE), A.SEGMENT4, B.SUBCOMPANY, A.SEGMENT2, A.CURRENCYCODE, A.SEGMENT5, A.POLICYNO, A.SEGMENT6) T WHERE T.AMOUNT <> 0 |
| c0xy1zgazyym8 | INSERT INTO BFP_MIRRORDETAIL_TD ( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, MODIFYDESC, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, STARTDATE, ENDDATE, SIGNDATE, TIMESTAMP, HIBERNATEVERSION, BUSINESSCHANNEL) SELECT SEQ_LISTNO.NEXTVAL, :B2 , ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, NULL, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, STARTDATE, ENDDATE, SIGNDATE, :B1 , '1', BUSINESSCHANNEL FROM BFP_TMP_MIRRORDETAIL T WHERE T.DATATYPE = 'SUM' |
| c61yvrr104ppk |
SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid
= s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst |
| 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') |
| cfw87jaa04qd8 | select path from MM_QUERYFILE_TD where applyno=:1 |
| f4r1rrdkxdnaz | INSERT INTO BFP_TEMP_BUSINESS (POLICYNO, AMOUNT, ACCOUNTDATE, DATATYPE) SELECT D.POLICYNO, SUM(D.REMAINS), :B1 , 'MDS' DATATYPE FROM BFP_MIRRORDETAIL_TD D, BFP_MIRROR_TD M WHERE D.MIRRORID = M.MIRRORID AND M.MIRRORDATE = :B1 AND M.MIRRORTYPE = '101' GROUP BY D.POLICYNO |
| 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 |
| fasad8pywykdm | INSERT INTO BFP_TMP_MIRRORDETAIL( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, MODIFYDESC, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, STARTDATE, ENDDATE, SIGNDATE, TIMESTAMP, HIBERNATEVERSION, DATATYPE, BUSINESSCHANNEL) SELECT T.LISTNO, T.MIRRORID, T.ERPACCOUNTCODE, T.SUBCOMPANY, T.DEPARTMENTCODE, T.CURRENCYCODE, T.AMOUNT, T.USEDAMOUNT, T.REMAINS, T.ACCOUNTDATE, T.CUSTOMERNAME, T.OPSTATUS, T.POLICYNO, T.ENDORSENO, T.UNITCODE, T.CLAIMNO, T.MODIFYDESC, T.CLASSESCODE, T.CLASSESCODENAME, T.UNITNAME, T.DEPARTMENTNAME, T.STARTDATE, T.ENDDATE, T.SIGNDATE, T.TIMESTAMP, T.HIBERNATEVERSION, 'INIT', T.BUSINESSCHANNEL FROM BFP_MIRRORDETAIL_TD T, BFP_MIRROR_TD M WHERE T.MIRRORID = M.MIRRORID AND M.MIRRORDATE = :B3 AND M.SUBCOMPANY = :B2 AND M.MIRRORTYPE = :B1 |
| fc1ct948abkwr | INSERT INTO BFP_POLICY_TD (SEQREPORTNO, BATCHID, SEQBUSINESS, SUBCOMPANY, DEPARTMENTCODE, POLICYNO, ENDORSENO, CLAIMNO, BIZNO, BUSINESSONE, BUSINESSTWO, SERIALNO, CURRENCYCODE, AMOUNT, CLASSESKIND, CLASSESCODE, STARTDATE, ENDDATE, SIGNDATE, INPUTDATE, PLANDATE, TRANSACTORCODE, UNDERWRITERCODE, AGENTCODE, AGENTNAME, BUSINESSCHANNEL, GRFLAG, HASPLAN, RENEWALFLAG, OFFSETNO, REALAMOUNT, SEGMENT1, SEGMENT2, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, ROWVERSION, STATUS, ERRMSG, TOUNITCODE, FROMUNITCODE, DESCRIPTION, DATASOURCE, OPDATE, CUSTOMERCODE, CUSTOMERNAME, BUSINESSTHREE, BUSINESSFOUR, CERTITYPE, IFSUPPLEMENT, PREMTYPE, EMPLOYESTATUS) VALUES (:B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , '2', :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) |
| fcsr3mt7jzznq | SELECT NVL(MAX(TRIM(AGTYP)), 'AD') AGTYP, MAX(AGNAME) FROM RAS_AGPCONT@BFR WHERE INS_CODE=:B2 AND AGAGC=:B1 |
| fkv9aynrt0sw6 | SELECT CASE WHEN EXISTS(SELECT 1 FROM MM_SUBCOMPANY_TC T WHERE T.SUBCOMPANY= :B1 ) THEN '1' ELSE '0' END AS FGS FROM DUAL |
| fsbqktj5vw6n9 |
select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca
st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1 |
| fux2zdk7hjjhf | UPDATE BFP_VOUCHER_TO V SET V.ATTRIBUTE11 = :B2 WHERE V.REFERENCE1 = :B1 |
| 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 |
| 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 |
| g8rhn3v9syy8s | SELECT /*+ driving_site(a) */INS_CODE, M2PCO , M2PNO , M2AMTP , M2FTRD, TRIM(M2TCOD) M2TCOD , M2EFFD, M2PTYP, M2CODE, M2AMTU FROM RLS_LFPUFTDH@BFR A WHERE A.M2PMOD = 'R' AND TRIM(A.M2TCOD) IN ('BRC', 'SUR') AND A.M2FTRD = :B1 AND A.M2AMTP <> 0 |
| gcu0c1chf0k24 |
SELECT A.DCPNO, A.INS_CODE SOURCELIB, A.DCPCO, TRIM(B.A54PLAN) A54PLAN, A.DCMODE, TRIM(A.DCFYP) DCFYP, CASE WHEN DCDOT > DCDUE THEN B.A54PRM ELSE 0 END AMT615, CASE WHEN DCDOT > DCDUE THEN 0 ELSE B.A54PRM END AMT616 FROM (SELECT DCPNO, INS_CODE, DCPCO, DCMODE, DCDOT, DCDUE, DCACT, DCSEQ, DCFYP FROM RLS_LFPPREM@BFR UNION ALL SELECT DCPNO, INS_CODE, DCPCO, DCMODE, DCDOT, DCDUE, DCACT, DCSEQ, DCFYP FROM RLS_LFPPREMH@BFR) A, RLS_LFPPREMD@BFR B WHERE A.DCPNO = B.A54PNO AND A.DCSEQ = B.A54SEQ AND A.DCDOT > 0 AND B.A54PRM <> 0 AND TRIM(A.DCACT) IN ('LA', 'PC', 'FP', 'D2') AND EXISTS (SELECT ACPNO, TRIM(ACTCD) ACTCD, ACDOT, ACFPD, ACDVD, ACDVDI, ACLN, ACLNI, ACMAE, TRIM(ACPLAN) ACPLAN FROM RLS_LFPACT@BFR WHERE TRIM(A.DCPNO) = TRIM(ACPNO) AND TRIM(A.DCACT) = TRIM(ACTCD) AND TRIM(A.DCDOT) = TRIM(ACDOT) UNION ALL SELECT ACPNO, TRIM(ACTCD) ACTCD, ACDOT, ACFPD, ACDVD, ACDVDI, ACLN, ACLNI, ACMAE, TRIM(ACPLAN) ACPLAN FROM RLS_LFPACTH@BFR WHERE TRIM(A.DCPNO) = TRIM(ACPNO) AND TRIM(A.DCACT) = TRIM(ACTCD) AND TRIM(A.DCDOT) = TRIM(ACDOT)) AND GREATEST(A.DCDOT, A.DCDUE) = :B1 UNION ALL SELECT A.DCPNO, A.INS_CODE SOURCELIB, A.DCPCO, TRIM(B.A54PLAN) A54PLAN, A.DCMODE, TRIM(A.DCFYP) DCFYP, CASE WHEN DCDOT > DCDUE THEN B.A54PRM ELSE 0 END AMT615, CASE WHEN DCDOT > DCDUE THEN 0 ELSE B.A54PRM END AMT616 FROM (SELECT DCPNO, INS_CODE, DCPCO, DCMODE, DCDOT, DCDUE, DCACT, DCSEQ, DCFYP FROM RLS_LFPPREM@BFR UNION ALL SELECT DC
PNO, INS_CODE, DCPCO, DCMODE, DCDOT, DCDUE, DCACT, DCSEQ, DCFYP FROM RLS_LFPPREMH@BFR) A, RLS_LFPPREMD@BFR B WHERE A.DCPNO = B.A54PNO AND A.DCSEQ = B.A54SEQ AND A.DCDOT > 0 AND B.A54PRM <> 0 AND TRIM(A.DCACT) = 'UFD' AND GREATEST(A.DCDOT, A.DCDUE) = :B1 |
| gdn3ysuyssf82 | SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1 |
| grwydz59pu6mc | select text from view$ where rowid=:1 |
| grzx1ww6wf4q2 | SELECT A.FLAGS FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1 |
| gvw5y39ru38su | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN mm_job_pkg.mm_job2; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |