Back to OIM Explorer

dbo.QER_FTAccountInheritFromOrg_L

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 970 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL31 lines
1CREATE FUNCTION dbo.QER_FTAccountInheritFromOrg_L(2  @PersonList dbo.QBM_YSingleGUID READONLY,3  @UID_BaseTreeAssignToUse varchar(38)4) RETURNS TABLE5  WITH schemabinding6AS7RETURN(8SELECT9  po.UID_Person AS UID_Person,10  po.UID_Org AS UID_Org,11  po.IsSecurityIncident AS IsSecurityIncident12FROM(13SELECT14  hpo.UID_Person, hpo.UID_Org, p.IsSecurityIncident15FROM @PersonList l16JOIN dbo.Person p17  ON l.UID_SingleGuid = p.UID_Person AND p.IsNoInherite = 018JOIN dbo.HelperPersonOrg hpo19  ON p.UID_Person = hpo.UID_Person20UNION21SELECT22  hpo.UID_Person, hpo.UID_Org, p.IsSecurityIncident23FROM @PersonList l24JOIN dbo.Person p25  ON l.UID_SingleGuid = p.UID_Person AND p.IsNoInherite = 026JOIN dbo.PersonInBaseTree hpo27  ON p.UID_Person = hpo.UID_Person) AS po28JOIN dbo.BaseTree b29  ON po.UID_Org = b.UID_Org AND b.IsNoInheriteToPerson = 030JOIN dbo.OrgRootAssign oa31  ON oa.UID_OrgRoot = b.UID_OrgRoot AND oa.IsAssignmentAllowed = 1 AND oa.UID_BaseTreeAssign = @UID_BaseTreeAssignToUse)
Open raw exported source
SQL ยท Raw8 lines
1create function dbo.QER_FTAccountInheritFromOrg_L( @PersonList dbo.QBM_YSingleGUID readonly  , @UID_BaseTreeAssignToUse varchar(38) ) returns table with2 schemabinding as return( select po.UID_Person as UID_Person , po.UID_Org as UID_Org , po.IsSecurityIncident as IsSecurityIncident from ( select hpo.UID_Person3, hpo.UID_Org, p.IsSecurityIncident from @PersonList l join dbo.Person p on l.UID_SingleGuid = p.UID_Person and p.IsNoInherite = 0 join dbo.HelperPersonOrg4 hpo on p.UID_Person = hpo.UID_Person union select hpo.UID_Person, hpo.UID_Org, p.IsSecurityIncident from @PersonList l join dbo.Person p on l.UID_SingleGuid5 = p.UID_Person and p.IsNoInherite = 0 join dbo.PersonInBaseTree hpo on p.UID_Person = hpo.UID_Person ) as po join dbo.BaseTree b on po.UID_Org = b.UID_Org6 and b.IsNoInheriteToPerson = 0 join dbo.OrgRootAssign oa on oa.UID_OrgRoot = b.UID_OrgRoot and oa.IsAssignmentAllowed = 1 and oa.UID_BaseTreeAssign = 7@UID_BaseTreeAssignToUse ) 8