create view uapm_v_batchdata_l1 as
select i.object_uuid hw_uuid,
                    i.ITEM_TYPE value_type,
                    i.ITEM_FORMAT value_format,
                   i.ITEM_VALUE_TEXT value_text,
                   i.ITEM_VALUE_LONG value_long,
                   i.ITEM_VALUE_DOUBLE value_double,
                   n.item_name value_name,
                   tn.tree_name parent_name,
                   tnp.tree_name pparent_name,
                   ip.domain_uuid domain_uuid,
                    ip.tenant_id
        from ((((inv_batch_tree ip join inv_tree_name_id tnp
                 on tnp.tree_name_id=ip.item_parent_name_id
                   and tnp.domain_uuid=ip.domain_uuid)
             join inv_tree_name_id tn on tn.tree_name_id=ip.item_name_id
                   and tn.domain_uuid=ip.domain_uuid)
             join inv_batch_item i on ip.item_id=i.item_parent_id
                   and ip.object_uuid=i.object_uuid
                   and i.domain_uuid=ip.domain_uuid
                   and i.tenant_id=ip.tenant_id)
             join inv_item_name_id n on i.item_name_id=n.item_name_id
             and n.domain_uuid=ip.domain_uuid)
GO
GRANT SELECT ON  [dbo].[uapm_v_batchdata_l1] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[uapm_v_batchdata_l1] TO [ca_itrm_group_ams]
GO