ALTER PROC [dbo].[rpt_MW_OUT_Byid] @p_OUT_ID VARCHAR(15) = NULL
--AS
--SELECT A.*,
--       B.BRANCH_CODE AS FR_BR_CODE,
--       B.BRANCH_NAME AS FR_BRNAME,
--       BR.BRANCH_CODE AS TO_BRCODE, 
--       BR.BRANCH_NAME AS TO_BRNAME,
--       C.DEP_CODE AS FR_DEPCODE,
--       C.DEP_NAME FR_DEPNAME,
--       CR.DEP_CODE AS TO_DEPCODE, CR.DEP_NAME AS TO_DEPNAME,
--       MB.MATERIAL_ID,
--       MB.PRICE_ID,
--       MB.QTY_BALANCE,
--	   MI.MATERIAL_NAME
--FROM MW_OUT_DT A
--    LEFT JOIN dbo.MW_OUT O ON A.OUT_DT_ID = O.OUT_ID
--    LEFT JOIN CM_BRANCH B ON O.BRN_ID = B.BRANCH_ID
--    LEFT JOIN CM_BRANCH BR ON A.TO_BRN_ID = BR.BRANCH_ID
--    LEFT JOIN CM_DEPARTMENT C ON O.DEPT_ID = C.DEP_ID
--	LEFT JOIN CM_DEPARTMENT CR ON A.TO_DEPT_ID = CR.DEP_ID
--    LEFT JOIN MW_MAST_BAL MB ON A.MAST_BAL_ID = MB.MAST_BAL_ID
--	LEFT JOIN MW_MAST_PRICE MP ON MB.PRICE_ID = MB.PRICE_ID
--	LEFT JOIN MW_IN MI ON MI.IN_ID= MP.MATERIAL_ID 
AS
DECLARE @TABLE TABLE(MASTERBAL_ID VARCHAR(15), SL_TONG INT)

INSERT INTO @TABLE SELECT MAST_BAL_ID, SUM(QTY) FROM MW_OUT_DT WHERE OUT_ID = @p_OUT_ID GROUP BY MAST_BAL_ID

	   SELECT A.OUT_DT_ID, A.OUT_ID,A.MAST_BAL_ID,A.CUST_NAME,A.QTY,A.PRICE,A.TOTAL_AMT,A.COST_ACC,
	   A.QTY_OLD QTY_OLD,A.TO_BRN_ID,A.TO_DEPT_ID,A.EVENT_NAME,A.IS_BCT,A.COST_ACC,
       B.BRANCH_CODE AS FR_BR_CODE,
       B.BRANCH_NAME AS FR_BRNAME,
       BR.BRANCH_CODE AS TO_BRCODE, 
       BR.BRANCH_NAME AS TO_BRNAME,
       C.DEP_CODE AS FR_DEPCODE,
       C.DEP_NAME FR_DEPNAME,
       CR.DEP_CODE AS TO_DEPCODE, CR.DEP_NAME AS TO_DEPNAME,
       MB.MATERIAL_ID,
       MB.PRICE_ID,
       --EP.SL_TON QTY_BALANCE ,EP.SL_TON + TT.SL_TONG SL_TON_TT,
	   ISNULL(EP.SL_TON,0) + TT.SL_TONG QTY_BALANCE ,ISNULL(EP.SL_TON,0) + TT.SL_TONG SL_TON_TT,
	   --EP.SL_TON + TT.SL_TONG QTY_BALANCE ,EP.SL_TON SL_TON_TT,
	   MI.MATERIAL_NAME, MP.PRICE_CODE,MB.TOTAL_AMT AS CUR_AMT_MASTBAL
		FROM MW_OUT_DT A
		LEFT JOIN @TABLE TT ON TT.MASTERBAL_ID = A.MAST_BAL_ID
		LEFT JOIN dbo.MW_OUT O ON A.OUT_DT_ID = O.OUT_ID
		LEFT JOIN CM_BRANCH B ON O.BRN_ID = B.BRANCH_ID
		LEFT JOIN CM_BRANCH BR ON A.TO_BRN_ID = BR.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT C ON O.DEPT_ID = C.DEP_ID
		LEFT JOIN CM_DEPARTMENT CR ON A.TO_DEPT_ID = CR.DEP_ID
		LEFT JOIN MW_MAST_BAL MB ON A.MAST_BAL_ID = MB.MAST_BAL_ID
		LEFT JOIN MW_MATERIAL MT ON MB.MATERIAL_ID = MT.MATERIAL_ID
		LEFT JOIN MW_MAST_PRICE MP ON MB.PRICE_ID = MP.PRICE_ID
		LEFT JOIN MW_IN MI ON MP.MATERIAL_ID = MI.IN_ID
		LEFT JOIN MW_EXPORT_VIEW EP ON A.MAST_BAL_ID= EP.MAST_BAL_ID
	WHERE A.OUT_ID = @p_OUT_ID OR @p_OUT_ID IS NULL OR @p_OUT_ID = '';