dbo.vw_ms_item_in_sum_to_memo

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE view  dbo.vw_ms_item_in_sum_to_memo
---XencX---with encryption
as    
SELECT        dt_ms_memo_detail_supply.supply_id_source AS ms_in_item_detail_id  
,sum(case when dt_ms_memo_header_h_status.ms_memo_header_status_id = 1 then dt_ms_memo_detail_supply.quantity else 0 end )  out_qty
,sum(case when dt_ms_memo_header_h_status.ms_memo_header_status_id = 0 then dt_ms_memo_detail_supply.quantity else 0 end )  plan_qty
FROM            dt_ms_memo_detail_supply INNER JOIN
                         dt_ms_memo_detail ON dt_ms_memo_detail_supply.ms_memo_detail_id = dt_ms_memo_detail.ms_memo_detail_id INNER JOIN
                         dt_ms_memo_header ON dt_ms_memo_detail.ms_memo_header_id = dt_ms_memo_header.ms_memo_header_id INNER JOIN
                         dt_ms_memo_header_h_status ON dt_ms_memo_header.ms_memo_header_h_status_id = dt_ms_memo_header_h_status.ms_memo_header_h_status_id
WHERE        (dt_ms_memo_detail_supply.supply_mode_source = 0) 
GROUP BY dt_ms_memo_detail_supply.supply_id_source

GO