select
  inst_id,                                 -- INST_ID NUMBER
  child_idx,                               -- CHILD_IDX NUMBER
  parent_idx,                              -- PARENT_IDX NUMBER
  sub_num,                                 -- SUB_NUM NUMBER
  to_number(                               -- SUB_SIZE NUMBER
    decode(sub_size,4294967295,NULL,sub_size)),
  to_number(                               -- ELEM_OFFSET NUMBER
    decode(elem_offset,4294967295,NULL,elem_offset)),
  sub_flags                                -- SUB_FLAGS NUMBER
from
  x$ksfmsubelem
where
  child_idx != 4294967295