How to Delete Assignment Sourcing Rule which is Item Type is MAKE.

*----------------------------------------------------------------------

-- Delete Assignment Sourcing Rule which is MAKE Item

----------------------------------------------------------------------*/

DELETE FROM  MRP_SR_ASSIGNMENTS MSRA

WHERE  MSRA.INVENTORY_ITEM_ID IN (SELECT DISTINCT MSI.INVENTORY_ITEM_ID

                                    FROM MTL_SYSTEM_ITEMS_B MSI,

                                         MRP_SR_ASSIGNMENTS MSRA

                                   WHERE 1=1

                                     AND MSI.SEGMENT1 = '1010000276'

                                     AND MSRA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID

                                     AND MSI.PLANNING_MAKE_BUY_CODE = 1 --1 Means Make ---  

                                  )