dbo.QBM_FCVObjectKeyToModuleOwner

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:57:24.267 · modified 2026-04-14T23:20:24.260 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	varchar	yes
`@Objectkey`	varchar	no

Referenced objects

Schema	Object	Class
	QBMModuleDependCollection	OBJECT_OR_COLUMN
dbo	QBM_FCVGUIDToModuleOwner	OBJECT_OR_COLUMN
dbo	QBM_FTString_Split_Ordinal	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.QBM_FCVObjectKeyToModuleOwner  (@Objectkey varchar(138)) returns varchar(3)  as begin return( select case when 
2z.Mod1 = z.Mod2 then z.Mod1 when 'CCC' in (z.Mod1, z.Mod2) then 'CCC' when z.c1 > ' ' then z.Mod2 when z.c2 > ' ' then z.Mod1 else 'ZZZ' end as ModuleOwner
3 from ( select y.Mod1, y.Mod2, co1.UID_ModulePredecessor as c1, co2.UID_ModulePredecessor as c2 from ( select max(dbo.QBM_FCVGUIDToModuleOwner(x.GUIDValue
4)) as Mod1, min(dbo.QBM_FCVGUIDToModuleOwner(x.GUIDValue)) as Mod2 from ( select case when isnull(s.value, '') = '' then '' else left(s.value, len(s.value
5) -3) end as GUIDValue     from dbo.QBM_FTString_Split_Ordinal(@ObjectKey, '>') s where s.ordinal in ( 5, 7) and s.value > ' ' )as x ) as y left outer 
6join QBMModuleDependCollection co1 with (readpast) on co1.UID_ModulePredecessor = concat(y.Mod1 , '-ModuleDefinition') and co1.UID_ModuleFollower = concat
7(y.Mod2 , '-ModuleDefinition') left outer join QBMModuleDependCollection co2 with (readpast) on co2.UID_ModulePredecessor = concat(y.mod2 , '-ModuleDefinition'
8) and co2.UID_ModuleFollower = concat(y.mod1 , '-ModuleDefinition') ) as z ) end 
9

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:20:24.260

None extracted.

Summary: reads/joins QBM_FTString_Split_Ordinal, QBMModuleDependCollection

Declared parameters

Parameter	Type	Direction
	`varchar(3)`	OUTPUT
`@Objectkey`	`varchar(138)`	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: @Objectkey @ObjectKey

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.QBM_FGIModulePrecedenceValid	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.GEN_T5021AFB4B041761EC1F61839A	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.GEN_T50452A328C7E282EB7AB86A91	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.GEN_T5402269F27C8C5DF4C5DCBD1A	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.GEN_T54FE1FB080A4A9D054F7199A8	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.GEN_T59C2EAA269B0FDFDFE2DFAAC2	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.GEN_T5BC79B72B981D1230589D4AC3	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.GEN_T5C11D0D26E43547AB2B9F6315	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.GEN_T5E10CEB2978D95B344783D750	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.GEN_T5EA3F5D4DCAE8BF115C6714EC	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBMVCustomInfo	SQL expression dependency	dbo · OBJECT_OR_COLUMN