WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
CDLD	2217133725	cdld1	1	10.2.0.4.0	YES	p780a

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	62075	27-Aug-13 09:00:15	879	87.3
End Snap:	62076	27-Aug-13 10:00:41	1105	94.7
Elapsed:		60.42 (mins)
DB Time:		921.45 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	81,920M	81,920M	Std Block Size:	8K
Shared Pool Size:	20,480M	20,480M	Log Buffer:	276,284K

Load Profile

	Per Second	Per Transaction
Redo size:	2,779,224.86	36,989.28
Logical reads:	461,735.92	6,145.34
Block changes:	18,704.19	248.94
Physical reads:	2,350.76	31.29
Physical writes:	1,328.46	17.68
User calls:	6,388.32	85.02
Parses:	1,248.11	16.61
Hard parses:	140.51	1.87
Sorts:	3,666.10	48.79
Logons:	21.27	0.28
Executes:	29,592.77	393.86
Transactions:	75.14

% Blocks changed per Read:	4.05	Recursive Call %:	83.34
Rollback per transaction %:	55.66	Rows per Sort:	32.66

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.97	Redo NoWait %:	100.00
Buffer Hit %:	99.50	In-memory Sort %:	100.00
Library Hit %:	99.23	Soft Parse %:	88.74
Execute to Parse %:	95.78	Latch Hit %:	99.45
Parse CPU to Parse Elapsd %:	12.39	% Non-Parse CPU:	98.82

Shared Pool Statistics

	Begin	End
Memory Usage %:	87.30	88.26
% SQL with executions>1:	98.50	83.21
% Memory for SQL w/exec>1:	97.56	86.73

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	6,788,865	27,353	4	49.5	User I/O
CPU time		16,906		30.6
SQL*Net break/reset to client	655,993	1,101	2	2.0	Application
read by other session	194,670	629	3	1.1	User I/O
gc buffer busy	348,835	542	2	1.0	Cluster

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	234.14	3.12
Global Cache blocks served:	193.12	2.57
GCS/GES messages received:	1,110.24	14.78
GCS/GES messages sent:	1,851.87	24.65
DBWR Fusion writes:	1.08	0.01
Estd Interconnect traffic (KB)	3,996.68

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

Buffer access - local cache %:	99.44
Buffer access - remote cache %:	0.05
Buffer access - disk %:	0.50

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	1.7
Avg global cache cr block receive time (ms):	0.5
Avg global cache current block receive time (ms):	0.7
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 %:	4.2
Avg global cache cr block flush time (ms):	2.4
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.1
Avg global cache current block flush time (ms):	42.0

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.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	51.70
% of indirect sent messages:	45.42
% of flow controlled messages:	2.87

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): 55286.8s
• 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

