create view ca_itrm.rep_view_sw_inv_R000083 as SELECT ca_software_def.name as sw_name,ca_software_def.sw_version_number, asset_source_uuid, dis_sw_uuid  FROM ca_discovered_software , ca_software_def , ca_category_member  WHERE ca_category_member.category_uuid=0xf7711c05b3885246bd980a476f7b91eb AND ca_category_member.sw_def_uuid=ca_discovered_software.sw_def_uuid AND ca_discovered_software.sw_def_uuid=ca_software_def.sw_def_uuid UNION SELECT ca_software_def.name as sw_name,ca_software_def.sw_version_number, asset_source_uuid, dis_sw_uuid  FROM ca_discovered_software , ca_software_def , ca_category_member , ca_link_sw_def  WHERE ca_category_member.category_uuid=0xf7711c05b3885246bd980a476f7b91eb AND ca_link_sw_def.primary_sw_def_uuid=ca_category_member.sw_def_uuid AND ca_link_sw_def.secondary_sw_def_uuid=ca_discovered_software.sw_def_uuid AND ca_link_sw_def.secondary_sw_def_uuid=ca_software_def.sw_def_uuid
GO