dbo.vw_ms_production_in_sum_to_retur

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view  dbo.vw_ms_production_in_sum_to_retur
---XencX---with encryption
as     

SELECT       dt_ms_production_retur_detail.ms_item_out_detail_id AS ms_production_in_detail_id  
,sum(case when dt_ms_production_retur_h_status.status_production_retur_id = 1 then dt_ms_production_retur_detail.quantity else 0 end )  out_qty
,sum(case when dt_ms_production_retur_h_status.status_production_retur_id = 0 then dt_ms_production_retur_detail.quantity else 0 end )  plan_qty
   
FROM            dt_ms_production_retur INNER JOIN
                         dt_ms_production_retur_h_status ON dt_ms_production_retur.ms_production_retur_h_status_id = dt_ms_production_retur_h_status.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

GROUP BY dt_ms_production_retur_detail.ms_item_out_detail_id
GO