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 |
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, |
| 5 |
ISNULL(DP.DEP_CODE,''), ISNULL(DP.DEP_NAME,''),DP.DEP_CODE, DP.DEP_NAME, BR.BRANCH_CODE AS DVKD_CODE, BR.BRANCH_NAME AS DVKD_NAME, A.COST_ACC AS COST_ACC |
| 6 |
FROM MW_OUT_DT A |
| 7 |
LEFT JOIN MW_MAST_BAL MB ON A.MAST_BAL_ID = MB.MAST_BAL_ID |
| 8 |
LEFT JOIN MW_MAST_PRICE MP ON MB.PRICE_ID = MP.PRICE_ID |
| 9 |
LEFT JOIN MW_IN MI ON MP.MATERIAL_ID = MI.IN_ID |
| 10 |
LEFT JOIN MW_MATERIAL MT ON MT.MATERIAL_ID = MI.MATERIAL_ID |
| 11 |
LEFT JOIN CM_UNIT UN ON UN.UNIT_ID = MT.UNIT_ID |
| 12 |
LEFT JOIN CM_DEPARTMENT DP ON A.TO_DEPT_ID = DP.DEP_ID |
| 13 |
--- LUCTV: 01 06 2020 - BO SUNG LAY MA DON VI KD, TEN DVKD THEO HD BAO HANH BAO TRI DU AN |
| 14 |
LEFT JOIN CM_BRANCH BR ON A.TO_BRN_ID = BR.BRANCH_ID |
| 15 |
WHERE A.OUT_ID =@OUT_ID OR @OUT_ID IS NULL OR @OUT_ID ='' |