dbo.QER_FGIGenProcIDForPWO
Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB
Interpretation
- Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.
Relations
- No extracted relations.
Typed Edges
- No typed edges extracted for this source.
References
- No direct source references extracted.
Referenced By
- dbo.CPL_ZITShopMakeDecisionCR
- dbo.CPL_ZITShopMakeDecisionOC
- dbo.CPL_ZITShopMakeDecisionOH
- dbo.QER_PITShopHelperFill_bulk
- dbo.QER_PITShopHelperFillAll
- dbo.QER_PITShopOrderMove_bulk
- dbo.QER_ZAllForPersonInBaseTree
- dbo.QER_ZITShopCheck
- dbo.QER_ZITShopCheckDecision
- dbo.QER_ZITShopCheckValid
- dbo.QER_ZITShopCheckWaiting
- dbo.QER_ZITShopHelperFill_Recalc
- dbo.QER_ZITShopMakeDecisionCD
- dbo.QER_ZITShopMakeDecisionEX
- dbo.QER_ZITShopMakeDecisionRI
- dbo.QER_ZITShopMakeDecisionSB
- dbo.QER_ZITShopMakeDecisionWC
- dbo.QER_ZITShopOrderAbort
- dbo.QER_ZITShopRepairClosed
- dbo.QER_TUHelperHeadOrg
- dbo.QER_TUHelperHeadPerson
- dbo.QER_TUPersonInBaseTree
- dbo.QER_TUPersonWantsOrg
Complete Source
1CREATE FUNCTION dbo.QER_FGIGenProcIDForPWO(2 @GenProcIDOfPWO varchar(38),3 @GenProcIDOfProcess varchar(38),4 @ConfigParmUseGenProcIDFromPWO BIT5) RETURNS varchar(386)7 WITH SCHEMABINDING8AS9BEGIN10 RETURN(11 SELECT CASE @ConfigParmUseGenProcIDFromPWO12 WHEN 1 THEN13 isnull(@GenProcIDOfPWO, @GenProcIDOfProcess)14 ELSE @GenProcIDOfProcess15 END)16ENDOpen raw exported source
1 create function dbo.QER_FGIGenProcIDForPWO(@GenProcIDOfPWO varchar(38) , @GenProcIDOfProcess varchar(38) , @ConfigParmUseGenProcIDFromPWO bit2 ) returns varchar(38) with SCHEMABINDING as begin return (select case @ConfigParmUseGenProcIDFromPWO when 1 then isnull(@GenProcIDOfPWO, @GenProcIDOfProcess3) else @GenProcIDOfProcess end ) end 4