Back to OIM Explorer

dbo.CPL_FTCCSESetCheckWithPWODet

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.191 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.CPL_FTCCSESetCheckWithPWO source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL42 lines
1CREATE FUNCTION dbo.CPL_FTCCSESetCheckWithPWODet(2  @ObjecKeysOfPWO QBM_YParameterList READONLY3) RETURNS TABLE4AS5RETURN(6SELECT7  bho.UID_ESet AS UID_ESet,8  cs.UID_ComplianceRule AS UID_ComplianceRule,9  cs.UID_ComplianceSubrule AS UID_ComplianceSubrule,10  cm.ObjectKeyElement AS ObjectKeyElement11FROM(12SELECT13  bo.UID_ESet, bo.Entitlement AS ObjectKey14FROM ESetHasEntitlement bo15JOIN ESet es16  ON bo.UID_ESet = es.UID_ESet17JOIN(18SELECT pwo.ObjectKeyOrgUsedInAssign19FROM PersonWantsOrg pwo20JOIN @ObjecKeysOfPWO o21  ON pwo.XObjectKey = o.Parameter1) AS s22  ON s.ObjectKeyOrgUsedInAssign = es.XObjectKey23WHERE24  bo.Entitlement NOT LIKE '<Key><T>ESet</T>%'25UNION26SELECT27  es.UID_ESet, pwo.ObjectKeyElementUsedInAssign28FROM PersonWantsOrg pwo29JOIN @ObjecKeysOfPWO o30  ON pwo.XObjectKey = o.Parameter131JOIN ESet es32  ON pwo.ObjectKeyOrgUsedInAssign = es.XObjectKey) AS bho33JOIN ComplianceSubRuleObject cm34  ON bho.Objectkey = cm.ObjectKeyElement35JOIN ComplianceSubRule cs36  ON cm.uid_ComplianceSubRule = cs.uid_ComplianceSubRule37WHERE38  EXISTS(39SELECT TOP 1 140FROM dbo.CPL_FTCCSESetCheckWithPWO(@ObjecKeysOfPWO) v41WHERE42  v.UID_ESet = bho.UID_ESet AND v.uid_compliancerule = cs.uid_complianceRule))
Open raw exported source
SQL ยท Raw9 lines
1create function dbo.CPL_FTCCSESetCheckWithPWODet  (@ObjecKeysOfPWO QBM_YParameterList readonly ) returns table as return ( select bho.UID_ESet as UID_ESet2 , cs.UID_ComplianceRule as UID_ComplianceRule , cs.UID_ComplianceSubrule as UID_ComplianceSubrule , cm.ObjectKeyElement as ObjectKeyElement from ( select3 bo.UID_ESet, bo.Entitlement as ObjectKey  from ESetHasEntitlement bo join ESet es on bo.UID_ESet = es.UID_ESet join (select pwo.ObjectKeyOrgUsedInAssign4 from PersonWantsOrg pwo join @ObjecKeysOfPWO o on pwo.XObjectKey = o.Parameter1 ) as s on s.ObjectKeyOrgUsedInAssign = es.XObjectKey where bo.Entitlement5 not like '<Key><T>ESet</T>%' union select es.UID_ESet, pwo.ObjectKeyElementUsedInAssign from PersonWantsOrg pwo join @ObjecKeysOfPWO o on pwo.XObjectKey6 = o.Parameter1 join ESet es on pwo.ObjectKeyOrgUsedInAssign = es.XObjectKey ) as bho join ComplianceSubRuleObject cm on bho.Objectkey = cm.ObjectKeyElement7 join ComplianceSubRule cs on cm.uid_ComplianceSubRule = cs.uid_ComplianceSubRule  where exists (select top 1 1 from dbo.CPL_FTCCSESetCheckWithPWO(@ObjecKeysOfPWO8) v where v.UID_ESet = bho.UID_ESet and v.uid_compliancerule = cs.uid_complianceRule ) ) 9