select
  pig.inst_id,                             -- INST_ID NUMBER
  kxfppigpig,                              -- QC_INSTANCE_GROUP VARCHAR2(64)
  decode(                                  -- WHY VARCHAR2(23)
    kxfppigsrc, 1, 'PARALLEL_INSTANCE_GROUP', 2, 'SERVICE', NULL),
  kxfpiginst                               -- INSTANCE_NUMBER NUMBER
from
  x$kxfppig pig,
  x$kxfpig ig
where
  pig.kxfppigpig = ig.kxfpigig