WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORCLDB	2105607667	orcldb2	2	10.2.0.4.0	YES	yjzhdb2

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	36864	16-Jan-13 10:00:22	390	3.4
End Snap:	36865	16-Jan-13 11:25:42	954	2.6
Elapsed:		85.33 (mins)
DB Time:		34,181.08 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	13,808M	13,808M	Std Block Size:	8K
Shared Pool Size:	9,968M	9,968M	Log Buffer:	14,288K

Load Profile

	Per Second	Per Transaction
Redo size:	4,769.39	1,491.06
Logical reads:	17,552.09	5,487.33
Block changes:	13.54	4.23
Physical reads:	38.21	11.94
Physical writes:	0.86	0.27
User calls:	72.76	22.75
Parses:	23.26	7.27
Hard parses:	0.52	0.16
Sorts:	43.81	13.70
Logons:	0.61	0.19
Executes:	66.02	20.64
Transactions:	3.20

% Blocks changed per Read:	0.08	Recursive Call %:	67.55
Rollback per transaction %:	80.19	Rows per Sort:	19.48

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.79	In-memory Sort %:	100.00
Library Hit %:	98.00	Soft Parse %:	97.74
Execute to Parse %:	64.77	Latch Hit %:	99.72
Parse CPU to Parse Elapsd %:	0.60	% Non-Parse CPU:	25.56

Shared Pool Statistics

	Begin	End
Memory Usage %:	71.07	68.41
% SQL with executions>1:	84.79	94.45
% Memory for SQL w/exec>1:	84.93	94.77

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
enq: SQ - contention	288,966	843,431	2,919	41.1	Configuration
latch: row cache objects	6,163,699	709,843	115	34.6	Concurrency
cursor: pin S wait on X	28,862,430	284,389	10	13.9	Concurrency
rdbms ipc reply	71,166	137,606	1,934	6.7	Other
row cache lock	19,885	55,525	2,792	2.7	Concurrency

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	27.65	8.64
Global Cache blocks served:	52.80	16.51
GCS/GES messages received:	594.00	185.70
GCS/GES messages sent:	404.90	126.58
DBWR Fusion writes:	0.13	0.04
Estd Interconnect traffic (KB)	838.69

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

