
                    select
                        rtrim(COALESCE(l1.Lpu_Nick,'')) || ', ' || rtrim(COALESCE(pu1.pmUser_Name,'')) || ' ('||rtrim(COALESCE(pu1.pmUser_login,''))||')' as "InspmUser",
                        rtrim(COALESCE(l2.Lpu_Nick,'')) || ', ' || rtrim(COALESCE(pu2.pmUser_Name,'')) || ' ('||rtrim(COALESCE(pu2.pmUser_login,''))||')' as "UpdpmUser",
                        to_char(e.RegistryErrorTFOMS_updDT, 'DD.MM.YYYY HH24:MI') as "UpdDate",
                        to_char(e.RegistryErrorTFOMS_insDT, 'DD.MM.YYYY HH24:MI') as "InsDate"
                    from r18.v_RegistryErrorTFOMS e
                        left join v_pmUser pu1  on e.pmUser_insID = pu1.pmUser_id
                        left join v_Lpu l1  on pu1.Lpu_id = l1.Lpu_id
                        left join v_pmUser pu2  on e.pmUser_updID = pu2.pmUser_id
                        left join v_Lpu l2  on pu2.Lpu_id = l2.Lpu_id
                        
                    where
                        e.RegistryErrorTFOMS_id = '621241'
                        
                
