dbo.QER_FTOrgAttHighest

1create function dbo.QER_FTOrgAttHighest (@uid_org varchar(38) , @uid_personinserted varchar(38)  , @uid_personordered varchar(38) , @WithFallBackRoot bit
2  , @IgnoreNoDecideForPerson bit  ) returns table as return ( select pib.UID_Org, pib.UID_Person, pwo.UID_PersonWantsOrg as UID_PWORulerOrigin from ( select
3 top 1 z.UID_Org from (select b.treelevel + 1 as treelevel, b.UID_OrgAttestator as UID_Org from BaseTreeCollection co join BaseTree b on co.UID_Org = @uid_org
4 and co.UID_ParentOrg = b.UID_Org   union all select 0, r.UID_OrgAttestator as uid_org from OrgRoot r join BaseTree b on b.UID_OrgRoot = r.UID_OrgRoot 
5and b.UID_Org = @uid_org where @WithFallBackRoot = 1 ) as z join PersonInBaseTree pio on z.UID_Org = pio.UID_Org and pio.XOrigin > 0 left outer join QER_VPersonsAreMe
6 api on pio.UID_Person = api.UID_PersonAlsoMe and api.UID_PersonOrigin = case when @uid_personinserted > ' ' and @IgnoreNoDecideForPerson = 0 and dbo.QBM_FGIConfigparmValue
7('QER\ITShop\PersonInsertedNoDecide') = '1' then @uid_personinserted else null end  left outer join QER_VPersonsAreMe apo on pio.UID_Person = apo.UID_PersonAlsoMe
8 and apo.UID_PersonOrigin = case when @uid_personordered > ' ' and @IgnoreNoDecideForPerson = 0 and dbo.QBM_FGIConfigparmValue('QER\ITShop\PersonOrderedNoDecide'
9) = '1' then @uid_personordered else null end  group by z.treelevel, z.UID_Org having min(api.UID_PersonAlsoMe ) is null and min(apo.UID_PersonAlsoMe )
10 is null order by z.treelevel desc  ) as oo join PersonInBaseTree pib on oo.UID_Org = pib.UID_Org left outer join PersonWantsOrg pwo on pwo.ObjectKeyAssignment
11 = pib.XObjectKey and pib.XOrigin > 0 and pwo.OrderState in ('Assigned', 'OrderProlongate', 'OrderUnsubscribe' ) ) 
12