WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
CHNLDB	1768945945	chnldb1	1	10.2.0.4.0	YES	sxyxydb1

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	33517	25-Jun-12 09:00:26	953	14.2
End Snap:	33518	25-Jun-12 10:00:14	973	15.6
Elapsed:		59.80 (mins)
DB Time:		1,280.35 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	61,440M	61,440M	Std Block Size:	8K
Shared Pool Size:	8,192M	8,192M	Log Buffer:	14,188K

Load Profile

	Per Second	Per Transaction
Redo size:	3,938,876.93	9,212.66
Logical reads:	1,183,823.84	2,768.85
Block changes:	19,333.14	45.22
Physical reads:	1,342.31	3.14
Physical writes:	542.79	1.27
User calls:	1,125.90	2.63
Parses:	623.10	1.46
Hard parses:	17.24	0.04
Sorts:	1,397.69	3.27
Logons:	1.04	0.00
Executes:	9,479.78	22.17
Transactions:	427.55

% Blocks changed per Read:	1.63	Recursive Call %:	93.19
Rollback per transaction %:	0.02	Rows per Sort:	26.62

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	99.89	In-memory Sort %:	100.00
Library Hit %:	99.48	Soft Parse %:	97.23
Execute to Parse %:	93.43	Latch Hit %:	95.91
Parse CPU to Parse Elapsd %:	57.66	% Non-Parse CPU:	99.33

Shared Pool Statistics

	Begin	End
Memory Usage %:	92.78	93.20
% SQL with executions>1:	68.95	47.55
% Memory for SQL w/exec>1:	61.77	45.86

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		50,281		65.5
db file sequential read	4,360,473	23,934	5	31.2	User I/O
log file parallel write	1,212,498	928	1	1.2	System I/O
gc cr grant 2-way	1,721,128	712	0	.9	Cluster
gc current block 2-way	1,388,135	664	0	.9	Cluster

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	543.79	1.27
Global Cache blocks served:	597.68	1.40
GCS/GES messages received:	2,377.53	5.56
GCS/GES messages sent:	2,726.02	6.38
DBWR Fusion writes:	9.00	0.02
Estd Interconnect traffic (KB)	10,128.53

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

Buffer access - local cache %:	99.84
Buffer access - remote cache %:	0.05
Buffer access - disk %:	0.11

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	1.0
Avg global cache current block receive time (ms):	0.6
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	9.9
Avg global cache cr block flush time (ms):	1.1
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.7
Avg global cache current block flush time (ms):	1.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.3
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.1
Avg GES message process time (ms):	0.0
% of direct sent messages:	47.69
% of indirect sent messages:	37.95
% of flow controlled messages:	14.36

Main Report

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

More RAC Statistics

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

Wait Events Statistics

• Time Model Statistics
• Wait Class
• Wait Events
• Background Wait Events
• Operating System Statistics
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

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

Back to Wait Events Statistics
Back to Top

Wait Class

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc

Back to Wait Events Statistics
Back to Top

