Back to OIM Explorer

dbo.CPL_FTCCSOrgCheckWithPWO

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.205 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.QER_FTPWOAssigmentSplitForBHO source text reference

References

Referenced By

Complete Source

SQL40 lines
1CREATE FUNCTION dbo.CPL_FTCCSOrgCheckWithPWO(2  @ObjecKeysOfPWO QBM_YParameterList READONLY3) RETURNS TABLE4AS5RETURN(6SELECT7  ps.UID_Org AS UID_Org,8  ps.UID_ComplianceRule AS UID_ComplianceRule9FROM(10SELECT11  sr.UID_ComplianceRule, sr.UID_ComplianceSubRule, bho.UID_Org12FROM ComplianceSubRule sr13JOIN ComplianceSubRuleObject cm14  ON cm.uid_ComplianceSubRule = sr.uid_ComplianceSubRule15JOIN(16SELECT17  bo.UID_Org, bo.ObjectKey18FROM BaseTreehasobject bo19JOIN dbo.QER_FTPWOAssigmentSplitForBHO(@ObjecKeysOfPWO) zu20  ON bo.UID_Org = zu.UID_Org21UNION22SELECT23  zu.UID_Org, zu.ObjectKey24FROM dbo.QER_FTPWOAssigmentSplitForBHO(@ObjecKeysOfPWO) zu) AS bho25  ON bho.Objectkey = cm.ObjectKeyElement26GROUP BY sr.UID_ComplianceRule, sr.UID_ComplianceSubRule, sr.CountMatchesMin, bho.UID_Org27HAVING COUNT(cm.ObjectKeyElement) >= CASE sr.CountMatchesMin28WHEN 0 THEN29130ELSE sr.CountMatchesMin31END) AS ps32JOIN compliancerule cr33  ON ps.uid_complianceRule = cr.uid_complianceRule AND cr.IsInActive = 0 AND cr.IsWorkingCopy = 034GROUP BY ps.UID_Org,35ps.UID_ComplianceRule36HAVING count(DISTINCT ps.uid_ComplianceSubRule) =(37SELECT count(*)38FROM ComplianceSubrule39WHERE40  uid_complianceRule = ps.UID_ComplianceRule))
Open raw exported source
SQL ยท Raw9 lines
1create function dbo.CPL_FTCCSOrgCheckWithPWO (@ObjecKeysOfPWO QBM_YParameterList readonly )   returns table as return( select ps.UID_Org as UID_Org , ps.UID_ComplianceRule2 as UID_ComplianceRule from ( select sr.UID_ComplianceRule, sr.UID_ComplianceSubRule, bho.UID_Org from ComplianceSubRule sr join ComplianceSubRuleObject3 cm on cm.uid_ComplianceSubRule = sr.uid_ComplianceSubRule join ( select bo.UID_Org, bo.ObjectKey  from BaseTreehasobject bo join dbo.QER_FTPWOAssigmentSplitForBHO4(@ObjecKeysOfPWO) zu on bo.UID_Org = zu.UID_Org union select zu.UID_Org, zu.ObjectKey from dbo.QER_FTPWOAssigmentSplitForBHO(@ObjecKeysOfPWO) zu ) as bho5 on bho.Objectkey = cm.ObjectKeyElement group by sr.UID_ComplianceRule, sr.UID_ComplianceSubRule, sr.CountMatchesMin, bho.UID_Org having COUNT(cm.ObjectKeyElement6) >= case sr.CountMatchesMin when 0 then 1 else sr.CountMatchesMin end ) as ps join compliancerule cr on ps.uid_complianceRule = cr.uid_complianceRule 7 and cr.IsInActive = 0 and cr.IsWorkingCopy = 0  group by ps.UID_Org, ps.UID_ComplianceRule having count(distinct ps.uid_ComplianceSubRule) = (select count8( * ) from ComplianceSubrule where uid_complianceRule = ps.UID_ComplianceRule ) ) 9