dbo.QBM_FGIModuleExists
SQL_SCALAR_FUNCTION
Created 2025-06-27T17:57:01.563 · modified 2026-04-14T23:14:10.520 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| bit | yes |
@ModuleName | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| QBMModuleDef | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create function dbo.QBM_FGIModuleExists ( @ModuleName varchar(3) ) returns bit as begin return ( case when @Modulename = 'CCC' then 2 1 when isnull(@ModuleName, '') = '' then 0 when exists ( select top 1 1 from QBMModuleDef d with (readpast) where d.ModuleName = @ModuleName ) then 1 3else 0 end ) end 4
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:14:10.520
None extracted.
Summary: reads/joins QBMModuleDef
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
| bit | OUTPUT |
@ModuleName | varchar(3) | 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: @ModuleName @Modulename
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_FCVGUIDToModuleOwner | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FGIGuidIsValid | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_ZAccountInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_ZADSMachineInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_ZBaseTreeHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_ZContactInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_ZOrgHasADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_ZAccountInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_ZBaseTreeHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_ZLDPMachineInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_ZOrgHasLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PDatabasePrepareCheck2 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PDeleteDeep_L | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PDynamicUserForPerson | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueLoad | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PRITriggerCreate | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PUserDetectByGroupList | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_ZProcessMarkDelete | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_PITShopPersonHasObjFill_b | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_PPersonDelete_GDPR | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZBaseTreeHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERAssign | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERResource | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERReuse | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERReuseUS | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERResource | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERReuse | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERReuseUS | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZQERWorkingMethodCleanUp | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.RPS_ZBaseTreeHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.RPS_ZOrgHasRPSReport | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB_K | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB1_K | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB2_K | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB3_K | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasTSBAccountDef | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB1 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB2 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB3 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasTSBAccountDef | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FTDialogProcessReady | SQL expression dependency | dbo · OBJECT_OR_COLUMN |