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
ReplyDeleteIam really enjoy to read your blog! it's very informative article..
Japanese Classes in Chennai
learn Japanese in Chennai
German Language Course in Chennai
Japanese Course in Chennai
IELTS Training in Chennai
TOEFL Training in Chennai
pearson vue
Japanese Classes in Porur
Japanese Classes in vadapalani
Japanese Classes in Thiruvanmiyur
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai
ReplyDeleteSpring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.
Spring Training in Chennai
The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training