Back to OIM Explorer

dbo.QER_FGIPWOOrderPerson

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 2.487 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_FTPWOOrderPerson_000 source text reference
  • references source dbo.QER_FTPWOOrderPerson_001 source text reference
  • references source dbo.QER_FTPWOOrderPerson_010 source text reference
  • references source dbo.QER_FTPWOOrderPerson_011 source text reference
  • references source dbo.QER_FTPWOOrderPerson_100 source text reference
  • references source dbo.QER_FTPWOOrderPerson_101 source text reference
  • references source dbo.QER_FTPWOOrderPerson_110 source text reference
  • references source dbo.QER_FTPWOOrderPerson_111 source text reference
  • references source dbo.QER_FTPWOOrderPerson source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL101 lines
1CREATE FUNCTION dbo.QER_FGIPWOOrderPerson(2  @UID_PersonOrdered varchar(38),3  @UID_ITShopOrgPR varchar(38),4  @UID_ACCProduct varchar(38),5  @ValidFrom datetime,6  @ValidUntil datetime7) RETURNS BIT8AS9BEGIN10  DECLARE @erg BIT = 011  IF @UID_ITShopOrgPR IS NULL AND @UID_PersonOrdered IS NULL AND @UID_ACCProduct IS NULL12  BEGIN13    IF EXISTS(14      SELECT 115      FROM dbo.QER_FTPWOOrderPerson_000(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct, @ValidFrom, @ValidUntil,16    1))17    BEGIN18      SELECT @erg = 119    END20    RETURN(@erg)21  END22  IF @UID_ITShopOrgPR IS NULL AND @UID_PersonOrdered IS NULL AND @UID_ACCProduct > ' '23  BEGIN24    IF EXISTS(25      SELECT 126      FROM dbo.QER_FTPWOOrderPerson_001(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct, @ValidFrom, @ValidUntil,27    1))28    BEGIN29      SELECT @erg = 130    END31    RETURN(@erg)32  END33  IF @UID_ITShopOrgPR > ' ' AND @UID_PersonOrdered IS NULL AND @UID_ACCProduct IS NULL34  BEGIN35    IF EXISTS(36      SELECT 137      FROM dbo.QER_FTPWOOrderPerson_010(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct, @ValidFrom, @ValidUntil,38    1))39    BEGIN40      SELECT @erg = 141    END42    RETURN(@erg)43  END44  IF @UID_ITShopOrgPR > ' ' AND @UID_PersonOrdered IS NULL AND @UID_ACCProduct > ' '45  BEGIN46    IF EXISTS(47      SELECT 148      FROM dbo.QER_FTPWOOrderPerson_011(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct, @ValidFrom, @ValidUntil,49    1))50    BEGIN51      SELECT @erg = 152    END53    RETURN(@erg)54  END55  IF @UID_ITShopOrgPR IS NULL AND @UID_PersonOrdered > ' ' AND @UID_ACCProduct IS NULL56  BEGIN57    IF EXISTS(58      SELECT 159      FROM dbo.QER_FTPWOOrderPerson_100(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct, @ValidFrom, @ValidUntil,60    1))61    BEGIN62      SELECT @erg = 163    END64    RETURN(@erg)65  END66  IF @UID_ITShopOrgPR IS NULL AND @UID_PersonOrdered > ' ' AND @UID_ACCProduct > ' '67  BEGIN68    IF EXISTS(69      SELECT 170      FROM dbo.QER_FTPWOOrderPerson_101(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct, @ValidFrom, @ValidUntil,71    1))72    BEGIN73      SELECT @erg = 174    END75    RETURN(@erg)76  END77  IF @UID_ITShopOrgPR > ' ' AND @UID_PersonOrdered > ' ' AND @UID_ACCProduct IS NULL78  BEGIN79    IF EXISTS(80      SELECT 181      FROM dbo.QER_FTPWOOrderPerson_110(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct, @ValidFrom, @ValidUntil,82    1))83    BEGIN84      SELECT @erg = 185    END86    RETURN(@erg)87  END88  IF @UID_ITShopOrgPR > ' ' AND @UID_PersonOrdered > ' ' AND @UID_ACCProduct > ' '89  BEGIN90    IF EXISTS(91      SELECT 192      FROM dbo.QER_FTPWOOrderPerson_111(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct, @ValidFrom, @ValidUntil,93    1))94    BEGIN95      SELECT @erg = 196    END97    RETURN(@erg)98  END99  endLabel:100  RETURN(@erg)101END
Open raw exported source
SQL ยท Raw17 lines
1  create   function dbo.QER_FGIPWOOrderPerson (@UID_PersonOrdered varchar(38)   , @UID_ITShopOrgPR varchar(38)   , @UID_ACCProduct varchar(38)  2 , @ValidFrom datetime   , @ValidUntil datetime   ) returns bit as begin declare @erg bit = 0     if @UID_ITShopOrgPR is null and @UID_PersonOrdered IS3 NULL and @UID_ACCProduct IS NULL begin if exists (select 1  from dbo.QER_FTPWOOrderPerson_000(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom4, @ValidUntil, 1) ) begin select @erg = 1 end  return(@erg)  end if @UID_ITShopOrgPR is null and @UID_PersonOrdered IS NULL and @UID_ACCProduct > ' ' begin5 if exists (select 1 from dbo.QER_FTPWOOrderPerson_001(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select6 @erg = 1 end  return(@erg)  end if @UID_ITShopOrgPR > ' ' and @UID_PersonOrdered is null and @UID_ACCProduct IS NULL begin if exists (select 1 from dbo.QER_FTPWOOrderPerson_0107(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select @erg = 1 end  return(@erg)  end if @UID_ITShopOrgPR >8 ' ' and @UID_PersonOrdered is null and @UID_ACCProduct > ' ' begin if exists (select 1 from dbo.QER_FTPWOOrderPerson_011(@UID_PersonOrdered, @UID_ITShopOrgPR9, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select @erg = 1 end  return(@erg)  end if @UID_ITShopOrgPR is null and @UID_PersonOrdered > ' ' and10 @UID_ACCProduct IS NULL begin if exists (select 1 from dbo.QER_FTPWOOrderPerson_100(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, 11@ValidUntil, 1) ) begin select @erg = 1 end  return(@erg)  end if @UID_ITShopOrgPR is null and @UID_PersonOrdered > ' ' and @UID_ACCProduct > ' ' begin12 if exists (select 1 from dbo.QER_FTPWOOrderPerson_101(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select13 @erg = 1 end  return(@erg)  end if @UID_ITShopOrgPR > ' ' and @UID_PersonOrdered > ' ' and @UID_ACCProduct IS NULL begin if exists (select 1 from dbo.QER_FTPWOOrderPerson_11014(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select @erg = 1 end  return(@erg)  end if @UID_ITShopOrgPR >15 ' ' and @UID_PersonOrdered > ' ' and @UID_ACCProduct > ' ' begin if exists (select 1 from dbo.QER_FTPWOOrderPerson_111(@UID_PersonOrdered, @UID_ITShopOrgPR16, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select @erg = 1 end  return(@erg)  end endLabel: return (@erg) end 17