dbo.vw_business_date_item_in_sum

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

SELECT        
dt_ms_item_daily_in_move_avg.ms_date_business_id
, dt_ms_item_daily_in_move_avg.ms_item_id
, SUM(isnull(vw_business_date_item_in_sum_bc_in.total_qty_pakai,0) + isnull(vw_business_date_item_in_sum_retur.total_qty_pakai,0)  + isnull(vw_business_date_item_in_sum_sto.total_qty_pakai,0)  + isnull(vw_business_date_item_in_sum_adjustment.total_qty_pakai,0) ) AS total_qty_pakai
, SUM(isnull(vw_business_date_item_in_sum_bc_in.total_amont_idr,0) + isnull(vw_business_date_item_in_sum_retur.total_amont_idr,0)   + isnull(vw_business_date_item_in_sum_sto.total_amont_idr,0)  + isnull(vw_business_date_item_in_sum_adjustment.total_amont_idr,0) ) AS total_amont_idr
, SUM(isnull(vw_business_date_item_in_sum_bc_in.total_amont_usd,0) + isnull(vw_business_date_item_in_sum_retur.total_amont_usd,0)   + isnull(vw_business_date_item_in_sum_sto.total_amont_usd,0)  + isnull(vw_business_date_item_in_sum_adjustment.total_amont_usd,0)) AS total_amont_usd
,dt_ms_item_daily_in_move_avg.ms_item_h_price_id
FROM            vw_business_date_item_in_sum_sto RIGHT OUTER JOIN
                         dt_ms_item_daily_in_move_avg ON vw_business_date_item_in_sum_sto.ms_date_business_id = dt_ms_item_daily_in_move_avg.ms_date_business_id AND 
                         vw_business_date_item_in_sum_sto.ms_item_id = dt_ms_item_daily_in_move_avg.ms_item_id LEFT OUTER JOIN
                         vw_business_date_item_in_sum_adjustment ON dt_ms_item_daily_in_move_avg.ms_date_business_id = vw_business_date_item_in_sum_adjustment.ms_date_business_id AND 
                         dt_ms_item_daily_in_move_avg.ms_item_id = vw_business_date_item_in_sum_adjustment.ms_item_id LEFT OUTER JOIN
                         vw_business_date_item_in_sum_retur ON dt_ms_item_daily_in_move_avg.ms_date_business_id = vw_business_date_item_in_sum_retur.ms_date_business_id AND 
                         dt_ms_item_daily_in_move_avg.ms_item_id = vw_business_date_item_in_sum_retur.ms_item_id LEFT OUTER JOIN
                         vw_business_date_item_in_sum_bc_in ON dt_ms_item_daily_in_move_avg.ms_date_business_id = vw_business_date_item_in_sum_bc_in.ms_date_business_id AND 
                         dt_ms_item_daily_in_move_avg.ms_item_id = vw_business_date_item_in_sum_bc_in.ms_item_id
GROUP BY dt_ms_item_daily_in_move_avg.ms_date_business_id
, dt_ms_item_daily_in_move_avg.ms_item_id
, dt_ms_item_daily_in_move_avg.ms_item_h_price_id
GO