C2P/C2P_Project/ext/Views/ext.v_ItemDetRcd.sql

CREATE VIEW ext.v_ItemDetRcd
AS
SELECT        ext.RcdItem.CodItemRcd AS CodItem, ext.RcdItem.ItemDescrRcd AS ItemDescr, ext.RcdItem.CodPlantRcd AS CodPlant, dbo.ItemDet.UnitWeight, dbo.ItemDet.CodItemGroup, 
                         ext.RcdClass01.CodClass01Rcd AS Class01, ext.RcdClass02.CodClass02Rcd AS Class02, '' AS Class03, '' AS Class04, '' AS Class05
FROM            dbo.ItemDet INNER JOIN
                         ext.RcdItem ON dbo.ItemDet.CodItem = ext.RcdItem.CodItem INNER JOIN
                         ext.RcdClass01 ON dbo.ItemDet.Class01 = ext.RcdClass01.CodClass01 INNER JOIN
                         ext.RcdClass02 ON dbo.ItemDet.Class02 = ext.RcdClass02.CodClass02
GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPaneCount', @value = 2, @level0type = N'SCHEMA', @level0name = N'ext', @level1type = N'VIEW', @level1name = N'v_ItemDetRcd';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane2', @value = N'    SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
', @level0type = N'SCHEMA', @level0name = N'ext', @level1type = N'VIEW', @level1name = N'v_ItemDetRcd';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane1', @value = 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 = "ItemDet"
            Begin Extent = 
               Top = 34
               Left = 516
               Bottom = 272
               Right = 686
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "RcdItem (ext)"
            Begin Extent = 
               Top = 6
               Left = 246
               Bottom = 178
               Right = 416
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "RcdClass01 (ext)"
            Begin Extent = 
               Top = 64
               Left = 836
               Bottom = 160
               Right = 1006
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "RcdClass02 (ext)"
            Begin Extent = 
               Top = 185
               Left = 840
               Bottom = 281
               Right = 1010
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 14
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         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 = 1605
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
     ', @level0type = N'SCHEMA', @level0name = N'ext', @level1type = N'VIEW', @level1name = N'v_ItemDetRcd';