CREATE VIEW [dbo].[al_bi_owned_res_view]
AS
SELECT     own_resource_uuid,dbo.al_bi_bintohexstr(own_resource_uuid) AS own_resource_uuid_display, inactive, asset_type_id, resource_name, resource_description, resource_family, resource_class,
                      resource_status, manufacturer_uuid, responsible_vendor_uuid, maintenance_org_uuid, responsible_org_uuid, org_bought_for_uuid,
                      resource_contact_uuid, resource_owner_uuid, location_uuid, floor_location, room_location, cabinet_location, shelf_location, slot_location, model_uuid,
                      host_name, mac_address, ip_address, resource_tag, operating_system, product_version, serial_number, dbo.SECS2DATE(acquire_date) AS acquire_date,
                      dbo.SECS2DATE(installation_date) AS installation_date, cost_center, gl_code, resource_quantity, requisition_id, purchase_order_id, ufam, creation_user,
                      dbo.SECS2DATE(creation_date) AS creation_date, last_update_user, dbo.SECS2DATE(last_update_date) AS last_update_date, version_number, supply_vendor_uuid,
                      maintenance_vendor_uuid, company_bought_for_uuid, resource_capacity_unit, resource_capacity, resource_alias,
                      asset_source_uuid,dbo.al_bi_bintohexstr(asset_source_uuid) AS asset_source_uuid_display, license_uuid, exclude_registration, delete_time, department, dbo.SECS2DATE(status_date)
                      AS status_date, license_information, resource_subclass, audit_date, exclude_reconciliation, dns_name, alternate_host_name,
                      dbo.SECS2DATE(discovery_last_run_date) AS discovery_last_run_date, previous_resource_tag, processor_count, processor_speed, processor_speed_unit,
                      processor_type, dbo.SECS2DATE(reconciliation_date) AS reconciliation_date, total_disk_space, total_disk_space_unit, total_memory, total_memory_unit,
                      billing_contact_uuid, support_contact1_uuid, support_contact2_uuid, support_contact3_uuid, disaster_recovery_contact_uuid,
                      backup_services_contact_uuid, network_contact_uuid, tenant, license_id, resource_deployment_status, is_asset, is_ci, lifecycle_status,
                      lifecycle_status_date
FROM         dbo.ca_owned_resource
GO