select
  tsk.INST_ID,                             -- INST_ID NUMBER
  stat.TASKNAME_KWQMNCTID,                 -- TASK_NAME VARCHAR2(32)
  tsk.TASK_NUMBER,                         -- TASK_NUMBER NUMBER
  decode (                                 -- TASK_TYPE VARCHAR2(40)
    stat.TASKTYPE_KWQMNCTID, 0, 'REPEATABLE_MULTIPLE', 1, 'REPEATABLE_SINGLE', 2, 'NONREPEATABLE_MULTIPLE', 3, 'NONREPEATABLE_SINGLE', 4, 'UNKNOWN', stat.TASKTYPE_KWQMNCTID),
  tsk.TASK_SUBMIT_TIME,                    -- TASK_SUBMIT_TIME TIMESTAMP(3) WITH TIME ZONE
  tsk.TASK_READY_TIME,                     -- TASK_READY_TIME TIMESTAMP(3) WITH TIME ZONE
  tsk.TASK_EXPIRY_TIME,                    -- TASK_EXPIRY_TIME TIMESTAMP(3) WITH TIME ZONE
  tsk.TASK_START_TIME,                     -- TASK_START_TIME TIMESTAMP(3) WITH TIME ZONE
  tsk.TASK_STATUS,                         -- TASK_STATUS VARCHAR2(32)
  tsk.SLAVE_NAME,                          -- SERVER_NAME VARCHAR2(64)
  tsk.TASK_RETRY,                          -- MAX_RETRIES NUMBER
  tsk.TASK_RUNS,                           -- NUM_RUNS NUMBER
  tsk.TASK_FAILURES                        -- NUM_FAILURES NUMBER
from
  X$KWQMNTASK tsk,
  X$KWQMNTASKSTAT stat
where
  tsk.TASK_ID = stat.TASKID_KWQMNCTID and tsk.INST_ID = stat.INST_ID