SELECT sub.id id,
  sub.pz_sl_kod code,
  sub.pz_sl_opis label,
  sub.kto_sl_kod personCode,
  sub.przycz_sl_kod causeCode,
  sub.roszcz_sl_kod claimCode,
  ru.ru_id_ewv ru_id,
  ru.ru_code ru_code,
  ru.ru_definition ru_rule,
  conn.fr_type ru_type
FROM
  ( SELECT DISTINCT ora_hash(vrs.sl_rs_id_ewv
    ||sl.sl_id_ewv
    ||vrs.sl_kod_kto_ewv
    ||vrs.sl_kod_przycz_ewv,9999999) id,
    vrs.sl_kod_przycz_ewv przycz_sl_kod,
    vrs.sl_kod_kto_ewv kto_sl_kod,
    sl.sl_opis pz_sl_opis,
    vrs.sl_kod_pz_ewv pz_sl_kod,
    vrs.sl_rs_kod roszcz_sl_kod,
    sl.sl_lp pz_sl_lp
  FROM v_sw_roszczenia_podmiotow vrs
  LEFT JOIN sl_slowniki sl
  ON (sl.sl_kod             = vrs.sl_kod_pz_ewv
  AND sl.sl_typ_sl_id       = '30450')
  WHERE vrs.sl_typ_pz_ewv   = 'PZ'
  AND vrs.sl_kod_typ_rsc_ewv= 'ZD'
  AND vrs.pp_id_ewv         = '7926249134'
  ) sub
LEFT JOIN te_form_connection conn
ON (conn.ff_code        = 'ZZ_POW_ZACH'
AND conn.fo_id_ewv      = '1'
AND (conn.sl_code       = sub.pz_sl_kod
OR conn.sl_code         = 'ITEMS')
AND conn.re_id_ewv_from = '32700' )
LEFT JOIN te_form_rule ru
ON (ru.ru_code        = conn.ru_code
AND ru.fo_id_ewv      = '1'
AND ru.re_id_ewv_from = '32700')
LEFT JOIN te_form_message msg
ON (msg.fm_code        = conn.FM_CODE
AND msg.fo_id_ewv      = '1'
AND msg.re_id_ewv_from = '32700')
ORDER BY sub.pz_sl_lp;