[ca_itrm].[rp_tmp_R000346000002ae18]
create view ca_itrm.rp_tmp_R000346000002ae18 as SELECT ca_software_def.name as sw_name,ca_company.company_name,ca_discovered_software.creation_date,ca_software_def.software_type_id, asset_source_uuid, dis_sw_uuid FROM ca_discovered_software , (ca_software_def left outer join ca_company on manufacturer_uuid=company_uuid) WHERE 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)
GO
