dbo.vw_business_date_item_in_sum_retur

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_business_date_item_in_sum_retur
---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_production_retur_h_status INNER JOIN
                         dt_ms_production_retur ON dt_ms_production_retur_h_status.ms_production_retur_h_status_id = dt_ms_production_retur.ms_production_retur_h_status_id INNER JOIN
                         dt_ms_production_retur_detail ON dt_ms_production_retur.ms_production_retur_id = dt_ms_production_retur_detail.ms_production_retur_id 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_production_retur_detail.ms_production_retur_detail_ID = dt_ms_item_in_detail.id_source
WHERE        
(dt_ms_production_retur_h_status.status_production_retur_id = 1) 
AND ((dt_ms_item_in_detail.mode_source =5 ))
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.is_adjustment=1)
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