dbo.vw_ms_production_in_sum_to_change_part

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO





CREATE view  dbo.vw_ms_production_in_sum_to_change_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 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
AND dt_ms_part_list_out.ms_process_id = 2

GROUP BY dt_ms_part_list_out.ms_item_out_detail_id


GO