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 NameDescriptionParameters
dbo.uspGetWhereUsedProductIDStored 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 NameTypeField Name
Production.BillOfMaterialsuser tableProductAssemblyID
Production.BillOfMaterialsuser tableComponentID
Production.BillOfMaterialsuser tableStartDate
Production.BillOfMaterialsuser tableEndDate
Production.BillOfMaterialsuser tableBOMLevel
Production.BillOfMaterialsuser tablePerAssemblyQty
Production.Productuser tableProductID
Production.Productuser tableName
Production.Productuser tableStandardCost
Production.Productuser tableListPrice