select
  inst_id,                                 -- INST_ID NUMBER
  ksulosno,                                -- SID NUMBER
  ksulosrn,                                -- SERIAL# NUMBER
  ksulounm,                                -- USERNAME VARCHAR2(30)
  ksulopna,                                -- OPNAME VARCHAR2(64)
  ksuloif5d,                               -- ADVISOR_NAME VARCHAR2(64)
  ksuloctx,                                -- TASK_ID NUMBER
  ksulotde,                                -- TARGET_DESC VARCHAR2(32)
  ksulosfr,                                -- SOFAR NUMBER
  ksulotot,                                -- TOTALWORK NUMBER
  ksulouni,                                -- UNITS VARCHAR2(32)
  ksuloif3,                                -- BENEFIT_SOFAR NUMBER
  ksuloif4,                                -- BENEFIT_MAX NUMBER
  ksuloif0,                                -- FINDINGS NUMBER
  ksuloif1,                                -- RECOMMENDATIONS NUMBER
  ksuloif2,                                -- TIME_REMAINING NUMBER
  to_date(                                 -- START_TIME DATE
    ksulostm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_date(                                 -- LAST_UPDATE_TIME DATE
    ksulolut,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  ksuloetm,                                -- ELAPSED_SECONDS NUMBER
  decode(                                  -- ADVISOR_METRIC1 NUMBER
    ksuloif6d, null, to_number(null), ksuloif6),
  ksuloif6d,                               -- METRIC1_DESC VARCHAR2(64)
  ksuloif7d                                -- EXECUTION_TYPE VARCHAR2(64)
from
  x$ksulop
where
  ksulopna in ('Advisor')