dbo.v_nonhib_inv_dtl

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_nonhib_inv_dtl
AS
SELECT     id_nonhib_dtl, id_nonhib_hdr, INVOICE_NO, INVDATE, invdate2, (CASE WHEN
                          (SELECT     COUNT(*) AS jml
                            FROM          [tbl_data_part_hs]
                            WHERE      [tbl_data_part_hs].[part_no2] = replace([ITEMNUMBER], CHAR(32), '')) 
                      > 0 THEN [ITEMNUMBER] ELSE (CASE WHEN [ITEMNUMBER2] = '' THEN [ITEMNUMBER] ELSE [ITEMNUMBER2] END) END) AS partnumberx, (CASE WHEN
                          (SELECT     COUNT(*) AS jml
                            FROM          [tbl_data_part_hs]
                            WHERE      [tbl_data_part_hs].[part_no2] = replace([ITEMNUMBER], CHAR(32), '')) = 0 THEN
                          (SELECT     TOP 1 part_name_customs
                            FROM          [tbl_data_part_hs]
                            WHERE      [tbl_data_part_hs].[part_no2] = replace([ITEMNUMBER2], CHAR(32), '')) ELSE
                          (SELECT     TOP 1 part_name
                            FROM          [tbl_data_part_hs]
                            WHERE      [tbl_data_part_hs].[part_no2] = replace([ITEMNUMBER], CHAR(32), '')) END) AS partname, (CASE WHEN
                          (SELECT     COUNT(*) AS jml
                            FROM          [tbl_data_part_hs]
                            WHERE      [tbl_data_part_hs].[part_no2] = replace([ITEMNUMBER], CHAR(32), '')) = 0 THEN
                          (SELECT     TOP 1 part_name_customs
                            FROM          [tbl_data_part_hs]
                            WHERE      [tbl_data_part_hs].[part_no2] = replace([ITEMNUMBER2], CHAR(32), '')) ELSE
                          (SELECT     TOP 1 part_name_customs
                            FROM          [tbl_data_part_hs]
                            WHERE      [tbl_data_part_hs].[part_no2] = replace([ITEMNUMBER], CHAR(32), '')) END) AS partnamecustoms, ITEMNUMBER, ITEMNUMBER2, CONTNO, INVQTY, 
                      PACK, UOMPFX, CNO, ORDERNO, VENDOR, ISNULL((CASE WHEN MONTH(INVDATE) < 7 THEN
                          (SELECT     TOP 1 QUOTECIFNI
                            FROM          [dbo].[tbl_item_list]
                            WHERE      replace([dbo].[tbl_item_list].PART_NO, CHAR(32), '') = REPLACE((CASE WHEN
                                                       (SELECT     COUNT(*) AS jml
                                                         FROM          [tbl_data_part_hs]
                                                         WHERE      [tbl_data_part_hs].[part_no2] = replace([ITEMNUMBER], CHAR(32), '')) = 0 THEN [ITEMNUMBER2] ELSE [ITEMNUMBER] END), CHAR(32), '')) 
                      ELSE
                          (SELECT     TOP 1 NQUOTECIFNI
                            FROM          [dbo].[tbl_item_list]
                            WHERE      replace([dbo].[tbl_item_list].PART_NO, CHAR(32), '') = REPLACE((CASE WHEN
                                                       (SELECT     COUNT(*) AS jml
                                                         FROM          [tbl_data_part_hs]
                                                         WHERE      [tbl_data_part_hs].[part_no2] = replace([ITEMNUMBER], CHAR(32), '')) = 0 THEN [ITEMNUMBER2] ELSE [ITEMNUMBER] END), CHAR(32), '')) 
                      END), 0) AS hargacif
FROM         dbo.tbl_nonhib_dtl
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[30] 4[18] 2[23] 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 = "tbl_nonhib_dtl" Begin Extent = Top = 6 Left = 38 Bottom = 125 Right = 198 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End Begin ColumnWidths = 19 Width = 284 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 3615 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 = 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'v_nonhib_inv_dtl'
GO

EXEC sys.sp_addextendedproperty N'MS_DiagramPaneCount', 1, 'SCHEMA', N'dbo', 'VIEW', N'v_nonhib_inv_dtl'
GO