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:	62269	04-Sep-13 11:00:23	1485	80.7
End Snap:	62270	04-Sep-13 12:00:03	1139	89.4
Elapsed:		59.66 (mins)
DB Time:		1,838.69 (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:	3,556,993.35	71,176.29
Logical reads:	380,433.65	7,612.57
Block changes:	20,500.03	410.21
Physical reads:	5,809.95	116.26
Physical writes:	974.75	19.50
User calls:	3,870.12	77.44
Parses:	818.09	16.37
Hard parses:	48.37	0.97
Sorts:	14,352.78	287.20
Logons:	14.45	0.29
Executes:	30,004.14	600.39
Transactions:	49.97

% Blocks changed per Read:	5.39	Recursive Call %:	89.31
Rollback per transaction %:	55.06	Rows per Sort:	5.98

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.98	Redo NoWait %:	99.05
Buffer Hit %:	98.50	In-memory Sort %:	100.00
Library Hit %:	99.63	Soft Parse %:	94.09
Execute to Parse %:	97.27	Latch Hit %:	99.85
Parse CPU to Parse Elapsd %:	27.86	% Non-Parse CPU:	99.07

Shared Pool Statistics

	Begin	End
Memory Usage %:	88.40	88.39
% SQL with executions>1:	91.44	93.05
% Memory for SQL w/exec>1:	91.80	93.39

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
log file switch completion	39,783	37,975	955	34.4	Configuration
buffer busy waits	43,024	25,306	588	22.9	Concurrency
db file sequential read	5,444,579	19,864	4	18.0	User I/O
CPU time		13,127		11.9
enq: SQ - contention	1,355	3,060	2,258	2.8	Configuration

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	108.73	2.18
Global Cache blocks served:	567.95	11.36
GCS/GES messages received:	1,137.45	22.76
GCS/GES messages sent:	1,117.33	22.36
DBWR Fusion writes:	5.27	0.11
Estd Interconnect traffic (KB)	5,853.80

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

Buffer access - local cache %:	98.47
Buffer access - remote cache %:	0.03
Buffer access - disk %:	1.50

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.4
Avg global cache cr block receive time (ms):	4.2
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.0
Avg global cache cr block flush time (ms):	2.7
Avg global cache current block pin time (ms):	0.7
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.3
Avg global cache current block flush time (ms):	28.7

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:	45.71
% of indirect sent messages:	47.46
% of flow controlled messages:	6.83

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): 110321.1s
• 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,361,842,901
• Captured SQL account for 50.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 20,797,964
• Captured SQL account for 53.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 107,406,183
• Captured SQL account for 75.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 2,928,535
• Captured SQL account for 41.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
05zkqm2f44kwp	UPDATE hb44 SET ahb400 = :1, yae113 = :2, yhb445 = :3, yhb441 = :4, yhb442 = :5, yhb443 = :6, yhb444 = :7, aae013 = :8, yhb446 = :9, aae163 = SYSDATE WHERE 1 = 1 AND yhb440 = :10
0c7v7xznduhu2	SELECT YKA055, YKA056, YKA057, YKA111, YKA107, YKA054 FROM YH00_KC24K2_2013_08 WHERE AKC190 = :B4 AND YKA103 = :B3 AND YKD007 = :B2 AND AKA213 = :B1
0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
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
0mtvc3f6f7020	select distinct b.yka316 as yka316, b.ykb037 as ykb037, b.ykc179 as ykc179, b.yke150 as yke150, b.aae030 as aae030, b.yke151 as yke151, (select sum(nvl(count(1), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1' group by c.akc190, c.yka103 having sum(c.yka107) + sum(c.yka065) > 0) as ykb009, (case when b.yke239 = '1' then (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') + (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) else (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') end) as yka107, (select nvl(sum(nvl(c.yka065, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') as yka065, (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb03 7 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) as bckkje, (case when b.yke239 = '1' then (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') + (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) else (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c. ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') end) - (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) as sjbfje, (select sum(nvl(count(1), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') in ('0', '2') group by c.akc190, c.yka103 having sum(c.yka065) + sum(c.yka107) >= 0) as bcbyzfrc, (select sum(nvl(sum(nvl(c.yka107, 0)), 0) + nvl(sum(nvl(c.yka065, 0)), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') in ('0', '2') group by c.akc190, c.yka103 having sum(c.yka065) + sum(c.yka107) >= 0) as bcbyzf, b.ykb053 as ykb053, b.akb020 as akb020, b.yab138 as yab138, b.ykb010 as ykb010, b.yka108 as yka108, a.yka032 as yka032, a.aae011 as aae011, a.aae036 as aae036, a.yab003 as yab003, a.ykc151 as ykc151, a.ykc152 as ykc152, a.ykb048 as ykb048, a.ykc153 as ykc153, a.ykc154 as ykc154, a.ykb049 as ykb049, a.yke097 as yke097, c.aae036 as yke058, a.yab141 as yab141, a.yke032 as yke032 from kc32k1 c, kb03k4 d, kb12k3 b, kb12k1 a WHERE a.akb020 = b.akb020 and a.ykb010 = b.ykb010 and a.yab138 = b.yab138 and d.ykb010 = a.ykb010 and d.aae075 = c.aae075 and b.ykb010 is not null and b.yab138 = :1 AND b.YKA108 = :2 AND b.AKB020 = :3 AND b.yka316 = :4 AND b.AKB020 in (select akb020 from kb01 where akb021 like :5||'%') order by yke05 8
0z45hcav2cpnj	select yab275 from AD53A4 where yae092 = :1
10xj8nynmpqtq	SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
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
25zfuwp9m97dn	BEGIN PKG_K_RECKONING.PRC_K_RECKONINGBYDETAIL(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;
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
298ppdduqr7wm	SELECT status FROM sys.wri$_adv_tasks WHERE id = :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
30brq42k0vk3k	SELECT count(1) FROM (SELECT a.yic052 as yic052, a.aac001 as aac001, b.aac003 as aac003, a.aae003 as aae003, a.aab001 as aab001, a.aae117 as aae117, sum(case when a.yae104 ='1' then (case when a.yic570 in ('011', '012', '013', '014', '015', '016', '017', '018', '019') then a.aic142 else 0 end ) else 0 end) as jbylj, sum(case when a.yae104 ='1' then (case when a.yic570 in ('101', '105') then a.aic142 else 0 end ) else 0 end) as gghlf, sum(case when a.yae104 ='1' then (case when a.yic570 not in ('011', '012', '013', '014', '015', '016', '017', '018', '019', '101', '105') then a.aic142 else 0 end ) else 0 end) as qtdy, sum(case when a.yae104 ='2' then a.aic142 else 0 end ) as bfylj, sum(case when a.yae104 ='7' then a.aic142 else 0 end ) as zfsbjzbf, sum(case when a.yae104 ='3' then -a.aic142 else 0 end ) as tfylj, sum(case when a.yae104 ='5' then a.aic142 else 0 end ) as tzbfylj, sum(decode(a.yae104, '3', -a.aic142, a.aic142)) as dyhj, a.yab003 as yab003 FROM v_ic14_ic14i1 a, ac01 b where a. aac001 = b.aac001 AND a.yae104 != '4' AND a.aae003 >= :1 AND a.aae003 <= :2 group by a.yic052, a.aac001, b.aac003, a.aae003, a.aab001, a.aae117, a.yab003 )
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
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
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
45t5rk1v0wvrg	SELECT AAA103 FROM AA10A1 WHERE AAA100 = :B2 AND AAA102 = :B1
4h3tnm388am71	UPDATE ad53a5 SET yae361 = null, yae362 = null, yae363 = null WHERE yae092 = :1
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4xb35u6kuxysv	SELECT "A1"."AKC190", "A1"."YKA103", "A1"."YKD007", "A1"."AAC001", "A1"."YAB139", "A1"."YAC005", "A1"."AAB001", "A1"."AKC021", "A1"."AKA130", "A1"."YKA032", "A1"."AKB020", "A1"."AKB021", "A1"."YKB006", "A1"."AKC266", "A1"."YKA107", "A1"."YKA065", "A1"."YKE291", "A1"."AAE011", "A1"."YKC141", "A1"."AAE036", "A1"."YAB003", "A1"."YKE293", "A1"."YKE292", "A1"."YKE294" FROM "KE13K1" "A1"
523gqjsz2xgau	UPDATE yhcip_ad60 a SET a.yad605 = sysdate, a.yad606 = (select yae051 from ad52 where yae049 = :1) WHERE a.yad608 = :2
58h5tztfjz526	SELECT AKC190, YKA103, YKD007, AKA130, YKC117, YKA032, AAC001, AAB001, AAB019, AAB020, YAB136, AAB021, AAC003, AAC004, AAC006, AKC023, YKC021, AKC021, YKC120, YKC150, YAC080, AKB020, AKB021, YKB006, AKB023, AKA101, AKA123, YKA026, YKA093, AAE013, YKE098, YAB139, YKA055, YKA056, YKA111, YKA057, NVL(YKA254, 0), NVL(YKC148, 0), NVL(YKA224, 0), AKB063, YKC173, YKC156, AKC025, NVL(YKA346, 0), NVL(YKA347, 0) FROM KC24K1 WHERE AKC190 = :B3 AND YKA103 = :B2 AND YKD007 = :B1
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
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)
5zjb0kz6wvuf0	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 UNION SELECT a.aac001 as aac001 FROM ic01 a WHERE a.aac001 = :23 AND a.aae002 > :24 AND a.yab003 = :25 UNION SELECT a.aac001 as aac001 FROM jc01 a WHERE a.aac001 = :26 AND a.aae002 > :27 AND a.yab003 = :28 UNION SELECT a.aac001 as aac001 FROM kc03 a WHERE a.aac001 = :29 AND a.aae002 > :30 AND a.yab003 = :31 UNION SELECT a.aac001 as aac001 FROM lc10 a WHERE a.aac001 = :32 AND a.aab001 = :33 AND a.aae002 > :34 AND a.yab003 = :35 UNION SELECT a.aac001 as aac001 FROM mc09 a WHERE a.aac001 = :36 AND a.aae002 > :37 AND a.yab003 = :38 UNION SELECT a.aac001 as aac001 FROM kc82 a WHERE a.aac001 = :39 AND a.aae001 IS NULL AND a.aab034 IS NULL AND a.aae002 > :40 AND a.yab003 = :41 UNION SELECT a.aac001 as aac001 FROM ic65 a WHERE a.aac001 = :42 AND a.aae002 > :43 AND a.yab003 = :44 )
66k8k4m0dmbmu	BEGIN pkg_P_SSCL.prc_A_AllotBill(:1, :2, :3, :4); 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"
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)
7fwhxcnh0wjth	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.ak c190 = b.akc190 AND a.yka103 = b.yka103 AND a.ykd007 = b.ykd007 AND a.aka130 = :2 AND b.aka130 = :3 AND b.aka213 = :4 AND b.akc190 = :5 AND b.yka103 = :6 AND b.ykd007 = :7 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, :8, '1', '2') as calsign FROM kc24k7 a where 1=1 AND a.aka130 = :9 AND a.akc190 = :10 AND a.yka103 = :11 AND a.ykd007 = :12 AND a.aka213 = :13 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, :14, '1', '2') as calsign FROM kc24kb a where 1=1 and a.aka213 = '0405' AND a.aka130 = :15 AND a.akc190 = :16 AND a.yka103 = :17 AND a.ykd007 = :18 AND a.aka213 = :19
7jthtfsjy2ryk	select O.name objname, O.type# objtype, U.name objowner, L2.* from (select /*+ ordered */ S.inst_id, S.sid, S.serial#, nvl(S.sql_id, 0) , DECODE(L.type, 'TM', L.id1, 'TX', decode(L.request, 0, NVL(LO.object_id, -1), S.row_wait_obj#), -1) AS object_id , S.username, S.row_wait_obj#, S.row_wait_block# , S.row_wait_row#, S.row_wait_file#, L.type , decode(L.lmode, 0, 'NONE', 1, 'NULL', 2, 'ROW SHARE', 3, 'ROW EXCLUSIVE', 4, 'SHARE', 5, 'SHARE ROW EXCLUSIVE', 6, 'EXCLUSIVE', '?') , decode(L.request, 0, 'NONE', 1, 'NULL', 2, 'ROW SHARE', 3, 'ROW EXCLUSIVE', 4, 'SHARE', 5, 'SHARE ROW EXCLUSIVE', 6, 'EXCLUSIVE', '?') , L.id1, L.id2, L.ctime , P.spid, S.sql_hash_value from gv$lock L, gv$session S, gv$process P, (select object_id, session_id, xidsqn from gv$locked_object where xidsqn >0) LO where L.inst_id = S.inst_id and S.inst_id=p.inst_id and S.sid = L.sid and P.addr = S.paddr and L.sid = LO.session_id(+) and L.id2 = LO.xidsqn(+) ) L2 , sys.obj$ O , sys.user$ U where O.obj#(+) = L2.object_id and O.owner# = U.user#(+)
7t09dnfxtqcw8	INSERT INTO AA79 (AAE790, YAB003, YAE049, AAC001, AAB001, AJE080, YLC001, YMC001, AAE002, AAE140, YIC052, AAE074, AAE036, AAE011, AAA792, AAA831, AAA101, AAA795, AAA796) VALUES (:B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, :B4 , '?', :B3 , NULL, :B2 , :B1 )
7t6ywavd6pfvm	select count(1) from ic10 a, ic14 b, ad04a1 c where a.aac001 = b.aac001 and b.aae076 = c.aae076 and a.aac001 = c.yad063 and a.yic635 = b.aae003 and nvl(a.aae116, ' ') = '1' and nvl(a.aae145, ' ') = '2' and ((nvl(c.yaa012, ' ') = '2') or (nvl(c.yaa012, ' ') = '3' and nvl(c.yaa011, ' ') = '2') ) and b.aae003 = (select max(aae003) from ic14 d where a.aac001 = d.aac001 and c.aae076 = d.aae076) and a.yab003 = :1
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"
8c72h5wf1xdny	SELECT * FROM KC03 where yab003 = :"SYS_B_00" and aae002 in(:"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11" , :"SYS_B_12")
8fmyhtxpg3t8b	INSERT INTO yhcip_log_operation ( aae217, yae041, yab109, yae093, aae206, aae213, aae214, aae215, aae216, aae211, aae013, aac003, aae218, yab110, yae043) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15)
8wqj8zn151043	BEGIN pkg_S_COMM.prc_s_main (:1, :2, :3, :4, :5, :6); END;
8x0bamn5cfmkc	UPDATE KC24K2 SET YKB010 = :B5 WHERE AKC190 = :B4 AND YKA103 = :B3 AND YKD007 = :B2 AND AKA213 = :B1 AND YKA032 = '2'
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
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
9mq90p42frzgz	INSERT INTO ae09 ( aae217, yae041, yab109, yae093, aae206, aae213, aae214, aae215, aae216, aae211, aae013, aac003, aae218, yab110, yae043) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15)
9rtkyw3tgmwct	select distinct b.yka316 as yka316, b.ykb037 as ykb037, b.ykc179 as ykc179, b.yke150 as yke150, b.aae030 as aae030, b.yke151 as yke151, (select sum(nvl(count(1), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1' group by c.akc190, c.yka103 having sum(c.yka107) + sum(c.yka065) > 0) as ykb009, (case when b.yke239 = '1' then (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') + (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) else (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') end) as yka107, (select nvl(sum(nvl(c.yka065, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') as yka065, (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb03 7 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) as bckkje, (case when b.yke239 = '1' then (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') + (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) else (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c. ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') end) - (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) as sjbfje, (select sum(nvl(count(1), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') in ('0', '2') group by c.akc190, c.yka103 having sum(c.yka065) + sum(c.yka107) >= 0) as bcbyzfrc, (select sum(nvl(sum(nvl(c.yka107, 0)), 0) + nvl(sum(nvl(c.yka065, 0)), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') in ('0', '2') group by c.akc190, c.yka103 having sum(c.yka065) + sum(c.yka107) >= 0) as bcbyzf, b.ykb053 as ykb053, b.akb020 as akb020, b.yab138 as yab138, b.ykb010 as ykb010, b.yka108 as yka108, a.yka032 as yka032, a.aae011 as aae011, a.aae036 as aae036, a.yab003 as yab003, a.ykc151 as ykc151, a.ykc152 as ykc152, a.ykb048 as ykb048, a.ykc153 as ykc153, a.ykc154 as ykc154, a.ykb049 as ykb049, a.yke097 as yke097, c.aae036 as yke058, a.yab141 as yab141, a.yke032 as yke032 from kc32k1 c, kb03k4 d, kb12k3 b, kb12k1 a WHERE a.akb020 = b.akb020 and a.ykb010 = b.ykb010 and a.yab138 = b.yab138 and d.ykb010 = a.ykb010 and d.aae075 = c.aae075 and b.ykb010 is not null and b.yab138 = :1 AND b.YKA108 = :2 AND b.AKB020 = :3 AND b.yka316 = :4 order by yke058
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
ak22sxb132bjs	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.ahc40g = :2 AND a.yhb53c = :3 AND a.yae429 = :4 AND a.aae011 like '%'||:5||'%' AND a.aae036 < TO_DATE(:6, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=5 and myrownum>0
au5afsy1zfrg0	-------------------?? select sum(a.yka055) as ????, sum(yka107) as ????, count(distinct a.akc190) as ??, akc021 as ???? from kc24k1 a, kc24k2 b where a.akc190 = b.akc190 and a.yka103 = b.yka103 and a.ykd007 = b.ykd007 and b.aka213 = '0301' and a.yka032 = '1' and b.aae036 BETWEEN TO_DATE('2012-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2012-08-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS') AND 1 = (select count(distinct d.ykd007) from kc24k2 d where d.akc190 = b.akc190 and d.yka103 = b.yka103) group by akc021
ax86kcsaph4w6	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 'KC24K2' escape '\' order by 4, 2, 3
azjrxwjb4yphu	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.yhb53k = :2 AND a.yhb53c = :3 AND e.trainnum IS NOT NULL AND a.aae017 like :4||'%' AND a.aae036 < TO_DATE(:5, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=10 and myrownum>0
bd4bznqbq73hk	select bo#, intcol# from icoldep$ where obj#=:1
bq82udbn5skfj	BEGIN PKG_RollBack.prc_OperationLog (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
byqns0178a0a1	SELECT SEQ_DEFAULT.NEXTVAL from dual
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 )
c4bsu2cz1jhtw	BEGIN pkg_COMM.prc_CrtFinanceInterface (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;
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
cfuv1z6p0u2pg	SELECT a.akc190 as akc190, a.yke149 as yke149, a.yka330 as yka330 FROM kc24k1 a, kc24k2 b where a.akc190 = b.akc190 and a.yka103 = b.yka103 and a.ykd007 = b.ykd007 and b.yka032 = :1 and a.yke239 ='1' and b.ykb037 = :2 and 1 = (select count(distinct c.ykd007) from kc24k1 c where c.akc190 = b.akc190 and c.yka103 = b.yka103) AND ( a.ykc105 = :3 OR a.ykc105 = :4 ) AND a.akb020 = :5 AND b.akb020 = :6 AND b.aae036 >= :7 AND b.aae036 < :8
ch3fs7uy0cfsv	BEGIN pkg_W_comm.prc_w_main(:1, :2, :3, :4, :5, :6); END;
chxn2bpd13p2b	DELETE FROM IC02 WHERE AAC001 = :B2 AND YIC477 = :B1
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
cqu92kh8vnyqq	UPDATE ad53a4 SET yae041=:1, yae042=:2, yab109=:3, yae116=:4, yae113=:5, yab003=:6, yab275=:7, aac002=:8, aae218=:9, yae525=:10, yae524=:11 WHERE yae092=:12 AND aae100 = '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
d4w677wdap2da	select aac003 as aac003, aac004 as aac004, aac002 as aac002, aka130 as aka130, aka213 as aka213, yka234 as yka234, yka107 as yka107, yka055 as yka055, yka056 as yka056, yka057 as yka057, yka065 as yka111, yka115 as yka115, aac001 as aac001, akc190 as akc190, akb020 as akb020, days as days, fyny as fyny, yab139 as yab139 from ( select d.aac003 as aac003, d.aac004 as aac004, c.aac002 as aac002, d.aka130 as aka130, a.aka213 as aka213, a.yka234 as yka234, d.aac001 as aac001, a.akc190 as akc190, sum(nvl(d.yka055, 0)) as yka055, (select nvl(sum(yka324), 0) from kb09k4 where akc190 = a.akc190 and yka103 = a.yka103 and aka213 = a.aka213 and ykd003='2') as yka056, sum(nvl(d.yka057, 0)) as yka057, sum(nvl(a.yka065, 0)) as yka065, a.ykc125 as yka115, sum(nvl(a.yka107, 0)) as yka107, to_char(sum(nvl(d.akb063, 0))) as days, d.akb020 as akb020, '' as fyny, a.yab139 as yab139 from kc24k2 a, ac01 c, kc24k1 d where d.akc190 = a.akc190 and d.yka103 = a.yka103 and d.ykd007 = a.ykd007 and c.aac001 = d.aac001 AND a.ykb010 is not null and a.yka032 = '2' and (a.akc190, a.yka103, a.aka213) in (select f.akc190, f.yka103, f.aka213 from kb03k9 f where f.akb020 = :1 and f.ykb053 = :2 and nvl(f.yke248, '1') = '1' and f.ykb037 = :3 and f.yab138 = :4 and f.ykb053 = f.ykb059 and 1=(select count(distinct g.ykd007) from kc24k2 g where g.akc190=f.akc190 and g.yka103=f.yka103)) and a.yka054 = '01' group by d.aac003, d.aac004, c.aac002, d.aka130, a.aka213, a.yka234, a.ykc125, d.aac001, a.akc190, d.akb020, a.yka103, a.yab139 having (sum(a.yka107) + sum(a.yka065)) > 0 union select d.aac003 as aac003, d.aac004 as aac004, c.aac002 as aac002, d.aka130 as aka130, a.aka213 as aka213, a.yka234 as yka234, d.aac001 as aac001, a.akc190 as akc190, sum(nvl(d.yka055, 0)) as yka055, (select nvl(sum(yka324), 0) from kb09k4 where akc190 = a.akc190 and yka103 = a.yka103 and aka213 = a.aka213 and ykd003='2') as yka056, sum(nvl(d.yka057, 0)) as yka057, sum(nvl(a.yka065, 0)) as yka065, a.ykc125 as yka115, sum(nvl(e.ykc139, 0) + nvl(e.ykc182, 0)) as yka107, to_char(sum(nvl(d.akb063, 0))) as days, d.akb020 as akb020, '' as fyny, a.yab139 as yab139 from kc24k2 a, ac01 c, kc24k1 d, kb11k9 e where d.akc19 0 = a.akc190 and d.yka103 = a.yka103 and d.ykd007 = a.ykd007 and c.aac001 = d.aac001 and e.akc190 = a.akc190 and e.yka103 = a.yka103 and e.ykd007 = a.ykd007 and a.yka054 in ('02', '03') AND a.ykb010 is not null and a.yka032 = '2' and (a.akc190, a.yka103, a.aka213) in (select f.akc190, f.yka103, f.aka213 from kb03k9 f where f.akb020 = :5 and f.ykb053 = :6 and nvl(f.yke248, '1') = '1' and f.ykb037 = :7 and f.yab138 = :8 and f.ykb053 = f.ykb059 and 1=(select count(distinct g.ykd007) from kc24k2 g where g.akc190=f.akc190 and g.yka103=f.yka103)) group by d.aac003, d.aac004, c.aac002, d.aka130, a.aka213, a.yka234, a.ykc125, d.aac001, a.akc190, d.akb020, a.yka103, a.yab139 having (sum(a.yka107) + sum(a.yka065)) > 0 order by aac001, aac003, aac004, aac002, aka130, aka213, yka234, yka107, akb020 ) union all select aac003 as aac003, aac004 as aac004, aac002 as aac002, aka130 as aka130, aka213 as aka213, yka234 as yka234, yka107 as yka107, yka055 as yka055, yka056 as yka056, yka057 as yka057, yka065 as yka111, yka115 as yka115, aac001 as aac001, akc190 as akc190, akb020 as akb020, days as days, fyny as fyny, yab139 as yab139 from ( select d.aac003 as aac003, d.aac004 as aac004, c.aac002 as aac002, d.aka130 as aka130, a.aka213 as aka213, a.yka234 as yka234, d.aac001 as aac001, a.akc190 as akc190, sum(nvl(d.yka055, 0)) as yka055, (select nvl(sum(yka324), 0) from kb09k4 where akc190 = a.akc190 and yka103 = a.yka103 and aka213 = a.aka213 and ykd003='2') as yka056, sum(nvl(d.yka057, 0)) as yka057, sum(nvl(a.yka065, 0)) as yka065, a.ykc125 as yka115, sum(nvl(a.yka107, 0)) as yka107, to_char(sum(nvl(d.akb063, 0))) as days, d.akb020 as akb020, to_char(a.aae036, 'yyyymmdd') as fyny, a.yab139 as yab139 from kc24k2 a, ac01 c, kc24k1 d where d.akc190 = a.akc190 and d.yka103 = a.yka103 and d.ykd007 = a.ykd007 and c.aac001 = d.aac001 AND a.ykb010 is not null and a.yka032 = '2' and (a.akc190, a.yka103, a.aka213) in (select f.akc190, f.yka103, f.aka213 from kb03k9 f where f.akb020 = :9 and f.ykb053 = :10 and nvl(f.yke248, '1') = '1' and f.ykb037 = :11 and f.yab138 = :12 and f.ykb053 <> f.ykb059 and 1=(select count(distinct g.ykd007) from kc24k2 g where g.akc1 90=f.akc190 and g.yka103=f.yka103)) and a.yka054 = '01' group by d.aac003, d.aac004, c.aac002, d.aka130, a.aka213, a.yka234, a.ykc125, d.aac001, a.akc190, d.akb020, to_char(a.aae036, 'yyyymmdd'), a.yka103, a.yab139 having (sum(a.yka107) + sum(a.yka065)) > 0 union select d.aac003 as aac003, d.aac004 as aac004, c.aac002 as aac002, d.aka130 as aka130, a.aka213 as aka213, a.yka234 as yka234, d.aac001 as aac001, a.akc190 as akc190, sum(nvl(d.yka055, 0)) as yka055, (select nvl(sum(yka324), 0) from kb09k4 where akc190 = a.akc190 and yka103 = a.yka103 and aka213 = a.aka213 and ykd003='2') as yka056, sum(nvl(d.yka057, 0)) as yka057, sum(nvl(a.yka065, 0)) as yka065, a.ykc125 as yka115, sum(nvl(e.ykc139, 0) + nvl(e.ykc182, 0)) as yka107, to_char(sum(nvl(d.akb063, 0))) as days, d.akb020 as akb020, to_char(a.aae036, 'yyyymmdd') as fyny, a.yab139 as yab139 from kc24k2 a, ac01 c, kc24k1 d, kb11k9 e where d.akc190 = a.akc190 and d.yka103 = a.yka103 and d.ykd007 = a.ykd007 and c.aac001 = d.aac001 and e.akc190 = a.akc190 and e.yka103 = a.yka103 and e.ykd007 = a.ykd007 AND a.ykb010 is not null and a.yka054 in ('02', '03') and a.yka032 = '2' and (a.akc190, a.yka103, a.aka213) in (select f.akc190, f.yka103, f.aka213 from kb03k9 f where f.akb020 = :13 and f.ykb053 = :14 and nvl(f.yke248, '1') = '1' and f.ykb037 = :15 and f.yab138 = :16 and f.ykb053 <> f.ykb059 and 1=(select count(distinct g.ykd007) from kc24k2 g where g.akc190=f.akc190 and g.yka103=f.yka103)) group by d.aac003, d.aac004, c.aac002, d.aka130, a.aka213, a.yka234, a.ykc125, d.aac001, a.akc190, d.akb020, to_char(a.aae036, 'yyyymmdd'), a.yka103, a.yab139 having (sum(a.yka107) + sum(a.yka065)) > 0 order by aac001, aac003, aac004, aac002, aka130, aka213, yka234, yka107, akb020 )
ddkfkj8czzdzh	SELECT COUNT(*) FROM (SELECT A.AAC001, A.AAE001 FROM KC60 A WHERE A.AAC001 = :B2 AND A.AAE001 = :B1 UNION ALL SELECT A.AAC001, A.AAE001 FROM KC60K1 A WHERE A.AAC001 = :B2 AND A.AAE001 = :B1 )
dguvtr341dabw	DECLARE s_yab003 kc24k2.yab003%TYPE; s_ykb010 kc24k2.ykb010%TYPE; s_aae075 kb03k4.aae075%TYPE; s_aae076 kc32k1.aae076%TYPE; d_aab191 ad04a1.aab191%TYPE; N_YKA055 YH00_KC24K2_2013_08.YKA055%TYPE; N_YKA056 YH00_KC24K2_2013_08.YKA056%TYPE; N_YKA057 YH00_KC24K2_2013_08.YKA057%TYPE; N_YKA111 YH00_KC24K2_2013_08.YKA111%TYPE; N_YKA107 YH00_KC24K2_2013_08.YKA107%TYPE; N_YKA324 YH00_KC24K2_2013_08.YKA107%TYPE; S_YKA054 YH00_KC24K2_2013_08.YKA054%TYPE; N_YKC139 KB11K9.YKC139%TYPE; N_YKC182 KB11K9.YKC182%TYPE; N_TCZFBF YH00_KC24K2_2013_08.TCZFBF%TYPE; --??????, NUMBER N_ZFFYZB YH00_KC24K2_2013_08.ZFFYZB%TYPE; --??????, NUMBER N_MLNYPF YH00_KC24K2_2013_08.MLNYPF%TYPE; --??????, NUMBER N_MLWYPF YH00_KC24K2_2013_08.MLWYPF%TYPE; --??????, NUMBER N_ZCNJCF YH00_KC24K2_2013_08.ZCNJCF%TYPE; --????????, NUMBER N_ZCWJCF YH00_KC24K2_2013_08.ZCWJCF%TYPE; --????????, NUMBER N_ZCNFWF YH00_KC24K2_2013_08.ZCNFWF%TYPE; --????????, NUMBER N_ZCWFWF YH00_KC24K2_2013_08.ZCWFWF%TYPE; --????????, NUMBER N_YPGGZF YH00_KC24K2_2013_08.YPGGZF%TYPE; N_JCGGZF YH00_KC24K2_2013_08.JCGGZF%TYPE; N_COUNT NUMBER(15):=0; cursor cur_yab003 IS /*SELECT a.yab003 FROM ab50 a WHERE a.yab235 = '1' AND a.yab003 <= 20 AND EXISTS (SELECT 1 FROM yh00_yab003_tj_lk b WHERE b.yab003 = a.yab003);*/ SELECT yab138 FROM yh00_ykb010_2013_08 WHERE yab138 IN (SELECT yab003 FROM yh00_yab003_tj_lk) GROUP BY yab138 ORDER BY count(1); cursor cur_ykb010 IS SELECT ykb010 FROM yh00_ykb010_2013_08 WHERE yab138 = s_yab003; cursor cur_kc24k2 IS SELECT akc190, yka103, ykd007, aka213 FROM YH00_KC24K2_2013_08 WHERE ykb010 = s_ykb010 AND yka324 IS NULL; /* select AKC190, --????, VARCHAR2 YKA103, --????, VARCHAR2 YKD007, --????, VARCHAR2 AKA213, --????, VARCHAR2 AAC001, --????, VARCHAR2 AKB020, --??????, VARCHAR2 AKB023, --??????, VARCHAR2 AKA101, --??????, VARCHAR2 AKA130, --????, VARCHAR2 AKC021, --??????, VARCHAR2 YKB010, --?????, VARCHAR2 AKB063, --????, NUMBER YKA055, --?????, NUMBER YKA056, --?????, NUMBER YKA057, --??????, NUMBER YKA111, --??????, NUMBER YKA107, --????, NUMBER YKA324, --????, NUMBER YKA065, --????????, NUMBER YKA115, --?????, NUMBER YKA058, --???????, NUMBER TCZFBF, --??????, NUMBER ZFFYZB, --??????, NUMBER MLNYPF, --??????, NUMBER MLWYPF, --??????, NUMBER ZCNJCF, --????????, NUMBER ZCWJCF, --????????, NUMBER ZCNFWF, --????????, NUMBER ZCWFWF, --????????, NUMBER YAB139, --?????????, CHAR YKB037, --?????, CHAR AAE076, --???????, VARCHAR2 YWDDSJ, --??????, DATE AAB191 --??/????, DATE from yh00_kc24k2_tj_lk --yh00_kc24k2_tj_lk */ BEGIN OPEN cur_yab003; LOOP FETCH cur_yab003 INTO s_yab003; EXIT WHEN cur_yab003%NOTFOUND; FOR rec_cur1 IN cur_ykb010 LOOP s_ykb010 := rec_cur1.ykb010; FOR rec_cur2 IN cur_kc24k2 LOOP N_COUNT := N_COUNT + 1; N_YKA055 := 0; N_YKA056 := 0; N_YKA057 := 0; N_YKA111 := 0; N_YKA107 := 0; N_YKC139 := 0; N_YKC182 := 0; N_YKA324 := NULL; N_TCZFBF := NULL; N_ZFFYZB := NULL; N_MLNYPF := NULL; N_MLWYPF := NULL; N_ZCNJCF := NULL; N_ZCWJCF := NULL; N_ZCNFWF := NULL; N_ZCWFWF := NULL; N_YPGGZF := NULL; N_JCGGZF := NULL; BEGIN SELECT YKA055, YKA056, YKA057, YK A111, YKA107, yka054 INTO N_YKA055, N_YKA056, N_YKA057, N_YKA111, N_YKA107, S_YKA054 FROM YH00_KC24K2_2013_08 WHERE AKC190 = rec_cur2.akc190 AND YKA103 = rec_cur2.YKA103 AND YKD007 = rec_cur2.YKD007 AND AKA213 = rec_cur2.aka213; EXCEPTION WHEN NO_DATA_FOUND THEN N_TCZFBF := 0; N_ZFFYZB := 0; N_MLNYPF := 0; N_MLWYPF := 0; N_ZCNJCF := 0; N_ZCWJCF := 0; N_ZCNFWF := 0; N_ZCWFWF := 0; N_YPGGZF := 0; N_JCGGZF := 0; GOTO label_next; WHEN OTHERS THEN GOTO label_next; END; BEGIN IF S_YKA054 <> '01' THEN BEGIN SELECT NVL(YKC139, 0), NVL(ykc182, 0) INTO N_YKC139, N_YKC182 FROM kb11k9 WHERE AKC190 = rec_cur2.akc190 AND YKA103 = rec_cur2.YKA103 AND YKD007 = rec_cur2.YKD007; EXCEPTION WHEN OTHERS THEN N_YKC139 := 0; N_YKC182 := 0; END; END IF; EXCEPTION WHEN OTHERS THEN NULL; END; BEGIN SELECT NVL(YKA324, 0) INTO N_YKA324 FROM KB09K4 WHERE AKC190 = rec_cur2.akc190 AND YKA103 = rec_cur2.YKA103 AND YKD007 = rec_cur2.YKD007 AND AKA213 = rec_cur2.aka213; EXCEPTION WHEN OTHERS THEN N_YKA324 := 0; END; N_YKA324 := NVL(N_YKA324, 0); N_YKA107 := N_YKA107 - N_YKA324; --TCZFBF, NUMBER(14, 2), --?????? --???????????????????????????? N_TCZFBF := N_YKA055 - N_YKA056 - N_YKA057 - N_YKA107; ----ZFFYZB, NUMBER(14, 2), --?????? ----?????????1??????????? ----MLNYPF, NUMBER(14, 2), --?????? ----?????????0~1?????????????? ----MLWYPF, NUMBER(14, 2), --?????? ----?????????1???????????? ----ZCNJCF, NUMBER(14, 2), --???????? ----?????????0~1?????????????????????? ----'020301', '020401', '020501', '020601' ----ZCWJCF, NUMBER(14, 2), --???????? ----?????????1???????????????????? ----'020301', '020401', '020501', '020601' ----ZCNFWF, NUMBER(14, 2), --???????? ----?? ???????0~1?????????????????????? ----'020101', '020201', '030101' ----ZCWFWF, NUMBER(14, 2), --???????? ----?????????1???????????????????? ----'020101', '020201', '030101' BEGIN SELECT SUM(NVL(yka315, 0)) INTO N_ZFFYZB FROM (SELECT NVL(yka315, 0) as yka315 FROM kc22k1 WHERE YKA096 = 1 AND akc190 = rec_cur2.akc190 UNION SELECT NVL(yka315, 0) as yka315 FROM kc22k2 WHERE YKA096 = 1 AND akc190 = rec_cur2.akc190); EXCEPTION WHEN NO_DATA_FOUND THEN N_ZFFYZB := 0; WHEN OTHERS THEN NULL; END; BEGIN SELECT SUM(NVL(yka315, 0)) INTO N_MLNYPF FROM (SELECT NVL(yka315, 0) as yka315 FROM kc22k1 WHERE YKA096 >= 0 AND YKA096 < 1 AND SUBSTR(YKA001, 1, 2) = '01' AND akc190 = rec_cur2.akc190 UNION SELECT NVL(yka315, 0) as yka315 FROM kc22k2 WHERE YKA096 > ;= 0 AND YKA096 < 1 AND SUBSTR(YKA001, 1, 2) = '01' AND akc190 = rec_cur2.akc190 ); EXCEPTION WHEN NO_DATA_FOUND THEN N_MLNYPF := 0; WHEN OTHERS THEN NULL; END; BEGIN SELECT SUM(NVL(yka315, 0)) INTO N_MLWYPF FROM (SELECT NVL(yka315, 0) as yka315 FROM kc22k1 WHERE YKA096 = 1 AND SUBSTR(YKA001, 1, 2) = '01' AND akc190 = rec_cur2.akc190 UNION SELECT NVL(yka315, 0) as yka315 FROM kc22k2 WHERE YKA096 = 1 AND SUBSTR(YKA001, 1, 2) = '01' AND akc190 = rec_cur2.akc190 ); EXCEPTION WHEN NO_DATA_FOUND THEN N_MLWYPF := 0; WHEN OTHERS THEN NULL; END; BEGIN SELECT SUM(NVL(yka315, 0)) INTO N_ZCNJCF FROM (SELECT NVL(yka315, 0) as yka315 FROM kc22k1 WHERE YKA096 >=0 AND YKA096<1 AND (YKA001='020301' OR YKA001='020401' OR YKA001='020501' OR YKA001='020601') AND akc190 = rec_cur2.akc190 UNION SELECT NVL(yka315, 0) as yka315 FROM kc22k2 WHERE YKA096 >=0 AND YKA096<1 AND (YKA001='020301' OR YKA001='020401' OR YKA001='020501' OR YKA001='020601') AND akc190 = rec_cur2.akc190 ); EXCEPTION WHEN NO_DATA_FOUND THEN N_ZCNJCF := 0; WHEN OTHERS THEN NULL; END; BEGIN SELECT SUM(NVL(yka315, 0)) INTO N_ZCWJCF FROM (SELECT NVL(yka315, 0) as yka315 FROM kc22k1 WHERE YKA096 =1 AND (YKA001='020301' OR YKA001='020401' OR YKA001='020501' OR YKA001='020601') AND akc190 = rec_cur2.akc190 UNION SELECT NVL(yka315, 0) as yka315 FROM kc22k2 WHERE YKA096 =1 AND (YKA001='020301' OR YKA001='020401' OR YKA001='020501' OR YKA001='020601') AND akc190 = rec_cur2.akc190 ); EXCEPTION WHEN NO_DATA_FOUND THEN N_ZCWJ CF := 0; WHEN OTHERS THEN NULL; END; BEGIN SELECT SUM(NVL(yka315, 0)) INTO N_ZCNFWF FROM (SELECT NVL(yka315, 0) as yka315 FROM kc22k1 WHERE YKA096 >=0 AND YKA096<1 AND (YKA001='020101' OR YKA001='020201' OR YKA001='030101') AND akc190 = rec_cur2.akc190 UNION SELECT NVL(yka315, 0) as yka315 FROM kc22k2 WHERE YKA096 >=0 AND YKA096<1 AND (YKA001='020101' OR YKA001='020201' OR YKA001='030101') AND akc190 = rec_cur2.akc190 ); EXCEPTION WHEN NO_DATA_FOUND THEN N_ZCNFWF := 0; WHEN OTHERS THEN NULL; END; BEGIN SELECT SUM(NVL(yka315, 0)) INTO N_ZCWFWF FROM (SELECT NVL(yka315, 0) as yka315 FROM kc22k1 WHERE YKA096 =1 AND (YKA001='020101' OR YKA001='020201' OR YKA001='030101') AND akc190 = rec_cur2.akc190 UNION SELECT NV L(yka315, 0) as yka315 FROM kc22k2 WHERE YKA096 =1 AND (YKA001='020101' OR YKA001='020201' OR YKA001='030101') AND akc190 = rec_cur2.akc190); EXCEPTION WHEN NO_DATA_FOUND THEN N_ZCWFWF := 0; WHEN OTHERS THEN NULL; END; BEGIN SELECT SUM(NVL(yka318, 0)) INTO N_YPGGZF FROM (SELECT NVL(yka318, 0) as yka318 FROM kc22k1 WHERE YKA096 >= 0 AND YKA096 < 1 AND SUBSTR(YKA001, 1, 2) = '01' AND akc190 = rec_cur2.akc190 UNION SELECT NVL(yka318, 0) as yka318 FROM kc22k2 WHERE YKA096 >= 0 AND YKA096 < 1 AND SUBSTR(YKA001, 1, 2) = '01' AND akc190 = rec_cur2.akc190 ); EXCEPTION WHEN NO_DATA_FOUND THEN N_YPGGZF := 0; WHEN OTHERS THEN NULL; END; BEGIN SELECT SUM(NVL(yka318, 0)) INTO N_JCGGZF FROM (SELECT NVL(yka318, 0) as yka 318 FROM kc22k1 WHERE YKA096 >=0 AND YKA096<1 AND (YKA001='020301' OR YKA001='020401' OR YKA001='020501' OR YKA001='020601') AND akc190 = rec_cur2.akc190 UNION SELECT NVL(yka318, 0) as yka318 FROM kc22k2 WHERE YKA096 >=0 AND YKA096<1 AND (YKA001='020301' OR YKA001='020401' OR YKA001='020501' OR YKA001='020601') AND akc190 = rec_cur2.akc190 ); EXCEPTION WHEN NO_DATA_FOUND THEN N_JCGGZF := 0; WHEN OTHERS THEN NULL; END; <<label_next>> UPDATE YH00_KC24K2_2013_08 SET YKA324 = N_YKA324, --????, NUMBER YKA107 = N_YKA107, TCZFBF = N_TCZFBF, --??????, NUMBER ZFFYZB = N_ZFFYZB, --??????, NUMBER MLNYPF = N_MLNYPF, --??????, NUMBER MLWYPF = N_MLWYPF, --??????, NUMBER ZCNJCF = N_ZCNJCF, --????????, NUMBER ZCWJCF = N_ZCWJCF, --????????, NUMBER ZCNFWF = N_ZCNFWF, --????????, NUMBER ZCWFWF = N_ZCWFWF, --????????, NUMBER YKC139 = N_YKC139, YKC182 = N_YKC182, YPGGZF = N_YPGGZF, --???????????? JCGGZF = N_JCGGZF --???????????? WHERE AKC190 = rec_cur2.akc190 AND YKA103 = rec_cur2.YKA103 AND YKD007 = rec_cur2.YKD007 AND AKA213 = rec_cur2.aka213; IF N_COUNT = 10000 THEN COMMIT; N_COUNT := 0; END IF; END LOOP; END LOOP; DELETE FROM yh00_yab003_tj_lk WHERE yab003 = s_yab003; COMMIT; END LOOP; CLOSE cur_yab003; END;
dh7a5k0c2yhgt	begin cdsi2.pkg_p_zhjz.prc_i_zhjz(PRM_AAC001=>:V001, PRM_YAB003=>:V002, PRM_APPCODE=>:V003, PRM_ERRORMSG=>:V004);end;
dnuasfch7q0up	SELECT a.yab003 as yab003, a.yac146 as yac146 FROM ac34 a WHERE a.yac146 = :1
dp14frvpfr74x	INSERT INTO KC22K2( AKC190, YKA105, YKA002, YKA003, YKA103, YKA104, AKA130, AKB020, AKB023, AKA101, YKB006, AAC001, YKA001, YKA094, YKA095, AKC226, AKC225, YKA299, YKA096, YKA315, YKA317, YKA318, YKA319, YKA097, YKA098, YKA099, YKA100, YKA101, YKA102, YKC105, YKE123, YKE098, YKA093, AAE011, YKC141, AAE036, YAB003, AAE013, YKE008, YKE009, YKD040, YKE011, YKE147, YKD003, YKB010, YKE187, YKE201, YKE199, YKE216, YKA348, YKA336, YKE112, YKE186, YKE426, YKE381, YKE407, YKE474, YKE492, YKE493, YKE494, YKE419, YKE420 ) SELECT AKC190, YKA105, YKA002, YKA003, YKA103, YKA104, AKA130, AKB020, AKB023, AKA101, YKB006, AAC001, YKA001, YKA094, YKA095, AKC226, AKC225, YKA299, YKA096, YKA315, YKA317, YKA318, YKA319, YKA097, YKA098, YKA099, YKA100, YKA101, YKA102, YKC105, YKE123, YKE098, YKA093, AAE011, YKC141, AAE036, YAB003, AAE013, YKE008, YKE009, YKD040, YKE011, YKE147, YKD003, :B3 , YKE187, YKE201, YKE199, :B2 , YKA348, YKA336, YKE112, YKE186, YKE426, YKE381, YKE407, YKE474, YKE492, YKE493, YKE494, YKE419, YKE420 FROM KC22K1 WHERE AKC190 = :B1
dp9qnuvv40ft9	SELECT * FROM "KE13K1"
dt3hnnhqxavz6	SELECT b.aac001 as aac001, b.aac002 as aac002, b.aac008 as aac008, b.aac004 as aac004, b.aac003 as aac003, b.aac006 as aac006, a.aab034, a.yab003, a.ync003, a.ync006, a.ync140, a.ync013, a.aac031, a.aac030, a.yac033, a.yae097, a.yae100, a.yae101, a.aae011, a.aae036, a.aae013, a.yab275, nvl(a.ync149, '0') as ync149 FROM ac01 b , nc01 a where a.aac001 = b.aac001 AND a.yab003 = :1
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
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
fj1kxr6aw0syz	SELECT COUNT(1) FROM KC03K1 WHERE AAC001 = :B2 AND AAE002 <= :B1
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;
fvrcjy3fgzbk1	update sst_terminal set ipaddress = :1 where termid = :2
g0rh0dv0c7fnj	SELECT SUM(NVL(YKA318, 0)) FROM (SELECT NVL(YKA318, 0) AS YKA318 FROM KC22K1 WHERE YKA096 >=0 AND YKA096<1 AND (YKA001='020301' OR YKA001='020401' OR YKA001='020501' OR YKA001='020601') AND AKC190 = :B1 UNION SELECT NVL(YKA318, 0) AS YKA318 FROM KC22K2 WHERE YKA096 >=0 AND YKA096<1 AND (YKA001='020301' OR YKA001='020401' OR YKA001='020501' OR YKA001='020601') AND AKC190 = :B1 )
g1jnb5j9pj1ju	SELECT SUM(NVL(YKA315, 0)) FROM (SELECT NVL(YKA315, 0) AS YKA315 FROM KC22K1 WHERE YKA096 = 1 AND AKC190 = :B1 UNION SELECT NVL(YKA315, 0) AS YKA315 FROM KC22K2 WHERE YKA096 = 1 AND AKC190 = :B1 )
g8zcvtwzq917c	SELECT a.yac005 as yac005, a.aac001 as aac001, a.yac137 as yac137, a.yac112 as yac112, a.yab003 as yab003, a.yac136 as yac136, a.yac150 as yac150, a.yac135 as yac135, a.aac002 as aac002, a.yae096 as yae096, a.aac003 as aac003, a.yac138 as yac138, a.yac140 as yac140, a.yac141 as yac141, a.yac142 as yac142, a.yac143 as yac143, a.yac144 as yac144, a.aab001 as aab001, null as ykc1243 FROM ac29 a WHERE a.yab003 = :1 AND a.aac001 = :2 AND a.yac112 = :3 and a.yac150 = :4 and a.yac137 = :5 order by a.aab001, a.aac001, a.yac141, a.yac135
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