Query related to task in informatica

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

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

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