dbo.vw_sa_data_detail_in_for_suppy

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*AND tbl_bc_in_hdr.JnsBarang<>'01'*/
CREATE VIEW dbo.vw_sa_data_detail_in_for_suppy
AS
SELECT        dbo.tbl_data_in_dtl.id_data_in_dtl, dbo.tbl_data_in_hdr.id_data_in_hdr, dbo.tbl_bc_in_hdr.id_bc_in_hdr, CAST(dbo.tbl_data_in_hdr.doc_in_date AS date) AS doc_in_date, dbo.tbl_data_in_hdr.doc_in_from_id, 
                         dbo.tbl_data_in_dtl.unit_in, dbo.tbl_data_in_dtl.qty_in * ISNULL(dbo.tbl_data_in_dtl.pengali, 1) AS qty_in, CAST(dbo.tbl_data_in_dtl.harga AS decimal(24, 6)) AS harga_satuan, 
                         dbo.tbl_data_in_dtl.qty_in * ISNULL(dbo.tbl_data_in_dtl.pengali, 1) - (ISNULL(dbo.vw_sa_data_detail_in_tmp_sa_pakai.total_pakai, 0) + ISNULL(dbo.vw_sa_data_detail_in_pakai.total_pakai, 0)) AS sisa, 
                         ISNULL(dbo.tbl_data_in_dtl.part_no, '') AS part_no, REPLACE(ISNULL(dbo.tbl_data_in_dtl.part_no, ''), ' ', '') AS part_no2, dbo.tbl_bc_in_hdr.KdKpbc, 
                         CASE WHEN tbl_bc_in_hdr.typedok = 'BC262' THEN '262' WHEN tbl_bc_in_hdr.typedok = 'BC23' THEN '23' WHEN tbl_bc_in_hdr.typedok = 'BC27' THEN '27' WHEN tbl_bc_in_hdr.typedok = 'BC271' THEN '27' WHEN
                          tbl_bc_in_hdr.typedok = 'BC40' THEN '40' ELSE tbl_bc_in_hdr.typedok END AS typedok, 
                         CASE WHEN tbl_bc_in_hdr.typedok = 'BC262' THEN 1 WHEN tbl_bc_in_hdr.typedok = 'BC23' THEN 0 WHEN tbl_bc_in_hdr.typedok = 'BC27' THEN 0 WHEN tbl_bc_in_hdr.typedok = 'BC40' THEN 1 ELSE 1 END AS
                          is_local, dbo.tbl_bc_in_hdr.CAR, dbo.tbl_bc_in_hdr.BC23No, dbo.tbl_bc_in_hdr.BC23Tg, dbo.tbl_bc_in_hdr.KdVal, dbo.tbl_bc_in_hdr.bc_in_from_in
FROM            dbo.tbl_data_in_dtl INNER JOIN
                         dbo.tbl_data_in_hdr ON dbo.tbl_data_in_dtl.id_data_in_hdr = dbo.tbl_data_in_hdr.id_data_in_hdr INNER JOIN
                         dbo.tbl_bc_in_hdr ON dbo.tbl_data_in_hdr.id_terkait = dbo.tbl_bc_in_hdr.id_bc_in_hdr LEFT OUTER JOIN
                         dbo.vw_sa_data_detail_in_pakai ON dbo.tbl_data_in_dtl.id_data_in_dtl = dbo.vw_sa_data_detail_in_pakai.id_data_in_dtl LEFT OUTER JOIN
                         dbo.vw_sa_data_detail_in_tmp_sa_pakai ON dbo.tbl_data_in_dtl.id_data_in_dtl = dbo.vw_sa_data_detail_in_tmp_sa_pakai.id_data_in_dtl
WHERE        (dbo.tbl_data_in_dtl.part_no IS NOT NULL) AND (dbo.tbl_data_in_hdr.doc_in_from_id = 2 OR
                         dbo.tbl_data_in_hdr.doc_in_from_id = 3 OR
                         dbo.tbl_data_in_hdr.doc_in_from_id = 4 OR
                         dbo.tbl_data_in_hdr.doc_in_from_id = 5) AND (dbo.tbl_data_in_dtl.type_brg = 1) AND (NOT (dbo.tbl_bc_in_hdr.typedok = 'BC262'))
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 = "tbl_data_in_dtl" Begin Extent = Top = 6 Left = 38 Bottom = 136 Right = 233 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "tbl_data_in_hdr" Begin Extent = Top = 138 Left = 38 Bottom = 268 Right = 251 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "tbl_bc_in_hdr" Begin Extent = Top = 6 Left = 271 Bottom = 136 Right = 446 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "vw_sa_data_detail_in_pakai" Begin Extent = Top = 138 Left = 289 Bottom = 234 Right = 459 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "vw_sa_data_detail_in_tmp_sa_pakai" Begin Extent = Top = 234 Left = 289 Bottom = 330 Right = 459 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 Filte', 'SCHEMA', N'dbo', 'VIEW', N'vw_sa_data_detail_in_for_suppy'
GO

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

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