SELECT
                    evn.Evn_id as "Evn_id",
                    exml.EvnXml_id as "EvnXml_id"
                    FROM dbo.v_Evn evn
                    LEFT JOIN dbo.v_EvnXml exml ON exml.Evn_id = evn.Evn_id
                    JOIN dbo.v_EvnPS ON (v_EvnPS.EvnPS_id = evn.Evn_rid)

                    WHERE (evn.Evn_IsSigned = 2 or EvnXml_IsSigned = 2)AND (evn.lpu_id = '150007')
