Back to OIM Explorer

dbo.CPL_FTCCSESetCheckWithPWO

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

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

SQL52 lines
1CREATE FUNCTION dbo.CPL_FTCCSESetCheckWithPWO(2  @ObjecKeysOfPWO QBM_YParameterList READONLY3) RETURNS TABLE4AS5RETURN(6SELECT7  ps.UID_ESet AS UID_ESet,8  ps.UID_ComplianceRule AS UID_ComplianceRule9FROM(10SELECT11  sr.UID_ComplianceRule, sr.UID_ComplianceSubRule, bho.UID_ESet12FROM ComplianceSubRule sr13JOIN ComplianceSubRuleObject cm14  ON cm.uid_ComplianceSubRule = sr.uid_ComplianceSubRule15JOIN(16SELECT17  bo.UID_ESet, bo.Entitlement AS ObjectKey18FROM ESetHasEntitlement bo19JOIN ESet es20  ON bo.UID_ESet = es.UID_ESet21JOIN(22SELECT pwo.ObjectKeyOrgUsedInAssign23FROM PersonWantsOrg pwo24JOIN @ObjecKeysOfPWO o25  ON pwo.XObjectKey = o.Parameter1) AS s26  ON s.ObjectKeyOrgUsedInAssign = es.XObjectKey27WHERE28  bo.Entitlement NOT LIKE '<Key><T>ESet</T>%'29UNION30SELECT31  es.UID_ESet, pwo.ObjectKeyElementUsedInAssign32FROM PersonWantsOrg pwo33JOIN @ObjecKeysOfPWO o34  ON pwo.XObjectKey = o.Parameter135JOIN ESet es36  ON pwo.ObjectKeyOrgUsedInAssign = es.XObjectKey) AS bho37  ON bho.Objectkey = cm.ObjectKeyElement38GROUP BY sr.UID_ComplianceRule, sr.UID_ComplianceSubRule, sr.CountMatchesMin, bho.UID_ESet39HAVING COUNT(cm.ObjectKeyElement) >= CASE sr.CountMatchesMin40WHEN 0 THEN41142ELSE sr.CountMatchesMin43END) AS ps44JOIN compliancerule cr45  ON ps.uid_complianceRule = cr.uid_complianceRule AND cr.IsInActive = 0 AND cr.IsWorkingCopy = 046GROUP BY ps.UID_ESet,47ps.UID_ComplianceRule48HAVING count(DISTINCT ps.uid_ComplianceSubRule) =(49SELECT count(*)50FROM ComplianceSubrule51WHERE52  uid_complianceRule = ps.UID_ComplianceRule))
Open raw exported source
SQL ยท Raw11 lines
1create function dbo.CPL_FTCCSESetCheckWithPWO (@ObjecKeysOfPWO QBM_YParameterList readonly ) returns table as return( select ps.UID_ESet as UID_ESet , 2ps.UID_ComplianceRule as UID_ComplianceRule from ( select sr.UID_ComplianceRule, sr.UID_ComplianceSubRule, bho.UID_ESet from ComplianceSubRule sr join 3ComplianceSubRuleObject cm on cm.uid_ComplianceSubRule = sr.uid_ComplianceSubRule join ( select bo.UID_ESet, bo.Entitlement as ObjectKey  from ESetHasEntitlement4 bo join ESet es on bo.UID_ESet = es.UID_ESet join (select pwo.ObjectKeyOrgUsedInAssign from PersonWantsOrg pwo join @ObjecKeysOfPWO o on pwo.XObjectKey5 = o.Parameter1 ) as s on s.ObjectKeyOrgUsedInAssign = es.XObjectKey where bo.Entitlement not like '<Key><T>ESet</T>%' union  select es.UID_ESet, pwo.ObjectKeyElementUsedInAssign6 from PersonWantsOrg pwo join @ObjecKeysOfPWO o on pwo.XObjectKey = o.Parameter1 join ESet es on pwo.ObjectKeyOrgUsedInAssign = es.XObjectKey ) as bho 7on bho.Objectkey = cm.ObjectKeyElement group by sr.UID_ComplianceRule, sr.UID_ComplianceSubRule, sr.CountMatchesMin, bho.UID_ESet having COUNT(cm.ObjectKeyElement8) >= case sr.CountMatchesMin when 0 then 1 else sr.CountMatchesMin end ) as ps join compliancerule cr on ps.uid_complianceRule = cr.uid_complianceRule 9and cr.IsInActive = 0 and cr.IsWorkingCopy = 0 group by ps.UID_ESet, ps.UID_ComplianceRule having count(distinct ps.uid_ComplianceSubRule) = (select count10( * ) from ComplianceSubrule where uid_complianceRule = ps.UID_ComplianceRule ) ) 11