PROC dbo.MW_OUT_Byid @p_OUT_ID VARCHAR(15) = NULL
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.NOTES,
	   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,
	   CR.BRANCH_ID AS TO_DEPT_BRN_ID,
       MB.MATERIAL_ID,
       MB.PRICE_ID, 
	   MI.MATERIAL_NAME, MP.PRICE_CODE,MB.TOTAL_AMT AS CUR_AMT_MASTBAL,
       CASE WHEN CW.WARE_CODE NOT IN ('05KM','06QT','07TT','08NV') THEN 0 ELSE ISNULL(A.VAT,MI.VAT) END AS VAT
       ,ISNULL(A.PRICE_VAT,0) AS PRICE_VAT, A.PRICE*A.QTY AS PRICE_NO_VAT,
	   D.UNIT_ID, D.UNIT_CODE, D.UNIT_NAME, A.RECEIVE_NOTES,
	   BR.BRANCH_CODE + ' - ' + BR.BRANCH_NAME AS TO_BRFULLNAME, CR.DEP_CODE + ' - ' + CR.DEP_NAME AS TO_DEPFULLNAME,
     CB1.BRANCH_CODE + '-' + CB1.BRANCH_NAME AS UNIT_RECEIVE_NAME, CB2.BRANCH_CODE + '-' + CB2.BRANCH_NAME AS UNIT_CHARGE_NAME, cd.DEP_ID AS DEP_RECEIVE, cd.DEP_NAME AS DEP_RECEIVE_NAME, cd1.DEP_ID AS DEP_CHARGE, cd1.DEP_NAME AS DEP_CHARGE_NAME,
     CB1.BRANCH_ID AS UNIT_RECEIVE, CB2.BRANCH_ID AS UNIT_CHARGE, D.UNIT_ID AS UNIT_PAY,D.UNIT_NAME AS UNIT_PAY_NAME, A.CUSTOMER_NAME, A.CUSTOMER_ID, A.CUSTOMER_LOCATION, A.QTY_REAL_OLD
     ,MB.QTY_REAL AS SL_TON_TT
     ,A.QTY_OLD AS QTY_BALANCE, A.QTY_RECEIVE, A.QTY_DAMAGED, A.QTY_LOSS
		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_WARE CW ON CW.WARE_ID = O.WARE_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 CM_UNIT D ON MT.UNIT_ID= D.UNIT_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
    LEFT JOIN CM_BRANCH CB1 ON CB1.BRANCH_ID = A.UNIT_RECEIVE
    LEFT JOIN CM_BRANCH CB2 ON CB2.BRANCH_ID = A.UNIT_CHARGE
    LEFT JOIN CM_DEPARTMENT cd ON cd.DEP_ID = A.DEP_RECEIVE
    LEFT JOIN CM_DEPARTMENT cd1 ON cd1.DEP_ID = A.DEP_CHARGE
	WHERE A.OUT_ID = @p_OUT_ID OR @p_OUT_ID IS NULL OR @p_OUT_ID = '';