Back to OIM Explorer

dbo.CPL_FTCCSOrgCheckWithPWODetai_

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 773 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.CPL_FTCCSOrgCheckWithPWODetail source text reference
  • references source dbo.QBM_FCVStringToList source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL28 lines
1CREATE FUNCTION dbo.CPL_FTCCSOrgCheckWithPWODetai_(2  @ObjecKeysOfPWO nvarchar(max)3) RETURNS @erg TABLE(UID_Org varchar(38) collate database_default,4UID_ComplianceRule varchar(38) collate database_default,5UID_ComplianceSubrule varchar(38) collate database_default,6ObjectKeyElement varchar(138) collate database_default7)8AS9BEGIN10  DECLARE @ObjecKeysOfPWO_L QBM_YParameterList11  INSERT INTO @ObjecKeysOfPWO_L(Parameter1)12  SELECT y.ParameterValue13  FROM dbo.QBM_FCVStringToList(@ObjecKeysOfPWO,14  '|',15  1,16  0) AS y17  INSERT INTO @erg(UID_Org,18  UID_ComplianceRule,19  UID_ComplianceSubrule,20  ObjectKeyElement)21  SELECT22    a.UID_Org,23    a.UID_ComplianceRule,24    a.UID_ComplianceSubrule,25    a.ObjectKeyElement26  FROM dbo.CPL_FTCCSOrgCheckWithPWODetail(@ObjecKeysOfPWO_L) a endLabel:27  RETURN28END
Open raw exported source
SQL ยท Raw6 lines
1create function dbo.CPL_FTCCSOrgCheckWithPWODetai_ (@ObjecKeysOfPWO nvarchar(max) ) returns @erg table (UID_Org varchar(38) collate database_default , 2UID_ComplianceRule varchar(38) collate database_default , UID_ComplianceSubrule varchar(38) collate database_default , ObjectKeyElement varchar(138) collate3 database_default ) as begin declare @ObjecKeysOfPWO_L QBM_YParameterList insert into @ObjecKeysOfPWO_L(Parameter1) select y.ParameterValue from dbo.QBM_FCVStringToList4( @ObjecKeysOfPWO, '|' , 1, 0) as y insert into @erg(UID_Org, UID_ComplianceRule, UID_ComplianceSubrule, ObjectKeyElement) select a.UID_Org,a.UID_ComplianceRule5, a.UID_ComplianceSubrule, a.ObjectKeyElement from dbo.CPL_FTCCSOrgCheckWithPWODetail(@ObjecKeysOfPWO_L) a endLabel: return end 6