Back to OIM Explorer

dbo.QER_FTPWOOrderPerson

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 5.416 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

Referenced By

Complete Source

1CREATE FUNCTION dbo.QER_FTPWOOrderPerson(2  @UID_PersonOrdered varchar(38),3  @UID_ITShopOrgPR varchar(38),4  @UID_ACCProduct varchar(38),5  @ValidFrom datetime,6  @ValidUntil datetime7) RETURNS @erg TABLE(UID_PersonOrdered varchar(38) collate database_default,8UID_ITShopOrgPR varchar(38) collate database_default,9UID_ITShopOrgBO varchar(38) collate database_default,10UID_ITShopOrgSH varchar(38) collate database_default,11UID_AccProduct varchar(38) collate database_default,12IsReusePossible BIT,13Ident_AccProduct nvarchar(256) collate database_default,14Description nvarchar(max) collate database_default,15UID_AccproductGroup varchar(38) collate database_default16)17AS18BEGIN19  IF @UID_PersonOrdered IS NULL AND @UID_ITShopOrgPR IS NULL AND @UID_ACCProduct IS NULL20  BEGIN21    INSERT INTO @erg(UID_PersonOrdered,22    UID_ITShopOrgPR,23    UID_ITShopOrgBO,24    UID_ITShopOrgSH,25    UID_AccProduct,26    IsReusePossible,27    Ident_AccProduct,28    Description,29    UID_AccproductGroup)30    SELECT31      UID_PersonOrdered,32      UID_ITShopOrgPR,33      UID_ITShopOrgBO,34      UID_ITShopOrgSH,35      UID_AccProduct,36      IsReusePossible,37      Ident_AccProduct,38      Description,39      UID_AccproductGroup40    FROM dbo.QER_FTPWOOrderPerson_000(@UID_PersonOrdered,41    @UID_ITShopOrgPR,42    @UID_ACCProduct,43    @ValidFrom,44    @ValidUntil,45    1073741824)46    GOTO endLabel47  END48  IF @UID_PersonOrdered IS NULL AND @UID_ITShopOrgPR IS NULL AND @UID_ACCProduct > ' '49  BEGIN50    INSERT INTO @erg(UID_PersonOrdered,51    UID_ITShopOrgPR,52    UID_ITShopOrgBO,53    UID_ITShopOrgSH,54    UID_AccProduct,55    IsReusePossible,56    Ident_AccProduct,57    Description,58    UID_AccproductGroup)59    SELECT60      UID_PersonOrdered,61      UID_ITShopOrgPR,62      UID_ITShopOrgBO,63      UID_ITShopOrgSH,64      UID_AccProduct,65      IsReusePossible,66      Ident_AccProduct,67      Description,68      UID_AccproductGroup69    FROM dbo.QER_FTPWOOrderPerson_001(@UID_PersonOrdered,70    @UID_ITShopOrgPR,71    @UID_ACCProduct,72    @ValidFrom,73    @ValidUntil,74    1073741824)75    GOTO endLabel76  END77  IF @UID_PersonOrdered IS NULL AND @UID_ITShopOrgPR > ' ' AND @UID_ACCProduct IS NULL78  BEGIN79    INSERT INTO @erg(UID_PersonOrdered,80    UID_ITShopOrgPR,81    UID_ITShopOrgBO,82    UID_ITShopOrgSH,83    UID_AccProduct,84    IsReusePossible,85    Ident_AccProduct,86    Description,87    UID_AccproductGroup)88    SELECT89      UID_PersonOrdered,90      UID_ITShopOrgPR,91      UID_ITShopOrgBO,92      UID_ITShopOrgSH,93      UID_AccProduct,94      IsReusePossible,95      Ident_AccProduct,96      Description,97      UID_AccproductGroup98    FROM dbo.QER_FTPWOOrderPerson_010(@UID_PersonOrdered,99    @UID_ITShopOrgPR,100    @UID_ACCProduct,101    @ValidFrom,102    @ValidUntil,103    1073741824)104    GOTO endLabel105  END106  IF @UID_PersonOrdered IS NULL AND @UID_ITShopOrgPR > ' ' AND @UID_ACCProduct > ' '107  BEGIN108    INSERT INTO @erg(UID_PersonOrdered,109    UID_ITShopOrgPR,110    UID_ITShopOrgBO,111    UID_ITShopOrgSH,112    UID_AccProduct,113    IsReusePossible,114    Ident_AccProduct,115    Description,116    UID_AccproductGroup)117    SELECT118      UID_PersonOrdered,119      UID_ITShopOrgPR,120      UID_ITShopOrgBO,121      UID_ITShopOrgSH,122      UID_AccProduct,123      IsReusePossible,124      Ident_AccProduct,125      Description,126      UID_AccproductGroup127    FROM dbo.QER_FTPWOOrderPerson_011(@UID_PersonOrdered,128    @UID_ITShopOrgPR,129    @UID_ACCProduct,130    @ValidFrom,131    @ValidUntil,132    1073741824)133    GOTO endLabel134  END135  IF @UID_PersonOrdered > ' ' AND @UID_ITShopOrgPR IS NULL AND @UID_ACCProduct IS NULL136  BEGIN137    INSERT INTO @erg(UID_PersonOrdered,138    UID_ITShopOrgPR,139    UID_ITShopOrgBO,140    UID_ITShopOrgSH,141    UID_AccProduct,142    IsReusePossible,143    Ident_AccProduct,144    Description,145    UID_AccproductGroup)146    SELECT147      UID_PersonOrdered,148      UID_ITShopOrgPR,149      UID_ITShopOrgBO,150      UID_ITShopOrgSH,151      UID_AccProduct,152      IsReusePossible,153      Ident_AccProduct,154      Description,155      UID_AccproductGroup156    FROM dbo.QER_FTPWOOrderPerson_100(@UID_PersonOrdered,157    @UID_ITShopOrgPR,158    @UID_ACCProduct,159    @ValidFrom,160    @ValidUntil,161    1073741824)162    GOTO endLabel163  END164  IF @UID_PersonOrdered > ' ' AND @UID_ITShopOrgPR IS NULL AND @UID_ACCProduct > ' '165  BEGIN166    INSERT INTO @erg(UID_PersonOrdered,167    UID_ITShopOrgPR,168    UID_ITShopOrgBO,169    UID_ITShopOrgSH,170    UID_AccProduct,171    IsReusePossible,172    Ident_AccProduct,173    Description,174    UID_AccproductGroup)175    SELECT176      UID_PersonOrdered,177      UID_ITShopOrgPR,178      UID_ITShopOrgBO,179      UID_ITShopOrgSH,180      UID_AccProduct,181      IsReusePossible,182      Ident_AccProduct,183      Description,184      UID_AccproductGroup185    FROM dbo.QER_FTPWOOrderPerson_101(@UID_PersonOrdered,186    @UID_ITShopOrgPR,187    @UID_ACCProduct,188    @ValidFrom,189    @ValidUntil,190    1073741824)191    GOTO endLabel192  END193  IF @UID_PersonOrdered > ' ' AND @UID_ITShopOrgPR > ' ' AND @UID_ACCProduct IS NULL194  BEGIN195    INSERT INTO @erg(UID_PersonOrdered,196    UID_ITShopOrgPR,197    UID_ITShopOrgBO,198    UID_ITShopOrgSH,199    UID_AccProduct,200    IsReusePossible,201    Ident_AccProduct,202    Description,203    UID_AccproductGroup)204    SELECT205      UID_PersonOrdered,206      UID_ITShopOrgPR,207      UID_ITShopOrgBO,208      UID_ITShopOrgSH,209      UID_AccProduct,210      IsReusePossible,211      Ident_AccProduct,212      Description,213      UID_AccproductGroup214    FROM dbo.QER_FTPWOOrderPerson_110(@UID_PersonOrdered,215    @UID_ITShopOrgPR,216    @UID_ACCProduct,217    @ValidFrom,218    @ValidUntil,219    1073741824)220    GOTO endLabel221  END222  IF @UID_PersonOrdered > ' ' AND @UID_ITShopOrgPR > ' ' AND @UID_ACCProduct > ' '223  BEGIN224    INSERT INTO @erg(UID_PersonOrdered,225    UID_ITShopOrgPR,226    UID_ITShopOrgBO,227    UID_ITShopOrgSH,228    UID_AccProduct,229    IsReusePossible,230    Ident_AccProduct,231    Description,232    UID_AccproductGroup)233    SELECT234      UID_PersonOrdered,235      UID_ITShopOrgPR,236      UID_ITShopOrgBO,237      UID_ITShopOrgSH,238      UID_AccProduct,239      IsReusePossible,240      Ident_AccProduct,241      Description,242      UID_AccproductGroup243    FROM dbo.QER_FTPWOOrderPerson_111(@UID_PersonOrdered,244    @UID_ITShopOrgPR,245    @UID_ACCProduct,246    @ValidFrom,247    @ValidUntil,248    1073741824)249  END250  endlabel:251  RETURN252END

