SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_adt_delete_components_view  AS  SELECT DISTINCT tr.object_uuid, tr.item_id, tr.item_name_id
AS tree_name_id, it.item_name_id  FROM inv_reconcile_tree tr  INNER JOIN inv_reconcile_item it ON
it.object_uuid = tr.object_uuid         AND it.item_parent_id = tr.item_id                               
/**** Don't delete this line ****/         
AND it.item_parent_name_id = tr.item_name_id                     
/**** Don't delete this line ****/         
AND (                                                            
/**** Don't delete this line ****/             
(it.item_parent_name_id = 4 and it.item_name_id = 1)         
/* Fixed Drive Type             */          
OR (it.item_parent_name_id = 4 and it.item_name_id = 5)         
/* Fixed Drive Model            */          
OR (it.item_parent_name_id = 4 and it.item_name_id = 6)         
/* Fixed Drive Vendor           */          
OR (it.item_parent_name_id = 4 and it.item_name_id = 8)         
/* Fixed Drive Size             */          
OR (it.item_parent_name_id = 6 and it.item_name_id = 1)         
/* Processor Type               */          
OR (it.item_parent_name_id = 6 and it.item_name_id = 5)         
/* Processor Model              */          
OR (it.item_parent_name_id = 6 and it.item_name_id = 6)         
/* Processor Vendor             */          
OR (it.item_parent_name_id = 6 and it.item_name_id = 13)        
/* Processor Speed              */          
OR (it.item_parent_name_id = 8 and it.item_name_id = 1)         
/* Network Adapter Type         */          
OR (it.item_parent_name_id = 8 and it.item_name_id = 5)         
/* Network Adapter Model        */          
OR (it.item_parent_name_id = 8 and it.item_name_id = 6)         
/* Network Adapter Vendor       */          
OR (it.item_parent_name_id = 8 and it.item_name_id = 15)        
/* Network Adapter MAC Address  */          
OR (it.item_parent_name_id = 32 and it.item_name_id = 1)        
/* CD-ROM Drive Type            */          
OR (it.item_parent_name_id = 32 and it.item_name_id = 5)        
/* CD-ROM Drive Model           */          
OR (it.item_parent_name_id = 32 and it.item_name_id = 6)        
/* CD-ROM Drive Vendor          */          
OR (it.item_parent_name_id = 32 and it.item_name_id = 13)       
/* CD-ROM Drive Size            */          
OR (it.item_parent_name_id = 42 and it.item_name_id = 1)        
/* Memory Type                  */          
OR (it.item_parent_name_id = 42 and it.item_name_id = 8)        
/* Memory Size                  */          
OR (it.item_parent_name_id = 42 and it.item_name_id = 179)      
/* Memory Form                  */      
)                                                            
/**** Don't delete this line ****/  

GO
GRANT SELECT ON  [dbo].[arg_adt_delete_components_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_adt_delete_components_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_adt_delete_components_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_adt_delete_components_view] TO [uapmreporting_group]
GO