[dbo].[al_bi_ltcdef

[dbo].[al_bi_ltcdef_view]

(local) > mdb > Views > dbo.al_bi_ltcdef_view

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:33:18 PM Thursday, February 10, 2011
Last Modified	10:33:18 PM Thursday, February 10, 2011

Columns

Name
TDID
TDTEXT
TDDATESP
TDPROT
CREATION_USER
CREATION_DATE
LAST_UPDATE_USER
LAST_UPDATE_DATE
VERSION_NUMBER
SOURCE_TYPE_ID
TENANT
TENANT_DISPLAY

SQL Script

CREATE VIEW [dbo].[al_bi_ltcdef_view]
AS
SELECT     TDID, TDTEXT, TDDATESP, TDPROT, CREATION_USER, CREATION_DATE, LAST_UPDATE_USER, LAST_UPDATE_DATE, VERSION_NUMBER,
                      SOURCE_TYPE_ID, TENANT,dbo.al_bi_bintohexstr(TENANT) AS TENANT_DISPLAY
FROM         dbo.ARG_LTCDEF
GO

Uses

[dbo].[arg_ltcdef]
[dbo].[al_bi_bintohexstr]
dbo