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]
GRANT SELECT ON  [dbo].[arg_adt_delete_components_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_adt_delete_components_view] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_adt_delete_components_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_adt_delete_components_view] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_adt_delete_components_view] TO [uapmreporting_group]
GO