dbo.QER_FGIPWOOrderPerson

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:59:27.080 · modified 2026-04-14T23:17:27.470 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	bit	yes
`@UID_PersonOrdered`	varchar	no
`@UID_ITShopOrgPR`	varchar	no
`@UID_ACCProduct`	varchar	no
`@ValidFrom`	datetime	no
`@ValidUntil`	datetime	no

Referenced objects

Schema	Object	Class
dbo	QER_FTPWOOrderPerson_000	OBJECT_OR_COLUMN
dbo	QER_FTPWOOrderPerson_001	OBJECT_OR_COLUMN
dbo	QER_FTPWOOrderPerson_010	OBJECT_OR_COLUMN
dbo	QER_FTPWOOrderPerson_011	OBJECT_OR_COLUMN
dbo	QER_FTPWOOrderPerson_100	OBJECT_OR_COLUMN
dbo	QER_FTPWOOrderPerson_101	OBJECT_OR_COLUMN
dbo	QER_FTPWOOrderPerson_110	OBJECT_OR_COLUMN
dbo	QER_FTPWOOrderPerson_111	OBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

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 IS
3 NULL and @UID_ACCProduct IS NULL begin if exists (select 1  from dbo.QER_FTPWOOrderPerson_000(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom
4, @ValidUntil, 1) ) begin select @erg = 1 end  return(@erg)  end if @UID_ITShopOrgPR is null and @UID_PersonOrdered IS NULL and @UID_ACCProduct > ' ' begin
5 if exists (select 1 from dbo.QER_FTPWOOrderPerson_001(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select
6 @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_010
7(@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_ITShopOrgPR
9, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select @erg = 1 end  return(@erg)  end if @UID_ITShopOrgPR is null and @UID_PersonOrdered > ' ' and
10 @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 > ' ' begin
12 if exists (select 1 from dbo.QER_FTPWOOrderPerson_101(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select
13 @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_110
14(@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_ITShopOrgPR
16, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1) ) begin select @erg = 1 end  return(@erg)  end endLabel: return (@erg) end 
17

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:17:27.470

None extracted.

Summary: reads/joins QER_FTPWOOrderPerson_000, QER_FTPWOOrderPerson_001, QER_FTPWOOrderPerson_010, QER_FTPWOOrderPerson_011, QER_FTPWOOrderPerson_100…

Declared parameters

Parameter	Type	Direction
	`bit`	OUTPUT
`@UID_PersonOrdered`	`varchar(38)`	input
`@UID_ITShopOrgPR`	`varchar(38)`	input
`@UID_ACCProduct`	`varchar(38)`	input
`@ValidFrom`	`datetime`	input
`@ValidUntil`	`datetime`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @UID_PersonOrdered @UID_ITShopOrgPR @UID_ACCProduct @ValidFrom @ValidUntil @erg

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

No reverse dependencies extracted.