dbo.v_data_bp_ct01_all

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_data_bp_ct01_all
AS
SELECT     dbo.tbl_bahanpenolong_out.id_bp_out_dtl, dbo.tbl_bahanpenolong_out.container_number, dbo.tbl_bahanpenolong_out.no_invoice, dbo.tbl_bahanpenolong_out.tgl_invoice, dbo.tbl_bahanpenolong_out.part_no, dbo.tbl_bahanpenolong_out.part_name, 
                  dbo.tbl_bahanpenolong_out.qty, dbo.tbl_bahanpenolong_out.qty_out, dbo.tbl_bahanpenolong_out.uom, dbo.tbl_bahanpenolong_out.doc_no, dbo.tbl_bahanpenolong_out.doc_date, dbo.tbl_bahanpenolong_out.doc_out_to, dbo.tbl_bahanpenolong_out.filename, 
                  dbo.tbl_bahanpenolong_out.car, CONVERT(varchar(10), dbo.tbl_bahanpenolong_out.create_date, 126) AS create_date, dbo.tbl_bahanpenolong_out.create_by, dbo.tbl_bahanpenolong_out.update_date, dbo.tbl_bahanpenolong_out.update_by, 
                  dbo.tbl_bahanpenolong_out.approved_date, dbo.tbl_bahanpenolong_out.price, dbo.tbl_bahanpenolong_out.status_data, dbo.tbl_bahanpenolong_out.kode_buyer, dbo.tbl_bahanpenolong_out.nama_buyer, dbo.tbl_bahanpenolong_out.id_memo_bp, 
                  dbo.tbl_bahanpenolong_out.bruto, dbo.tbl_bahanpenolong_out.hs_kode, dbo.tbl_bahanpenolong_out.jmkemas, dbo.tbl_bahanpenolong_out.jnkemas, dbo.tbl_bahanpenolong_out.netto
FROM        tbl_bahanpenolong_out
UNION ALL
SELECT     0, [ContainerNo], [InvoiceNo], [TgDok], [part_no], [Description], [Qty], [Qty], 'pce', [NODAFT], [TGDAFT], 1, 'ORACLE', [CAR], NULL, 'SYSTEM', NULL, 'SYSTEM', NULL, NULL, 'APPROVED', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
FROM        [dbo].[v_data_ct_01_oracle]
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 = End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End End Begin CriteriaPane = Begin ColumnWidths = 11 Column = 1440 Alias = 900 Table = 1176 Output = 720 Append = 1400 NewValue = 1170 SortType = 1356 SortOrder = 1416 GroupBy = 1350 Filter = 1356 Or = 1350 Or = 1350 Or = 1350 End End End ', 'SCHEMA', N'dbo', 'VIEW', N'v_data_bp_ct01_all'
GO

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