CREATE VIEW ARG_CORA_VIEW
AS
select la.logical_asset_uuid,
       oa.own_resource_uuid,
       oa.serial_number as own_serial_number,
       oa.host_name as own_host_name,
       oa.resource_name as own_resource_name,
       oa.mac_address as own_mac_address,
       oa.resource_tag as own_resource_tag,
       oa.tenant as own_tenant,
       oa.inactive as own_inactive,
       oa.ufam as own_ufam,
       oa.exclude_reconciliation as own_exclude_reconciliation,
       oa.reconciliation_date as own_reconciliation_date,
       oa.asset_source_uuid as own_asset_source_uuid,
       dh.dis_hw_uuid,
       dh.serial_number as dis_serial_number,
       dh.host_name as dis_host_name,
       dh.label as dis_label,
       dh.asset_tag as dis_asset_tag,
       dh.primary_mac_address as dis_primary_mac_address,
       dh.discovery_changes_switch as dis_discovery_changes_switch,
       dh.tenant_id as dis_tenant,
       dh.asset_source_uuid as dis_asset_source_uuid
from ca_logical_asset la
left join ca_asset_source os on la.logical_asset_uuid = os.logical_asset_uuid and os.subschema_id = 1 and os.delete_time is null
left join ca_owned_resource oa on os.asset_source_uuid = oa.asset_source_uuid
left join ca_asset_source ds on la.logical_asset_uuid = ds.logical_asset_uuid and ds.subschema_id = 3 and ds.delete_time is null
left join ca_discovered_hardware dh on ds.asset_source_uuid = dh.asset_source_uuid
where la.delete_time is null
GO