dbo.uspGetWhereUsedProductID

Procedure/Function: 'dbo.uspGetWhereUsedProductID', Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID.

Procedure Name	Description	Parameters
dbo.uspGetWhereUsedProductID	Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID.	@RETURN_VALUE int(10) [RETURN VALUE], @StartProductID int(10) [INPUT], @CheckDate datetime(23) [INPUT]

Dependencies for Procedure/Function 'dbo.uspGetWhereUsedProductID', 10 items

Object Name	Type	Field Name
Production.BillOfMaterials	user table	ProductAssemblyID
Production.BillOfMaterials	user table	ComponentID
Production.BillOfMaterials	user table	StartDate
Production.BillOfMaterials	user table	EndDate
Production.BillOfMaterials	user table	BOMLevel
Production.BillOfMaterials	user table	PerAssemblyQty
Production.Product	user table	ProductID
Production.Product	user table	Name
Production.Product	user table	StandardCost
Production.Product	user table	ListPrice