select
  t1.inst_id,                              -- INST_ID NUMBER
  t1.ksllasnam,                            -- PARENT_NAME VARCHAR2(64)
  t2.ksllwnam,                             -- WHERE VARCHAR2(80)
  t1.kslnowtf,                             -- NWFAIL_COUNT NUMBER
  t1.kslsleep,                             -- SLEEP_COUNT NUMBER
  t1.kslwscwsl,                            -- WTR_SLP_COUNT NUMBER
  t1.kslwsclthg,                           -- LONGHOLD_COUNT NUMBER
  t2.ksllwnam                              -- LOCATION VARCHAR2(80)
from
  x$ksllw t2,
  x$kslwsc t1
where
  t2.indx = t1.indx