I want to restrict the Product Order to be raised in below condition.
for a sale order say 101 which contains 3 item say Item1, Item2, Item3.
Then Prod order should be raise for sale order 101 and for item1 only once. Means
Multiple production order based on a sale order for an item(finished goods) should be blocked..
Can anybody let me know how can i achieve this via Stored Procedure.