dbo.QER_FTPWOOrderPerson_101

SQL_INLINE_TABLE_VALUED_FUNCTION

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

Open formatted source/search result

Parameters

Name	Type	Output
`@UID_PersonOrdered`	varchar	no
`@dummyUID_ITShopOrgPR`	varchar	no
`@UID_ACCProduct`	varchar	no
`@ValidFrom`	datetime	no
`@ValidUntil`	datetime	no
`@CountRecords`	int	no

Referenced objects

Schema	Object	Class
	AccProduct	OBJECT_OR_COLUMN
	BaseTree	OBJECT_OR_COLUMN
	BaseTreeAssign	OBJECT_OR_COLUMN
	BaseTreeHasObject	OBJECT_OR_COLUMN
	DialogTable	OBJECT_OR_COLUMN
	PersonInBaseTree	OBJECT_OR_COLUMN
	QERAssign	OBJECT_OR_COLUMN
dbo	QBM_FCVStringToInt	OBJECT_OR_COLUMN
dbo	QBM_FGIConfigparmValue	OBJECT_OR_COLUMN
dbo	QER_FGIPwoValidDateRangesExist	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_FTPWOOrderPerson_101 (@UID_PersonOrdered varchar(38) , @dummyUID_ITShopOrgPR varchar(38) , @UID_ACCProduct varchar(38) , @ValidFrom
2 datetime , @ValidUntil datetime , @CountRecords int ) returns table as return ( select distinct top (@CountRecords) cum.UID_Person as UID_PersonOrdered
3 , pr.UID_Org as UID_ITShopOrgPR , bo.UID_Org as UID_ITShopOrgBO , bo.UID_ParentOrg as UID_ITShopOrgSH , a.UID_AccProduct as UID_AccProduct , ba.IsReusePossible
4 , a.Ident_AccProduct as Ident_AccProduct , a.Description as Description , a.UID_AccProductGroup as UID_AccProductGroup from BaseTree pr join BaseTree 
5bo on bo.ITShopInfo = 'BO' and bo.uid_Org = pr.UID_ParentOrg and pr.uid_PWODecisionMethod > ' ' and pr.ITShopInfo = 'PR' and pr.UID_ACCProduct = @UID_ACCProduct
6     join BaseTree cu on bo.UID_ParentOrg = cu.UID_ParentOrg and cu.ITShopInfo = 'CU' join PersonInBaseTree cum on cu.uid_org = cum.uid_org and cum.XOrigin
7 > 0 and cum.UID_Person = @UID_PersonOrdered join AccProduct a on a.IsInactive = 0 and a.UID_AccProduct = @UID_ACCProduct join BaseTreeAssign ba with (readpast
8) on ba.IsITShopEnabled = 1 join DialogTable t with (readpast) on ba.UID_DialogTableElement = t.UID_DialogTable join BaseTreeHasObject bho on pr.UID_Org
9 = bho.UID_Org and bho.InheritInfo = 1  and bho.ObjectKey like '<Key><T>' + t.TableName + '</T>%'  left outer join QERAssign qa on bho.ObjectKey = qa.XObjectKey
10 where 1 = case   when ((sign(len(isnull(qa.ObjectKeyAssignTarget, ''))) ^1 ) & ba.IsReusePossible) = 1 and @ValidFrom is null and @ValidUntil is null 
11then 1 when ((sign(len(isnull(qa.ObjectKeyAssignTarget, ''))) ^1 ) & ba.IsReusePossible) = 1 then dbo.QER_FGIPwoValidDateRangesExist(@UID_PersonOrdered
12, pr.UID_Org, @ValidFrom, @ValidUntil) when dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('QER\ITShop\GapBehavior\GapFitting'), 0) = 2 then 1  else
13 dbo.QER_FGIPwoValidDateRangesExist(@UID_PersonOrdered, pr.UID_Org, @ValidFrom, @ValidUntil) end ) 
14

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

None extracted.

Summary: reads/joins BaseTree, PersonInBaseTree, AccProduct, BaseTreeAssign, DialogTable…; uses config QER\ITShop\GapBehavior\GapFitting

Declared parameters

Parameter	Type	Direction
`@UID_PersonOrdered`	`varchar(38)`	input
`@dummyUID_ITShopOrgPR`	`varchar(38)`	input
`@UID_ACCProduct`	`varchar(38)`	input
`@ValidFrom`	`datetime`	input
`@ValidUntil`	`datetime`	input
`@CountRecords`	`int`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

SQL dependency metadata

Config/session

Config: QER\ITShop\GapBehavior\GapFitting

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @UID_PersonOrdered @dummyUID_ITShopOrgPR @UID_ACCProduct @ValidFrom @ValidUntil @CountRecords

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.

Referencing object	Relation	Evidence
dbo.QER_FGIPWOOrderPerson	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_FTPWOOrderPerson	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_FGIPWOOrderPerson	source text reference	SQL_SCALAR_FUNCTION
dbo.QER_FTPWOOrderPerson	source text reference	SQL_TABLE_VALUED_FUNCTION