Open raw exported source

1create function dbo.QER_FTPWOOrderPerson (@UID_PersonOrdered varchar(38)   , @UID_ITShopOrgPR varchar(38)   , @UID_ACCProduct varchar(38)   , @ValidFrom2 datetime   , @ValidUntil datetime   ) returns @erg table  (UID_PersonOrdered varchar(38) collate database_default  , UID_ITShopOrgPR varchar(38) collate3 database_default  , UID_ITShopOrgBO varchar(38) collate database_default  , UID_ITShopOrgSH varchar(38) collate database_default  , UID_AccProduct varchar4(38) collate database_default , IsReusePossible bit , Ident_AccProduct nvarchar(256) collate database_default , Description nvarchar(max) collate database_default5  , UID_AccproductGroup varchar(38) collate database_default  ) as begin    if @UID_PersonOrdered is null and @UID_ITShopOrgPR is null and @UID_ACCProduct6 is null begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct7 , Description , UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible8, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_000(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom9, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered is null and @UID_ITShopOrgPR is null and @UID_ACCProduct > ' ' begin insert into @erg10 (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup11 ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup12 from dbo.QER_FTPWOOrderPerson_001(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered13 is null and @UID_ITShopOrgPR > ' ' and @UID_ACCProduct is null begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH14 , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO15 , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_010(@UID_PersonOrdered16, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered is null and @UID_ITShopOrgPR > ' ' and17 @UID_ACCProduct > ' ' begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible18, Ident_AccProduct , Description , UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct19, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_011(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct20,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered > ' ' and @UID_ITShopOrgPR is null and @UID_ACCProduct is null begin insert21 into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description ,22 UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct23 , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_100(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 107374182424) goto endLabel end if @UID_PersonOrdered > ' ' and @UID_ITShopOrgPR is null and @UID_ACCProduct > ' ' begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR25 , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup ) select UID_PersonOrdered26 , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_10127(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered > ' ' and @UID_ITShopOrgPR28 > ' ' and @UID_ACCProduct is null begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible29, Ident_AccProduct , Description , UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct30, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_110(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct31,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered > ' ' and @UID_ITShopOrgPR > ' ' and @UID_ACCProduct > ' ' begin insert into32 @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup33 ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup34 from dbo.QER_FTPWOOrderPerson_111(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1073741824)  end endlabel: return end35 36