[ca_itrm].[rp_tmp_R000300000004502f]
create view ca_itrm.rp_tmp_R000300000004502f as SELECT ca_software_def.name as sw_name,ca_software_def.sw_version_label,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=0x161a34d8781f4a4da235be34781d5ccb 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 AND (ca_software_def.source_type_id=1 OR ca_software_def.source_type_id=2) UNION SELECT ca_software_def.name as sw_name,ca_software_def.sw_version_label,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=0x161a34d8781f4a4da235be34781d5ccb 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 AND (ca_software_def.source_type_id=1 OR ca_software_def.source_type_id=2)
GO