Buffer access - local cache %:	99.63
Buffer access - remote cache %:	0.16
Buffer access - disk %:	0.21

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.3
Avg global cache cr block receive time (ms):	0.7
Avg global cache current block receive time (ms):	1.1
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 %:	15.2
Avg global cache cr block flush time (ms):	0.2
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.0
Avg global cache current block flush time (ms):	2.3

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.4
% of direct sent messages:	9.11
% of indirect sent messages:	90.38
% of flow controlled messages:	0.50

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): 2050864.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

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: 89,860,481
• Captured SQL account for 52.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 195,607
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 338,009
• Captured SQL account for 24.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 119,067
• Captured SQL account for 65.0% 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
04ft7y07kxpuv	SELECT COUNT(1) FROM (SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_af98dd529c0_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:1 AND P.PRO_STARTED_TIME<=:2 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_3a7aaa31d61_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:3 AND P.PRO_STARTED_TIME<=:4 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_3dfc3fdaa3_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:5 AND P.PRO_STARTED_TIME<=:6 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_1fff41bda1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:7 AND P.PRO_STARTED_TIME<=:8 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREAT E_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_16053f53e1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:9 AND P.PRO_STARTED_TIME<=:10 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_3ea4a565b1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:11 AND P.PRO_STARTED_TIME<=:12 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_f9f4e2a1996_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:13 AND P.PRO_STARTED_TIME<=:14 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFI NITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7f59fede84_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:15 AND P.PRO_STARTED_TIME<=:16 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_a88aac62c41_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:17 AND P.PRO_STARTED_TIME<=:18 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.R ESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_6500ab027d7_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:19 AND P.PRO_STARTED_TIME<=:20 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.REA D_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_233d3773591_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:21 AND P.PRO_STARTED_TIME<=:22 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7cf58be2f41_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:23 AND P.PRO_STARTED_TIME<=:24 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_1ed73e63b51_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:25 AND P.PRO_STARTED_TIME<=:26 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROC ESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_f98a5c213c4_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:27 AND P.PRO_STARTED_TIME<=:28 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_e0c2d41f03_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:29 AND P.PRO_STARTED_TIME<=:30 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_ NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_e13e9f610f0_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:31 AND P.PRO_STARTED_TIME<=:32 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJ ECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_64de0102ed5_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:33 AND P.PRO_STARTED_TIME<=:34 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7f112c77fb_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:35 AND P.PRO_STARTED_TIME<=:36 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_ NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_1cae5be28d1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:37 AND P.PRO_STARTED_TIME<=:38 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK _LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_38f4e4f3c0_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:39 AND P.PRO_STARTED_TIME<=:40 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_a8e0c9533c1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:41 AND P.PRO_STARTED_TIME<=:42 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESC RIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_266e561d55_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:43 AND P.PRO_STARTED_TIME<=:44 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P .STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_64386582623_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:45 AND P.PRO_STARTED_TIME<=:46 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7ee47433479_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:47 AND P.PRO_STARTED_TIME<=:48 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_C URRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_058ff981a41_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:49 AND P.PRO_STARTED_TIME<=:50 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_57f88342c11_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:51 AND P.PRO_STARTED_TIME<=:52 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_26946152c97_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:53 AND P.PRO_STARTED_TIME<=:54 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P .PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_f92530c472_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:55 AND P.PRO_STARTED_TIME<=:56 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLE TED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_db1e3741b23_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:57 AND P.PRO_STARTED_TIME<=:58 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7f70abb272f_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:59 AND P.PRO_STARTED_TIME<=:60 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIM E, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_792b7c62c41_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:61 AND P.PRO_STARTED_TIME<=:62 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DEL EGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_79424851873_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:63 AND P.PRO_STARTED_TIME<=:64 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_9a1ecacf11_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O0000000001443???????????????????????????????????????????????????????????????????????????????????????????????ITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P. ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_4a88b6d1800_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:67 AND P.PRO_STARTED_TIME<=:68 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCE LLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_e057ce91132_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:69 AND P.PRO_STARTED_TIME<=:70 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_640754f1d21_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:71 AND P.PRO_STARTED_TIME<=:72 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_b3a2ebe2491_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:73 AND P.PRO_STARTED_TIME<=:74 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SE NT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_14fe5e81a51_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:75 AND P.PRO_STARTED_TIME<=:76 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_23498ca3913_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:77 AND P.PRO_STARTED_TIME<=:78 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRE NT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_3d6731a1b11_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:79 AND P.PRO_STARTED_TIME<=:80 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_ CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_201abae3e3_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:81 AND P.PRO_STARTED_TIME<=:82 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7e6a40036f5_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:83 AND P.PRO_STARTED_TIME<=:84 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTI VITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_6d5ac10161_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:85 AND P.PRO_STARTED_TIME<=:86 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_dd362de2ae3_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:87 AND P.PRO_STARTED_TIME<=:88 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7f4c4073a6d_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:89 AND P.PRO_STARTED_TIME<=:90 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FOR M_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_42adcbd931_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:91 AND P.PRO_STARTED_TIME<=:92 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.com pleted', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_4305d8d24d2_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:93 AND P.PRO_STARTED_TIME<=:94 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_9a4461d2993_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:95 AND P.PRO_STARTED_TIME<=:96 ORDER BY PRO_STARTED_TIME DESC ) T
05uqdabhzncdc	select role# from defrole$ d, user$ u where d.user#=:1 and u.user#=d.user# and u.defrole=2 union select privilege# from sysauth$ s, user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0myxrqwncjy7c	select ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S%' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S%') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000487' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000487') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000559' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000559') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000562' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000562') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000564' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000564') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000565' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000565') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000568' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000568') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000569' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000569') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000571' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000571') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000573' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000573') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000575' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000575') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000577' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S000 00000000577') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000579' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000579') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000580' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000580') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000581' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000581') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000583' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000583') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000585' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000585') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000587' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corpora tion_id like 'S00000000000587') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000589' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000589') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000591' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000591') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000555' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000555') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S00000000000593' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S00000000000593') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S41000000007661' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S41000000007661') ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL where POL.corporation_id like 'S41000000016607' union all SELECT count(POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH WHERE poh.corporation_id like 'S41000000016607') ) from dual
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0xj23wwhq0vzk	select LXRID, XM, XB, SJ, BZ, YHMXID, DW, BM, ZW, YX, DH, YB, DZ from MISP_LXR where (XM like'139%' or SJ like '139%' ) and ( yhmxid ='5099' or lxrid in (select yhid from misp_txlmx where txlid in(select id from misp_txl where lx='2' and (bz='2' and jgbh in(004100280015)or (bz='1' and substr(jgbh, 0, 8) in (00410028)))))) order by nlssort(XM, 'NLS_SORT=SCHINESE_PINYIN_M')
15qtn4rj237dt	select * from (select a.*, rownum AS linenum from ( select * from ( --???????? select * from ( select '0' as auditkind, a.id as itemid, 0 as flowid, a.name||'??????????????????' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(fp.passtime, 'yyyy-MM-dd') as setime, a.itemflowid, ( select count(1) as docnum from t_item_file where filenameexid = (select id from t_config_filename t where itemflowid = 30 and wordnum = 1) and itemid = a.id )num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a left join t_company e on e.orgid = a.companyid left join t_item_firstpass fp on fp.itemid = a.id and fp.ifpass=1 left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid =30)aa where aa.num=0 --???????? union all select '1' as auditkind, a.id as itemid, 0 as flowid, a.name||'???????????????' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(b.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, 0 as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a join t_item_argumentation b on a.id = b.itemid and b.advice is null and b.resulttype=0 left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid>30 --?????? union all select '2' as auditkind, a.id as itemid, c.id as flowid, a.name||'???? ????(<font color=red>'||cc.realname||'</font>)' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(c.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, 0 as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a join t_waitprocess c on c.infoid = a.id and c.ifview=0 --???? 0??? and c.wptype=0 --???? and c.infotype=1 --????1 ?????? and c.infotimetype=0 --???????? 0??? --and c.wpuserid =2320--??id left join sec_user cc on cc.user_id = c.processuserid left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid=0 and c.id= (select max(id) from t_waitprocess wp where wp.infoid = a.id and wp.ifview=0 --???? 0??? and wp.wptype=0 --???? and wp.infotype=1 --????1 ?????? and wp.infotimetype=0 --???????? 0??? ) --??????? union all select '410372' as auditkind, a.id as itemid, c.id as flowid, a.name||'?????????(<font color=red>'||cc.realname||'</font>)' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(c.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, 0 as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a join t_waitprocess c on c.infoid = a.id and c.ifview=0 --???? 0??? and c.wptype=0 --???? and c.infotype=6 --????6 ??????? and c.infotimetype=0 --???????? 0??? --and c.wpuserid =2320--??id left join sec_user cc on cc.user_id = c.processuserid left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype le ft join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid=0 and c.id= (select max(id) from t_waitprocess wp where wp.infoid = a.id and wp.ifview=0 --???? 0??? and wp.wptype=0 --???? and c.infotype=6 --????6 ??????? and wp.infotimetype=0 --???????? 0??? ) --?????? union all select '3' as auditkind, a.id as itemid, c.id as flowid, a.name||'????????(<font color=red>'||cc.realname||'</font>)' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(c.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, 0 as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a join t_waitprocess c on c.infoid = a.id and c.ifview=0 --???? 0??? and c.wptype=0 --???? and c.infotype=2 --????2 ?????? and c.infotimetype=0 --???????? 0??? --and c.wpuserid =2320--??id left join sec_user cc on cc.user_id = c.processuserid left join t_company e on e .orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid=60 and c.id= (select max(id) from t_waitprocess wp where wp.infoid = a.id and wp.ifview=0 --???? 0??? and wp.wptype=0 --???? and wp.infotype=2 --????2 ?????? and wp.infotimetype=0 --???????? 0??? ) --??????? union all select '4' as auditkind, a.id as itemid, c.id as flowid, a.name||'?????????(<font color=red>'||cc.realname||'</font>)' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(c.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, 0 as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a join t_waitprocess c on c.infoid = a.id and c.ifview=0 --???? 0??? and c.wptype=0 --???? and c.infotype=3 --????3 ??????? and c.infotimetype=0 --???????? 0??? --and c.wpuserid =2320--??id left join sec_user cc on cc.user_id = c.processuserid left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid=60 and c.id= (select max(id) from t_waitprocess wp where wp.infoid = a.id and wp.ifview=0 --???? 0??? and wp.wptype=0 --???? and wp.infotype=3 --????3 ??????? and wp.infotimetype=0 --???????? 0??? ) --?????? union all select '5' as auditkind, a.id as itemid, c.id as flowid, a.name||'????????(<font color=red>'||cc.realname||'</font>)' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(c.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, 0 as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a join t_waitprocess c on c.infoid = a.id and c.ifview=0 --???? 0??? and c.wptype=0 --???? and c.infotype=4 --????4 ?????? and c.infotimetype=0 --???????? 0??? --and c.wpuserid =2320--??id left join sec_user cc on cc.user_id = c.processuserid left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid=60 and c.id= (select max(id) from t_waitprocess wp where wp.infoid = a.id and wp.ifview=0 --???? 0??? and wp.wptype=0 --???? and wp.infotype=4 --????4 ?????? and wp.infotimetype=0 --???????? 0??? ) --??????? union all select '6' as auditkind, a.id as itemid, c.id as flowid, a.name||'?????????(<font color=red>'||cc.realname||'</font>)' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'| |to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(c.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, 0 as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a join t_waitprocess c on c.infoid = a.id and c.ifview=0 --???? 0??? and c.wptype=0 --???? and c.infotype=5 --????5 ??????? and c.infotimetype=0 --???????? 0??? --and c.wpuserid =2320--??id left join sec_user cc on cc.user_id = c.processuserid left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid=60 and c.id= (select max(id) from t_waitprocess wp where wp.infoid = a.id and wp.ifview=0 --???? 0??? and wp.wptype=0 --???? and wp.infotype=5 --????5 ??????? and wp.infotimetype=0 --???????? 0??? ) --????? union all select * from( select '7' as auditkind, a.id as itemid, 0 as flowid, a.name||'?????, ???????????' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildu nit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(es.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, (select count(*) from t_item_bargain bar where bar.itemid=a.id) as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a left join t_item_establish es on es.itemid = a.id left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid=60 )aa where aa.num=0 --???? union all select * from (select '8' as auditkind, a.id as itemid, 0 as flowid, '??? ' || a.name || ' ??' || to_char(sysdate, 'MM') || '??' as name, '????:' || a.name || '<br>????:' || ba.name || '<br>????:' || a.buildunit || '<br>??:' || g.name || '<br>?????:' || a.itemprincipa l || '<br>???:' || j.realname || '<br>??????(?):' || a.totalmoney1 || '<br>????:' || to_char(a.starttime, 'yyyy-MM-dd') || '~' || to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(trunc(sysdate, 'Q'), 'yyyy-MM-dd') as setime, a.itemflowid, (select count(*) from t_item_yuebao yuebao where yuebao.month =to_char(sysdate, 'yyyy-MM') and yuebao.itemid = a.id) as num from (select item1.* from t_item item1 where item1.adduserid =2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id = user1.itemid and user1.userid =2320) a left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype = h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid >=60 and a.itemflowid<80) aa where aa.num = 0 --????? union all select '12' as auditkind, a.id as itemid, af.id as flowid, a.name||'????????????????' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:' ||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(af.addtime, 'yyyy-MM-dd') as setime, 0 as itemflowid, 0 as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a join t_item_afterevaluate af on af.itemid=a.id and (af.infostate = -1 or af.infostate = -2) left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid=120 --???????????? union all select '13' as auditkind, a.id as itemid, 0 as flowid, case when b.jdtime>sysdate then a.name||'???????????, ?????'||to_char(b.jdtime, 'YYYY-MM-DD') else a.name||'???'||a.name||'??????' end as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemp rincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd') as title, to_char(b.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, 0 as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a join t_item_appraisal b on a.id = b.itemid and b.jdadvice is null and b.infostate=1 and b.isbackup=1 left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid where a.itemflowid=80 --???(???) union all select * from ( select '23' as auditkind, a.id as itemid, 0 as flowid, a.name||'?????, ???????' as name, '????:'||a.name|| '<br>????:'||ba.name|| '<br>????:'||a.buildunit|| '<br>??:'||g.name|| '<br>?????:'||a.itemprincipal|| '<br>???:'||j.realname|| '<br>??????(?):'||a.totalmoney1|| '<br>????:'||to_char(a.starttime, 'yyyy-MM-dd')||'~'||to_char(a.endtime, 'yyyy-MM-dd' ) as title, to_char(b.addtime, 'yyyy-MM-dd') as setime, a.itemflowid, ( select count(*) from t_item_establish est where est.itemid=a.id) as num from ( select item1.* from t_item item1 where item1.adduserid=2320 union select item2.* from t_item item2 join t_item_user user1 on item2.id=user1.itemid and user1.userid=2320 ) a left join t_itemflow_log b on a.id = b.iteminfoid and b.ifprocess=0 left join t_item_establish es on es.itemid = a.id left join t_company e on e.orgid = a.companyid left join t_itemflow f on f.id = a.itemflowid left join t_company_part g on g.id = a.partid left join t_config_infotype h on a.classtype=h.id left join t_config_infotype i on i.id = a.itemtype left join sec_user j on j.user_id = a.adduserid left join t_item_batch ba on ba.id = a.batchid --where a.itemflowid>=50 and a.companyid=41037 where a.itemflowid=60 and a.companyid=41037 )aa where aa.num=0 union all select auditkind, itemid, flowid, '??'||aaa.num||'?????????' as name, title, setime, itemflowid, num from( select '25' as auditkind, 0 as itemid, 0 as flowid, '' as name, '' as title, '' as setime, 0 as itemflowid, aa.COUNT_ as num from (select count(1) as COUNT_ from t_teamachievement a join T_TEAMACHIEVEMENT_PASS b on a.passid = b.id and b.passuserid = 2320) aa )aaa where aaa.num>0 ) order by setime desc ) a where rownum <= :1 ) b where linenum > :2
1a2th0cazcmfg	select to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')-updatepwdtime from mulu_user where cn='zhangdesheng' and to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')>add_months(updatepwdtime, validtime)
1tpyhtn6pyqk7	SELECT EDTREELOG_TB_SEQ.NEXTVAL FROM DUAL
29qjtb2fpytvx	select sum(e.totalmoney2) lxmoney, sum(p.paymoney) bofu, sum(u.moneynum) fasheng from t_item_establish e join t_item t1 on e.itemid = t1.id and t1.companyid=41018 left join t_item_paymoney p on t1.id = p.itemid left join t_item_usemoney u on t1.id = u.itemid where e.addtime between add_months(SYSDATE, -6) and SYSDATE and p.addtime between add_months(SYSDATE, -6) and SYSDATE and u.addtime between add_months(SYSDATE, -6) and SYSDATE
2hxc5a45f6611	select rowid, BH, FSBH, HM, WJ, FSZT, CWCS FROM FAX_FSDL WHERE SCBZ=0 AND ( XLH=:1 OR XLH=-1 )AND( FSZT=0 OR FSZT=3 AND CWCS<9 AND CSSJ<=:2 ) AND( WJ IS NOT NULL )AND( HM IS NOT NULL ) ORDER BY FSJB ASC, FSZT ASC, CWCS ASC, FSSJ ASC
2kv4anr9gpzcx	select dxp_I_draw_schedule.code, dxp_I_draw_schedule.year_diff, dxp_I_draw_schedule.month_diff, dxp_I_draw_schedule.day_diff, dxp_I_draw_schedule.nexttime, to_char(dxp_I_draw_schedule.intervaldate), to_char(dxp_I_draw_schedule.intervaltime), dxp_I_draw_schedule.type, report_info.is_year, dxp_I_draw_schedule.starttime, dxp_I_draw_schedule.endtime from dxp_I_draw_schedule, report_info where dxp_I_draw_schedule.code=report_info.code
2mu1u9cmpbv7t	select CZYID, JGBH, MC, MM, DH, SJ, XX, CZLB, ZXBZ, XB, ZP, BMGW, ZC, MSN, DLSJ, DLCS, BZSM from GG_CZYB
2u71ukp18t4yf	select rowid, BH, SJR, WD, FSJB, XLH FROM FAX_FSRW WHERE FSLB=1 AND LB=:1 AND ZT=0 AND DSY<=:2 AND DSR<=:3 AND DSS<=:4 AND DSF<=:5 ORDER BY FSJB ASC, ZGSJ ASC
3xvwqk6bn6vyb	select to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')-updatepwdtime from mulu_user where cn='wangpeijia' and to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')>add_months(updatepwdtime, validtime)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5wbraag0mtrr3	select value from init_para where name='ReportServer_Path'
6n32g2gmn3f1w	select LXRID, XM, XB, SJ, BZ, YHMXID, DW, BM, ZW, YX, DH, YB, DZ from MISP_LXR where (XM like'137%' or SJ like '137%' ) and ( yhmxid ='1646' or lxrid in (select yhid from misp_txlmx where txlid in(select id from misp_txl where lx='2' and (bz='2' and jgbh in(004100110018)or (bz='1' and substr(jgbh, 0, 8) in (00410011)))))) order by nlssort(XM, 'NLS_SORT=SCHINESE_PINYIN_M')
6p3vhs91w8ca5	select ID, SENDER, RECEIVER, MESSAGE from EXCHANGEMSG where STATUS=1 and DIRECTION=2 order by ID
6py30612fg63q	select LXRID, XM, XB, SJ, BZ, YHMXID, DW, BM, ZW, YX, DH, YB, DZ from MISP_LXR where (XM like'13837%' or SJ like '13837%' ) and ( yhmxid ='781' or lxrid in (select yhid from misp_txlmx where txlid in(select id from misp_txl where lx='2' and (bz='2' and jgbh in(004101210105)or (bz='1' and substr(jgbh, 0, 8) in (00410121)))))) order by nlssort(XM, 'NLS_SORT=SCHINESE_PINYIN_M')
6ukrs1d8a3akv	select CZYID, JGBH, MC, MM, DH, SJ, XX, CZLB, ZXBZ, XB, ZP, BMGW, ZC, MSN, DLSJ, DLCS, BZSM from GG_CZYB where CZYID = :1
6zz06abjfwwf8	update EXCHANGEMSG set STATUS=1 where STATUS=0 and DIRECTION=2
82d3cfudv18cr	select INIT_PARA.VALUE , INIT_PARA.NAME from INIT_PARA where (INIT_PARA.NAME = 'AutoSendMonthTime')
84ddngs592kns	delete EXCHANGEMSG where STATUS=1 and DIRECTION=2
865vq5dwxbz0d	SELECT SPENDTIME FROM DA_EXAMRESULT WHERE PLAN_ID='8a6692013c3bb8f8013c3d74f2ee0568' AND USER_ID='41042519840906001X'
9jhkxmdsh9bax	select value from init_para where name='XmlBakPath'
9mq0gmr1y4w65	select LXRID, XM, XB, SJ, BZ, YHMXID, DW, BM, ZW, YX, DH, YB, DZ from MISP_LXR where (XM like'1383%' or SJ like '1383%' ) and ( yhmxid ='6690' or lxrid in (select yhid from misp_txlmx where txlid in(select id from misp_txl where lx='2' and (bz='2' and jgbh in(004100150003)or (bz='1' and substr(jgbh, 0, 8) in (00410015)))))) order by nlssort(XM, 'NLS_SORT=SCHINESE_PINYIN_M')
9nmnbnxfz49cn	SELECT * FROM ( SELECT ROW_.*, ROWNUM ROWNUM_ FROM ( SELECT ORG_ID, ORDER_ID, USER_ID, PARENT_ID, ORG_NAME, USER_NAME, USER_DUTY, UNIT_TYPE FROM AJ_T_ZJ_THREESAFENET WHERE ORG_ID=9999404267 order by ORDER_ID ) ROW_ WHERE ROWNUM <= :1) WHERE ROWNUM_ > :2
9ybujhqnhwav4	SELECT Resource_SID from AgContents WHERE Resource_SID=:1
a1gavphjwh5tn	select to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')-updatepwdtime from mulu_user where cn='wangying2' and to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')>add_months(updatepwdtime, validtime)
a5k6mdr4n28j1	select LXRID, XM, XB, SJ, BZ, YHMXID, DW, BM, ZW, YX, DH, YB, DZ from MISP_LXR where (XM like'1393%' or SJ like '1393%' ) and ( yhmxid ='5970' or lxrid in (select yhid from misp_txlmx where txlid in(select id from misp_txl where lx='2' and (bz='2' and jgbh in(00410027)or (bz='1' and substr(jgbh, 0, 8) in (00410027)))))) order by nlssort(XM, 'NLS_SORT=SCHINESE_PINYIN_M')
abu2bxv8jd3tu	INSERT INTO JJFL.COMMON_USERS(ACCOUNT, PASSWORD, USERNAME, SGLAWLOGINENABLE, LOGINDISABLED, DEPARTMENT) VALUES (:1, :2, :3, :4, :5, :6)
af373vvc94dpq	select ID, JGBH, YHID from MISP_JGMX where yhid='15936909156'
b4zk191s0t3fg	select to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')-updatepwdtime from mulu_user where cn='zongdezhi' and to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')>add_months(updatepwdtime, validtime)
b76gp8ch20qr9	select ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S%' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000487' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000487' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000559' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000559' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000562' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000562' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000564' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000564' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000565' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000565' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000568' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000568' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000569' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000569' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000571' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000571' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000573' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000573' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000575' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000575' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000577' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000577' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000579' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000579' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000580' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000580' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000581' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000581' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000583' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh. corporation_id like 'S00000000000583' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000585' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000585' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000587' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000587' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000589' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000589' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000591' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000591' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000555' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000555' AND poh.LOGIN_T IME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S00000000000593' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S00000000000593' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S41000000007661' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S41000000007661' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon WHERE pon.corporation_id like 'S41000000016607' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh WHERE poh.corporation_id like 'S41000000016607' AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') ) from dual
bunvx480ynf57	SELECT 1 FROM DUAL
cd21m11ra4fcx	select JGBH, JGMC, GLYID, DWDZ, DWCZH, DWZJ, XSSX, SJBH from GG_JGBH where JGBH = :1
cxryjk2b9ftnp	select MISP_ZLDX_DXID.nextval from dual
d1pz5p8jwk86u	select to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')-updatepwdtime from mulu_user where cn='zhanghuawei2' and to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')>add_months(updatepwdtime, validtime)
dq2n3k5qx4zky	select LXRID, XM, XB, SJ, BZ, YHMXID, DW, BM, ZW, YX, DH, YB, DZ from MISP_LXR where (XM like'13803%' or SJ like '13803%' ) and ( yhmxid ='781' or lxrid in (select yhid from misp_txlmx where txlid in(select id from misp_txl where lx='2' and (bz='2' and jgbh in(004101210105)or (bz='1' and substr(jgbh, 0, 8) in (00410121)))))) order by nlssort(XM, 'NLS_SORT=SCHINESE_PINYIN_M')
fc47q236ryhbf	update dxp_monitor_heart_log a set a.heart_time = sysdate where upper(a.monitor_name) = 'SCHEDULE'
fzdsu9c27zqax	select to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')-updatepwdtime from mulu_user where cn='hanlei' and to_date(to_char(sysdate, 'yyyy-mm-dd'), 'yyyy-mm-dd')>add_months(updatepwdtime, validtime)
g524gj33dg2mk	SELECT * FROM ( SELECT ROW_.*, ROWNUM ROWNUM_ FROM ( SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_af98dd529c0_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:1 AND P.PRO_STARTED_TIME<=:2 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCES S_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_3a7aaa31d61_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:3 AND P.PRO_STARTED_TIME<=:4 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_3dfc3fdaa3_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:5 AND P.PRO_STARTED_TIME<=:6 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_1fff41bda1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:7 AND P.PRO_STARTED_TIME<=:8 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESER VE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_16053f53e1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:9 AND P.PRO_STARTED_TIME<=:10 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_3ea4a565b1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:11 AND P.PRO_STARTED_TIME< =:12 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_f9f4e2a1996_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:13 AND P.PRO_STARTED_TIME<=:14 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_ NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7f59fede84_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:15 AND P.PRO_STARTED_TIME<=:16 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_a88aac62c41_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:17 AND P.PRO_STARTED_TIME<=:18 UNION SELEC T P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_6500ab027d7_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:19 AND P.PRO_STARTED_TIME<=:20 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_T IME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_233d3773591_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:21 AND P.PRO_STARTED_TIME<=:22 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7cf58be2f41_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:23 AND P.PRO_STARTED_TIME<=:24 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_1ed73e63b51_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:25 AND P.PRO_STARTED_TIME<=:26 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFI NITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_f98a5c213c4_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:27 AND P.PRO_STARTED_TIME<=:28 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_e0c2d41f03_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:29 AND P.PRO_STARTED_TIME<=:30 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.R ESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_e13e9f610f0_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:31 AND P.PRO_STARTED_TIME<=:32 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.REA D_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_64de0102ed5_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:33 AND P.PRO_STARTED_TIME<=:34 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7f112c77fb_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:35 AND P.PRO_STARTED_TIME<=:36 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_1cae5be28d1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:37 AND P.PRO_STARTED_TIME<=:38 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCE SS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_38f4e4f3c0_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:39 AND P.PRO_STARTED_TIME<=:40 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_a8e0c9533c1_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:41 AND P.PRO_STARTED_TIME<=:42 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_N AME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_266e561d55_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:43 AND P.PRO_STARTED_TIME<=:44 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJEC T FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_64386582623_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:45 AND P.PRO_STARTED_TIME<=:46 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7ee47433479_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:47 AND P.PRO_STARTED_TIME<=:48 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_N AME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_058ff981a41_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:49 AND P.PRO_STARTED_TIME<=:50 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_ LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_57f88342c11_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:51 AND P.PRO_STARTED_TIME<=:52 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_26946152c97_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:53 AND P.PRO_STARTED_TIME<=:54 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESC RIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_f92530c472_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:55 AND P.PRO_STARTED_TIME<=:56 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P .STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_db1e3741b23_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:57 AND P.PRO_STARTED_TIME<=:58 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7f70abb272f_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:59 AND P.PRO_STARTED_TIME<=:60 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_C URRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_792b7c62c41_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:61 AND P.PRO_STARTED_TIME<=:62 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_79424851873_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:63 AND P.PRO_STARTED_TIME<=:64 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_9a1ecacf11_Wor1' AND P.PROCESS_TYPE = 'proxy' ???????????????????????????????????????????????????????????????????????????????????????????????ON SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_D??????????????????????????????????????? ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_e057ce91132_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:69 AND P.PRO_STARTED_TIME<=:70 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_640754f1d21_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:71 AND P.PRO_STARTED_TIME<=:72 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_b3a2ebe2491_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:73 AND P.PRO_STARTED_TIME<=:74 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_S TATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_14fe5e81a51_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:75 AND P.PRO_STARTED_TIME<=:76 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_23498ca3913_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:77 AND P.PRO_STARTED_TIME<=:78 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAM E, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_3d6731a1b11_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:79 AND P.PRO_STARTED_TIME<=:80 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('c losed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_201abae3e3_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:81 AND P.PRO_STARTED_TIME<=:82 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7e6a40036f5_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:83 AND P.PRO_STARTED_TIME<=:84 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P. SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_6d5ac10161_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:85 AND P.PRO_STARTED_TIME<=:86 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_dd362de2ae3_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:87 AND P.PRO_STARTED_TIME<=:88 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_7f4c4073a6d_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:89 AND P.PRO_STARTED_TIME<=:90 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE _ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_42adcbd931_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:91 AND P.PRO_STARTED_TIME<=:92 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.termina ted', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_4305d8d24d2_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:93 AND P.PRO_STARTED_TIME<=:94 UNION SELECT P.PROCESS_ID, P.PRIORITY, P.RESOURCE_REQ_ID, P.RESOURCE_REQ_NAME, P.PROCESS_NAME, P.PRO_DESCRIPTION, P.PRO_CURRENT_STATE, P.PRO_STARTED_TIME, P.ACTIVITY_ID, P.ACT_DEFINITION_ID, P.ACT_CURRENT_STATE, P.ACTIVITY_NAME, P.FORM_ID, P.SOURCE_REFERENCE_ID, P.PREVIOUS_ACTIVITY, P.PREVIOUS_ACTIVITY_NAME, P.PREVIOUS_RESOURCE, P.PREVIOUS_RESOURCE_NAME, P.USER_ID, P.WORK_ORDER, P.USER_NAME, P.RESOURCE_TYPE, P.FROM_DATE, P.THRU_DATE, P.STATUS_ID, P.PROCESS_TYPE, P.PROCESS_RESERVE_TYPE_ID, P.MGR_NAME, P.CREATE_TIME, P.PRO_DEFINITION_ID, P.READ_MARK , P.PROCESS_NAME AS SUBJECT FROM WF_TASK_LIST P WHERE P.STATUS_ID NOT IN ('TASK_COMPLETED', 'TASK_DELEGATED', 'TASK_CANCELLED', 'TASK_SENT') and P.ACT_CURRENT_STATE not in ('closed.completed', 'closed.terminated', 'closed.aborted') AND P.RESOURCE_TYPE='HUMAN' AND P.PRO_DEFINITION_ID='Package_9a4461d2993_Wor1' AND P.PROCESS_TYPE = 'proxy' AND P.USER_ID = 'O00000000014431' AND P.PRO_STARTED_TIME>=:95 AND P.PRO_STARTED_TIME<=:96 ORDER BY PRO_STARTED_TIME DESC ) ROW_ WHERE ROWNUM <= :97) WHERE ROWNUM_ > :98

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

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Top

Advisory Statistics

• Instance Recovery Stats
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin snapshot, E: End snapshot

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

• B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

• only enqueues with waits are shown
• Enqueue stats gathered prior to 10g should not be compared with 10g data
• ordered by Wait Time desc, Waits desc

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

• Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
• STO - Snapshot Too Old count, OOS - Out of Space count
• Undo segment block stats:
• uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
• eS - expired Stolen, eR - expired Released, eU - expired reUsed

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

Back to Undo Statistics
Back to Top

Latch Statistics

• Latch Activity
• Latch Sleep Breakdown
• Latch Miss Sources
• Parent Latch Statistics
• Child Latch Statistics

Latch Activity

• "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
• "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
• "Pct Misses" for both should be very close to 0.0