No data exists for this section of the report.

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: 1,673,928,924
• Captured SQL account for 60.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 8,522,186
• Captured SQL account for 19.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 107,282,517
• Captured SQL account for 76.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 4,524,778
• Captured SQL account for 38.8% 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
0bawsn4zxmmxs	SELECT a.yae020 as yae020, a.yad081 as yad081, a.yad073 as yad073, a.yad090 as yad090, b.yad007 as yad007, b.yad143 as yad143, a.yad107 as yad107, a.yad035 as yad035, b.yad078 as yad078, a.yad038 as yad038, a.yad006 as yad006, a.yad059 as yad059, a.yad052 as yad052, a.yad034 as yad034, CASE WHEN NVL(b.yad106, 0) >= 0 THEN '1' ELSE '2' END as aad032, b.aad033 as aad033, b.yad132 as yad132, b.yad133 as yad133, b.yad106 as yad106, a.aab191 as aab191, a.yad005 as yad005, a.yad076 as yad076, a.yad008 as yad008, a.aae072 as aae072, a.yad085 as yad085, a.yad113 as yad113, a.yad118 as yad118, a.yad091 as yad091, a.yad111 as yad111, a.yad077 as yad077, a.yad119 as yad119, a.yad114 as yad114, a.yad115 as yad115, a.yad116 as yad116, a.yad117 as yad117, a.aae011 as aae011, a.aae036 as aae036, a.yab003 as yab003 FROM ad11a1 a , ad11a7 b WHERE a.yab003 = :1 AND b.yab003 = :2 AND a.yad034 = :3 AND b.yad034 = :4 AND a.yae020 = b.yae020 AND b.yad078 = :5 AND ((SUBSTR(a.yad034, 3, 3) = '101' AND a.yad059 != '142') OR (SUBSTR(a.yad034, 3, 3) != '101' AND a.yad059 != '142') OR (SUBSTR(a.yad034, 3, 3) != '101' and a.yad059 = '142' and a.aad033 != 0)) AND (( a.aab191<TO_DATE('20070601', 'yyyy-mm-dd')) OR ( a.aab191>=TO_DATE('20070601', 'yyyy-mm-dd') AND (nvl(a.yad132, 1) != '0'OR nvl(a.yad133, 1) != '0')) OR a.yad059='144' ) AND a.aab191 >= :6 AND a.aab191 <= :7 ORDER BY TRUNC(a.aab191, 'DD') , a.aae036 , a.yae020
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0jsdzq8h7w7sn	DELETE yhcip_ad60 WHERE yad608 = :1
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0z45hcav2cpnj	select yab275 from AD53A4 where yae092 = :1
194cr2bar9nxc	SELECT COUNT(1) as value FROM KC74K1 a WHERE a.akb020 = :1 AND 1 = (select count(distinct e.ykd007) from kc74k1 e where e.akc190 = a.akc190 and e.yka103 = a.yka103) AND EXISTS ( SELECT 1 FROM Kb30K4 WHERE akc190 = a.akc190 AND yka103 = a.yka103 AND ykd007 = a.ykd007 AND akb020 = :2 AND yka316 = :3 AND ykb053 = :4 AND ykb037 = :5 AND ykb010 = :6 AND yab138 = :7 AND nvl(yke248, '0') = '1' ) AND ( EXISTS ( SELECT 1 FROM kc72k6 e where e.akc190 = a.akc190 and e.yka103 = a.yka103 and e.yke493 in ('1', '2') union SELECT 1 FROM kc72k7 f where f.akc190 = a.akc190 and f.yka103 = a.yka103 and f.yke493 in ('1', '2') ) or exists ( select 1 from ke20k8 d where d.yke940 = '2' and d.YKE933 = a.akb020 and d.yke953 = '1' and d.yke900 in ('X03', 'X04') and d.aae030 <= a.aae036 and d.aae031 > a.aae036 ) )
19rkm1wsf9axx	insert into WRI$_ALERT_HISTORY (sequence_id, reason_id, owner, object_name, subobject_name, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, resolution, metric_value) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)
1mjd9xp80vuqa	select node, owner, name from syn$ where obj#=:1
1zvcgsyrftw4u	SELECT FB02.AAC003 AS NAME FROM FB02 WHERE FB02.YFB000 IN (SELECT FB01.YFB000 FROM FB01 WHERE FB01.YFB027 = :B2 ) AND FB02.AAC008 = '01' AND YAB003 = :B1 UNION SELECT FB03.AAB004 AS NAME FROM FB03 WHERE FB03.YFB000 IN (SELECT FB01.YFB000 FROM FB01 WHERE FB01.YFB027 = :B2 ) AND FB03.AAC008 = '01' AND YAB003 = :B1
260ggyxcr4xbf	SELECT a.yae051 yae051, a.yae100 yae100, a.yae101 yae101, a.yae103 yae103, a.yae162 yae162, a.yae163 yae163, a.yae114 yae114, a.yae049 yae049, a.aaa831 aaa831, a.yae270 yae270, a.yae315 yae315 FROM (select yae049, yae051, yae100, yae101, yae103, yae162, yae163, yae114, aaa831, yae270, yae315 from ad52 where level = :1 and nvl(yae270, '0')!='1' and (yae162 = '0' or yae162=:2) and yae163='1' start with yae049= (select yae049 from ad52 where yae100 is null) connect by prior yae049=yae100) a, ad54 b where a.yae049 = b.yae106 AND b.yae107 = '100050' AND b.yae093 = :3 union select yae051, yae100, yae101, yae103, yae162, yae163, yae114, yae049, aaa831, yae270, yae315 from ad52 where level = :4 and nvl(yae270, '0')!='1' and (yae162 = '0' or yae162=:5) and yae163='0' start with yae049= (select yae049 from ad52 where yae100 is null) connect by prior yae049=yae100
26n1c5v5mdrwp	INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab158), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
275gymhxpdpzm	UPDATE ad53a4 SET yae361 = '0' , yae362 = 0 WHERE yae092 = :1
2gaw5rszx83h0	SELECT a.yae092 as userId, a.yab109 as departId, a.aac003 as "name" , a.aac004 as sex , a.yab003 as orgId , a.yae041 as loginId, a.yae042 as password, a.yae113 as lastLoginRoleId, a.yae376 as lastLoginDepartId, a.yae378 as leaderId, a.yae361 as locked, a.yae362 as passwordFaultNum, a.yae363 as passwordEditTime, a.yae114 as orderId, a.aae100 as available, a.aae011 as operator, a.aae036 as operateTime, a.yad53g as workMode, a.yae098 as phone, a.yae222 as email, a.aae005 as aae005, a.aae006 as aae006, a.aae007 as aae007, a.yae061 as yae061 FROM ad53a4 a WHERE a.yae041 = :1 AND a.aae100 = :2
2hwxauy2yymjv	SELECT FB02.AAC003 AS NAME FROM FB02 WHERE FB02.YFB000 IN (SELECT FB01.YFB000 FROM FB01 WHERE FB01.YFB027 = :B2 ) AND FB02.AAC008 = '02' AND YAB003=:B1 UNION SELECT FB03.AAB004 AS NAME FROM FB03 WHERE FB03.YFB000 IN (SELECT FB01.YFB000 FROM FB01 WHERE FB01.YFB027 = :B2 ) AND FB03.AAC008 = '02' AND YAB003=:B1
2rau9dc88kngh	UPDATE TMP_AD05COLUMNFILTER SET EXIST = '1' WHERE COLNAME = :B1
2t161650jhd42	BEGIN pkg_P_Comm.prc_P_crtFinancialInterface(:1, :2, :3, :4, :5, :6, :7, :8, :9); END;
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
34njtkggt2way	select * from (select rownum as myrownum, c.* from ( SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae 401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d. yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb53b = :1 AND (a.yhb53c = '01' or a.yhb53c = '02' or a.yhb53c = '03' or a.yhb53c = '04') AND a.aae011 like '%'||:2||'%' AND a.aae036 < TO_DATE(:3, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=10 and myrownum>0
34y4r72q56aqf	UPDATE yhcip_ad60 a SET a.yad605 = sysdate WHERE a.yad608 = :1
35msdrq6f95x1	BEGIN pkg_k_cxmztc_shjs.prc_k_cxmztc_mztccs(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;
367s0wrh1dbmv	BEGIN PKG_C_WORKFLOW.PRC_COMPLETETASK(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); END;
36n0mn04vqu6v	BEGIN pkg_p_jjzj.prc_crtQuidsFinaPlan(:1, :2, :3, :4, :5, :6, :7); END;
36p2gr6241mtz	UPDATE IC01 SET YIC586 = SYSDATE, YIC585 = :B6 WHERE YAE202 = :B5 AND AAC001 = :B4 AND AAE002 = :B3 AND NVL(AAE120, '0') = :B2 AND YIC585 = :B1
39dmujs4s995n	INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.aab214), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
3ffm1jwvzzv2t	INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.aab215), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
3hsnfxapuk9xq	SELECT COUNT(1) FROM NC08N1 WHERE AAE076 = :B1
3kwd49jy7sbdg	SELECT /*+ index(ad04a1 IDX$$_8B7C0001) */ DISTINCT YAD104 FROM AD04A1 WHERE AAD030 = 'nc21' AND YAA016 = :B4 AND YAD052 = :B3 AND YAA011 = :B2 AND YAA012 = :B1 AND YAD141 IS NULL
3mf07mp2t5kg9	select * from sys.all_indexes where table_name = :object_name and table_owner = :object_owner order by index_name
42tf0pb9kx5j2	SELECT b.ahb400 AS ahb400, b.yae113 AS yae113, b.yhb443 AS yhb444, SUM(b.yhb441) AS yhb441, SUM(b.yhb442) AS yhb442, b.yhb446 as yhb446 FROM (SELECT a.ahb400 AS ahb400, a.yae113 AS yae113, to_char(a.yhb443, 'yyyy') AS yhb443, a.yhb441 AS yhb441, a.yhb442 AS yhb442, a.yhb446 as yhb446 FROM hb44 a ) b WHERE 1 = 1 AND b.ahb400 = :1 AND b.yae113 = :2 AND b.yhb443 = :3 AND b.yhb446 = :4 GROUP BY b.ahb400, b.yae113, b.yhb443, b.yhb446
42zjdn5b3pskp	SELECT distinct a.akc190 as akc190, a.yke149 as yke149, a.yka330 as yka330, a.yka103 as yka103 FROM kc74k1 a where a.yka032 = :1 and (a.yke239 = '1' or a.yke239 = '3') and a.ykb037 = :2 and (select sum(b.yka307) from kc74k1 b where b.akc190 = a.akc190 ) > 0 AND ( a.ykc105 = :3 OR a.ykc105 = :4 ) AND a.akb020 = :5 AND a.aae036 >= :6 AND a.aae036 < :7 + 1 group by a.akc190, a.yke149, a.yka330, a.yka103 having sum(a.yka055) > 0
45t5rk1v0wvrg	SELECT AAA103 FROM AA10A1 WHERE AAA100 = :B2 AND AAA102 = :B1
480mk93kaf4ty	SELECT MIN(AAE072) FROM AD12A2 WHERE YAB003 = :B4 AND YAD085 = :B3 AND AAE011 = :B2 AND YAD057 = :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
50adkzqvrrwau	INSERT INTO AC17A1( YAC102, YAC097, AAC001, AAB001, AAE140, YAC101, AAE002, YAC105, AKC023, YAC004, AAA041, YAA017, AKA042, YAC095, AAC123, YAC009, YAC008, YKC176, YAC014, YAC202, YAC017, YAC016, YAC096, YAC114, YAC115, AAC131, YAC099, YAC110, YAC100, AAB191, AAE076, YAB003, AAE011, AAE036) SELECT YAC102, YAC097, AAC001, AAB001, AAE140, YAC101, AAE002, YAC105, AKC023, YAC004, AAA041, YAA017, AKA042, YAC095, AAC123, YAC009, YAC008, YKC176, YAC014, YAC202, YAC017, YAC016, YAC096, YAC114, YAC115, AAC131, YAC099, YAC110, YAC100, :B3 , AAE076, YAB003, AAE011, AAE036 FROM AC17 WHERE AAE076 = :B2 AND AAE140 = :B1
523gqjsz2xgau	UPDATE yhcip_ad60 a SET a.yad605 = sysdate, a.yad606 = (select yae051 from ad52 where yae049 = :1) WHERE a.yad608 = :2
58nu3sw11004g	SELECT a.yhb440 as yhb440, a.ahb400 as ahb400, b.ahb401 as ahb401, a.yae113 as yae113, a.yhb445 as yhb445, a.yhb441 as yhb441, a.yhb442 as yhb442, a.yhb443 as yhb443, a.yhb444 as yhb444, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.yhb446 as yhb446, a.yhb447 as yhb447, a.aae163 as aae163 FROM hb44 a, hb40 b WHERE a.ahb400 = b.ahb400 AND a.ahb400 = :1 AND a.yae113 = :2 AND a.yhb445 = :3 AND a.yhb443 >= TO_DATE(:4, 'yyyy-MM-dd') AND a.yhb443 < TO_DATE(:5, 'yyyy-MM-dd')+1 AND a.yhb446 = :6 order by a.aae036 desc
5d98npqck43hf	SELECT COUNT(1) as value FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d.yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb53b = :1 AND (a.yhb53c = '01' or a.yhb53c = '02' or a.yhb53c = '03' or a.yhb53c = '04') AND a.aae011 like '%'||:2||'%' AND a.aae036 < TO_DATE(:3, 'yyyy-MM-dd')+1
5dvmd55tx7fcf	SELECT YKA103, YKD007, AKC190 FROM( SELECT YKA103, YKD007, AKC190 FROM KC74K1 A WHERE A.AKB020 = :B1 AND 1 = (SELECT COUNT(DISTINCT E.YKD007) FROM KC74K1 E WHERE E.AKC190 = A.AKC190 AND E.YKA103 = A.YKA103) AND EXISTS ( SELECT 1 FROM KB30K4 WHERE AKC190 = A.AKC190 AND YKA103 = A.YKA103 AND YKD007 = A.YKD007 AND AKB020 = :B1 AND YKA316 = :B6 AND YKB053 = :B5 AND YKB037 = :B4 AND YAB138 = :B3 AND YKB010 = :B2 AND NVL(YKE248, '0') = '1' ) AND ( EXISTS ( SELECT 1 FROM KC72K6 E WHERE E.AKC190 = A.AKC190 AND E.YKA103 = A.YKA103 AND E.YKE493 IN ('1', '2') UNION SELECT 1 FROM KC72K7 F WHERE F.AKC190 = A.AKC190 AND F.YKA103 = A.YKA103 AND F.YKE493 IN ('1', '2') ) OR EXISTS ( SELECT 1 FROM KE20K8 D WHERE D.YKE940 = '2' AND D.YKE933 = A.AKB020 AND D.YKE953 = '1' AND D.YKE900 IN ('X03', 'X04') AND D.AAE030 <= A.AAE036 AND D.AAE031 > A.AAE036 ) ) ORDER BY DBMS_RANDOM.VALUE ) WHERE ROWNUM <= :B7
5j31x1u543s8t	insert into tmp_we01(yae051, ywe001, ywe006, tmp000, tmp001, tmp002, tmp003, tmp004, tmp005, tmp006, tmp007, tmp008, tmp009, tmp010, tmp011, tmp012, tmp013, tmp014, tmp015, tmp016, tmp017, tmp018, tmp019, tmp020, tmp021, tmp022, tmp023)select :"SYS_B_0", WC02A1.ywe001, WC02A1.ywe006, :"SYS_B_1", to_char(we01.ywe003, :"SYS_B_2"), WC02A1.AAB001, WC02A1.YWE007, WC02A1.YWE008, WC02A1.AAC001, WC02A1.AAC003, WC02A1.AAC002, WC02A1.AAC013, WC02A1.AAE140, to_char(WC02A1.AAC030, :"SYS_B_3"), to_char(WC02A1.AAC040), WC02A1.YWE010, WC02A1.AAE013, WC02A1.YAB139, to_char(WC02A1.AAE011), to_char(WC02A1.AAE036, :"SYS_B_4"), WC02A1.YAB003, WC02A1.YWE015, to_char(WC02A1.YAE032), to_char(WC02A1.YAE033, :"SYS_B_5"), WC02A1.AAE061, WC02A1.YAC210, WC02A1.AAE150 from WC02A1, we01 where we01.ywe001 = WC02A1.ywe001 AND upper(we01.yae049) = upper(:"SYS_B_6") and WC02A1.aab001 = :"SYS_B_7" and WC02A1.yab139 = :"SYS_B_8" and WC02A1.ywe007 <> :"SYS_B_9"
5kv0g5aamcn4h	INSERT INTO TMP_AD05COLUMNFILTER (COLNAME, EXIST, AD05COLNAME) SELECT :B1 , '1', :B2 FROM DUAL WHERE EXISTS (SELECT * FROM TMP_AD05COLUMNFILTER WHERE COLNAME = :B1 ) AND NOT EXISTS (SELECT * FROM TMP_AD05COLUMNFILTER WHERE COLNAME = :B1 AND AD05COLNAME = :B2 )
5mw0ksn1paxn5	INSERT INTO tmp_ic04i5 ( YAB281, AAE001, AAE041, AAE042, AIC020, AAA042, AAA041, BJ, AIC072, LX, AIC075, HJ, AIC041, YAD110, AIC079, AAA043, AAE013) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
5nmj1gx78v580	BEGIN pkg_N_Approve.pkg_n_RDcx(:1, :2, :3, :4, :5, :6, :7, :8, :9); END;
5p4w0w0hvxgm7	BEGIN pkg_N_Approve.prc_i_RetireRollbackPayment_TF(:1, :2, :3, :4, :5, :6, :7); END;
5z9udzqfgu7x7	SELECT SEQ_A_YAE099.NEXTVAL FROM DUAL
63v12phpwckzq	select * from (select rownum as myrownum, c.* from ( SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae 401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d. yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb53b = :1 AND (a.yhb53c = '05' or a.yhb53c = '06' or a.yhb53c = '07' or a.yhb53c = '09' or a.yhb53c = '08') AND e.trainnum IS NOT NULL AND a.yae429 = :2 AND a.aae011 like '%'||:3||'%' AND a.aae036 < TO_DATE(:4, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=10 and myrownum>0
66k8k4m0dmbmu	BEGIN pkg_P_SSCL.prc_A_AllotBill(:1, :2, :3, :4); END;
67zu7azx7j0dv	select * from (select rownum as myrownum, c.* from ( SELECT a.aae076 as aae076, a.yaa009 as yaa009, a.yad052 as yad052, a.yad060 as yad060, sum(a.yaa007) as yaa007, trunc(a.yad009) as yad009, a.yaa011 as yaa011, a.yaa012 as yaa012, a.yad063 as yad063, a.yad064 as yad064 FROM ad04a1 a WHERE a.yaa012 NOT IN('2', '4') AND a.yaa011 NOT IN('3', '1') AND a.yab003 = :1 AND a.yad052 = :2 AND a.yad060 IN( 'P01' ) AND EXISTS(SELECT 1 FROM ab09 b WHERE b.aae076 = a.aae076 AND b.aab001 = a.yad063 AND b.aae003 >= :3 AND b.aae003 <= :4 ) GROUP BY a.aae076, a.yaa009, a.yad052, a.yad060, trunc(a.yad009), a.yaa011, a.yaa012, a.yad063, a.yad064 ) c)where myrownum<=20 and myrownum>0
689prwbd8yznj	BEGIN pkg_F_Tellership.prc_CrtDailyBalance (:1, :2, :3, :4, :5, :6, :7, :8); END;
6d8mztcnfwgxp	UPDATE TMP_AD05COLUMNFILTER SET EXIST = '0'
6r6g3vwg9p393	select * from (select null table_qualifier, decode (o1.owner, :"SYS_B_00", chr(:"SYS_B_01"), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner, :"SYS_B_02", decode(o1.object_type, :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", o1.object_type), :"SYS_B_07", decode(o1.object_type, :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", o1.object_type), o1.object_type) table_type, null remarks from all_objects o1 where o1.object_type in (:"SYS_B_12", :"SYS_B_13")union select null table_qualifier, decode (o2.owner , :"SYS_B_14", chr(:"SYS_B_15"), o2.owner) table_owner, o2.object_name table_name, :"SYS_B_16" table_type, null remarks from all_objects o2, all_objects o3, all_synonyms s where o2.object_type = :"SYS_B_17" and o3.object_type in (:"SYS_B_18", :"SYS_B_19") and o2.owner = s.owner and o2.object_name = s.synonym_name and s.table_owner = o3.owner and s.table_name = o3.object_name) tables where :"SYS_B_20"=:"SYS_B_21" and table_owner like :"SYS_B_22" escape :"SYS_B_23" and table_name like :"SYS_B_24" escape :"SYS_B_25" order by :"SYS_B_26", :"SYS_B_27", :"SYS_B_28"
6uaz66tj900yn	select * from (select rownum as myrownum, c.* from ( SELECT a.aac001 as aac001, a.aac004 as aac004, a.aac011 as aac011, a.aac005 as aac005, a.yac067 as yac067, a.aac021 as aac021, a.aac008 as aac008, a.aac009 as aac009, a.aac002 as aac002, a.aac003 as aac003, a.aac006 as aac006, a.aac007 as aac007, a.yac066 as yac066, a.aac010 as aac010, a.aac025 as aac025, a.aae004 as aae004, a.aae005 as aae005, a.aae006 as aae006, a.aae007 as aae007, a.yae098 as yae098, a.aae011 as aae011, a.aae036 as aae036, a.yac005 as yac005, a.yae096 as yae096, a.yae222 as yae222, a.aae008 as aae008, a.aae009 as aae009, a.aae010 as aae010, a.yac112 as yac112, a.yae245 as yae245, a.yae246 as yae246, a.yac210 as yac210, a.yac213 as yac213, a.yac214 as yac214 FROM ac01 a order by a.aac006 desc ) c)where myrownum<=20 and myrownum>0
6xf29xtgxg9x7	INSERT INTO yhcip_ad60 ( yad608, yad600, aae017, yae092, yad601, aac003, aae005, yad602, yad604, yad607, yad603, yad605, yad606) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, SYSDATE, SYSDATE, :11)
6xsrw96qcdpuw	BEGIN pkg_F_Note.prc_GetMinNoteId (:1, :2, :3, :4, :5, :6, :7, :8, :9); END;
7745bywu03x0j	BEGIN PKG_I_Finance.PRC_I_CrtJsqd(:1, :2, :3, :4, :5, :6); END;
7h8p5tvjp09db	select * from (select rownum as myrownum, c.* from ( SELECT /*+index (b PK_KC24K2)*/ a.akc190 as akc190, a.yka103 as yka103, a.ykd007 as ykd007, b.aka213 as aka213, a.aka130 as aka130, a.yka032 as yka032, a.aac001 as aac001, a.aac003 as aac003, a.aac004 as aac004, b.yka115 as yka115, b.yka058 as yka058, b.ykc125 as ykc125, (b.yka107 - nvl((select nvl(c.yka248, 0) from kc20kf c where c.akc190 = a.akc190 and rownum = 1), 0)) as yka107, b.yka065 as yka065, a.akb020 as akb020, a.akb021 as akb021, a.akb023 as akb023, a.aka101 as aka101, a.yab139 as yab139, a.aab001 as aab001, a.aab019 as aab019, a.aab020 as aab020, a.yab136 as yab136, a.aab021 as aab021, a.ykc117 as ykc117, a.akc021 as akc021, a.ykc120 as ykc120, a.ykc150 as ykc150, a.yac080 as yac080, (a.yka055 - nvl((select nvl(c.yka055, 0) from kc20kf c where c.akc190 = a.akc190 and rownum = 1), 0)) as yka055, a.yka056 as yka056, (a.yka111 - nvl((select nvl(c.yka055, 0) from kc20kf c where c.akc190 = a.akc190 and rownum = 1), 0)) as yka111, a.yka057 as yka057, a.yka254 as yka254, a.ykc105 as ykc105, (a.ykc148 - nvl((select nvl(c.yka055, 0) from kc20kf c where c.akc190 = a.akc190 and rownum = 1), 0)) as ykc148, a.yka224 as yka224, a.akb063 as akb063, a.ykc173 as ykc173, b.aae073 as aae073, b.ykd002 as ykd002, b.yka222 as yka222, b.yka307 as yka307, b.yka234 as yka234, b.yka308 as yka308, b.yke119 as yke119, b.ykc141 as ykc141, b.aae036 as aae036, '' as ykd001, b.ykb010 as ykb010, (select nvl(sum(c.yka237), 0) from kb09k4 c where c.akc190 = a.akc190 and c.yka103 = a.yka103 and c.aka213 = '0101' ) as yka237, (select nvl(sum(c.yka324), 0) from kb09k4 c where c.akc190 = a.akc190 and c.yka103 = a.yka103 and c.aka213 = '0101' ) as yka324, a.yke239 as yke239, DECODE(b.ykb010, :1, '1', '2') as calsign FROM kc24k1 a, kc24k2 b WHERE a.akc190 = b.akc190 AND a.yka103 = b.yka103 AND a.ykd007 = b.ykd007 AND a.aab001 = :2 AND b.aka213 = :3 AND b.aae036 >= to_date(:4, 'yyyy-mm-dd') AND b.aae036 < to_date(:5, 'yyyy-mm-dd')+1 union SELECT a.akc190 as akc190, a.yka103 as yka103, a.ykd007 as ykd007, a.aka213 as aka213, a.aka130 as aka130, a.yka032 as yka032, a.aac001 as aac001, a.aac003 as aac003, a.aac004 as aac004, a.yka115 as yka115, a.yka058 as yka058, a.ykc125 as ykc125, a.yka107 as yka107, 0 as yka065, a.akb020 as akb020, a.akb021 as akb021, a.akb023 as akb023, a.aka101 as aka101, a.yab139 as yab139, ' ' as aab001, ' ' as aab019, ' ' as aab020, ' ' as yab136, ' ' as aab021, ' ' as ykc117, ' ' as akc021, ' ' as ykc120, ' ' as ykc150, ' ' as yac080, a.yka055 as yka055, a.yka056 as yka056, a.yka111 as yka111, a.yka057 as yka057, a.yka254 as yka254, '' as ykc105, a.ykc148 as ykc148, a.yka224 as yka224, a.akb063 as akb063, ' ' as ykc173, a.aae073 as aae073, ' ' as ykd002, a.yka222 as yka222, a.yka307 as yka307, a.yka234 as yka234, 0 as yka308, a.yke119 as yke119, a.ykc141 as ykc141, a.aae036 as aae036, a.ykd001 as ykd001, a.ykb010 as ykb010, (select nvl(sum(c.yka237), 0) from kb09k4 c where c.akc190 = a.akc190 and c.yka103 = a.yka103 and c.aka213 = '0101' ) as yka237, (select nvl(sum(c.yka324), 0) from kb09k4 c where c.akc190 = a.akc190 and c.yka103 = a.yka103 and c.aka213 = '0101' ) as yka324, a.yke239 as yke239, DECODE(a.ykb010, :6, '1', '2') as calsign FROM kc24k7 a where 1=1 AND EXISTS (select '1' from ac02 where aac001 = a.aac001 and aae140='03' and aab001 = :7 ) AND a.aka213 = :8 AND a.aae036 >= to_date(:9, 'yyyy-mm-dd') AND a.aae036 < to_date(:10, 'yyyy-mm-dd')+1 union SELECT a.akc190 as akc190, a.yka103 as yka103, a.ykd007 as ykd007, a.aka213 as aka213, a.aka130 as aka130, a.yka032 as yka032, a.aac001 as aac001, a.aac003 as aac003, a.aac004 as aac004, a.yka115 as yka115, a.yka058 as yka058, a.ykc125 as ykc125, (a.yka107 - nvl((select nvl(c.yka379, 0) from kc20kf c where c.akc190 = a.akc190 and rownum = 1), 0)) as yka107, 0 as yka065, a.akb020 as akb020, a.akb021 as akb021, a.akb023 as akb023, a.aka101 as aka101, a.yab139 as yab139, ' ' as aab001, ' ' as aab019, ' ' as aab020, ' ' as yab136, ' ' as aab021, ' ' as ykc117, ' ' as akc021, ' ' as ykc120, ' ' as ykc150, ' ' as yac080, (a.yka055 - nvl((select nvl(c.yka055, 0) from kc20kf c where c.akc190 = a.akc190 and rownum = 1), 0)) as yka055, a.yka056 as yka056, (a.yka111 - nvl((select nvl(c.yka055, 0) from kc20kf c where c.akc190 = a.akc190 and rownum = 1), 0)) as yka111, a.yka057 as yka057, a.yka254 as yka254, '' as ykc105, (a.ykc148 - nvl((select nvl(c.yka055, 0) from kc20kf c where c.akc190 = a.akc190 and rownum = 1), 0)) as ykc148, a.yka224 as yka224, a.akb063 as akb063, ' ' as ykc173, a.aae073 as aae073, ' ' as ykd002, a.yka222 as yka222, a.yka307 as yka307, a.yka234 as yka234, 0 as yka308, a.yke119 as yke119, a.ykc141 as ykc141, a.aae036 as aae036, a.ykd001 as ykd001, a.ykb010 as ykb010, (select nvl(sum(c.yka237), 0) from kb09k4 c where c.akc190 = a.akc190 and c.yka103 = a.yka103 and c.aka213 = '0405' ) as yka237, (select nvl(sum(c.yka324), 0) from kb09k4 c where c.akc190 = a.akc190 and c.yka103 = a.yka103 and c.aka213 = '0405' ) as yka324, a.yke239 as yke239, DECODE(a.ykb010, :11, '1', '2') as calsign FROM kc24kb a where 1=1 and a.aka213 = '0405' AND EXISTS (select '1' from ac02 where aac001 = a.aac001 and aae140='03' and aab001 = :12 ) AND a.aka213 = :13 AND a.aae036 >= to_date(:14, 'yyyy-mm-dd') AND a.aae036 < to_date(:15, 'yyyy-mm-dd')+1 ) c)where myrownum<=20 and myrownum>0
827bvj5wj7gd5	select * from (select rownum as myrownum, c.* from ( SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae 401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d. yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb53b = :1 AND (a.yhb53c = '01' or a.yhb53c = '02' or a.yhb53c = '03' or a.yhb53c = '04') AND a.aae017 like :2||'%' AND a.aae036 < TO_DATE(:3, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=10 and myrownum>0
87zh2fkrfr7sk	select null, co.owner, co.table_name, co.column_name, decode(data_type, :"SYS_B_000", :"SYS_B_001", :"SYS_B_002", :"SYS_B_003", :"SYS_B_004", :"SYS_B_005", :"SYS_B_006", -:"SYS_B_007", :"SYS_B_008", -:"SYS_B_009", :"SYS_B_010", :"SYS_B_011", :"SYS_B_012", -:"SYS_B_013", :"SYS_B_014", :"SYS_B_015", :"SYS_B_016", :"SYS_B_017", :"SYS_B_018"), data_type, decode(data_type, :"SYS_B_019", :"SYS_B_020", :"SYS_B_021", :"SYS_B_022", :"SYS_B_023", :"SYS_B_024", :"SYS_B_025", :"SYS_B_026", :"SYS_B_027", :"SYS_B_028", :"SYS_B_029", decode(data_precision, null, decode(data_scale, null, :"SYS_B_030", :"SYS_B_031", :"SYS_B_032", :"SYS_B_033"), data_precision), data_length), decode(data_type, :"SYS_B_034", :"SYS_B_035", :"SYS_B_036", :"SYS_B_037", :"SYS_B_038", decode(data_precision, null, decode(data_scale, null, :"SYS_B_039", :"SYS_B_040", :"SYS_B_041", :"SYS_B_042"), data_precision + :"SYS_B_043"), :"SYS_B_044", :"SYS_B_045", :"SYS_B_046", :"SYS_B_047", data_length), decode(data_type, :"SYS_B_048", :"SYS_B_049", :"SYS_B_050", null, data_scale), decode(data_type, :"SYS_B_051", :"SYS_B_052", :"SYS_B_053", :"SYS_B_054", :"SYS_B_055", :"SYS_B_056", null), decode(nullable, :"SYS_B_057", :"SYS_B_058", :"SYS_B_059", :"SYS_B_060", :"SYS_B_061"), null, co.column_id from all_tab_columns co where :"SYS_B_062"=:"SYS_B_063" and co.owner like :"SYS_B_064" escape :"SYS_B_065" and co.table_name like :"SYS_B_066" escape :"SYS_B_067" union select null, decode (sy.owner, :"SYS_B_068", chr(:"SYS_B_069"), sy.owner), sy.synonym_name, co.column_name, decode(data_type, :"SYS_B_070", :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076", -:"SYS_B_077", :"SYS_B_078", -:"SYS_B_079", :"SYS_B_080", :"SYS_B_081", :"SYS_B_082", -:"SYS_B_083", :"SYS_B_084", :"SYS_B_085", :"SYS_B_086", :"SYS_B_087", :"SYS_B_088"), data_type, decode(data_type, :"SYS_B_089", :"SYS_B_090", :"SYS_B_091", :"SYS_B_092", :"SYS_B_093", :"SYS_B_094", :"SYS_B_095", :"SYS_B_096", :"SYS_B_097", :"SYS_B_098", :"SYS_B_099", decode(data_precision, null, decode(data_scale, null, :"SYS_B_100", :"SYS_B_101", :"SYS_B_102", :"SYS_B_103"), data_precision), data_length), decode(data_type, :"SYS_B_104", :"SYS_B_105", :"SYS_B_106", :"SYS_B_107", :"SYS_B_108", decode(data_precision, null, decode(data_scale, null, :"SYS_B_109", :"SYS_B_110", :"SYS_B_111", :"SYS_B_112"), data_precision + :"SYS_B_113"), :"SYS_B_114", :"SYS_B_115", :"SYS_B_116", :"SYS_B_117", data_length), decode(data_type, :"SYS_B_118", :"SYS_B_119", :"SYS_B_120", null, data_scale), decode(data_type, :"SYS_B_121", :"SYS_B_122", :"SYS_B_123", :"SYS_B_124", :"SYS_B_125", :"SYS_B_126", null), decode(nullable, :"SYS_B_127", :"SYS_B_128", :"SYS_B_129", :"SYS_B_130", :"SYS_B_131"), null, co.column_id from all_tab_columns co, all_synonyms sy where co.owner = sy.table_owne r and co.table_name = sy.table_name and sy.owner like :"SYS_B_132" escape :"SYS_B_133" and sy.synonym_name like :"SYS_B_134" escape :"SYS_B_135" order by :"SYS_B_136", :"SYS_B_137", :"SYS_B_138", :"SYS_B_139"
8d80pyymmudcv	select * from (select rownum as myrownum, c.* from ( SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae 401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d. yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb535 = :1 AND a.yhb53b = :2 AND (a.yhb53c = '05' or a.yhb53c = '06' or a.yhb53c = '07' or a.yhb53c = '09' or a.yhb53c = '08') AND e.trainnum IS NOT NULL AND a.yae429 = :3 AND a.aae011 like '%'||:4||'%' AND a.aae036 < TO_DATE(:5, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=10 and myrownum>0
8gj7mzvy1xy2n	SELECT '??????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct(CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS shwtg FROM Wb02a1 a, we01 b WHERE 1=1 AND a.ywe007 = :1 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :2 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :3) UNION SELECT '???????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct(CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS shwtg FROM Wb02a3 a, we01 b WHERE 1=1 AND a.ywe007 = :4 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :5 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :6) UNION SELECT '????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct( CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS shwtg FROM Wc02a1 a, we01 b WHERE 1=1 AND a.ywe007 = :7 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :8 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :9) UNION SELECT '????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct(CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS shwtg FROM Wc02a2 a, we01 b WHERE 1=1 AND a.ywe007 = :10 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :11 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :12) UNION SELECT '????????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct(CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS s hwtg FROM Wc02a3 a, we01 b WHERE 1=1 AND a.ywe007 = :13 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :14 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :15) UNION SELECT '??????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct(CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS shwtg FROM Wc02a4 a, we01 b WHERE 1=1 AND a.ywe007 = :16 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :17 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :18) UNION SELECT '?????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct(CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS shwtg FROM Wc02a5 a, we01 b WHERE 1=1 AND a.ywe007 = :19 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :20 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :21) UNION SELECT '????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct(CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS shwtg FROM Wc02a6 a, we01 b WHERE 1=1 AND a.ywe007 = :22 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :23 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :24) UNION SELECT '????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct(CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS shwtg FROM Wc02a8 a, we01 b WHERE 1=1 AND a.ywe007 = :25 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :26 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :27) UNION SELECT '????' AS yae049, COUNT(distinct(CASE WHEN a.ywe015 IN ('00', '02') THEN a.aab001 ELSE NUll END)) AS xcl, COUNT(distinct(CASE WHEN a.ywe015 IN ('01') THEN a.aab001 ELSE NUll END)) AS xsh, COUNT(distinct(CASE WHEN a.ywe015 IN ('03') THEN a.aab001 ELSE NUll END)) AS shwtg FROM Wc02a9 a, we01 b WHERE 1=1 AND a.ywe007 = :28 AND a.aab001 = b.aab001 AND a.ywe001 = b.ywe001 AND a.yab139 = :29 AND exists (select 1 from ab02a1 b where b.aab001 = a.aab001 and b.yab004 = :30)
8jwc9b9k6gsqa	INSERT INTO tmp_ad04 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", SUM(NVL(ync058, :"SYS_B_06")), :"SYS_B_07", TO_DATE(:"SYS_B_08", :"SYS_B_09"), v_nc16n1.yab003 FROM v_nc16n1 WHERE v_nc16n1.aae076 = :"SYS_B_10" AND v_nc16n1.ync052=:"SYS_B_11" AND v_nc16n1.yab003 = :"SYS_B_12" AND ync005=:"SYS_B_13" GROUP BY v_nc16n1.yab003
8w0ypxyputwqs	BEGIN pkg_p_report01.prc_p_crtDeptEmpList(:1, :2, :3, :4, :5); END;
8wqj8zn151043	BEGIN pkg_S_COMM.prc_s_main (:1, :2, :3, :4, :5, :6); END;
92kgyt769cwys	INSERT INTO yhcip_ad61 ( yad608, yad600, aae017, yae092, yad601, aac003, aae005, yad602, yad604, yad607, yad603, yad605, yad606, yad611) SELECT yad608, yad600, aae017, yae092, yad601, aac003, aae005, yad602, yad604, yad607, yad603, SYSDATE, yad606, ROUND((SYSDATE - yad603)*24*3600) FROM yhcip_ad60 WHERE yad608 = :1
9ahnfzvqgh1q8	SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d.yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb53b = :1 AND a.yhb53k = :2 AND a.yhb53c = :3 AND e.trainnum IS NOT NULL AND a.yae429 = :4 AND a.aae017 like :5||'%' order by a.aae036 desc
9c2z7xkx0n7t8	INSERT INTO AA82 (AAE820, AAA801, AAE790, AAA821) VALUES (:B2 , 'CC02', :B1 , '1')
9css6bw8u84yt	SELECT a.aaa100 as codeType, a.aaa102 as codeValue, a.aaa101 as codeTypeDESC, a.aaa103 as codeDESC, a.yab003 as orgId, a.aae120 as validFlag FROM aa10a1 a WHERE a.aaa100 = :1 AND a.aaa102 = :2 AND a.yab003 = :3 ORDER BY a.aaa100 , a.aaa102
9nbuw357wuyt4	select * from (select rownum as myrownum, c.* from ( SELECT a.ahc400 as ahc400, a.ahb530 as ahb530, d.yhb440 as yhb440, d.yha430 as yha430, d.aae030 as aae030, d.aae031 as aae031, d.yhb535 as yhb535, d.yhb53b as yhb53b, d.yhb53c as yhb53c, d.yhb534 as yhb534, d.yhb53p as yhb53p, d.ahc40g as ahc40g_cls, d.yae429 as yae429, e.ahb400 as ahb400, e.ahb401 as ahb401, e.yhb407 as yhb407, a.yhc460 as yhc460, a.aac001 as aac001, c.aac002 as aac002, c.aac003 as aac003, c.aac004 as aac004, c.aac006 as aac006, c.aae005 as aae005, c.yae422 as yae422, c.aac026 as aac026, c.aac021 as aac021, c.acc101 as acc101, a.yhc462 as yhc462, a.yac108 as yac108, a.yac109 as yac109, a.yhc584 as yhc584, CASE WHEN YHB53C IN ('05', '06', '07', '08', '09') THEN (CASE WHEN A.YAE107 = '01' THEN '1.00' WHEN A.YAE107 IN ('00', '02', '03', '04') AND A.YHC584 IS NOT NULL THEN '0.80' WHEN A.YHB53D / 1 = 0 THEN '0.00' WHEN A.YHC40V IS NOT NULL THEN TO_CHAR(A.YHC40V/100, '0.00') ELSE '0.60' END) ELSE NULL END AS bili, a.yhc40v as yhc40v, a.yhb53d as yhb53d, a.yhc561 as yhc561, a.yhb53e as yhb53e, a.yae107 as yae107, a.yhc401 as yhc401, a.yhc402 as yhc402, a.ahc40g as ahc40g, a.yhc409 as yhc409, a.yhc403 as yhc403, a.yhc405 as yhc405, a.ahc40h as ahc40h, a.aae043 as aae043, a.yhc407 as yhc407, a.yhc408 as yhc408, a.yhc406 as yhc406, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae416 as yae416, a.yae423 as yae423, a.yae412 as yae412, a.yae415 as yae415, a.yae417 as yae417, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.yhc40j as yhc40j, a.yhc40k as yhc40k, a.yhc40l as yhc40l, a.yhc40m as yhc40m, a.yhc40n as yhc40n, a.yhc40o as yhc40o, a.yhc40p as yhc40p, a.yhc40q as yhc40q, a.aab300 as aab300, a.aje080 as aje080, a.aab001 as aab001, a.yhc40r as yhc40r, a.yhc40s as yhc40s, a .yhc40t as yhc40t, a.yhc40u as yhc40u, a.yae102 as yae102, a.yhc40w as yhc40w, a.yhc40x as yhc40x, a.yhc40y as yhc40y, a.aae163 as aae163 FROM hc40 a, ac01 c, hb53 d, hb40 e WHERE a.aac001 = c.aac001 AND a.ahb530 = d.ahb530 AND d.ahb400 = e.ahb400 AND d.yhb535 = :1 AND d.yhb53b = :2 AND d.yae429 = :3 AND d.ahc40g = :4 AND (d.yhb53c <> '01' and d.yhb53c <> '02') AND a.aae011 like '%'||:5||'%' AND a.aae017 like :6||'%' AND a.aae036 < TO_DATE(:7, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=60 and myrownum>0
9rjy1dsu6a4qx	SELECT a.aae076 as aae076, sum(a.yka156) as yka156 from kc32k3 a where exists (select 1 from kb03kd b where b.akb020 = :1 and b.ykb010 = :2 and b.yab138 = :3 and b.aae075 = a.aae075 union select 1 from kb11ke b where b.akb020 = :4 and b.ykb010 = :5 and b.yab138 = :6 and b.aae075 = a.aae075 ) and a.yad060 in ('K38', 'K37') group by a.aae076
9t8hdsbdh5twh	INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab160), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
9v53122v2dxza	select distinct (to_char(to_date(sdate, 'yyyymmdd'), 'YYYY') || '?' || to_char(to_date(sdate, 'yyyymmdd'), 'mm') || '?' || to_char(to_date(sdate, 'yyyymmdd'), 'dd') || '?' )as sdate, s, f_getnotice(b.sdate, b.s, b.cnum, :1) as con, decode(b.cnum, 1, '???', 2, '???', 3, '???', 4, '???', 5, '???', 6, '???') as th, TO_CHAR(TO_DATE(sdate, 'YYYYMMDD'), 'DAY') as week, cnum from fb_dateweek b where sdate = to_char(trunc(to_date(substr(f_getQuerySartDateByCurDate(''), 0, 8), 'yyyy-mm-dd')+:2), 'yyyymmdd') order by sdate, s, cnum
ayf1s8qhtkgsc	INSERT INTO IC35I1(YAE099, YAE652, AAC001, AAC002, AAC003, YIC075, AAE011, AAE036, YAB003, AAB034, AAE013, AAE120, YAE403, YAE425, YAC146 ) VALUES(:B10 , '01', :B9 , :B8 , :B7 , :B6 , :B2 , :B3 , :B1 , :B5 , :B4 , '0', :B3 , :B2 , :B1 )
b058ymxj1rvkg	SELECT sql_id, sql_text from v$sql WHERE sql_id in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
bd4bznqbq73hk	select bo#, intcol# from icoldep$ where obj#=:1
btcy8gwhm5r5u	SELECT a.aae017 as aae017, a.yab110 as yab110, a.aae043_real as aae043_real, a.aae043 as aae043, a.acb200 as acb200, a.acb210 as acb210, a.aab004 as aab004, a.acb206 as acb206, a.aae005 as aae005, a.aca111 as aca111, a.aca112 as aca112, a.yca111 as yca111, a.acb21d as acb21d, a.acb21e as acb21e, a.acb21f as acb21f, a.personall as personall, a.aac011_real as aac011_real, a.aac011 as aac011, a.ycb212_real as ycb212_real, a.ycb212 as ycb212, a.acb21h_real as acb21h_real, a.acb21h as acb21h, a.acb217_real as acb217_real, a.acb217 as acb217, a.ycb21d_real as ycb21d_real, a.ycb21d as ycb21d, a.ycb213_real as ycb213_real, a.ycb213 as ycb213, a.ycb21c_real as ycb21c_real, a.ycb21c as ycb21c, a.age_min as age_min, a.age_max as age_max, a.age_between as age_between, a.ytjrs as ytjrs , a.ycgrs as ycgrs , a.yxkqs as yxkqs , a.yxjzrq_real as yxjzrq_real, a.yxjzrq as yxjzrq, a.jbsj_real as jbsj_real, a.jbsj as jbsj, a.xxlx_real as xxlx_real, a.xxl x as xxlx, a.aae005_d as aae005_d FROM cb20_viw a WHERE 1=1 AND aae017 like '51010002'||'%'
c1hphn9z0jt78	SELECT * FROM ad53a4 WHERE yae092 = :1 AND aae100 = '1'
c213cg9humu1t	SELECT c.yae093 as roleId, c.yab109 as departId, c.aae100 as available, c.aae011 as operator, c.aae036 as operateTime FROM ad53a4 a, ad53a6 b , ad53a7 c WHERE a.yae092 = b.yae092 AND b.yae093 = c.yae093 AND b.yab109 = c.yab109 AND a.yae092 = :1 AND b.yae092 = :2 AND a.aae100 = :3 AND c.aae100 = :4 UNION SELECT d.yae374 as roleId, d.yab109 as departId, d.aae100 as available, d.aae011 as operator, d.aae036 as operateTime FROM ad53a4 a, ad53a6 b , ad53a7 c, ad53a3 d, ad53a4 e WHERE a.yae092 = b.yae092 AND b.yae093 = c.yae093 AND d.yae093 = c.yae093 AND b.yae093 = d.yae093 AND b.yab109 = c.yab109 AND d.yab109 = c.yab109 AND b.yab109 = d.yab109 AND d.yae375 = a.yae092 AND d.yae092 = e.yae092 AND e.yae092 = :5 AND d.yae092 = :6 AND a.aae100 = :7 AND c.aae100 = :8 AND d.aae100 = :9 AND e.aae100 = :10 AND ( d.aae030 IS NULL OR TRUNC(d.aae030, 'DD') <= :11 ) AND ( d.aae031 IS NULL OR TRUNC(d.aae031 + 1, 'DD') > :12 )
c2hwmr4rkas2k	select a.aab001 as aab001, a.aab004 as aab004, a.aab003 as aab003, a.aab013 as aab013, a.aae013 as aae013, b.cbrs as cbrs , b.cbrs_01 as cbrs_01 , b.cbrs_02 as cbrs_02 , b.cbrs_03_zz as cbrs_03_zz , b.cbrs_03_tx as cbrs_03_tx , b.cbrs_03_lx as cbrs_03_lx , b.cbrs_03_qt as cbrs_03_qt , b.cbrs_04 as cbrs_04 , b.cbrs_05 as cbrs_05 , b.cbrs_41_zz as cbrs_41_zz , b.cbrs_41_tx as cbrs_41_tx , b.cbrs_41_lx as cbrs_41_lx , b.cbrs_41_qt as cbrs_41_qt from (select aab001 as aab001, aab004 as aab004, aab003 as aab003, aab013 as aab013, aae013 as aae013 from ab01 where 1 = 1 and aab001 in (select aab001 from ab02a1 where yab004 >= :1 and yab004 <= :2 and yab003 = :3 ) ) a, (select c.aab001 as aab001, count(distinct c.aac001 ) as cbrs , sum(case when c.aae140 = '01' then 1 else 0 end ) as cbrs_01 , sum(case when c.aae140 = '02' then 1 else 0 end ) as cbrs_02 , sum(case when c.aae140 = '03' and d.akc021 = '11' then 1 else 0 end ) as cbrs_03_zz , sum(case when c.aae140 = '03' and d.akc021 in ('21', '23', '24') then 1 else 0 end ) as cbrs_03_tx , sum(case when c.aae140 = '03' and d.akc021 in ('31') then 1 else 0 end ) as cbrs_03_lx , sum(case when c.aae140 = '03' and d.akc021 not in ('31', '21', '23', '24', '11') then 1 else 0 end ) as cbrs_03_qt , sum(case when c.aae140 = '04' then 1 else 0 end ) as cbrs_04 , sum(case when c.aae140 = '05' then 1 else 0 end ) as cbrs_05 , sum(case when c.aae140 = '41' and d.akc021 = '11' then 1 else 0 end ) as cbrs_41_zz , sum(case when c.aae140 = '41' and d.akc021 in ('21', '23', '24') then 1 else 0 end ) as cbrs_41_tx , sum(case when c.aae140 = '41' and d.akc021 in ('31') then 1 else 0 end ) as cbrs_41_lx , sum(case when c.aae140 = '41' and d.akc021 not in ('31', '21', '23', '24', '11') then 1 else 0 end ) as cbrs_41_qt from ac02 c , kc01 d where c.aac031 = '1' and c .aac001 = d.aac001 (+) and c.aab001 in (select aab001 from ab02a1 where yab004 >= :4 and yab004 <= :5 and yab003 = :6 ) and c.yab003 = :7 and c.yab003 = d.yab003 group by c.aab001 ) b where a.aab001 = b.aab001 order by a.aab001
c6stav6grpfqv	select * from (select rownum as myrownum, c.* from ( SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae 401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d. yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb53b = :1 AND (a.yhb53c = '01' or a.yhb53c = '02' or a.yhb53c = '03' or a.yhb53c = '04') AND a.aae017 like :2||'%' AND a.aae036 >= TO_DATE(:3, 'yyyy-MM-dd') AND a.aae036 < TO_DATE(:4, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=10 and myrownum>0
c80buqvjzuqc9	SELECT NVL(SUM(AJC070), 0) FROM JC13 WHERE AJE080 = :B1 AND AJA002 = '102' AND AJE081 = (SELECT MIN(AJE081) FROM JC13 WHERE AJE080 = :B1 AND AJC098 > 0)
cf8fyu7n9yc27	select * from sys.all_objects where object_type = :object_type and owner = :object_owner and object_name = :object_name and :sub_object is null
cfbd91skrtfhn	INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.aab213), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
ch3fs7uy0cfsv	BEGIN pkg_W_comm.prc_w_main(:1, :2, :3, :4, :5, :6); END;
ck0anvagmvwda	INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab157), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
ck45pb7dq63qp	SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d.yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.ahb5 30 = :1
cvnxmz8vjqrcq	SELECT aaa100 as codeType, aaa102 as codeValue, aaa101 as codeTypeDESC, aaa103 as codeDESC, yab003 as orgId, aae120 as validFlag FROM aa10a1 ORDER BY aaa100 , aaa102
cyab8kbu800kn	BEGIN PKG_K_PAYMENT.PRC_K_ACCEPT(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10); END;
d3vdgnnm2x4f7	SELECT O.OBJECT_TYPE, O.OWNER, O.OBJECT_NAME FROM SYS.ALL_OBJECTS O WHERE O.OWNER = :B2 AND O.OBJECT_NAME = :B1 AND OBJECT_TYPE IN ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') AND ROWNUM = 1
d5j4sv2waq4nd	SELECT count(aac001) from (SELECT a.aac001 as aac001 FROM ic01i1 a WHERE a.aac001 = :1 AND a.aae143 ='1' AND a.aae076 is null AND not exists ( select 1 from ic01i2 b where a.aac001 = b.aac001 and a.aae002 = b.aae002 and a.aab001 = b.aab001 ) AND a.aae002 <= :2 AND a.yab003 = :3 UNION SELECT a.aac001 as aac001 FROM jc01j1 a WHERE a.aac001 = :4 AND a.aae143 ='1' AND a.aae076 is null AND not exists ( select 1 from jc01j2 b where a.aac001 = b.aac001 and a.aae002 = b.aae002 and a.aab001 = b.aab001 ) AND a.aae002 <= :5 AND a.yab003 = :6 UNION SELECT a.aac001 as aac001 FROM kc03k1 a WHERE a.aac001 = :7 AND a.aae143 ='1' AND a.aae076 is null AND not exists ( select 1 from kc03k2 b where a.aac001 = b.aac001 and a.aae002 = b.aae002 and a.aab001 = b.aab001 ) AND a.aae002 <= :8 AND a.yab003 = :9 UNION SELECT a.aac001 as aac001 FROM lc10l1 a WHERE a.aac001 = :10 AND a.aab001 = :11 AND a.aae143 ='1' AND a.aae076 is null AND not exists ( select 1 from lc10l2 b where a.aac001 = b.aac001 and a.aae002 = b.aae002 and a.aab001 = b.aab001 ) AND a.aae002 <= :12 AND a.yab003 = :13 UNION SELECT a.aac001 as aac001 FROM mc09m1 a WHERE a.aac001 = :14 AND a.aae143 ='1' AND a.aae076 is null AND not exists ( select 1 from mc09m2 b where a.aac001 = b.aac001 and a.aae002 = b.aae002 and a.aab001 = b.aab001 ) AND a.aae002 <= :15 AND a.yab003 = :16 UNION SELECT a.aac001 as aac001 FROM kc82k1 a WHERE a.aac001 = :17 AND a.aae143 ='1' AND a.aae076 is null AND a.aae001 IS NULL AND a.aab034 IS NULL AND not exists ( select 1 from kc82k2 b where a.aac001 = b.aac001 and a.aae002 = b.aae002 and a.aab001 = b.aab001 ) AND a.aae002 <= :18 AND a.yab003 = :19 UNION SELECT a.aac001 as aac001 FROM ic65i1 a WHERE a.aac001 = :20 AND a.aae143 ='1' AND a.aae076 is null AND not exists ( select 1 from ic65i2 b where a.aac001 = b.aac001 and a.aae002 = b.aae002 and a.aab001 = b.aab001 ) AND a.aae002 <= :21 AND a.yab003 = :22 )
dk0w6y0bdwxbv	SELECT SUM(AJC051) FROM JC10 WHERE AAC001 = :B1
dnuasfch7q0up	SELECT a.yab003 as yab003, a.yac146 as yac146 FROM ac34 a WHERE a.yac146 = :1
dp9qnuvv40ft9	SELECT * FROM "KE13K1"
dtb0h253k5trk	SELECT c.yae093 as roleId, c.yab109 as departId, c.aae100 as available, c.aae011 as operator, c.aae036 as operateTime FROM ad53a4 a, ad53a6 b , ad53a7 c WHERE a.yae092 = b.yae092 AND b.yae093 = c.yae093 AND b.yab109 = c.yab109 AND b.yae093 = :1 AND c.yae093 = :2 AND b.yab109 = :3 AND c.yab109 = :4 AND a.yae092 = :5 AND b.yae092 = :6 AND a.aae100 = :7 AND c.aae100 = :8
f0n9c5a21u851	SELECT COUNT(1) FROM KC74K1 A WHERE A.AKB020 = :B1 AND 1 = (SELECT COUNT(DISTINCT E.YKD007) FROM KC74K1 E WHERE E.AKC190 = A.AKC190 AND E.YKA103 = A.YKA103) AND EXISTS ( SELECT 1 FROM KB30K4 WHERE AKC190 = A.AKC190 AND YKA103 = A.YKA103 AND YKD007 = A.YKD007 AND AKB020 = :B1 AND YKA316 = :B6 AND YKB053 = :B5 AND YKB037 = :B4 AND YKB010 = :B3 AND YAB138 = :B2 ) AND ( EXISTS ( SELECT 1 FROM KC72K6 E WHERE E.AKC190 = A.AKC190 AND E.YKA103 = A.YKA103 AND E.YKE493 IN ('1', '2') UNION SELECT 1 FROM KC72K7 F WHERE F.AKC190 = A.AKC190 AND F.YKA103 = A.YKA103 AND F.YKE493 IN ('1', '2') ) OR EXISTS ( SELECT 1 FROM KE20K8 D WHERE D.YKE940 = '2' AND D.YKE933 = A.AKB020 AND D.YKE953 = '1' AND D.YKE900 IN ('X03', 'X04') AND D.AAE030 <= A.AAE036 AND D.AAE031 > A.AAE036 ) )
fajgr1jkq71kd	INSERT INTO YH01_ZYLL ( AAC001 ) VALUES ( :"SYS_B_0" )
fhw6psnfb8g61	select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner, 'SYS', decode(o1.object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', o1.object_type), 'SYSTEM', decode(o1.object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', o1.object_type), o1.object_type) table_type, null remarks from all_objects o1 where o1.object_type in ('TABLE', 'VIEW')union select null table_qualifier, decode (o2.owner , 'PUBLIC', chr(0), o2.owner) table_owner, o2.object_name table_name, 'SYNONYM' table_type, null remarks from all_objects o2, all_objects o3, all_synonyms s where o2.object_type = 'SYNONYM' and o3.object_type in ('TABLE', 'VIEW') and o2.owner = s.owner and o2.object_name = s.synonym_name and s.table_owner = o3.owner and s.table_name = o3.object_name) tables where 1=1 and table_owner like 'CDSI2' escape '\' and table_name like 'KB01' escape '\' order by 4, 2, 3
fnj6cnubp1sau	begin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end;
fpqbpgdtsnja5	BEGIN pkg_W_comm.prc_w_Query(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15); END;
fqmpmkfr6pqyk	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) 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')
fyr0h959fmf93	BEGIN pkg_K_TJ.prc_k_TJ1(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;
gav6pch9hqa72	INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.aab212), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
ggfwbdmnaqr30	SELECT UPPER(A.COLUMN_NAME) COLNAME, UPPER(A.DATA_TYPE) DATATYPE, B.COMMENTS COMMENTS FROM ALL_TAB_COLS A, ALL_COL_COMMENTS B WHERE A.OWNER = B.OWNER AND A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME AND A.TABLE_NAME = :B1 ORDER BY A.COLUMN_ID
gj2dg4jc2x3fq	select 99 / 100, 1 - to_number(to_char(to_date('1997-11-02', 'yyyy-mm-dd'), 'D')), '00.00.0000 '||banner from v$version where banner like 'Oracle%'
grwydz59pu6mc	select text from view$ where rowid=:1
gt99a8nm62p38	INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab159), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003

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