Views [dbo].[al_bi_dl_doc_loc_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:33:18 PM Thursday, February 10, 2011
Last Modified10:33:18 PM Thursday, February 10, 2011
Columns
Name
id
inactive
value
description
source_type_id
creation_user
creation_date
last_update_user
last_update_date
version_number
organization_uuid
ORGANIZATION_UUID_DISPLAY
tenant
TENANT_DISPLAY
SQL Script
CREATE VIEW [dbo].[al_bi_dl_doc_loc_view]
AS
SELECT     id, inactive, value, description, source_type_id, creation_user, creation_date, last_update_user, last_update_date, version_number,
                      organization_uuid,dbo.al_bi_bintohexstr(organization_uuid) AS ORGANIZATION_UUID_DISPLAY, tenant,dbo.al_bi_bintohexstr(tenant) AS TENANT_DISPLAY
FROM         dbo.arg_dl_doc_location
GO
Uses