dbo.vw_ms_molts_grn

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_ms_molts_grn
AS
SELECT        dbo.test_compare.id, CAST(CASE WHEN vw_ms_header_bc_in.ID_HEADER IS NULL THEN 0 ELSE 1 END AS bit) AS used, dbo.test_compare.GRNUMBER, dbo.test_compare.GRDATE, 
                         dbo.test_compare.PARTNUMBER, dbo.test_compare.PARTCODE, dbo.test_compare.PARTUNIT, dbo.test_compare.PARTETA, dbo.test_compare.GRQTY, dbo.test_compare.PARTPRICE, 
                         dbo.test_compare.PONUMBER, dbo.test_compare.PODATE, dbo.test_compare.surat_jalan, dbo.test_compare.faktur_no, dbo.test_compare.faktur_date, dbo.test_compare.inv_no, dbo.test_compare.inv_date, 
                         ISNULL(dbo.vw_ms_header_bc_in.KODE_DOKUMEN_PABEAN, '') AS KODE_DOKUMEN_PABEAN, ISNULL('BC ' + dbo.vw_ms_header_bc_in.KODE_DOKUMEN_PABEAN, '') AS BC_TYPE, 
                         ISNULL(dbo.vw_ms_header_bc_in.NOMOR_AJU, '') AS CAR, ISNULL(dbo.date_to_str(dbo.vw_ms_header_bc_in.TANGGAL_DAFTAR), '') AS BC_DATE, ISNULL(dbo.vw_ms_header_bc_in.NOMOR_DAFTAR, '') 
                         AS BC_NO, ISNULL(dbo.vw_ms_header_bc_in.status_tpb_in_name, '') AS STATUS_MODULE, dbo.test_compare.SHIPPING, dbo.test_compare.SHIPPER, dbo.test_compare.create_date, 
                         users_create.username AS create_by, dbo.test_compare.mapping_supplier_customer_id, CAST(CASE WHEN test_compare.mapping_supplier_customer_id IS NULL THEN 0 ELSE 1 END AS bit) AS mapped, 
                         dbo.test_compare.mapping_date, dbo.dt_ms_supplier_customer.supplier_customer_code AS mapping_by, CASE WHEN CAST(CASE WHEN vw_ms_header_bc_in.ID_HEADER IS NULL THEN 0 ELSE 1 END AS bit) 
                         = 1 THEN 1 WHEN dt_ms_supplier_customer.ms_supplier_customer_id IS NULL THEN 2 ELSE 0 END AS r_s, dbo.vw_ms_item.ms_type_id, CAST(CASE WHEN vw_ms_item.ms_type_id IS NULL 
                         THEN 0 ELSE 1 END AS bit) AS cleansing, ISNULL(dbo.vw_ms_item.ms_type_name, '-') AS kategori_internal
FROM            dbo.test_compare INNER JOIN
                         dbo.users AS users_create ON dbo.test_compare.create_by = users_create.id LEFT OUTER JOIN
                         dbo.dt_ms_supplier_customer ON dbo.test_compare.mapping_supplier_customer_id = dbo.dt_ms_supplier_customer.ms_supplier_customer_id LEFT OUTER JOIN
                         dbo.vw_ms_header_bc_in ON dbo.test_compare.source_out_id = dbo.vw_ms_header_bc_in.ID_HEADER LEFT OUTER JOIN
                         dbo.vw_ms_item ON dbo.test_compare.PARTCODE = dbo.vw_ms_item.part_no
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 = "test_compare" Begin Extent = Top = 6 Left = 38 Bottom = 136 Right = 292 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "users_create" Begin Extent = Top = 138 Left = 38 Bottom = 268 Right = 208 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "dt_ms_supplier_customer" Begin Extent = Top = 270 Left = 38 Bottom = 400 Right = 270 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "vw_ms_header_bc_in" Begin Extent = Top = 402 Left = 38 Bottom = 532 Right = 333 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "vw_ms_item" Begin Extent = Top = 138 Left = 246 Bottom = 268 Right = 460 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" 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 = 135', 'SCHEMA', N'dbo', 'VIEW', N'vw_ms_molts_grn'
GO

EXEC sys.sp_addextendedproperty N'MS_DiagramPane2', 
N'0 Or = 1350 Or = 1350 End End End ', 'SCHEMA', N'dbo', 'VIEW', N'vw_ms_molts_grn'
GO

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