10.1
List
Command tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (58)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.2
List
Decision tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (59)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.3
List
Event Wait tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (60)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.4
List
Event Raise tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (61)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.5
List
Start tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (62)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.6
List
Email tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (65)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.7
List
Timer tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (66)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.8
List
Assignment tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (67)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.9
List
Session tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (60)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.10
List
Control tasks
SELECT SUBJECT_AREA, TASK_TYPE_NAME, TASK_NAME
FROM REP_ALL_TASKS
WHERE TASK_TYPE IN (91)
--AND
SUBJECT_AREA= 'ABC'
ORDER BY 1, 2, 3
10.11
List
Command Task Value
SELECT distinct a.SUBJECT_AREA,a.TASK_NAME,a.TASK_TYPE_NAME,
b.pm_value, b.val_name
FROM REP_ALL_TASKS a, opb_task_val_list b
WHERE a.TASK_TYPE IN (58,59,60,65, 66,68,70,71)
and a.task_id = b.task_id
ORDER BY 1, 2, 3
No comments:
Post a Comment