Views [dbo].[al_bi_itemver_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
IVID
IVNAME
IVAVFRDT
IVAVTODT
IVSUPPDT
IVYEAR2K
IVMANNBR
CREATION_USER
CREATION_DATE
LAST_UPDATE_USER
LAST_UPDATE_DATE
VERSION_NUMBER
SW_DEF_UUID
MODEL_UUID
MODEL_UUID_DISPLAY
TENANT
TENANT_DISPLAY
SQL Script
CREATE VIEW [dbo].[al_bi_itemver_view]
AS
SELECT     IVID, IVNAME, IVAVFRDT, IVAVTODT, IVSUPPDT, IVYEAR2K, IVMANNBR, CREATION_USER, CREATION_DATE, LAST_UPDATE_USER,
                      LAST_UPDATE_DATE, VERSION_NUMBER, SW_DEF_UUID, MODEL_UUID,dbo.al_bi_bintohexstr(MODEL_UUID) AS MODEL_UUID_DISPLAY, TENANT,dbo.al_bi_bintohexstr(TENANT)
                      AS TENANT_DISPLAY
FROM         dbo.ARG_ITEMVER
GO
Uses