dbo.vw_ms_change_part_in_sum_to_part

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO




CREATE view  dbo.vw_ms_change_part_in_sum_to_part
---XencX---with encryption
as     
SELECT        
dt_ms_part_list_out.ms_item_out_detail_id
,sum(case when dt_ms_part_list_change_part_h_status.ms_part_list_change_part_status_id = 1 then dt_ms_part_list_out.quantity else 0 end )  out_qty
,sum(case when dt_ms_part_list_change_part_h_status.ms_part_list_change_part_status_id = 0 then dt_ms_part_list_out.quantity else 0 end )  plan_qty
FROM            dt_ms_part_list_change_part_h_status 
INNER JOIN dt_ms_part_list_change_part_header ON dt_ms_part_list_change_part_h_status.ms_part_list_change_part_h_status_id = dt_ms_part_list_change_part_header.ms_part_list_change_part_h_status_id 
INNER JOIN dt_ms_part_list_change_part_detail AS dt_ms_part_list_change_part_detail ON dt_ms_part_list_change_part_header.ms_part_list_change_part_id = dt_ms_part_list_change_part_detail.ms_part_list_change_part_id 
INNER JOIN dt_ms_part_list_out ON dt_ms_part_list_change_part_detail.ms_part_list_change_part_detail_id = dt_ms_part_list_out.ms_part_list_process_detail_id
where dt_ms_part_list_change_part_h_status.ms_part_list_change_part_status_id<>-1
GROUP BY dt_ms_part_list_out.ms_item_out_detail_id
 



GO