To delete an item which does not violate any delete constraint, navigate to Delete items window

1. Enter a group name at the header and save it.
2. Enter the items needs to be deleted at the line level and save it.
3. Click on delete groups button to delete all the item in the group. Delete item information request is fired.
View the request o/p

 

 

Use custom deletion constraints to enforce specific business rules. Custom deletion constraints prevent the deletion of bills or routings if your data meets the conditions set forth in the constraint.

To create a custom deletion constraint:

1.   Navigate to the Deletion Constraints window:
           
            Inventory->Setup->Items->Delete Constraints
     
2. Enter a name for the deletion constraint.
         
3. Indicate whether the constraint is enabled. An enabled deletion constraint means that it is in effect when the delete concurrent program runs.
         
4. Select what kind of delete entity the constraint applies to: item, bill, routing, component, or operation.
         
5. Enter the SQL Select Statement that the delete concurrent program is to execute. You cannot update SQL statements for predefined deletion constraints.
         
6. Indicate whether to delete if there are rows found or no rows found by the SQL Select Statement
         
7. Enter a failure message from Oracle Application Object Library’s message dictionary to display if the delete fails.

You can define manufacturer part numbers for items. You can use this information for reporting purposes; and in catalog searches for particular items.
Navigate to the Manufacturers window , Enter the name of the manufacturer &  Save your work.

1. Navigate to the Manufacturers window.
2. Choose Parts.
3. Enter a manufacturer part number.
4. Enter an item.
You can assign the same item to multiple manufacturer part numbers.