Back to OIM Explorer

dbo.CPL_FTCCSOrgCheckWithPWODetail

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 885 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_FTCCSOrgCheckWithPWO source text reference
  • references source dbo.QER_FTPWOAssigmentSplitForBHO source text reference

References

Referenced By

Complete Source

SQL30 lines
1CREATE FUNCTION dbo.CPL_FTCCSOrgCheckWithPWODetail(2  @ObjecKeysOfPWO QBM_YParameterList READONLY3) RETURNS TABLE4AS5RETURN(6SELECT7  bho.UID_Org AS UID_Org,8  cs.UID_ComplianceRule AS UID_ComplianceRule,9  cs.UID_ComplianceSubrule AS UID_ComplianceSubrule,10  cm.ObjectKeyElement AS ObjectKeyElement11FROM(12SELECT13  bo.UID_Org, bo.ObjectKey14FROM BaseTreehasobject bo15JOIN dbo.QER_FTPWOAssigmentSplitForBHO(@ObjecKeysOfPWO) zu16  ON bo.UID_Org = zu.UID_Org17UNION18SELECT19  zu.UID_Org, zu.ObjectKey20FROM dbo.QER_FTPWOAssigmentSplitForBHO(@ObjecKeysOfPWO) zu) AS bho21JOIN ComplianceSubRuleObject cm22  ON bho.Objectkey = cm.ObjectKeyElement23JOIN ComplianceSubRule cs24  ON cm.uid_ComplianceSubRule = cs.uid_ComplianceSubRule25WHERE26  EXISTS(27SELECT TOP 1 128FROM dbo.CPL_FTCCSOrgCheckWithPWO(@ObjecKeysOfPWO) v29WHERE30  v.uid_org = bho.uid_org AND v.uid_compliancerule = cs.uid_complianceRule))
Open raw exported source
SQL ยท Raw7 lines
1create function dbo.CPL_FTCCSOrgCheckWithPWODetail (@ObjecKeysOfPWO QBM_YParameterList readonly )  returns table as return ( select bho.UID_Org as UID_Org2 , cs.UID_ComplianceRule as UID_ComplianceRule , cs.UID_ComplianceSubrule as UID_ComplianceSubrule , cm.ObjectKeyElement as ObjectKeyElement  from ( select3 bo.UID_Org, bo.ObjectKey  from BaseTreehasobject bo join dbo.QER_FTPWOAssigmentSplitForBHO(@ObjecKeysOfPWO) zu on bo.UID_Org = zu.UID_Org union select4 zu.UID_Org, zu.ObjectKey from dbo.QER_FTPWOAssigmentSplitForBHO (@ObjecKeysOfPWO) zu ) as bho join ComplianceSubRuleObject cm on bho.Objectkey = cm.ObjectKeyElement5 join ComplianceSubRule cs on cm.uid_ComplianceSubRule = cs.uid_ComplianceSubRule  where exists (select top 1 1 from dbo.CPL_FTCCSOrgCheckWithPWO(@ObjecKeysOfPWO6) v where v.uid_org = bho.uid_org and v.uid_compliancerule = cs.uid_complianceRule ) ) 7