13.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
13.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
13.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
13.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
13.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
13.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
13.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
13.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
13.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
13.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
13.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