select
  inst_id,                                 -- INST_ID NUMBER
  number_kfgbrb,                           -- GROUP_NUMBER NUMBER
  'REBAL',                                 -- OPERATION CHAR(5)
  decode(                                  -- STATE VARCHAR2(4)
    error_kfgbrb, 0, decode(( 
      select
        state_kfgmg
      from
        x$kfgmg
      where
        number_kfgmg=number_kfgbrb and op_kfgmg = 1), 1, 'WAIT', 2, 'RUN', 3, 'REAP', 4, 'WAIT', 5, 'HALT', 6, 'ERRS', 'WAIT'), 'ERRS'), 
  power_kfgbrb,                            -- POWER NUMBER
  (                                        -- ACTUAL NUMBER
  select
    actual_kfgmg
  from
    x$kfgmg
  where
    number_kfgmg=number_kfgbrb and op_kfgmg = 1), 
  (                                        -- SOFAR NUMBER
  select
    sofar_kfgmg
  from
    x$kfgmg
  where
    number_kfgmg=number_kfgbrb and op_kfgmg = 1), 
  (                                        -- EST_WORK NUMBER
  select
    work_kfgmg
  from
    x$kfgmg
  where
    number_kfgmg=number_kfgbrb and op_kfgmg = 1), 
  (                                        -- EST_RATE NUMBER
  select
    rate_kfgmg
  from
    x$kfgmg
  where
    number_kfgmg=number_kfgbrb and op_kfgmg = 1), 
  (                                        -- EST_MINUTES NUMBER
  select
    time_kfgmg
  from
    x$kfgmg
  where
    number_kfgmg=number_kfgbrb and op_kfgmg = 1), 
  decode(                                  -- ERROR_CODE VARCHAR2(44)
    error_kfgbrb, 0, '', 'ORA-' || error_kfgbrb)
from
  x$kfgbrb
union all
select
  inst_id,                                 -- INST_ID NUMBER
  number_kfgmg,                            -- GROUP_NUMBER NUMBER
  'ONLIN',                                 -- OPERATION CHAR(5)
  'RUN',                                   -- STATE VARCHAR2(4)
  1,                                       -- POWER NUMBER
  0,                                       -- ACTUAL NUMBER
  0,                                       -- SOFAR NUMBER
  0,                                       -- EST_WORK NUMBER
  0,                                       -- EST_RATE NUMBER
  0,                                       -- EST_MINUTES NUMBER
  ''                                       -- ERROR_CODE VARCHAR2(44)
from
  x$kfgmg
where
  op_kfgmg = 4