APPS.MTL_CATALOG_SEARCH_ITEMS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

procedure delete_row (item_id      NUMBER,
                      org_id       NUMBER,
                      handle       NUMBER) IS

begin

     delete from MTL_CATALOG_SEARCH_ITEMS mtl
     where mtl.inventory_item_id = item_id
      and  mtl.organization_id = org_id
      and  mtl.group_handle_id = handle;

Line: 19

end delete_row ;