dbo.vw_ms_item_in_sum_to_sto

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

SELECT        dt_ms_item_in_detail.id_source as ms_in_item_detail_id
,abs(sum(case when dt_ms_adj_sto_h_status.status_adj_sto_id = 1 then dt_ms_item_in_detail.quantity_pakai else 0 end ))  out_qty
,abs(sum(case when dt_ms_adj_sto_h_status.status_adj_sto_id = 0 then dt_ms_item_in_detail.quantity_pakai else 0 end ))  plan_qty
FROM            dt_ms_adj_sto INNER JOIN
                         dt_ms_adj_sto_h_status ON dt_ms_adj_sto.ms_adj_sto_h_status_id = dt_ms_adj_sto_h_status.ms_adj_sto_h_status_id INNER JOIN
                         dt_ms_item_in_detail ON dt_ms_adj_sto.ms_adj_sto_id = dt_ms_item_in_detail.id_source_header
WHERE        (dt_ms_item_in_detail.mode_source = 4) 
AND (dt_ms_item_in_detail.quantity_pakai<0)
GROUP BY dt_ms_item_in_detail.id_source
GO