View providing translated application names, shortcuts, states, and overview types.
Definition
CREATE VIEW
[mr].[Application] AS
SELECT
[a].[Application_Id],
[a].[Enum_Key] [Application_Key],
[ts].[Translation] [Application_Shortcut],
[ta].[Translation] [Application_Name],
[a].[Description_Key] [Description],
[os].[Enum_Key] [Object_State],
[ot].[Enum_Key] [Application_Overview_Object_Type]
FROM
[dbo].[C_Application] [a]
LEFT JOIN [dbo].[C_Object_State] [os] ON [os].[State_Id] = [a].[Object_State_Id]
LEFT JOIN [fw].[Translation] [ta] ON [ta].[Translation_key] = [a].[Name_Key]
LEFT JOIN [fw].[Translation] [ts] ON [ts].[Translation_key] = [a].[Shortcut_Key]
LEFT JOIN [dbo].[C_Object_Type] [ot] ON [ot].[Object_Type_Id] = [a].[Object_Type_Id]
Columns