rpt_MW_OUT_PXK_Excel_BanViet.txt
| 1 |
ALTER PROCEDURE [dbo].[rpt_MW_OUT_PXK_Excel_BanViet] |
|---|---|
| 2 |
@OUT_ID varchar(15) = NULL |
| 3 |
AS |
| 4 |
DECLARE @IS_MULTI_BRANCH INT = 0; |
| 5 |
SET @IS_MULTI_BRANCH = |
| 6 |
CASE WHEN (SELECT DISTINCT COUNT(TO_BRN_ID) FROM MW_OUT_DT WHERE OUT_ID = @OUT_ID) > 1 |
| 7 |
AND (SELECT COUNT(TO_BRN_ID) FROM MW_OUT_DT WHERE OUT_ID = @OUT_ID) > 1 THEN 1 END |
| 8 |
SELECT Row_number() over(order by A.OUT_DT_ID) AS STT, A.QTY, A.NOTES,MI.MATERIAL_NAME, UN.UNIT_CODE, UN.UNIT_NAME, |
| 9 |
ISNULL(DP.DEP_CODE,''), ISNULL(DP.DEP_NAME,''),DP.DEP_CODE, DP.DEP_NAME, BR.BRANCH_CODE AS DVKD_CODE, A.COST_ACC AS COST_ACC, |
| 10 |
CASE WHEN @IS_MULTI_BRANCH = 1 THEN 'Chung-DVKD' ELSE BR.BRANCH_NAME END AS DVKD_NAME |
| 11 |
FROM MW_OUT_DT A |
| 12 |
LEFT JOIN MW_MAST_BAL MB ON A.MAST_BAL_ID = MB.MAST_BAL_ID |
| 13 |
LEFT JOIN MW_MAST_PRICE MP ON MB.PRICE_ID = MP.PRICE_ID |
| 14 |
LEFT JOIN MW_IN MI ON MP.MATERIAL_ID = MI.IN_ID |
| 15 |
LEFT JOIN MW_MATERIAL MT ON MT.MATERIAL_ID = MI.MATERIAL_ID |
| 16 |
LEFT JOIN CM_UNIT UN ON UN.UNIT_ID = MT.UNIT_ID |
| 17 |
LEFT JOIN CM_DEPARTMENT DP ON A.TO_DEPT_ID = DP.DEP_ID |
| 18 |
--- LUCTV: 01 06 2020 - BO SUNG LAY MA DON VI KD, TEN DVKD THEO HD BAO HANH BAO TRI DU AN |
| 19 |
LEFT JOIN CM_BRANCH BR ON A.TO_BRN_ID = BR.BRANCH_ID |
| 20 |
WHERE A.OUT_ID =@OUT_ID OR @OUT_ID IS NULL OR @OUT_ID ='' |