DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

ALTER PROCEDURE [dbo].[rpt_MW_LIQ_MASTER_PXK_Excel_BanViet]

@LIQ_ID	varchar(15) = NULL

AS

SELECT Row_number() over(order by A.LIQ_DT_ID) AS STT, A.QTY, A.NOTES,MI.MATERIAL_NAME, UN.UNIT_CODE, UN.UNIT_NAME,DP.DEP_CODE, DP.DEP_NAME,BR.BRANCH_CODE AS DVKD_CODE, BR.BRANCH_NAME AS DVKD_NAME, A.COST_ACC 

FROM MW_LIQ_DT A 

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 = MP.PRICE_ID

LEFT JOIN MW_IN MI ON MP.MATERIAL_ID = MI.IN_ID

LEFT JOIN MW_MATERIAL MT ON MT.MATERIAL_ID = MI.MATERIAL_ID

LEFT JOIN CM_UNIT UN ON UN.UNIT_ID = MT.UNIT_ID

LEFT JOIN CM_DEPARTMENT DP ON A.TO_DEPT_ID = DP.DEP_ID

--- LUCTV: 01 06 2020 - BO SUNG LAY MA DON VI KD, TEN DVKD THEO HD BAO HANH BAO TRI DU AN

LEFT JOIN CM_BRANCH BR ON MB.BRANCH_ID = BR.BRANCH_ID

WHERE A.LIQ_ID =@LIQ_ID OR @LIQ_ID IS NULL OR @LIQ_ID =''

SELECT (N'TP. Hồ Chí Minh, ngày ' + CONVERT(VARCHAR,  DAY(A.CREATE_DT)))

+ N' tháng ' + CONVERT(VARCHAR,  MONTH(A.CREATE_DT)) + N' năm ' + CONVERT(VARCHAR,  YEAR(A.CREATE_DT)) AS OUT_DATE

FROM dbo.MW_LIQ_MASTER A WHERE LIQ_ID = @LIQ_ID