dbo.vw_business_date_item_in_sum_sto

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_business_date_item_in_sum_sto
---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_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 INNER JOIN
                         dt_ms_adj_sto ON dt_ms_item_in_detail.id_source_header = dt_ms_adj_sto.ms_adj_sto_id INNER JOIN
                         dt_ms_adj_sto_h_status ON dt_ms_adj_sto.ms_adj_sto_h_status_id = dt_ms_adj_sto_h_status.ms_adj_sto_h_status_id
WHERE        (dt_ms_item_in_detail.mode_source = 4) 
AND (dt_ms_adj_sto_h_status.status_adj_sto_id = 1)
AND (dt_ms_item_in_detail.total_amont_idr <> 0)
AND (dt_ms_item_in_detail.total_amont_usd <> 0) 
AND (dt_ms_item_in_detail.quantity_pakai >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