dbo.QER_FTPwoNextDecisionMaker

SQL_TABLE_VALUED_FUNCTION

Created 2026-04-14T23:17:27.243 · modified 2026-04-14T23:17:27.243 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@uid_personwantsorg`	varchar	no

Referenced objects

Schema	Object	Column/minor	Class
	personwantsorg		OBJECT_OR_COLUMN
	QER_VITShopDecisionPerson_IS		OBJECT_OR_COLUMN
	QER_YPWONextDecisionMaker		TYPE
	QERWorkingStep		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

1create function dbo.QER_FTPwoNextDecisionMaker (@uid_personwantsorg varchar(38)) returns @erg table ( Ordernumber int , UID_PWOHelperPWO varchar(38) collate
2 database_default , UID_PersonHead varchar(38) collate database_default , UID_PWODecisionRule varchar(38) collate database_default , LevelNumber int , 
3SubLevelNumber int , UID_QERWorkingStep varchar(38) collate database_default , RulerLevel int    ) as begin declare @CurrentLevel int declare @UID_QERWorkingMethod
4 varchar(38) declare @lauf int = 1 declare @work QER_YPWONextDecisionMaker   select top 1 @UID_QERWorkingMethod = pwo.UID_QERWorkingMethod , @CurrentLevel
5 = pwo.DecisionLevel from personwantsorg pwo where pwo.uid_personwantsorg = @uid_personwantsorg;    insert into @work (UID_QERWorkingStep, LevelNumber,
6 positivesteps, Ordernumber) select s.UID_QERWorkingStep, s.LevelNumber, s.PositiveSteps, 1 as Ordernumber from QERWorkingStep s where s.UID_QERWorkingMethod
7 = @UID_QERWorkingMethod and s.LevelNumber = @CurrentLevel while @Lauf > 0 begin insert into @work (UID_QERWorkingStep, LevelNumber, positivesteps, Ordernumber
8) select distinct a.UID_QERWorkingStep, a.LevelNumber, a.positivesteps, h.ordernumber +1 from QERWorkingStep a join @work h on a.levelnumber = h.levelnumber
9 + h.positiveSteps where a.UID_QERWorkingMethod = @UID_QERWorkingMethod and h.positiveSteps <> 0 and not exists (select top 1 1 from @work w where w.UID_QERWorkingStep
10 = a.UID_QERWorkingStep ) select @lauf = @@rowcount end insert into @erg ( Ordernumber, UID_PWOHelperPWO, UID_PersonHead, UID_PWODecisionRule, LevelNumber
11, SubLevelNumber, UID_QERWorkingStep , RulerLevel) select distinct sNext.Ordernumber, hNext.UID_PWOHelperPWO, hNext.UID_Person  , hNext.UID_PWODecisionRule
12, hNext.LevelNumber, hNext.SubLevelNumber, hNext.UID_QERWorkingStep , hnext.RulerLevel from (select UID_QERWorkingStep, LevelNumber, positivesteps , ordernumber
13 from @work ) as sNext  join QER_VITShopDecisionPerson_IS hNext on hNext.uid_personwantsorg = @uid_personwantsorg and sNext.levelnumber = hNext.Levelnumber
14 and sNext.UID_QERWorkingStep = hNext.UID_QERWorkingStep return end 
15

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.243

None extracted.

Summary: writes INSERT into; reads/joins personwantsorg, QERWorkingStep, QER_VITShopDecisionPerson_IS

Declared parameters

Parameter	Type	Direction
`@uid_personwantsorg`	`varchar(38)`	input

DML targets

INSERT into

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_personwantsorg @erg @CurrentLevel @UID_QERWorkingMethod @lauf @work @Lauf @rowcount

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.