Wait Events

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• Total Buffer Gets: 4,247,833,416
• Captured SQL account for 70.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 4,816,519
• Captured SQL account for 28.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 34,015,652
• Captured SQL account for 5.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 2,235,835
• Captured SQL account for 71.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
00r5cy9j8dfup	SELECT /*+index(pr PK_P10I_MD_RISKCON)*/ '1', CASE WHEN LENGTHB(REPLACE(REPLACE(PR.APID, ' '), '¡¡')) - 20 <= 0 THEN REPLACE(REPLACE(PR.APID, ' '), '¡¡') ELSE NULL END, CASE WHEN LENGTHB(REPLACE(REPLACE(PR.PID, ' '), '¡¡')) - 20 <= 0 THEN REPLACE(REPLACE(PR.PID, ' '), '¡¡') ELSE NULL END, PR.EMPNO, PR.APPNO, PR.DESKPAY, PR.POLIST, PR.APPDATE, PR.CSRNO, PR.BEGDATE, REPLACE(PR.SALEATTR, ' '), PR.SRC_SYS, LENGTH(REPLACE(PR.SALEATTR, ' ')), CASE WHEN LENGTHB(REPLACE(REPLACE(PR.OWNER_SOURCE_ID, ' '), '¡¡')) - 20 <= 0 THEN REPLACE(REPLACE(PR.OWNER_SOURCE_ID, ' '), '¡¡') ELSE NULL END, CASE WHEN LENGTHB(REPLACE(REPLACE(PR.INSURED_SOURCE_ID, ' '), '¡¡')) - 20 <= 0 THEN REPLACE(REPLACE(PR.INSURED_SOURCE_ID, ' '), '¡¡') ELSE NULL END, PR.TMOUNT, APPF FROM P10I_MD_RISKCON PR WHERE PR.BRANCH = :B3 AND PR.POLICYNO = :B2 AND PR.CLASSCODE = :B1
09q9qy9xdnpg9	INSERT INTO TBL_TEMP_COMMON (ID, STR_1, STR_2, STR_3, STR_4, STR_5, STR_6, STR_7, STR_8, STR_9, STR_10, STR_11, STR_12, STR_13, STR_14, STR_15, STR_17, DATE_1, NUM_1, NUM_2, NUM_3, NUM_4, NUM_5, NUM_6, NUM_7, NUM_8, NUM_9, NUM_10) SELECT /*+index(a )*/ CHAROLEID, A.POLICYNO || A.CLASSCODE POLICYNO, DECODE(ISSALE, '10', '10', '50', '50', '00', '00', '00') ISSALE, NVL(C.CODEVALUE, 'KB01') SALEATTR, BJTYPE, NVL(SETCODE, '1') SETCODE, A.POLICYNO PREPOLICYNO, A.CLASSCODE PRECLASSCODE, (CASE WHEN YEARNO = 2 THEN '2' WHEN YEARNO = 3 THEN '3' WHEN YEARNO = 4 THEN '4' WHEN YEARNO > 4 AND IS_SPE = '1' THEN '6' ELSE '5' END) YEARNO, (CASE WHEN B.CLASSCODE IS NOT NULL AND BIGPOLICY IS NOT NULL THEN A.POLICYNO || A.CLASSCODE ELSE NULL END) ISBIGWN, (CASE WHEN B.CLASSCODE IS NOT NULL AND BIGPOLICY IS NULL THEN A.POLICYNO || A.CLASSCODE ELSE NULL END) ISNOBIGWN, (CASE WHEN BIGPOLICY IS NOT NULL THEN A.POLICYNO || A.CLASSCODE ELSE NULL END) ISBIG, (CASE WHEN POLIST IN ('3', '4', 'B') THEN A.POLICYNO || A.CLASSCODE ELSE NULL END) SXPIC, (CASE WHEN POLIST IN ('3', '4', 'B') AND EMPSTATUS = 'UQ5' THEN A.POLICYNO || A.CLASSCODE ELSE NULL END) QUITSXPIC, (CASE WHEN POLIST IN ('7', '8', '9', 'C') THEN A.POLICYNO || A.CLASSCODE ELSE NULL END) TBPIC, (CASE WHEN POLIST IN ('7', '8', '9', 'C') AND EMPSTATUS = 'UQ5' THEN A.POLICYNO || A.CLASSCODE ELSE NULL END) QUITTBPIC, (CASE WHEN EMPSTATUS = 'UQ5' THEN A.POLICYNO || A.CLASSCODE ELSE NU LL END) QUITSHOPIC, A.COVER1 DATE_1, (CASE WHEN POLIST IN ('3', '4', 'B') THEN AMOUNT + STDRATE + UNSTDRATE ELSE 0 END) SXFEE, (CASE WHEN POLIST IN ('3', '4', 'B') AND EMPSTATUS = 'UQ5' THEN AMOUNT + STDRATE + UNSTDRATE ELSE 0 END) QUITSXFEE, (CASE WHEN POLIST IN ('7', '8', '9', 'C') THEN AMOUNT + STDRATE + UNSTDRATE ELSE 0 END) TBFEE, (CASE WHEN POLIST IN ('7', '8', '9', 'C') AND EMPSTATUS = 'UQ5' THEN AMOUNT + STDRATE + UNSTDRATE ELSE 0 END) QUITTBFEE, (CASE WHEN B.CLASSCODE IS NOT NULL AND BIGPOLICY IS NOT NULL THEN AMOUNT + STDRATE + UNSTDRATE ELSE 0 END) ISBIGWNFEE, (CASE WHEN B.CLASSCODE IS NOT NULL AND BIGPOLICY IS NULL THEN AMOUNT + STDRATE + UNSTDRATE ELSE 0 END) ISNOBIGWNFEE, (CASE WHEN BIGPOLICY IS NOT NULL THEN AMOUNT + STDRATE + UNSTDRATE ELSE 0 END) ISBIGFEE, AMOUNT + STDRATE + UNSTDRATE SHOFEE, 0 PREFEE, (CASE WHEN EMPSTATUS = 'UQ5' THEN AMOUNT + STDRATE + UNSTDRATE ELSE 0 END) QUITSHOFEE FROM CRM_SPREREC A, S_HCRS_CLASSCODE B, CRM_SALEATTR_ATTRIBUTION C WHERE A.CLASSCODE = B.CLASSCODE(+) AND A.SALEATTR = C.CODE(+) AND A.COVER1 BETWEEN :B3 AND :B2 AND A.DATAOWNER = :B1 AND A.ISSALE IN ('00', '10', '50') AND A.ISSHORTRISK = '0' AND A.STATUS = '4' AND A.PCODE <> 'T' AND C.TYPE = 'KB' AND C.DIVID = :B1
0bvgz7v863mmd	SELECT EMPNO EMPNO, ACTEMPNO ACTEMPNO, POLICYNO POLICYNO, CLASSCODE CLASSCODE, PAYCODE PAYCODE, SETCODE SETCODE, DECODE((AMOUNT + STDRATE + UNSTDRATE) * AYJRATE, NULL, 0, (AMOUNT + STDRATE + UNSTDRATE) * AYJRATE) FEE_SELLFEE, (AMOUNT + STDRATE + UNSTDRATE) FEE_AMOUNT, DECODE(AYJRATE, NULL, 0, AYJRATE) RATIO_FYC, TO_CHAR(PAYDATE, 'yyyy-mm-dd') PAYDATE, DECODE(YEARNUM, NULL, 0, YEARNUM) YEARNUM, DECODE(YEAR, NULL, 0, YEAR) YEAR, DECODE(ZJYJ, NULL, 0, ZJYJ) FEE_ZJYJ, DECODE(FJYJ, NULL, 0, FJYJ) FEE_FJYJ, DECODE(XQYJ, NULL, 0, XQYJ) FEE_XQYJ, PCODE PCODE, APPNAME APPNAME, ZONENO ZONENO, SALEATTR SALEATTR, XBJL XBJL, AWARDRATE AWARDRAIE, APPDATE APPDATE, STDFEE, DATAOWNER FROM CRM_KF_PREREC WHERE EMPNO = :B4 AND COMDATE = :B3 AND PAYDATE BETWEEN :B2 AND :B1
0gb2vt49q2n85	BEGIN SP_BALANCE_COMMISION_LOOP(:1, :2, :3, :4, :5); END;
0j0bmhqjhvcnr	SELECT NVL(SUM(CASE WHEN ACTUALDAY >= 18 THEN 1 ELSE 0 END), 0), NVL(SUM(CASE WHEN ACTUALDAY >= 8 AND ACTUALDAY < 18 THEN 1 ELSE 0 END), 0), NVL(SUM(CASE WHEN ACTUALDAY >= 4 AND ACTUALDAY < 8 THEN 1 ELSE 0 END), 0), NVL(SUM(CASE WHEN ACTUALDAY >= 1 AND ACTUALDAY < 4 THEN 1 ELSE 0 END), 0), NVL(SUM(CASE WHEN ACTUALDAY < 1 THEN 1 ELSE 0 END), 0) FROM TBL_ATTENDANCE WHERE CHANNELROLEID IN (SELECT CHAROLID FROM TMP_CP_CHAROLID) AND COMDATE = :B1
0kz7jrgu3yquu	SELECT SUM(PM.AMOUNT) FROM TBL_PREREC P, TBL_PREREC_MATCHREST PM WHERE 0 = 0 AND P.ID = PM.PRERECID AND (EXISTS (SELECT 'x' FROM TMP_T_ADDR B WHERE P.RECADDR = B.ADDR) OR EXISTS (SELECT 'x' FROM TMP_T_PID T WHERE P.PID = T.PID)) AND EXISTS (SELECT 'x' FROM TMP_T_AREACODE A WHERE PM.AREACODE = A.AREACODE) AND P.CHATYPE = 'U12' AND P.DATAOWNER = :B1 AND P.COMDATE = :B2 AND PM.ISSETCODE IN (1, 2) AND PM.COMDATE = :B2 AND PM.DATAOWNER = :B1
0m45xhg2tn4w4	select factorset0_.id as id410_1_, factorset0_.FACTDESC as FACTDESC410_1_, factorset0_.FACTCODE as FACTCODE410_1_, factorset0_.FACTNAME as FACTNAME410_1_, factorset0_.CATEGORYCODE as CATEGORY5_410_1_, factorset0_.COMMENTS as COMMENTS410_1_, factorset0_.DATAOWNER as DATAOWNER410_1_, factorset0_.CREATEDATE as CREATEDATE410_1_, factorset0_.DESTORYDATE as DESTORYD9_410_1_, factorset0_.FIRSTINSERT as FIRSTIN10_410_1_, factorset0_.LASTMODIFIED as LASTMOD11_410_1_, factorset0_.INSERTMAN as INSERTMAN410_1_, factorset0_.UPDATEMAN as UPDATEMAN410_1_, part1_.id as id412_0_, part1_.EXPRESSION as EXPRESSION412_0_, part1_.PARTCODE as PARTCODE412_0_, part1_.PARTNAME as PARTNAME412_0_, part1_.COMMENTS as COMMENTS412_0_, part1_.DATAOWNER as DATAOWNER412_0_, part1_.CREATEDATE as CREATEDATE412_0_, part1_.DESTORYDATE as DESTORYD8_412_0_, part1_.FIRSTINSERT as FIRSTINS9_412_0_, part1_.LASTMODIFIED as LASTMOD10_412_0_, part1_.INSERTMAN as INSERTMAN412_0_, part1_.UPDATEMAN as UPDATEMAN412_0_, part1_.ELEMENTID as ELEMENTID412_0_, part1_.FACTORSETID as FACTORS14_412_0_ from S_VERSION_FACTORSET factorset0_ left outer join S_VERSION_PART part1_ on factorset0_.id=part1_.FACTORSETID where factorset0_.id=:1
1vy3pgr9v67cj	select person0_.id as id124_, person0_.DATAOWNER as DATAOWNER124_, person0_.BIRTHDATE as BIRTHDATE124_, person0_.COMMENTS as COMMENTS124_, person0_.DIEDATE as DIEDATE124_, person0_.EDUCATION as EDUCATION124_, person0_.GENDER as GENDER124_, person0_.HEALTH as HEALTH124_, person0_.HEIGHT as HEIGHT124_, person0_.HISTORY as HISTORY124_, person0_.HOBBY as HOBBY124_, person0_.HOUSEID as HOUSEID124_, person0_.MARRIAGE as MARRIAGE124_, person0_.NAME as NAME124_, person0_.NATION as NATION124_, person0_.PID as PID124_, person0_.POLICE as POLICE124_, person0_.POLITICS as POLITICS124_, person0_.WEIGHT as WEIGHT124_, person0_.FIRSTINSERT as FIRSTIN20_124_, person0_.LASTMODIFIED as LASTMOD21_124_, person0_.INSERTMAN as INSERTMAN124_, person0_.UPDATEMAN as UPDATEMAN124_, person0_.LIMRA_TR as LIMRA24_124_, person0_.LIMRA_DATE as LIMRA25_124_ from TBL_PERSON person0_ inner join TBL_PERSON_ROLE personrole1_ on person0_.id=personrole1_.person4Id inner join TBL_CHANNELROLE channelrol2_ on personrole1_.id=channelrol2_.personRole5Id where channelrol2_.id=:1
1z9x1vyhuzdhh	SELECT DECODE(LENGTH(TRIM(PE.STATUS)), 1, TRIM(PE.STATUS), '1') FROM P10I_MD_EMPNO PE WHERE PE.EMPNO = :B1
22jf4vm5p845d	BEGIN :1 := pkg_tx_effectpolicyquery.effectpolicyquery(: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); END;
27vuav86zjn9s	select bean0_.id as id403_0_, bean0_.BEANNAME as BEANNAME403_0_, bean0_.BEANTYPE as BEANTYPE403_0_, bean0_.COMMENTS as COMMENTS403_0_, bean0_.DATAOWNER as DATAOWNER403_0_, bean0_.CREATEDATE as CREATEDATE403_0_, bean0_.DESTORYDATE as DESTORYD7_403_0_, bean0_.FIRSTINSERT as FIRSTINS8_403_0_, bean0_.LASTMODIFIED as LASTMODI9_403_0_, bean0_.INSERTMAN as INSERTMAN403_0_, bean0_.UPDATEMAN as UPDATEMAN403_0_ from S_VERSION_BEAN bean0_ where bean0_.id=:1
2ag650m04cb4y	BEGIN :1 := f_empquery(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); END;
2ag8cwu8aumk7	BEGIN rpt_qt_mp_sectnormtrace(1123, last_day(add_months(trunc(sysdate), -1))); END;
2dyqr984d4dg2	select count(t.id) from PROCESS_EVENT_REMINDER t where t.remind_flag='1' and t.CHAROLEID = :1 and t.DATAOWNER = :2 and t.NEXT_REMIND_DATE is not null and t.cover1 >= :3 and t.cover1 <= :4 and trunc(t.next_remind_date, 'dd') >= :5 and trunc(t.next_remind_date, 'dd') <= :6 and t.remind_type = :7
2fktwcwyngsrv	SELECT * FROM CRM_AGT_PREREC WHERE POLICYNO = :B4 AND DATAOWNER = :B3 AND COVER1 >= :B2 - 5 AND COVER1 <= :B2 + 5 AND CLASSCODE = :B1
2hnd6xv7sy3bg	SELECT SUM(NVL(PM.AMOUNT, 0)) FROM TBL_PREREC P, TBL_PREREC_MATCHREST PM, S_RISKCLASS S WHERE 0 = 0 AND P.ID = PM.PRERECID AND P.CLASSCODE = S.CLASSCODE AND EXISTS (SELECT 'x' FROM TMP_T_AREACODE T WHERE PM.AREACODE = T.AREACODE) AND S.TIMESTR <> '1' AND S.DATAOWNER = :B1 AND P.SIGN IN ('3', '4') AND P.CHATYPE = 'U12' AND P.DATAOWNER = :B1 AND P.COMDATE = :B2 AND PM.ISSETCODE IN (1, 2) AND PM.COMDATE = :B2 AND PM.DATAOWNER = :B1
2k32q8d98sj4f	select checkresul0_.channelRole2Id as col_0_0_ from TBL_CHECK_RESULT checkresul0_, TBL_CHANNELROLE channelrol1_ where checkresul0_.channelRole2Id=channelrol1_.id and (checkresul0_.channelRole2Id in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , :207 , :208 , :209 , :210 , :211 , :212 , :213 , :214 , :215 , :216 , :217 , :218 , :219 , :220 , :221 , :222 , :223 , :224 , :225 , :226 , :227 , :228 , :229 , :230 , :231 , :232 , :233 , :234 , :235 , :236 , :237 , :238 , :239 , :240 , :241 , :242 , :243 , :244 , :245 , :246 , :247 , :248 , :249 , :250 , :251 , :252 , :253 , :254 , :255 , :256 , :257 , :258 , :259 , :260 , :261 , :262 , :263 , :264 , :265 , :266 , :267 , :268 , :269 , :270 , :271 , :272 , :273 , :274 , :275 , :276 , :277 , :278 , :279 , :280 , :281 , :282 , :283 , :284 , :285 , :286 , :287 , :288 , :289 , :290 , :291 , :292 , :293 , :294 , :295 , :296 , :297 , :298 , :299 , :300)) and channelrol1_.JOBCODE=:301 and channelrol1_.STATUS=:302 and checkresul0_.JOBCODE=:303 and to_char(checkresul0_.COMDATE, 'yyyy-MM')=:304 and (checkresul0_.CHKTYPE in (:305 , :306))
2kzq8t90rdc02	insert into TBL_Rules_Query_Faster (DIVID, CHANNELROLEID, CHATYPE, COMDATE, VERSIONID, id) values (:1, :2, :3, :4, :5, :6)
2sd9cnm0xv93y	SELECT TRIM(PMD.ZONEID) FROM P10I_MD_DISTRICT_BDH PMD WHERE PMD.BRANCH = :B2 AND PMD.POLICYNO = :B1
2tnrwxk6tzmvx	select * from ( select mpadjustme0_.id as id88_0_, channelrol1_.id as id154_1_, mpadjustme0_.channelRoleId as channelR2_88_0_, mpadjustme0_.ARTICLENO as ARTICLENO88_0_, mpadjustme0_.DATAOWNER as DATAOWNER88_0_, mpadjustme0_.FACTOR as FACTOR88_0_, mpadjustme0_.FTYPE as FTYPE88_0_, mpadjustme0_.REASON as REASON88_0_, mpadjustme0_.REVMAN as REVMAN88_0_, mpadjustme0_.REVTIME as REVTIME88_0_, mpadjustme0_.ADJVALUE as ADJVALUE88_0_, mpadjustme0_.CHKSTATUS as CHKSTATUS88_0_, mpadjustme0_.COMDATE as COMDATE88_0_, mpadjustme0_.IMPORTATION as IMPORTA13_88_0_, mpadjustme0_.FIRSTINSERT as FIRSTIN14_88_0_, mpadjustme0_.LASTMODIFIED as LASTMOD15_88_0_, mpadjustme0_.INSERTMAN as INSERTMAN88_0_, mpadjustme0_.UPDATEMAN as UPDATEMAN88_0_, channelrol1_.DATAOWNER as DATAOWNER154_1_, channelrol1_.CHATYPE as CHATYPE154_1_, channelrol1_.SALESCHATYPE as SALESCHA4_154_1_, channelrol1_.COMMENTS as COMMENTS154_1_, channelrol1_.DEPTNO as DEPTNO154_1_, channelrol1_.DIVCODE as DIVCODE154_1_, channelrol1_.EMPNO as EMPNO154_1_, channelrol1_.FIRSTINSERT as FIRSTINS9_154_1_, channelrol1_.INSERTMAN as INSERTMAN154_1_, channelrol1_.JOBCODE as JOBCODE154_1_, channelrol1_.LASTMODIFIED as LASTMOD12_154_1_, channelrol1_.ORGCODE as ORGCODE154_1_, channelrol1_.personRole5Id as personRole14_154_1_, channelrol1_.STATUS as STATUS154_1_, channelrol1_.UPDATEMAN as UPDATEMAN154_1_, channelrol1_.channelRole13Id as channel17_154_1_, channelrol1_.JOINDATE as JOINDATE154_1_, channelrol1_.NAME as NAME154_1_, channelrol1_.JOIN as JOIN154_1_, channelrol1_.isFourorg as isFourorg154_1_, channelrol1_.QUIT as QUIT154_1_, channelrol1_.QUITDATE as QUITDATE154_1_, channelrol1_.DEPTID as DEPTID154_1_, channelrol1_.SCORE as SCORE154_1_, channelrol1_.SIGNCBS as SIGNCBS154_1_, channelrol1_.SIGNZYX as SIGNZYX154_1_, channelrol1_.SIGNSALESZYX as SIGNSAL28_154_1_, channelrol1_.SIGNFF as SIGNFF154_1_, channelrol1_.TURN as TURN154_1_, channelrol1_.DIVISIONID as DIVISIONID154_1_, channelrol1_.CUSTOMDIVCODE as CUSTOMD32_154_1_, channelrol1_.qual as qual154_1_, channelrol1_.tax as tax154_1_, channelrol1_.SALESLEVEL as SALESLEVEL154_1_, channelrol1_.SOURCE as SOURCE154_1_, channelrol1_.SALESLEVELMONTH as SALESLE37_154_1_, channelrol1_.ISSECMANAGER as ISSECMA38_154_1_ from TBL_MP_ADJUSTMENT mpadjustme0_ inner join TBL_CHANNELROLE channelrol1_ on mpadjustme0_.channelRoleId=channelrol1_.id, MV_CHAINFO mvchainfo2_ where mpadjustme0_.channelRoleId=mvchainfo2_.CHAROLID and mpadjustme0_.COMDATE=mvchainfo2_.COMDATE and (mvchainfo2_.DEPTID in (select userorgs3_.div_Or_Dept_Id from USER_ORGS userorgs3_ where userorgs3_.dataOwner=992 and userorgs3_.keys=103506569.362696 and (userorgs3_.levelDefine like '992.%') and userorgs3_.createDate<=to_date('2012-06-18', 'yyyy-mm-dd') and userorgs3_.effectDate<=to_date('2012-06-18', 'yyyy-mm-dd') and (userorgs3_.destroyDate is null or userorgs3_.destroyDate>to_date('2012-06-18', 'yyyy-mm-dd')) and (userorgs3_.quitDate is null or userorgs3_.quitDate>to_date('2012-06-18', 'yyyy-mm-dd')) and userorgs3_.isDivision=0)) and mpadjustme0_.DATAOWNER=:1 and mvchainfo2_.fgsId=:2 and mpadjustme0_.COMDATE>=:3 and mpadjustme0_.COMDATE<=:4 and (mpadjustme0_.FACTOR in (:5)) and (mpadjustme0_.CHKSTATUS in (:6 , :7 , :8)) ) where rownum <= :9
2vy7kr7th7t64	SELECT COUNT(1) FROM ( SELECT EMPNO, SUM(AMOUNT) AS AMOUNT FROM TBL_PREREC WHERE COMDATE = :B2 AND DATAOWNER = :B1 AND PAYCODE = '13' AND YEAR = 1 AND PCODE IN ('2', '8') AND EMPNO IN (SELECT EMPNO FROM TMP_CP_EMPNO) GROUP BY EMPNO) WHERE AMOUNT >= 1000
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
3k5yznjgmvmyx	SELECT NVL(SUM(CASE WHEN ISEXCEL = 1 THEN 1 ELSE 0 END), 0) FROM EXCELLABERMONITOR_MV WHERE FGSID = :B2 AND COMDATE = :B1 AND CHAROLID IN (SELECT CHAROLID FROM TMP_CP_CHAROLID)
3uxmm93jq560j	BEGIN :1 := pkg_kf_actfee.Fn_Actfee(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
3ya293qcruucy	select parameters0_.FACTORSETID as FACTORS12_1_, parameters0_.id as id1_, parameters0_.SALIENCE as SALIENCE1_, parameters0_.id as id411_0_, parameters0_.PARADESC as PARADESC411_0_, parameters0_.PARAVALUE as PARAVALUE411_0_, parameters0_.COMMENTS as COMMENTS411_0_, parameters0_.DATAOWNER as DATAOWNER411_0_, parameters0_.CREATEDATE as CREATEDATE411_0_, parameters0_.DESTORYDATE as DESTORYD7_411_0_, parameters0_.FIRSTINSERT as FIRSTINS8_411_0_, parameters0_.LASTMODIFIED as LASTMODI9_411_0_, parameters0_.INSERTMAN as INSERTMAN411_0_, parameters0_.UPDATEMAN as UPDATEMAN411_0_, parameters0_.FACTORSETID as FACTORS12_411_0_ from S_VERSION_PARAMETERSET parameters0_ where parameters0_.FACTORSETID=:1
4562baqr17r8g	select count(*) as col_0_0_ from TBL_CHANNELROLE channelrol0_ where (channelrol0_.STATUS is not null) and channelrol0_.DATAOWNER=1124 and channelrol0_.JOBCODE='YC99' and channelrol0_.CHATYPE=:1 and channelrol0_.JOINDATE<=:2 and (exists (select 1 from TBL_SALESNET_CHAROLE_RELATION salesnetch1_, TBL_CHANNELROLE channelrol2_ where salesnetch1_.CHANNELROLEID=channelrol2_.id and salesnetch1_.salesNetId=channelrol0_.salesNetID and (channelrol2_.NAME like :3) and (channelrol2_.EMPNO like :4) and salesnetch1_.effectDate<=:5 and (salesnetch1_.quitDate>:6 or salesnetch1_.quitDate is null))) and (channelrol0_.salesNetID in (select salesnetch4_.salesNetId from TBL_SALESNET_CHAROLE_RELATION salesnetch4_, TBL_CHANNELROLE channelrol5_ where salesnetch4_.CHANNELROLEID=channelrol5_.id and (channelrol5_.DEPTID in (select userorgs6_.div_Or_Dept_Id from USER_ORGS2 userorgs6_ where userorgs6_.effectDate<=to_date('2012-06-25', 'yyyy-mm-dd') and (userorgs6_.levelDefine like '2313.1124.'||'%') and userorgs6_.channel='U17')) and salesnetch4_.effectDate<=:7 and (salesnetch4_.quitDate>:8 or salesnetch4_.quitDate is null)))
4j15frqaytqu9	SELECT SUM(NVL(PM.AMOUNT, 0)) FROM TBL_PREREC P, TBL_PREREC_MATCHREST PM WHERE 0 = 0 AND P.ID = PM.PRERECID AND (EXISTS (SELECT 'x' FROM TMP_T_ADDR B WHERE P.RECADDR = B.ADDR) OR EXISTS (SELECT 'x' FROM TMP_T_PID T WHERE P.PID = T.PID)) AND EXISTS (SELECT 'x' FROM TMP_T_AREACODE A WHERE PM.AREACODE = A.AREACODE) AND P.CHATYPE = 'U12' AND P.DATAOWNER = :B1 AND P.COMDATE = :B2 AND PM.ISSETCODE IN (1, 2) AND PM.COMDATE = :B2 AND PM.DATAOWNER = :B1
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
4xnxp2u6s6z5z	select count(*) as col_0_0_ from TBL_MP_ADJUSTMENT mpadjustme0_ inner join TBL_CHANNELROLE channelrol1_ on mpadjustme0_.channelRoleId=channelrol1_.id, MV_CHAINFO mvchainfo2_ where mpadjustme0_.channelRoleId=mvchainfo2_.CHAROLID and mpadjustme0_.COMDATE=mvchainfo2_.COMDATE and (mvchainfo2_.DEPTID in (select userorgs3_.div_Or_Dept_Id from USER_ORGS userorgs3_ where userorgs3_.dataOwner=992 and userorgs3_.keys=112669606.361444 and (userorgs3_.levelDefine like '992.%') and userorgs3_.createDate<=to_date('2012-06-18', 'yyyy-mm-dd') and userorgs3_.effectDate<=to_date('2012-06-18', 'yyyy-mm-dd') and (userorgs3_.destroyDate is null or userorgs3_.destroyDate>to_date('2012-06-18', 'yyyy-mm-dd')) and (userorgs3_.quitDate is null or userorgs3_.quitDate>to_date('2012-06-18', 'yyyy-mm-dd')) and userorgs3_.isDivision=0)) and mpadjustme0_.DATAOWNER=:1 and mvchainfo2_.fgsId=:2 and mpadjustme0_.COMDATE>=:3 and mpadjustme0_.COMDATE<=:4 and (mpadjustme0_.FACTOR in (:5)) and (mpadjustme0_.CHKSTATUS in (:6))
4ztdv8v6urxn1	select * from ( select mpadjustme0_.id as id88_0_, channelrol1_.id as id154_1_, mpadjustme0_.channelRoleId as channelR2_88_0_, mpadjustme0_.ARTICLENO as ARTICLENO88_0_, mpadjustme0_.DATAOWNER as DATAOWNER88_0_, mpadjustme0_.FACTOR as FACTOR88_0_, mpadjustme0_.FTYPE as FTYPE88_0_, mpadjustme0_.REASON as REASON88_0_, mpadjustme0_.REVMAN as REVMAN88_0_, mpadjustme0_.REVTIME as REVTIME88_0_, mpadjustme0_.ADJVALUE as ADJVALUE88_0_, mpadjustme0_.CHKSTATUS as CHKSTATUS88_0_, mpadjustme0_.COMDATE as COMDATE88_0_, mpadjustme0_.IMPORTATION as IMPORTA13_88_0_, mpadjustme0_.FIRSTINSERT as FIRSTIN14_88_0_, mpadjustme0_.LASTMODIFIED as LASTMOD15_88_0_, mpadjustme0_.INSERTMAN as INSERTMAN88_0_, mpadjustme0_.UPDATEMAN as UPDATEMAN88_0_, channelrol1_.DATAOWNER as DATAOWNER154_1_, channelrol1_.CHATYPE as CHATYPE154_1_, channelrol1_.SALESCHATYPE as SALESCHA4_154_1_, channelrol1_.COMMENTS as COMMENTS154_1_, channelrol1_.DEPTNO as DEPTNO154_1_, channelrol1_.DIVCODE as DIVCODE154_1_, channelrol1_.EMPNO as EMPNO154_1_, channelrol1_.FIRSTINSERT as FIRSTINS9_154_1_, channelrol1_.INSERTMAN as INSERTMAN154_1_, channelrol1_.JOBCODE as JOBCODE154_1_, channelrol1_.LASTMODIFIED as LASTMOD12_154_1_, channelrol1_.ORGCODE as ORGCODE154_1_, channelrol1_.personRole5Id as personRole14_154_1_, channelrol1_.STATUS as STATUS154_1_, channelrol1_.UPDATEMAN as UPDATEMAN154_1_, channelrol1_.channelRole13Id as channel17_154_1_, channelrol1_.JOINDATE as JOINDATE154_1_, channelrol1_.NAME as NAME154_1_, channelrol1_.JOIN as JOIN154_1_, channelrol1_.isFourorg as isFourorg154_1_, channelrol1_.QUIT as QUIT154_1_, channelrol1_.QUITDATE as QUITDATE154_1_, channelrol1_.DEPTID as DEPTID154_1_, channelrol1_.SCORE as SCORE154_1_, channelrol1_.SIGNCBS as SIGNCBS154_1_, channelrol1_.SIGNZYX as SIGNZYX154_1_, channelrol1_.SIGNSALESZYX as SIGNSAL28_154_1_, channelrol1_.SIGNFF as SIGNFF154_1_, channelrol1_.TURN as TURN154_1_, channelrol1_.DIVISIONID as DIVISIONID154_1_, channelrol1_.CUSTOMDIVCODE as CUSTOMD32_154_1_, channelrol1_.qual as qual154_1_, channelrol1_.tax as tax154_1_, channelrol1_.SALESLEVEL as SALESLEVEL154_1_, channelrol1_.SOURCE as SOURCE154_1_, channelrol1_.SALESLEVELMONTH as SALESLE37_154_1_, channelrol1_.ISSECMANAGER as ISSECMA38_154_1_ from TBL_MP_ADJUSTMENT mpadjustme0_ inner join TBL_CHANNELROLE channelrol1_ on mpadjustme0_.channelRoleId=channelrol1_.id, MV_CHAINFO mvchainfo2_ where mpadjustme0_.channelRoleId=mvchainfo2_.CHAROLID and mpadjustme0_.COMDATE=mvchainfo2_.COMDATE and (mvchainfo2_.DEPTID in (select userorgs3_.div_Or_Dept_Id from USER_ORGS userorgs3_ where userorgs3_.dataOwner=992 and userorgs3_.keys=112669606.361444 and (userorgs3_.levelDefine like '992.%') and userorgs3_.createDate<=to_date('2012-06-18', 'yyyy-mm-dd') and userorgs3_.effectDate<=to_date('2012-06-18', 'yyyy-mm-dd') and (userorgs3_.destroyDate is null or userorgs3_.destroyDate>to_date('2012-06-18', 'yyyy-mm-dd')) and (userorgs3_.quitDate is null or userorgs3_.quitDate>to_date('2012-06-18', 'yyyy-mm-dd')) and userorgs3_.isDivision=0)) and mpadjustme0_.DATAOWNER=:1 and mvchainfo2_.fgsId=:2 and mpadjustme0_.COMDATE>=:3 and mpadjustme0_.COMDATE<=:4 and (mpadjustme0_.FACTOR in (:5)) and (mpadjustme0_.CHKSTATUS in (:6)) ) where rownum <= :7
575r4zt2yg1h7	BEGIN :1 := PKG_KF_CUSTOMERCOST.fn_query_customer_cost(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22); END;
59ujp2du0b3tv	BEGIN :1 := pkg_kf_progress.fn_personal_progress_real(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17); END;
5ngzsfstg8tmy	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
677yb93dmxnvb	select checkresul0_.channelRole2Id as col_0_0_ from TBL_CHECK_RESULT checkresul0_, TBL_CHANNELROLE channelrol1_ where checkresul0_.channelRole2Id=channelrol1_.id and (checkresul0_.channelRole2Id in (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , :207 , :208 , :209 , :210 , :211 , :212 , :213 , :214 , :215 , :216 , :217 , :218 , :219 , :220 , :221 , :222 , :223 , :224 , :225 , :226 , :227 , :228 , :229 , :230 , :231 , :232 , :233 , :234 , :235 , :236 , :237 , :238 , :239 , :240 , :241 , :242 , :243 , :244 , :245 , :246 , :247 , :248 , :249 , :250 , :251 , :252 , :253 , :254 , :255 , :256 , :257 , :258 , :259 , :260 , :261 , :262 , :263 , :264 , :265 , :266 , :267 , :268 , :269 , :270 , :271 , :272 , :273 , :274 , :275 , :276 , :277 , :278 , :279 , :280 , :281 , :282 , :283 , :284 , :285 , :286 , :287 , :288 , :289 , :290 , :291 , :292 , :293 , :294 , :295 , :296 , :297 , :298 , :299 , :300)) and channelrol1_.JOBCODE=:301 and channelrol1_.STATUS=:302 and checkresul0_.JOBCODE=:303 and checkresul0_.CHKJOBCODE=:304 and checkresul0_.COMDATE=to_date('20120531', 'yyyyMMdd') and (checkresul0_.CHKTYPE in (:305 , :306 , :307))
6c7xnctq2rf6j	SELECT COUNT('x') FROM TBL_PREREC P, TBL_PREREC_MATCHREST PM WHERE 0 = 0 AND P.ID = PM.PRERECID AND (EXISTS (SELECT 'x' FROM TMP_T_ADDR B WHERE P.RECADDR = B.ADDR) OR EXISTS (SELECT 'x' FROM TMP_T_PID T WHERE P.PID = T.PID)) AND EXISTS (SELECT 'x' FROM TMP_T_AREACODE A WHERE PM.AREACODE = A.AREACODE) AND P.CHATYPE = 'U12' AND P.DATAOWNER = :B2 AND P.COMDATE = :B1 AND PM.ISSETCODE IN (1, 2) AND PM.DATAOWNER = :B2 AND PM.COMDATE = :B1
6z1h40c4zjbma	BEGIN sp_kf_salary_xb_cal(:1, :2, :3); END;
7mquy9fz08mur	SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01"), COUNT(DISTINCT C3), NVL(SUM(CASE WHEN C3 IS NULL THEN :"SYS_B_02" ELSE :"SYS_B_03" END), :"SYS_B_04") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("POLICY") FULL("POLICY") NO_PARALLEL_INDEX("POLICY") */ :"SYS_B_05" AS C1, CASE WHEN "POLICY"."ISPAY"=:"SYS_B_06" AND "POLICY"."ISSHORTRISK"=:"SYS_B_07" THEN :"SYS_B_08" ELSE :"SYS_B_09" END AS C2, "POLICY"."POLICYNO" AS C3 FROM "CRM_SPREREC_TMP_REP1" SAMPLE BLOCK (:"SYS_B_10" , :"SYS_B_11") SEED (:"SYS_B_12") "POLICY") SAMPLESUB
7yz9uk81m7fvd	BEGIN pkg_kf_exam12.p_check_yj(:1, :2, :3, :4); END;
81zkvfbtv676m	INSERT INTO TMP_CP_CHAROLID(CHAROLID) VALUES(:B1 )
8ac6vtkr9hryx	DELETE FROM TMP_P10I_TD_PREREC
8b4h6xmzmztqh	BEGIN :1 := pkg_yb_div_performance.fn_divDept_performance(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); END;
8j3svsat91s2h	BEGIN :1 := pkg_yb_policyy_report.fn_policyy_query(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45); END;
8sth9pjv5ahwb	SELECT SUM(NVL(P.BZAMOUNT, 0)) FROM TBL_PREREC P, TBL_PREREC_MATCHREST PM WHERE 0 = 0 AND P.ID = PM.PRERECID AND (EXISTS (SELECT 'x' FROM TMP_T_ADDR B WHERE P.RECADDR = B.ADDR) OR EXISTS (SELECT 'x' FROM TMP_T_PID T WHERE P.PID = T.PID)) AND EXISTS (SELECT 'x' FROM TMP_T_AREACODE A WHERE PM.AREACODE = A.AREACODE) AND P.CHATYPE = 'U12' AND P.DATAOWNER = :B1 AND P.COMDATE = :B2 AND PM.ISSETCODE IN (1, 2) AND PM.COMDATE = :B2 AND PM.DATAOWNER = :B1
8x2ngxvf33v38	select count(*) as col_0_0_ from TBL_MP_ADJUSTMENT mpadjustme0_ inner join TBL_CHANNELROLE channelrol1_ on mpadjustme0_.channelRoleId=channelrol1_.id, MV_CHAINFO mvchainfo2_ where mpadjustme0_.channelRoleId=mvchainfo2_.CHAROLID and mpadjustme0_.COMDATE=mvchainfo2_.COMDATE and (mvchainfo2_.DEPTID in (select userorgs3_.div_Or_Dept_Id from USER_ORGS userorgs3_ where userorgs3_.dataOwner=992 and userorgs3_.keys=103506569.362696 and (userorgs3_.levelDefine like '992.%') and userorgs3_.createDate<=to_date('2012-06-18', 'yyyy-mm-dd') and userorgs3_.effectDate<=to_date('2012-06-18', 'yyyy-mm-dd') and (userorgs3_.destroyDate is null or userorgs3_.destroyDate>to_date('2012-06-18', 'yyyy-mm-dd')) and (userorgs3_.quitDate is null or userorgs3_.quitDate>to_date('2012-06-18', 'yyyy-mm-dd')) and userorgs3_.isDivision=0)) and mpadjustme0_.DATAOWNER=:1 and mvchainfo2_.fgsId=:2 and mpadjustme0_.COMDATE>=:3 and mpadjustme0_.COMDATE<=:4 and (mpadjustme0_.FACTOR in (:5)) and (mpadjustme0_.CHKSTATUS in (:6 , :7 , :8))
8xvb2q81v61bn	SELECT MAX(SRE.A1), MAX(SRE.A2), MAX(SRE.A4) FROM S_RISKLIST_EX SRE WHERE SRE.DATAOWNER = :B2 AND SRE.CLASSCODE = :B1
8ykptdvha6r5g	INSERT INTO TMP_CP_EMPNO(EMPNO) SELECT EMPNO FROM TBL_CHANNELROLE WHERE ID IN (SELECT CHAROLID FROM TMP_CP_CHAROLID)
8zh540qgs26cn	BEGIN :1 := PKG_PROCESS_CUSTOMER_POLICY.customer_policy_query(:2, :3, :4, :5, :6, :7, :8, :9, :10); END;
93wh8wmsr0k06	BEGIN sp_yy_agt_prerec(:1, :2, :3); END;
9p1um1wd886xb	select o.owner#, u.name, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# order by o.obj#
9t3vghtjguswu	UPDATE CRM_XBYJ SET XBJL = XBJL + :B3 WHERE DATAOWNER = :B2 AND COMDATE = :B1 AND CHAROLEID = (SELECT ID FROM TBL_CHANNELROLE WHERE CHATYPE = 'U13' AND EMPNO = :B4 )
9y105utjvav97	declare l_dataowner_name tbl_division_mapping.dname%type; ld_comdate date; ln_branch tbl_division.governid%type; ln_POLICYNO tbl_prerec.policyno%type; ln_CLASSCODE tbl_prerec.classcode%type; ln_YEARNUM NUMBER; ln_PAYCODE tbl_prerec.paycode%type; ln_CURRCODE tbl_prerec.currcode%type; ln_STDRATE NUMBER(18, 2); ln_UNSTDRATE NUMBER(18, 2); ln_SETCODE tbl_prerec.setcode%type; ln_SALEATTR p10i_md_riskcon.saleattr%type; ln_EMPNO tbl_channelrole.empno%type; ln_CONTNO tbl_policy_orphan.contno%type; ln_PID tbl_policy_orphan.pid%type; ln_PNAME tbl_channelrole.name%type; ln_PTELE tbl_policy_orphan.ptele%type; ln_APPF tbl_policy_orphan.appf%type; ln_DESKPAY tbl_policy_orphan.deskpay%type; ln_APPNO tbl_policy_orphan.appno%type; ln_POLIST tbl_policy_orphan.polist%type; ln_DELSTAT tbl_policy_orphan.delstat%type; ln_PRELNAME tbl_policy_orphan.prelname%type; ln_HEALTH tbl_policy_orphan.health%type; ln_OPERNO tbl_policy_orphan.operno%type; ln_DEBIST tbl_policy_orphan.debist%type; ln_DELTLAG tbl_policy_orphan.deltlag%type; ln_LOSTTIME NUMBER; ln_NPAYLEN NUMBER(16, 2); ln_DELAGE NUMBER; ln_DBDATE DATE; ln_RATE NUMBER(16, 2); ln_STOPAGE NUMBER; ln_PEDATE DATE; ln_TTIME NUMBER; ln_TMOUNT NUMBER(16, 2); ln_DELCODE tbl_policy_orphan.delcode%type ; ln_NRETDATE DATE; ln_VERNO tbl_policy_orphan.verno%type; ln_PAYSEQ rpt_getdate_03.varchar7%type; ln_PIECES NUMBER(16, 3); ln_APPDATE DATE; ln_APID tbl_policy_orphan.apid%type; ln_PAYFRMAGE NUMBER; ln_BEGDATE DATE; ln_STOPDAT DATE; ln_RECVDAT DATE; ln_NEXTDATE DATE; ln_RECADDR tbl_policy_orphan.recaddr%type; ln_PRNTDATE DATE; ln_DEPTNO tbl_policy_orphan.deptno%type; ln_PAYSTATUS tbl_policy_orphan.paystatus%type; ln_DEL tbl_policy_orphan.del%type; ln_RECZIP tbl_policy_orphan.reczip%type; ln_RECTELE tbl_policy_orphan.rectele%type; ln_PADDR tbl_policy_orphan.paddr%type; ln_PZIP tbl_policy_orphan.pzip%type; ln_APADDR tbl_policy_orphan.apaddr%type; ln_APZIP tbl_policy_orphan.apzip%type; ln_APNAME tbl_policy_orphan.apname%type; ln_APTELE tbl_policy_orphan.aptele%type; ln_DIVID NUMBER; ln_ISSETCODE tbl_policy_orphan.issetcode%type; ln_DIVCODE tbl_division.divcode%type; ln_count number; ln_log_comdate date; ln_procename varchar2(100); ln_comments varchar2(200); ln_timestr s_riskclass.timestr%type; ln_zzgsid number; ln_startdate date; v_cnt number; v_fgsid number; v_yearnum number; ln_quitdate date; -- altered by cwy cursor riskcon_cursor is select trim(POLICYNO), POLIST, DELSTAT, trim(PID), PRELNAME, APPNO, HEALTH, CURRCODE, OPERNO, DEBIST, APPF, DELTLAG, LOSTTIME, DESKPAY, NPAYLEN, PAYCODE, DELAGE, DBDATE, RATE, STOPAGE, PEDATE, YEARNUM, TTIME, TMOUNT, DELCODE, NRETDATE, VERNO, PAYSEQ, PIECES, APPDATE, trim(APID), PAYFRMAGE, trim(CLASSCODE), trim(EMPNO), BEGDATE, STOPDAT, RECVDAT, NEXTDATE, SETCODE, trim(RECADDR), PRNTDATE, DEPTNO, STDRATE, UNSTDRATE, CONTNO, PAYSTATUS, DEL, RECZIP, RECTELE, paddr, pzip, pname, ptele, apaddr, apzip, apname, aptele, saleattr, issetcode from tmp_riskcon where dataowner = l_dataowner_name; cursor p10_empno is select distinct areacode from tmp_qt_areacode; cursor c_year(w_branch number, w_policyno varchar2, w_classcode varchar2) is select yearnum from p10i_td_prerec t where t.branch =w_branch and t.policyno = w_policyno and t.classcode = w_classcode order by cover1 desc; cursor p10_riskcon is select rc.policyno, rc.polist, trim(rc.pid), rc.prelname, substr(trim(rc.appno), 1, 15), rc.operno, rc.appf, rc.deskpay, rc.npaylen, rc.tmount, substr(trim(rc.payseq), 1, 1000), rc.pieces, rc.appdate, trim(rc.apid), rc.classcode, rc.empno, rc.begdate, rc.stopdate, rc.unstdrate, rc.saleattr from P10I_MD_RISKCON rc where rc.branch = ln_branch and rc.empno = ln_EMPNO; begin insert into tmp_qt_areacode(areacode) select empno from p10i_md_empno where branch='00000000000001' and status='9'; insert into tmp_qt_areacode(areacode) selec t empno from tbl_channelrole c where dataowner = 1121 and c.status = 'UQ5'; v_fgsid := 1121; delete from rpt_getdate_04; commit; select divcode into ln_branch from tbl_division where id = v_fgsid; ln_log_comdate := trunc(sysdate, 'dd'); select divname into l_dataowner_name from tbl_division where id = v_fgsid; --dbms_output.put_line('ln_branch='||ln_branch||'=l_dataowner_name='||l_dataowner_name); l_dataowner_name := trim(l_dataowner_name); open p10_empno; loop <<loop5>> fetch p10_empno into ln_EMPNO ; exit when p10_empno%notfound; --ÅжÏÒµÎñÔ±ÊÇ·ñÓÐÆäËûÇþµÀÔÚÖ° select count(1) into v_cnt from tbl_channelrole where empno=ln_empno and status in('UQ1', 'UQ4'); if v_cnt > 0 then goto loop5; end if; open p10_riskcon; loop <<loop4>> fetch p10_riskcon into ln_POLICYNO, ln_POLIST, ln_PID, ln_PRELNAME, ln_APPNO, ln_OPERNO, ln_APPF, ln_DESKPAY, ln_NPAYLEN, ln_TMOUNT, ln_PAYSEQ, ln_PIECES, ln_APPDATE, ln_APID, ln_CLASSCODE, ln_EMPNO, ln_BEGDATE, ln_STOPDAT, ln_UNSTDRATE, ln_SALEATTR; exit when p10_riskcon%notfound; begin select t.pedate, t.nretdate, t.nextdate, t.setcode, t.recaddr, t.recz ip, t.rectele, t.paysch into ln_PEDATE, ln_NRETDATE, ln_NEXTDATE, ln_SETCODE, ln_RECADDR, ln_RECZIP, ln_RECTELE, ln_PAYCODE from P10I_MD_MONEYSCH t where branch = ln_branch and policyno = ln_POLICYNO and classcode = ln_CLASSCODE; exception when others then ln_PEDATE := null; ln_NRETDATE := null; ln_NEXTDATE := null; ln_SETCODE := null; ln_RECADDR := null; ln_RECZIP := null; ln_RECTELE := null; end; v_yearnum := null; open c_year(ln_branch, ln_POLICYNO, ln_CLASSCODE); fetch c_year into v_yearnum; --È¡³¤¶ÌÏÕ±êÖ¾ begin select timestr into ln_timestr from s_riskclass where classcode = ln_CLASSCODE and rownum = 1; exception when others then ln_timestr := null; end; --È¡¸ÃÈËËùÊô»ú¹¹ begin select max(trim(divcode)) into ln_DIVCODE from tbl_channelrole where empno = ln_EMPNO and dataowner = v_fgsid; exception when others then ln_DIVCODE := null; end; --È¡ËùÊô»ú¹¹±êʶ begin select max(id) into ln_DIVID from tbl_division where divcode = ln_DIVCODE; exception when others then ln_DIVID := null; end; --È¡ÖÐÖ§¹«Ë¾±êʶ ln_zzgsid := null; if ln_DIVID is not null then begin select division6id into ln_zzgsid from tbl_division_relation where division5id = ln_DIVID; exception when others then ln_zzgsid := null; end; end if; --Èç¹û¸ÃÈ˱¾ÏµÍ³¹¤ºÅ, ÔòÈ¡empno_xsqd±íÖÐËùÊô»ú¹¹ if ln_DIVID is null then begin select max(trim(governid)) into ln_DIVCODE from tmp_empno_xsqd where empno = ln_EMPNO and dataowner = l_dataowner_name; select max(id) into ln_DIVID from tbl_division where governid = ln_DIVCODE; exception when others then ln_DIVCODE := null; end; end if; --ȡͶ±£È˱»±£ÈËÐÕÃû begin select name into ln_pname From p10i_md_person where id = ln_pid; exception when others then ln_pname := null; end; begin select name into ln_apname From p10i_md_person where id = ln_apid; exception when others then ln_apname := null; end; --È¡Óʱ༰µØÖ· begin select trim(zip), trim(subaddr) into ln_pzip, ln_paddr From p10i_md_address where pid = ln_pid and usage = '1'; exception when others then ln_pzip := null; ln_paddr := null; end; begi n select trim(zip), trim(subaddr) into ln_apzip, ln_apaddr From p10i_md_address where pid = ln_apid and usage = '1'; exception when others then ln_apzip := null; ln_apaddr := null; end; --È¡µç»°ºÅÂë begin select trim(tel) into ln_ptele From p10i_md_phone where pid = ln_pid and branch = ln_branch and usage = '1'; exception when others then ln_ptele := null; end; begin select trim(tel) into ln_aptele From p10i_md_phone where pid = ln_apid and branch = ln_branch and usage = '1'; exception when others then ln_aptele := null; end; --ln_PAYSEQ:=null; --dbms_output.put_line('ln_PAYSEQ='||length(ln_PAYSEQ)||'ln_PAYSEQ='||ln_PAYSEQ); begin insert into rpt_getdate_04 (NUMBER1, DEPARTCODE, DEPARTNAME, SECCODE, SECNAME, ZGSCODE, ZGSNAME, ZZGSCODE, ZZGSNAME, FGSCODE, FGSNAME, NUMBER27, ZZGSID, NUMBER2, FGSID, NUMBER4, DEPTNAME, NUMBER6, DATE5, NUMBER9, NUMBER10, DATE3, NUMBER12, NUMBER13, NUMBER14, VARCHAR4, DATE1, VARCHAR6, VARCHAR7, NUMBER16, DATE2, VARCHAR13, NUMBER17, JOBCODE, VARCHAR1, DATE6, DATE7, DATE8, DATE9, NUMBER18, VARCHAR3, DATE4, VARCHAR5, NUMBER7, NUMBER8, VARCHAR8, VARCHAR9, VARCHAR10, VARCHAR11, VARCHAR12, NUMBER5, DATE10, VARCHAR15, VARCHAR16, VARCHAR17, VARCHAR18, VARCHAR19, VARCHAR20, EMPNO, NAME, NUMBER15, CHATYPE, NUMBER28, DEPTCODE, NUMBER3) values (seq_policy_orphan.nextval, ln_POLICYNO, ln_POLIST, null, ln_PID, ln_PRELNAME, substr(trim(ln_appno), 1, 15), null, null, ln_OPERNO, null, to_number(ln_APPF), null, null, to_number(ln_DESKPAY), ln_NPAYLEN, ln_PAYCODE, null, null, null, null, ln_PEDATE, v_yearnum, null, ln_TM OUNT, null, ln_NRETDATE, null, ln_PAYSEQ, ln_PIECES, ln_APPDATE, ln_APID, null, ln_CLASSCODE, ln_EMPNO, ln_BEGDATE, ln_STOPDAT, null, ln_NEXTDATE, ln_SETCODE, ln_RECADDR, null, null, null, ln_UNSTDRATE, null, null, null, ln_RECZIP, ln_RECTELE, v_fgsid, sysdate, ln_PADDR, ln_PZIP, ln_PNAME, ln_PTELE, ln_APADDR, ln_APZIP, ln_APNAME, ln_APTELE, ln_DIVID, ln_SALEATTR, null, ln_timestr, ln_zzgsid); commit; exception when others then null; end; close c_year; end loop; close p10_riskcon; end loop; close p10_empno; end;
9zg6y3ucgy8kb	select n.intcol# from ntab$ n, col$ c where n.obj#=:1 and c.obj#=:1 and c.intcol#=n.intcol# and bitand(c.property, 32768)!=32768
a3fyqj631xwxg	SELECT SUM(NVL(PM.AMOUNT, 0)) FROM TBL_PREREC P, TBL_PREREC_MATCHREST PM, S_RISKCLASS S WHERE 0 = 0 AND P.ID = PM.PRERECID AND P.CLASSCODE = S.CLASSCODE AND EXISTS (SELECT 'x' FROM TMP_T_AREACODE T WHERE PM.AREACODE = T.AREACODE) AND S.TIMESTR <> '1' AND S.DATAOWNER = :B1 AND P.SIGN IN ('1', '2') AND P.CHATYPE = 'U12' AND P.DATAOWNER = :B1 AND P.COMDATE = :B2 AND PM.ISSETCODE IN (1, 2) AND PM.COMDATE = :B2 AND PM.DATAOWNER = :B1
a76pcfa674u86	BEGIN :1 := pkg_kf_progress.fn_personal_progress(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15); END;
aa74933cncj8t	BEGIN rpt_qt_mp_premiumanlys(1002, last_day(add_months(trunc(sysdate), -1))); END;
abkry80wma7y0	select details0_.CHECKID as CHECKID1_, details0_.id as id1_, details0_.id as id407_0_, details0_.EXPRESSION as EXPRESSION407_0_, details0_.FILTER as FILTER407_0_, details0_.COMMENTS as COMMENTS407_0_, details0_.DATAOWNER as DATAOWNER407_0_, details0_.CREATEDATE as CREATEDATE407_0_, details0_.DESTORYDATE as DESTORYD7_407_0_, details0_.FIRSTINSERT as FIRSTINS8_407_0_, details0_.LASTMODIFIED as LASTMODI9_407_0_, details0_.INSERTMAN as INSERTMAN407_0_, details0_.UPDATEMAN as UPDATEMAN407_0_, details0_.CHECKID as CHECKID407_0_, details0_.FACTORSETID as FACTORS13_407_0_ from S_VERSION_CHECK_DETAIL details0_ where details0_.CHECKID=:1
adbkdb5d91j26	SELECT /*+index(pmr PK_P10I_MD_RISKCON)*/ PMR.GPOLICYNO FROM P10I_MD_RISKCON PMR WHERE PMR.BRANCH = :B2 AND PMR.POLICYNO = :B1 UNION ALL SELECT /*+index(pmr IDX_P10I_MD_RISKCON_07)*/ PMR.GPOLICYNO FROM P10I_MD_RISKCON PMR WHERE PMR.BRANCH = :B2 AND PMR.GPOLICYNO = :B1
ah12nrzj1uyaw	DELETE FROM TMP_CP_EMPNO
amn7zwufxvc67	INSERT INTO TMP_T_PID (PID) SELECT DISTINCT TRIM(T.APID) FROM TBL_POLICY_ORPHAN T WHERE EXISTS (SELECT 'x' FROM TMP_T_AREACODE A WHERE T.AREACODE = A.AREACODE) AND T.ISSETCODE IN ('1', '2') AND T.DATAOWNER = :B1
asusxf6k5rr3t	insert into tmp_supervise_policy_pay (charoleid, POLICYNO, classcode, APPID, APPNAME, AMOUNT, EMPNAME, COVER1, YEARNO, PAYDATE, FACTAMOUNT, DESKPAY, URGE_CONDITION, ISSHORTRISK, EMPNO, POLIST, issale, appf) select t.charoleid, t.policyno, t.classcode, t.appid, t.appname, t.stdrate + t.unstdrate + t.amount as amount, t.empname, t.cover1, t.yearno, t.paydate, t.factamount, t.deskpay, t.COLLECTION_CONDITION, case when t.isshortrisk = 1 and t.continue in ('1', '3') then 'ÊÇ' when t.isshortrisk = 0 then ' ' else '·ñ' end as ISSHORTRISK, t.empno, t.polist, t.issale, 1 from crm_sprerec t where t.dataowner = :1 and t.charoleid = :2 and t.cover1 >= :3 and t.cover1 <= :4 and t.ispay = '1' and (t.status = '4' or t.isshortrisk = '1') and t.issale = :5 and exists ( select 1 from p10i_md_riskcon c where c.branch=:6 and c.policyno = t.policyno and c.classcode = t.classcode and c.appf = '1' )
au7f6hpnhxpkx	select ts# from ts$ where dflmaxext =:1 and bitand(flags, 1024) =1024 and online$=1
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b8ynfbqxxhg09	SELECT /*+index(pmp IDX_P10I_MD_PERSON_01)*/ TRIM(PMP.NAME) FROM P10I_MD_PERSON PMP WHERE PMP.ID = :B1
bkudtmvhhjgjx	select recommenda0_.id as id144_, recommenda0_.EFFECTDATE as EFFECTDATE144_, recommenda0_.QUITDATE as QUITDATE144_, recommenda0_.DATAOWNER as DATAOWNER144_, recommenda0_.ASSISTANT as ASSISTANT144_, recommenda0_.RECASSO as RECASSO144_, recommenda0_.RECDATE as RECDATE144_, recommenda0_.channelRole12Id as channelR8_144_, recommenda0_.channelRole14Id as channelR9_144_, recommenda0_.FIRSTINSERT as FIRSTIN10_144_, recommenda0_.LASTMODIFIED as LASTMOD11_144_, recommenda0_.INSERTMAN as INSERTMAN144_, recommenda0_.UPDATEMAN as UPDATEMAN144_ from TBL_RECOMMENDATION_RELATION recommenda0_ where (recommenda0_.DATAOWNER=2313 or recommenda0_.DATAOWNER=:1) and recommenda0_.channelRole12Id=:2 and recommenda0_.RECASSO=:3 and recommenda0_.EFFECTDATE<=:4
bpd0x5nx9vs2h	BEGIN :1 := pkg_kf_progress.fn_division_progress(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
bz417yaz2d3xt	BEGIN :1 := pkg_kf_simple_query.fn_paidUp_premium_info(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21); END;
d26mmuw6jrdz8	SELECT COUNT(1), NVL(SUM(CASE WHEN IS_HEALTHPSN = 1 THEN 1 ELSE 0 END), 0) FROM RPT_HEALTHPSNLABER WHERE FGSID = :B2 AND COMDATE = :B1 AND CHAROLID IN (SELECT CHAROLID FROM TMP_CP_CHAROLID)
d4d352d0f7m4z	BEGIN rpt_qt_mp_sectnormtrace(1002, last_day(add_months(trunc(sysdate), -1))); END;
ddxt3ws42k47n	SELECT SUM(NVL(P.BZAMOUNT, 0)) FROM TBL_PREREC P, TBL_PREREC_MATCHREST PM WHERE 0 = 0 AND P.ID = PM.PRERECID AND EXISTS (SELECT 'x' FROM TMP_T_AREACODE T WHERE PM.AREACODE = T.AREACODE) AND P.CHATYPE = 'U12' AND P.DATAOWNER = :B1 AND P.COMDATE = :B2 AND PM.ISSETCODE IN (1, 2) AND PM.COMDATE = :B2 AND PM.DATAOWNER = :B1
dkdqhrbkx5y0z	SELECT /*+index(pma IDX_P10I_MD_APPPOS_01)*/ 1 FROM P10I_MD_APPPOS PMA WHERE PMA.BRANCH = :B3 AND PMA.POLICYNO = :B2 AND PMA.CLASSCODE = :B1 AND PMA.CHANGEID = '33' AND PMA.STATUS = 3 AND ROWNUM = 1
fdfc4cb16ufu8	SELECT MIN(T.LEVELDEFINE) FROM USER_ORGS T WHERE T.DESTROYDATE IS NULL AND (T.QUITDATE IS NULL OR T.QUITDATE > TRUNC(SYSDATE)) AND T.CHANNEL = :B3 AND T.DIV_OR_DEPT_ID = :B2 AND T.KEYS = :B1
ffq9ssfmpx53k	BEGIN :1 := pkg_kf_report_query21.fn_report_query21(:2, :3, :4, :5, :6, :7, :8, :9, :10); END;
fgfzdgng3ytxd	DELETE FROM TMP_CP_CHAROLID
fgrczp30cjbu8	SELECT SUM(NVL(PM.AMOUNT, 0)) FROM TBL_PREREC P, TBL_PREREC_MATCHREST PM, S_RISKCLASS S, S_RISKNAME RN WHERE 0 = 0 AND P.ID = PM.PRERECID AND P.CLASSCODE = S.CLASSCODE AND P.CLASSCODE = RN.CLASSCODE AND EXISTS (SELECT 'x' FROM TMP_T_AREACODE T WHERE PM.AREACODE = T.AREACODE) AND RN.TYPE NOT IN ('01', '07') AND RN.DATAOWNER = :B1 AND S.TIMESTR = '1' AND S.DATAOWNER = :B1 AND P.PAYCODE IN ('10', '11', '12', '13') AND P.CHATYPE = 'U12' AND P.DATAOWNER = :B1 AND P.COMDATE = :B2 AND PM.ISSETCODE IN (1, 2) AND PM.COMDATE = :B2 AND PM.DATAOWNER = :B1
fs3adu0nuu5dv	SELECT /*+index(pmr PK_P10I_MD_RISKCON)*/ PMR.APPDATE, CASE WHEN LENGTHB(REPLACE(REPLACE(PMR.PID, ' '), '¡¡')) - 18 <= 0 THEN REPLACE(REPLACE(PMR.PID, ' '), '¡¡') ELSE SUBSTRB(PMR.PID, 1, 18) END, PMR.APPNO, PMR.EMPNO, CASE WHEN LENGTHB(REPLACE(REPLACE(PMR.APID, ' '), '¡¡')) - 18 <= 0 THEN REPLACE(REPLACE(PMR.APID, ' '), '¡¡') ELSE SUBSTRB(PMR.APID, 1, 18) END, PMR.SALEATTR, TRIM(OWNER_SOURCE_ID), TRIM(INSURED_SOURCE_ID) FROM P10I_MD_RISKCON PMR WHERE PMR.BRANCH = :B3 AND PMR.POLICYNO = :B2 AND PMR.CLASSCODE = :B1
fspxt56r74b50	select moneyprovi0_.id as id86_, moneyprovi0_.DIVROOT as DIVROOT86_, moneyprovi0_.JOBCODE as JOBCODE86_, moneyprovi0_.channelRoleId as channelR4_86_, moneyprovi0_.employeeId as employeeId86_, moneyprovi0_.MONTH as MONTH86_, moneyprovi0_.DATAOWNER as DATAOWNER86_, moneyprovi0_.ELETYPE as ELETYPE86_, moneyprovi0_.ELEVALUE as ELEVALUE86_, moneyprovi0_.ENDDATE as ENDDATE86_, moneyprovi0_.COMDATE as COMDATE86_, moneyprovi0_.STARTDATE as STARTDATE86_, moneyprovi0_.FIRSTINSERT as FIRSTIN13_86_, moneyprovi0_.LASTMODIFIED as LASTMOD14_86_, moneyprovi0_.INSERTMAN as INSERTMAN86_, moneyprovi0_.UPDATEMAN as UPDATEMAN86_, moneyprovi0_.PAYMENTMETHOD as PAYMENT17_86_, moneyprovi0_.MSTYPE as MSTYPE86_, moneyprovi0_.DIVISIONID as DIVISIONID86_, moneyprovi0_.STATUS as STATUS86_, moneyprovi0_.DEPTID as DEPTID86_, moneyprovi0_.CHATYPE as CHATYPE86_ from TBL_MONEY_PROVISION_ELEMENT moneyprovi0_ where moneyprovi0_.DIVROOT=:1 and months_between(:2, moneyprovi0_.COMDATE)<:3 and months_between(:4, moneyprovi0_.COMDATE)>=0 and (moneyprovi0_.channelRoleId in (:5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , :207 , :208 , :209 , :210 , :211 , :212 , :213 , :214 , :215 , :216 , :217 , :218 , :219 , :220 , :221 , :222 , :223 , :224 , :225 , :226 , :227 , :228 , :229 , :230 , :231 , :232 , :233 , :234 , :235 , :236 , :237 , :238 , :239 , :240 , :241 , :242 , :243 , :244 , :245 , :246 , :247 , :248 , :249 , :250 , :251 , :252 , :253 , :254 , :255 , :256 , :257 , :258 , :259 , :260 , :261 , :262 , :263 , :264 , :265 , :266 , :267 , :268 , :269 , :270 , :271 , :272 , :273 , :274 , :275 , :276 , :277 , :278 , :279 , :280 , :281 , :282 , :283 , :284 , :285 , :286 , :287 , :288 , :289 , :290 , :291 , :292 , :293 , :294 , :295 , :296 , :297 , :298 , :299 , :300 , :301 , :302 , :303 , :304 , :305 , :306 , :307 , :308 , :309 , :310 , :311 , :312 , :313 , :314 , :315 , :316 , :317 , :318 , :319 , :320 , :321 , :322 , :323 , :324 , :325 , :326 , :327 , :328 , :329 , :330 , :331 , :332 , :333 , :334 , :335 , :336 , :337 , :338 , :339 , :340 , :341 , :342 , :343 , :344 , :345 , :346 , :347 , :348 , :349 , :350 , :351 , :352 , :353 , :354 , :355 , :356 , :357 , :358 , :359 , :360 , :361 , :362 , :363 , :364 , :365 , :366 , :367 , :368 , :369 , :370 , :371 , :372 , :373 , :374 , :375 , :376 , :377 , :378 , :379 , :380 , :381 , :382 , :383 , :384 , :385 , :386 , :387 , :388 , :389 , :390 , :391 , :392 , :393 , :394 , :395 , :396 , :397 , :398 , :399 , :400 , :401 , :402 , :403 , :404 , :405 , :406 , :407 , :408 , :409 , :410 , :411 , :412 , :413 , :414 , :415 , :416 , :417 , :418 , :419 , :420 , :421 , :422 , :423 , :424 , :425 , :426 , :427 , :428 , :429 , :430 , :431 , :432 , :433 , :434 , :435 , :436 , :437 , :438 , :439 , :440 , :441 , :442 , :443 , :444 , :4 45 , :446 , :447 , :448 , :449 , :450 , :451 , :452 , :453 , :454 , :455 , :456 , :457 , :458 , :459 , :460 , :461 , :462 , :463 , :464 , :465 , :466 , :467 , :468 , :469 , :470 , :471 , :472 , :473 , :474 , :475 , :476 , :477 , :478 , :479 , :480 , :481 , :482 , :483 , :484 , :485 , :486 , :487 , :488 , :489 , :490 , :491 , :492 , :493 , :494 , :495 , :496 , :497 , :498 , :499 , :500 , :501 , :502 , :503 , :504 , :505 , :506 , :507 , :508 , :509 , :510 , :511 , :512 , :513 , :514 , :515 , :516 , :517 , :518 , :519 , :520 , :521 , :522 , :523 , :524 , :525 , :526 , :527 , :528 , :529 , :530 , :531 , :532 , :533 , :534 , :535 , :536 , :537 , :538 , :539 , :540 , :541 , :542 , :543 , :544 , :545 , :546 , :547 , :548 , :549 , :550 , :551 , :552 , :553 , :554 , :555 , :556 , :557 , :558 , :559 , :560 , :561 , :562 , :563 , :564 , :565 , :566 , :567 , :568 , :569 , :570 , :571 , :572 , :573 , :574 , :575 , :576 , :577 , :578 , :579 , :580 , :581 , :582 , :583 , :584 , :585 , :586 , :587 , :588 , :589 , :590 , :591 , :592 , :593 , :594 , :595 , :596 , :597 , :598 , :599 , :600 , :601 , :602 , :603 , :604 , :605 , :606 , :607 , :608 , :609 , :610 , :611 , :612 , :613 , :614 , :615 , :616 , :617 , :618 , :619 , :620 , :621 , :622 , :623 , :624 , :625 , :626 , :627 , :628 , :629 , :630 , :631 , :632 , :633 , :634 , :635 , :636 , :637 , :638 , :639 , :640 , :641 , :642 , :643 , :644 , :645 , :646 , :647 , :648 , :649 , :650 , :651 , :652 , :653 , :654 , :655 , :656 , :657 , :658 , :659 , :660 , :661 , :662 , :663 , :664 , :665 , :666 , :667 , :668 , :669 , :670 , :671 , :672 , :673 , :674 , :675 , :676 , :677 , :678 , :679 , :680 , :681 , :682 , :683 , :684 , :685 , :686 , :687 , :688 , :689 , :690 , :691 , :692 , :693 , :694 , :695 , :696 , :697 , :698 , :699 , :700 , :701 , :702 , :703 , :704 , :705 , :706 , :707 , :708 , :709 , :710 , :711 , :712 , :713 , :714 , :715 , :716 , :717 , :718 , :719 , :720 , :721 , :722 , :723 , :724 , :725 , :726 , :727 , :728 , :729 , :730 , :731 , :732 , :733 , :734 , :735 , :736 , :737 , :738 , :739 , :740 , :741 , :742 , :743 , :744 , :745 , :746 , :747 , :748 , :749 , :750 , :751 , :752 , :753 , :754 , :755 , :756 , :757 , :758 , :759 , :760 , :761 , :762 , :763 , :764 , :765 , :766 , :767 , :768 , :769 , :770 , :771 , :772 , :773 , :774 , :775 , :776 , :777 , :778 , :779 , :780 , :781 , :782 , :783 , :784 , :785 , :786 , :787 , :788 , :789 , :790 , :791 , :792 , :793 , :794 , :795 , :796 , :797 , :798 , :799 , :800 , :801 , :802 , :803 , :804 , :805 , :806 , :807 , :808 , :809 , :810 , :811 , :812 , :813 , :814 , :815 , :816 , :817 , :818 , :819 , :8 20 , :821 , :822 , :823 , :824 , :825 , :826 , :827 , :828 , :829 , :830 , :831 , :832 , :833 , :834 , :835 , :836 , :837 , :838 , :839 , :840 , :841 , :842 , :843 , :844 , :845 , :846 , :847 , :848 , :849 , :850 , :851 , :852 , :853 , :854 , :855 , :856 , :857 , :858 , :859 , :860 , :861 , :862 , :863 , :864 , :865 , :866 , :867 , :868 , :869 , :870 , :871 , :872 , :873 , :874 , :875 , :876 , :877 , :878 , :879 , :880 , :881 , :882 , :883 , :884 , :885 , :886 , :887 , :888 , :889 , :890 , :891 , :892 , :893 , :894 , :895 , :896 , :897 , :898 , :899 , :900 , :901 , :902 , :903 , :904 , :905 , :906 , :907 , :908 , :909 , :910 , :911 , :912 , :913 , :914 , :915 , :916 , :917 , :918 , :919 , :920 , :921 , :922 , :923 , :924 , :925 , :926 , :927 , :928 , :929 , :930 , :931 , :932 , :933 , :934 , :935 , :936 , :937 , :938 , :939 , :940 , :941 , :942 , :943 , :944 , :945 , :946 , :947 , :948 , :949 , :950 , :951 , :952 , :953 , :954 , :955 , :956 , :957 , :958 , :959 , :960 , :961 , :962 , :963 , :964 , :965 , :966 , :967 , :968 , :969 , :970 , :971 , :972 , :973 , :974 , :975 , :976 , :977 , :978 , :979 , :980 , :981 , :982 , :983 , :984 , :985 , :986 , :987 , :988 , :989 , :990 , :991 , :992 , :993 , :994 , :995 , :996 , :997 , :998 , :999 , :1000 , :1001 , :1002 , :1003 , :1004) or moneyprovi0_.cha nnelRoleId in (:1005 , :1006 , :1007 , :1008 , :1009 , :1010 , :1011 , :1012 , :1013 , :1014 , :1015 , :1016 , :1017 , :1018 , :1019 , :1020 , :1021 , :1022 , :1023 , :1024 , :1025 , :1026 , :1027 , :1028 , :1029 , :1030 , :1031 , :1032 , :1033 , :1034 , :1035 , :1036 , :1037 , :1038 , :1039 , :1040 , :1041 , :1042 , :1043 , :1044 , :1045 , :1046 , :1047 , :1048 , :1049 , :1050 , :1051 , :1052 , :1053 , :1054 , :1055 , :1056 , :1057 , :1058 , :1059 , :1060 , :1061 , :1062 , :1063 , :1064 , :1065 , :1066 , :1067 , :1068 , :1069 , :1070 , :1071 , :1072 , :1073 , :1074 , :1075 , :1076 , :1077 , :1078 , :1079 , :1080 , :1081 , :1082 , :1083 , :1084 , :1085 , :1086 , :1087 , :1088 , :1089 , :1090 , :1091 , :1092 , :1093 , :1094 , :1095 , :1096 , :1097 , :1098 , :1099 , :1100 , :1101 , :1102 , :1103 , :1104 , :1105 , :1106 , :1107 , :1108 , :1109 , :1110 , :1111 , :1112 , :1113 , :1114 , :1115 , :1116 , :1117 , :1118 , :1119 , :1120 , :1121 , :1122 , :1123 , :1124 , :1125 , :1126 , :1127 , :1128 , :1129 , :1130 , :1131 , :1132 , :1133 , :1134 , :1135 , :1136 , :1137 , :1138 , :1139 , :1140 , :1141 , :1142 , :1143 , :1144 , :1145 , :1146 , :1147 , :1148 , :1149 , :1150 , :1151 , :1152 , :1153 , :1154 , :1155 , :1156 , :1157 , :1158 , :1159 , :1160 , :1161 , :1162 , :1163 , :1164 , :1165 , :1166 , :1167 , :1168 , :1169 , :1170 , :1171 , :1172 , :1173 , :1174 , :1175 , :1176 , :1177 , :1178 , :1179 , :1180 , :1181 , :1182 , :1183 , :1184 , :1185 , :1186 , :1187 , :1188 , :1189 , :1190 , :1191 , :1192 , :1193 , :1194 , :1195 , :1196 , :1197 , :1198 , :1199 , :1200 , :1201 , :1202 , :1203 , :1204 , :1205 , :1206 , :1207 , :1208 , :1209 , :1210 , :1211 , :1212 , :1213 , :1214 , :1215 , :1216 , :1217 , :1218 , :1219 , :1220 , :1221 , :1222 , :1223 , :1224 , :1225 , :1226 , :1227 , :1228 , :1229 , :1230 , :1231 , :1232 , :1233 , :1234 , :1235 , :1236 , :1237 , :1238 , :1239 , :1240 , :1241 , :1242 , :1243 , :1244 , :1245 , :1246 , :1247 , :1248 , :1249 , :1250 , :1251 , :1252 , :1253 , :1254 , :1255 , :1256 , :1257 , :1258 , :1259 , :1260 , :1261 , :1262 , :1263 , :1264 , :1265 , :1266 , :1267 , :1268 , :1269 , :1270 , :1271 , :1272 , :1273 , :1274 , :1275 , :1276 , :1277 , :1278 , :1279 , :1280 , :1281 , :1282 , :1283 , :1284 , :1285 , :1286 , :1287 , :1288 , :1289 , :1290 , :1291 , :1292 , :1293 , :1294 , :1295 , :1296 , :1297 , :1298 , :1299 , :1300 , :1301 , :1302 , :1303 , :1304 , :1305 , :1306 , :1307 , :1308 , :1309 , :1310 , :1311 , :1312 , :1313 , :1314 , :1315 , :1316 , :1317 , :1318 , :1319 , :1320 , :1321 , :1322 , :1323 , :1324 , :1325 , :1326 , :1327 , :1328 , :1329 , :1330 , :1331 , :1332 , :1333 , :1334 , :1335 , :1336 , :1337 , :1338 , :1339 , :1340 , :1341 , :1342 , :1343 , :1344 , :1345 , :1346 , :1347 , :1348 , :1349 , :1350 , :1351 , :1352 , :1353 , :1354 , :1355 , :1356 , :1357 , :1358 , :1359 , :1360 , :1361 , :1362 , :1363 , :1364 , :1365 , :1366 , :1367 , :1368 , :1369 , :1370 , :1371 , :1372 , :1373 , :1374 , :1375 , :1376 , :1377 , :1378 , :1379 , :1380 , :1381 , :1382 , :1383 , :1384 , :1385 , :1386 , :1387 , :1388 , :1389 , :1390 , :1391 , :1392 , :1393 , :1394 , :1395 , :1396 , :1397 , :1398 , :1399 , :1400 , :1401 , :1402 , :1403 , :1404 , :1405 , :1406 , :1407 , :1408 , :1409 , :1410 , :1411 , :1412 , :1413 , :1414 , :1415 , :1416 , :1417 , :1418 , :1419 , :1420 , :1421 , :1422 , :1423 , :1424 , :1425 , :1426 , :1427 , :1428 , :1429 , :1430 , :1431 , :1432 , :1433 , :1434 , :1435 , :1436 , :1437 , :1438 , :1439 , :1440 , :1441 , :1442 , :1443 , :1444 , :1445 , :1446 , :1447 , :1448 , :1449 , :1450 , :1451 , :1452 , :1453 , :1454 , :1455 , :1456 , :1457 , :1458 , :1459 , :1460 , :1461 , :1462 , :1463 , :1464 , :1465 , :1466 , :1467 , :1468 , :1469 , :1470 , :1471 , :1472 , :1473 , :1474 , :1475 , :1476 , :1477 , :1478 , :1479 , :1480 , :1481 , :1482 , :1483 , :1484 , :1485 , :1486 , :1487 , :1488 , :1489 , :1490 , :1491 , :1492 , :1493 , :1494 , :1495 , :1496 , :1497 , :1498 , :1499 , :1500 , :1501 , :1502 , :15 03 , :1504 , :1505 , :1506 , :1507 , :1508 , :1509 , :1510 , :1511 , :1512 , :1513 , :1514 , :1515 , :1516 , :1517 , :1518 , :1519 , :1520 , :1521 , :1522 , :1523 , :1524 , :1525 , :1526 , :1527 , :1528 , :1529 , :1530 , :1531 , :1532 , :1533 , :1534 , :1535 , :1536 , :1537 , :1538 , :1539 , :1540 , :1541 , :1542 , :1543 , :1544 , :1545 , :1546 , :1547 , :1548 , :1549 , :1550 , :1551 , :1552 , :1553 , :1554 , :1555 , :1556 , :1557 , :1558 , :1559 , :1560 , :1561 , :1562 , :1563 , :1564 , :1565 , :1566 , :1567 , :1568 , :1569 , :1570 , :1571 , :1572 , :1573 , :1574 , :1575 , :1576 , :1577 , :1578 , :1579 , :1580 , :1581 , :1582 , :1583 , :1584 , :1585 , :1586 , :1587 , :1588 , :1589 , :1590 , :1591 , :1592 , :1593 , :1594 , :1595 , :1596 , :1597 , :1598 , :1599 , :1600 , :1601 , :1602 , :1603 , :1604 , :1605 , :1606 , :1607 , :1608 , :1609 , :1610 , :1611 , :1612 , :1613 , :1614 , :1615 , :1616 , :1617 , :1618 , :1619 , :1620 , :1621 , :1622 , :1623 , :1624 , :1625 , :1626 , :1627 , :1628 , :1629 , :1630 , :1631 , :1632 , :1633 , :1634 , :1635 , :1636 , :1637 , :1638 , :1639 , :1640 , :1641 , :1642 , :1643 , :1644 , :1645 , :1646 , :1647 , :1648 , :1649 , :1650 , :1651 , :1652 , :1653 , :1654 , :1655 , :1656 , :1657 , :1658 , :1659 , :1660 , :1661 , :1662 , :1663 , :1664 , :1665 , :1666 , :1667 , :1668 , :1669 , :1670 , :1671 , :1672 , :1673 , :1674 , :1675 , :1676 , :1677 , :1678 , :1679 , :1680 , :1681 , :1682 , :1683 , :1684 , :1685 , :1686 , :1687 , :1688 , :1689 , :1690 , :1691 , :1692 , :1693 , :1694 , :1695 , :1696 , :1697 , :1698 , :1699 , :1700 , :1701 , :1702 , :1703 , :1704 , :1705 , :1706 , :1707 , :1708 , :1709 , :1710 , :1711 , :1712 , :1713 , :1714 , :1715 , :1716 , :1717 , :1718 , :1719 , :1720 , :1721 , :1722 , :1723 , :1724 , :1725 , :1726 , :1727 , :1728 , :1729 , :1730 , :1731 , :1732 , :1733 , :1734 , :1735 , :1736 , :1737 , :1738 , :1739 , :1740 , :1741 , :1742 , :1743 , :1744 , :1745 , :1746 , :1747 , :1748 , :1749 , :1750 , :1751 , :1752 , :1753 , :1754 , :1755 , :1756 , :1757 , :1758 , :1759 , :1760 , :1761 , :1762 , :1763 , :1764 , :1765 , :1766 , :1767 , :1768 , :1769 , :1770 , :1771 , :1772 , :1773 , :1774 , :1775 , :1776 , :1777 , :1778 , :1779 , :1780 , :1781 , :1782 , :1783 , :1784 , :1785 , :1786 , :1787 , :1788 , :1789 , :1790 , :1791 , :1792 , :1793 , :1794 , :1795 , :1796 , :1797 , :1798 , :1799 , :1800 , :1801 , :1802 , :1803 , :1804 , :1805 , :1806 , :1807 , :1808 , :1809 , :1810 , :1811 , :1812 , :1813 , :1814 , :1815 , :1816 , :1817 , :1818 , :1819 , :1820 , :1821 , :1822 , :1823 , :1824 , :1825 , :1826 , :1827 , :1828 , :1829 , :1830 , :1831 , :1832 , :1833 , :1834 , :1835 , :1836 , :1837 , :1838 , :1839 , :1840 , :1841 , :1842 , :1843 , :1844 , :1845 , :1846 , :1847 , :1848 , :1849 , :1850 , :1851 , :1852 , :1853 , :1854 , :1855 , :1856 , :1857 , :1858 , :1859 , :1860 , :1861 , :1862 , :1863 , :1864 , :1865 , :1866 , :1867 , :1868 , :1869 , :1870 , :1871 , :1872 , :1873 , :1874 , :1875 , :1876 , :1877 , :1878 , :1879 , :1880 , :1881 , :1882 , :1883 , :1884 , :1885 , :1886 , :1887 , :1888 , :1889 , :1890 , :1891 , :1892 , :1893 , :1894 , :1895 , :1896 , :1897 , :1898 , :1899 , :1900 , :1901 , :1902 , :1903 , :1904 , :1905 , :1906 , :1907 , :1908 , :1909 , :1910 , :1911 , :1912 , :1913 , :1914 , :1915 , :1916 , :1917 , :1918 , :1919 , :1920 , :1921 , :1922 , :1923 , :1924 , :1925 , :1926 , :1927 , :1928 , :1929 , :1930 , :1931 , :1932 , :1933 , :1934 , :1935 , :1936 , :1937 , :1938 , :1939 , :1940 , :1941 , :1942 , :1943 , :1944 , :1945 , :1946 , :1947 , :1948 , :1949 , :1950 , :1951 , :1952 , :1953 , :1954 , :1955 , :1956 , :1957 , :1958 , :1959 , :1960 , :1961 , :1962 , :1963 , :1964 , :1965 , :1966 , :1967 , :1968 , :1969 , :1970 , :1971 , :1972 , :1973 , :1974 , :1975 , :1976 , :1977 , :1978 , :1979 , :1980 , :1981 , :1982 , :1983 , :1984 , :1985 , :1986 , :1987 , :1988 , :1989 , :1990 , :1991 , :1992 , :1993 , :1994 , :1995 , :1996 , :1997 , :1998 , :1999 , :2000 , :2001 , :2002 , :20 03 , :2004) or moneyprovi0_.channelRoleId in (:2005 , :2006 , :2007 , :2008 , :2009 , :2010 , :2011 , :2012 , :2013 , :2014 , :2015 , :2016 , :2017 , :2018 , :2019 , :2020 , :2021 , :2022 , :2023 , :2024 , :2025 , :2026 , :2027 , :2028 , :2029 , :2030 , :2031 , :2032 , :2033 , :2034 , :2035 , :2036 , :2037 , :2038 , :2039 , :2040 , :2041 , :2042 , :2043 , :2044 , :2045 , :2046 , :2047 , :2048 , :2049 , :2050 , :2051 , :2052 , :2053 , :2054 , :2055 , :2056 , :2057 , :2058 , :2059 , :2060 , :2061 , :2062 , :2063 , :2064 , :2065 , :2066 , :2067 , :2068 , :2069 , :2070 , :2071 , :2072 , :2073 , :2074 , :2075 , :2076 , :2077 , :2078 , :2079 , :2080 , :2081 , :2082 , :2083 , :2084 , :2085 , :2086 , :2087 , :2088 , :2089 , :2090 , :2091 , :2092 , :2093 , :2094 , :2095 , :2096 , :2097 , :2098 , :2099 , :2100 , :2101 , :2102 , :2103 , :2104 , :2105 , :2106 , :2107 , :2108 , :2109 , :2110 , :2111 , :2112 , :2113 , :2114 , :2115 , :2116 , :2117 , :2118 , :2119 , :2120 , :2121 , :2122 , :2123 , :2124 , :2125 , :2126 , :2127 , :2128 , :2129 , :2130 , :2131 , :2132 , :2133 , :2134 , :2135 , :2136 , :2137 , :2138 , :2139 , :2140 , :2141 , :2142 , :2143 , :2144 , :2145 , :2146 , :2147 , :2148 , :2149 , :2150 , :2151 , :2152 , :2153 , :2154 , :2155 , :2156 , :2157 , :2158 , :2159 , :2160 , :2161 , :2162 , :2163 , :2164 , :2165 , :216 6 , :2167 , :2168 , :2169 , :2170 , :2171 , :2172 , :2173 , :2174 , :2175 , :2176 , :2177 , :2178 , :2179 , :2180 , :2181 , :2182 , :2183 , :2184 , :2185 , :2186 , :2187 , :2188 , :2189 , :2190 , :2191 , :2192 , :2193 , :2194 , :2195 , :2196 , :2197 , :2198 , :2199 , :2200 , :2201 , :2202 , :2203 , :2204 , :2205 , :2206 , :2207 , :2208 , :2209 , :2210 , :2211 , :2212 , :2213 , :2214 , :2215 , :2216 , :2217 , :2218 , :2219 , :2220 , :2221 , :2222 , :2223 , :2224 , :2225 , :2226 , :2227 , :2228 , :2229 , :2230 , :2231 , :2232 , :2233 , :2234 , :2235 , :2236 , :2237 , :2238 , :2239 , :2240 , :2241 , :2242 , :2243 , :2244 , :2245 , :2246 , :2247 , :2248 , :2249 , :2250 , :2251 , :2252 , :2253 , :2254 , :2255 , :2256 , :2257 , :2258 , :2259 , :2260 , :2261 , :2262 , :2263 , :2264 , :2265 , :2266 , :2267 , :2268 , :2269 , :2270 , :2271 , :2272 , :2273 , :2274 , :2275 , :2276 , :2277 , :2278 , :2279 , :2280 , :2281 , :2282 , :2283 , :2284 , :2285 , :2286 , :2287 , :2288 , :2289 , :2290 , :2291 , :2292 , :2293 , :2294 , :2295 , :2296 , :2297 , :2298 , :2299 , :2300 , :2301 , :2302 , :2303 , :2304 , :2305 , :2306 , :2307 , :2308 , :2309 , :2310 , :2311 , :2312 , :2313 , :2314 , :2315 , :2316 , :2317 , :2318 , :2319 , :2320 , :2321 , :2322 , :2323 , :2324 , :2325 , :2326 , :2327 , :2328 , :2329 , :2330 , :2331 , :2332 , : 2333 , :2334 , :2335 , :2336 , :2337 , :2338 , :2339 , :2340 , :2341 , :2342 , :2343 , :2344 , :2345 , :2346 , :2347 , :2348 , :2349 , :2350 , :2351 , :2352 , :2353 , :2354 , :2355 , :2356 , :2357 , :2358 , :2359 , :2360 , :2361 , :2362 , :2363 , :2364 , :2365 , :2366 , :2367 , :2368 , :2369 , :2370 , :2371 , :2372 , :2373 , :2374 , :2375 , :2376 , :2377 , :2378 , :2379 , :2380 , :2381 , :2382 , :2383 , :2384 , :2385 , :2386 , :2387 , :2388 , :2389 , :2390 , :2391 , :2392 , :2393 , :2394 , :2395 , :2396 , :2397 , :2398 , :2399 , :2400 , :2401 , :2402 , :2403 , :2404 , :2405 , :2406 , :2407 , :2408 , :2409 , :2410 , :2411 , :2412 , :2413 , :2414 , :2415 , :2416 , :2417 , :2418 , :2419 , :2420 , :2421 , :2422 , :2423 , :2424 , :2425 , :2426 , :2427 , :2428 , :2429 , :2430 , :2431 , :2432 , :2433 , :2434 , :2435 , :2436 , :2437 , :2438 , :2439 , :2440 , :2441 , :2442 , :2443 , :2444 , :2445 , :2446 , :2447 , :2448 , :2449 , :2450 , :2451 , :2452 , :2453 , :2454 , :2455 , :2456 , :2457 , :2458 , :2459 , :2460 , :2461 , :2462 , :2463 , :2464 , :2465 , :2466 , :2467 , :2468 , :2469 , :2470 , :2471 , :2472 , :2473 , :2474 , :2475 , :2476 , :2477 , :2478 , :2479 , :2480 , :2481 , :2482 , :2483 , :2484 , :2485 , :2486 , :2487 , :2488 , :2489 , :2490 , :2491 , :2492 , :2493 , :2494 , :2495 , :2496 , :2497 , :2498 , :2499 , :2500 , :2501 , :2502 , :2503 , :2504 , :2505 , :2506 , :2507 , :2508 , :2509 , :2510 , :2511 , :2512 , :2513 , :2514 , :2515 , :2516 , :2517 , :2518 , :2519 , :2520 , :2521 , :2522 , :2523 , :2524 , :2525 , :2526 , :2527 , :2528 , :2529 , :2530 , :2531 , :2532 , :2533 , :2534 , :2535 , :2536 , :2537 , :2538 , :2539 , :2540 , :2541 , :2542 , :2543 , :2544 , :2545 , :2546 , :2547 , :2548 , :2549 , :2550 , :2551 , :2552 , :2553 , :2554 , :2555 , :2556 , :2557 , :2558 , :2559 , :2560 , :2561 , :2562 , :2563 , :2564 , :2565 , :2566 , :2567 , :2568 , :2569 , :2570 , :2571 , :2572 , :2573 , :2574 , :2575 , :2576 , :2577 , :2578 , :2579 , :2580 , :2581 , :2582 , :2583 , :2584 , :2585 , :2586 , :2587 , :2588 , :2589 , :2590 , :2591 , :2592 , :2593 , :2594 , :2595 , :2596 , :2597 , :2598 , :2599 , :2600 , :2601 , :2602 , :2603 , :2604 , :2605 , :2606 , :2607 , :2608 , :2609 , :2610 , :2611 , :2612 , :2613 , :2614 , :2615 , :2616 , :2617 , :2618 , :2619 , :2620 , :2621 , :2622 , :2623 , :2624 , :2625 , :2626 , :2627 , :2628 , :2629 , :2630 , :2631 , :2632 , :2633 , :2634 , :2635 , :2636 , :2637 , :2638 , :2639 , :2640 , :2641 , :2642 , :2643 , :2644 , :2645 , :2646 , :2647 , :2648 , :2649 , :2650 , :2651 , :2652 , :2653 , :2654 , :2655 , :2656 , :2657 , :2658 , :2659 , :2660 , :2661 , :2662 , :2663 , :2664 , :2665 , :266 6 , :2667 , :2668 , :2669 , :2670 , :2671 , :2672 , :2673 , :2674 , :2675 , :2676)) and moneyprovi0_.ELETYPE=:2677 and moneyprovi0_.CHATYPE=:2678
g8023vax021bk	BEGIN :1 := pkg_kf_simple_query.fn_receive_premium_info(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25); END;
gdbq9u4n3mvrk	BEGIN rpt_qt_mp_premiumanlys(1123, last_day(add_months(trunc(sysdate), -1))); END;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• Tablespace IO Stats
• File IO Stats

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File