[dbo].[arg_location

[dbo].[arg_location_view]

(local) > mdb > Views > dbo.arg_location_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:36:54 PM Monday, March 01, 2010
Last Modified	10:36:54 PM Monday, March 01, 2010

Columns

Name
location_uuid
location_name
inactive
pri_phone_number
fax_number
address_1
address_2
mail_address_1
mail_address_2
mail_address_3
city
state
address_3
mail_address_6
mail_address_5
mail_address_4
address_6
address_5
address_4
primary_contact_uuid
zip
country
county
geo_coord_type
geo_coords
contact_address_flag
creation_user
site_id
creation_date
comments
last_update_user
last_update_date
version_number
exclude_registration
delete_time
location_type_id
parent_location_uuid
organization_uuid
tenant
region_id
company_uuid

SQL Script

SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_location_view AS SELECT dbo.ca_location.*, dbo.ca_link_company_location.company_uuid AS company_uuid FROM dbo.ca_link_company_location RIGHT OUTER JOIN dbo.ca_location ON dbo.ca_link_company_location.location_uuid = dbo.ca_location.location_uuid WHERE (dbo.ca_location.parent_location_uuid IS NULL)

GO

Uses