CREATE VIEW [dbo].[al_bi_organization_view]
AS
SELECT     organization_uuid,dbo.al_bi_bintohexstr(organization_uuid) AS organization_uuid_display, parent_org_uuid, description, org_name, abbreviation, pri_phone_cc,
                      pri_phone_number, alt_phone_cc, alt_phone_number, fax_cc, fax_number, email_address, location_uuid, pager_email_address, inactive,
                      creation_user, creation_date, last_update_user, last_update_date, version_number, company_uuid, comments, contact_uuid, cost_center,
                      exclude_registration, delete_time, tenant
FROM         dbo.ca_organization
GO