dbo.uspGetBillOfMaterials

Procedure/Function: 'dbo.uspGetBillOfMaterials', Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.

Procedure Name	Description	Parameters
dbo.uspGetBillOfMaterials	Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.	@RETURN_VALUE int(10) [RETURN VALUE], @StartProductID int(10) [INPUT], @CheckDate datetime(23) [INPUT]

Dependencies for Procedure/Function 'dbo.uspGetBillOfMaterials', 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