Back to OIM Explorer

dbo.QER_FTPersonInheritFromOrg_L

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 868 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

SQL29 lines
1CREATE FUNCTION dbo.QER_FTPersonInheritFromOrg_L(2  @DBQueueCurrent dbo.QBM_YDBQueueCurrent 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  pe.IsSecurityIncident AS IsSecurityIncident12FROM(13SELECT14  hpo.UID_Person, hpo.UID_Org15FROM @DBQueueCurrent p16JOIN dbo.HelperPersonOrg hpo17  ON p.UID_Parameter = hpo.UID_Person18UNION19SELECT20  pio.UID_Person, pio.UID_Org21FROM @DBQueueCurrent p22JOIN dbo.PersonInBaseTree pio23  ON p.UID_Parameter = pio.UID_Person) AS po24JOIN dbo.Person pe25  ON po.UID_Person = pe.UID_Person AND pe.IsNoInherite = 026JOIN dbo.BaseTree b27  ON po.UID_Org = b.UID_Org AND b.IsNoInheriteToPerson = 028JOIN dbo.OrgRootAssign oa29  ON oa.UID_OrgRoot = b.UID_OrgRoot AND oa.IsAssignmentAllowed = 1 AND oa.UID_BaseTreeAssign = @UID_BaseTreeAssignToUse)
Open raw exported source
SQL ยท Raw7 lines
1create function dbo.QER_FTPersonInheritFromOrg_L( @DBQueueCurrent dbo.QBM_YDBQueueCurrent readonly , @UID_BaseTreeAssignToUse varchar(38) ) returns table2 with schemabinding as return( select po.UID_Person as UID_Person , po.UID_Org as UID_Org , pe.IsSecurityIncident as IsSecurityIncident from ( select hpo.UID_Person3, hpo.UID_Org from @DBQueueCurrent p join dbo.HelperPersonOrg hpo on p.UID_Parameter = hpo.UID_Person union select pio.UID_Person, pio.UID_Org from @DBQueueCurrent4 p join dbo.PersonInBaseTree pio on p.UID_Parameter = pio.UID_Person ) as po join dbo.Person pe on po.UID_Person = pe.UID_Person and pe.IsNoInherite = 50 join dbo.BaseTree b on po.UID_Org = b.UID_Org and b.IsNoInheriteToPerson = 0 join dbo.OrgRootAssign oa on oa.UID_OrgRoot = b.UID_OrgRoot and oa.IsAssignmentAllowed6 = 1 and oa.UID_BaseTreeAssign = @UID_BaseTreeAssignToUse ) 7