dbo.vw_business_date_item_in_sum_bc_in

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_business_date_item_in_sum_bc_in
---XencX---with encryption
as   
SELECT        
  dt_ms_item_daily_in_move_avg.ms_date_business_id
, dt_ms_item_daily_in_move_avg.ms_item_id
, SUM(dt_ms_item_in_detail.quantity_pakai) AS total_qty_pakai
, SUM(dt_ms_item_in_detail.total_amont_idr) AS total_amont_idr
, SUM(cast(dt_ms_item_in_detail.total_amont_usd as decimal(38,5))) AS total_amont_usd
, dt_ms_item_daily_in_move_avg.ms_item_h_price_id
  FROM            dt_ms_tpb_in_header_h_status INNER JOIN
                         dt_ms_tpb_in_header ON dt_ms_tpb_in_header_h_status.dt_ms_tpb_in_header_h_status_id = dt_ms_tpb_in_header.dt_ms_tpb_in_header_h_status_id INNER JOIN
                         dt_ms_tpb_in_barang ON dt_ms_tpb_in_header.ID_HEADER = dt_ms_tpb_in_barang.ID_HEADER INNER JOIN
                         dt_ms_item_daily_in_move_avg INNER JOIN
                         dt_ms_item_in_detail ON dt_ms_item_daily_in_move_avg.ms_item_in_move_avg_id = dt_ms_item_in_detail.ms_item_in_move_avg_id ON dt_ms_tpb_in_barang.ID = dt_ms_item_in_detail.id_source
WHERE        
(dt_ms_tpb_in_header_h_status.status_tpb_in_id = 3) 
AND ((dt_ms_item_in_detail.mode_source = 2))
AND (dt_ms_item_in_detail.total_amont_idr > 0)
AND (dt_ms_item_in_detail.total_amont_usd > 0)
GROUP BY 
dt_ms_item_daily_in_move_avg.ms_date_business_id
, dt_ms_item_daily_in_move_avg.ms_item_id
, dt_ms_item_daily_in_move_avg.ms_item_h_price_id
GO