dbo.vw_part_list_change_part_header

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO




CREATE VIEW dbo.vw_part_list_change_part_header
AS
SELECT        
b.ms_part_list_change_part_id
, dbo.enum_ms_part_list_change_part_status.ms_part_list_change_part_status_name
, b.ms_part_list_change_part_no
, b.ms_part_list_change_part_date
, c.part_no
, c.part_name
, b.assets_list_id
, dbo.dt_ms_assets_list.assets_number
, dbo.dt_ms_part_list_change_part_h_status.status_info
, dbo.dt_ms_part_list_change_part_h_status.create_date AS status_date
, b.ms_car_line_no
, dt_ms_car_line.ms_car_line_name
, users_status.username AS status_by
, b.create_date
, users_create.username AS create_by
, b.modify_date
, users_modify.username AS modify_by
, b.ms_item_id
, dbo.dt_ms_part_list_change_part_h_status.ms_part_list_change_part_status_id
, b.ms_part_list_change_part_h_status_id
FROM            dbo.users AS users_create 
RIGHT OUTER JOIN dbo.dt_ms_part_list_change_part_header AS b 
INNER JOIN dt_ms_car_line ON b.ms_car_line_no = dt_ms_car_line.ms_car_line_no 
INNER JOIN dbo.dt_ms_part_list_change_part_h_status ON b.ms_part_list_change_part_h_status_id = dbo.dt_ms_part_list_change_part_h_status.ms_part_list_change_part_h_status_id 
INNER JOIN dbo.enum_ms_part_list_change_part_status ON dbo.dt_ms_part_list_change_part_h_status.ms_part_list_change_part_status_id = dbo.enum_ms_part_list_change_part_status.ms_part_list_change_part_status_id 
LEFT OUTER JOIN dbo.dt_ms_assets_list ON b.assets_list_id = dbo.dt_ms_assets_list.assets_list_id 
LEFT OUTER JOIN dbo.users AS users_modify ON b.modify_by = users_modify.id ON users_create.id = b.create_by 
LEFT OUTER JOIN dbo.users AS users_status ON dbo.dt_ms_part_list_change_part_h_status.create_by = users_status.id 
LEFT OUTER JOIN dbo.dt_ms_item AS c ON b.ms_item_id = c.ms_item_id




GO

EXEC sys.sp_addextendedproperty N'MS_DiagramPane1', 
N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = "(H (1[40] 4[20] 2[20] 3) )" End Begin PaneConfiguration = 1 NumPanes = 3 Configuration = "(H (1 [50] 4 [25] 3))" End Begin PaneConfiguration = 2 NumPanes = 3 Configuration = "(H (1 [50] 2 [25] 3))" End Begin PaneConfiguration = 3 NumPanes = 3 Configuration = "(H (4 [30] 2 [40] 3))" End Begin PaneConfiguration = 4 NumPanes = 2 Configuration = "(H (1 [56] 3))" End Begin PaneConfiguration = 5 NumPanes = 2 Configuration = "(H (2 [66] 3))" End Begin PaneConfiguration = 6 NumPanes = 2 Configuration = "(H (4 [50] 3))" End Begin PaneConfiguration = 7 NumPanes = 1 Configuration = "(V (3))" End Begin PaneConfiguration = 8 NumPanes = 3 Configuration = "(H (1[56] 4[18] 2) )" End Begin PaneConfiguration = 9 NumPanes = 2 Configuration = "(H (1 [75] 4))" End Begin PaneConfiguration = 10 NumPanes = 2 Configuration = "(H (1[66] 2) )" End Begin PaneConfiguration = 11 NumPanes = 2 Configuration = "(H (4 [60] 2))" End Begin PaneConfiguration = 12 NumPanes = 1 Configuration = "(H (1) )" End Begin PaneConfiguration = 13 NumPanes = 1 Configuration = "(V (4))" End Begin PaneConfiguration = 14 NumPanes = 1 Configuration = "(V (2))" End ActivePaneConfig = 0 End Begin DiagramPane = Begin Origin = Top = 0 Left = 0 End Begin Tables = Begin Table = "users_create" Begin Extent = Top = 6 Left = 38 Bottom = 136 Right = 208 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "b" Begin Extent = Top = 6 Left = 246 Bottom = 136 Right = 530 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "dt_ms_part_list_change_part_h_status" Begin Extent = Top = 6 Left = 568 Bottom = 136 Right = 852 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "enum_ms_part_list_change_part_status" Begin Extent = Top = 138 Left = 38 Bottom = 234 Right = 330 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "dt_ms_assets_list" Begin Extent = Top = 138 Left = 368 Bottom = 268 Right = 598 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "users_modify" Begin Extent = Top = 6 Left = 890 Bottom = 136 Right = 1060 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "users_status" Begin Extent = Top = 138 Left = 636 Bottom = 268 ', 'SCHEMA', N'dbo', 'VIEW', N'vw_part_list_change_part_header'
GO

EXEC sys.sp_addextendedproperty N'MS_DiagramPane2', 
N' Right = 806 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "c" Begin Extent = Top = 138 Left = 844 Bottom = 268 Right = 1042 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End Begin ColumnWidths = 9 Width = 284 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 End End Begin CriteriaPane = Begin ColumnWidths = 11 Column = 1440 Alias = 900 Table = 1170 Output = 720 Append = 1400 NewValue = 1170 SortType = 1350 SortOrder = 1410 GroupBy = 1350 Filter = 1350 Or = 1350 Or = 1350 Or = 1350 End End End ', 'SCHEMA', N'dbo', 'VIEW', N'vw_part_list_change_part_header'
GO

EXEC sys.sp_addextendedproperty N'MS_DiagramPaneCount', 2, 'SCHEMA', N'dbo', 'VIEW', N'vw_part_list_change_part_header'
GO