ALTER PROCEDURE dbo.ASS_LIQUIDATION_BVB_Export
@p_LIQ_ID	varchar(15)  = NULL

AS
	
BEGIN 
	SELECT ROW_NUMBER() OVER (ORDER BY A.LIQ_ID) AS STT, A.*, B.ASSET_NAME, B.ASSET_CODE,
	--A.REMAIN_VALUE AS REMAIN_AMORTIZED_AMT,
	ISNULL((B.AMORT_AMT - B.AMORTIZED_AMT), B.AMORT_AMT) AS REMAIN_AMORTIZED_AMT,  --So tien khau hao con lai
	E.STATUS_NAME ASS_STATUS_NAME, --Tinh trang tai san
	BR_C.BRANCH_CODE BRANCH_CODE_CRE, BR_C.BRANCH_NAME BRANCH_NAME_CRE, BR_U.BRANCH_CODE BRANCH_CODE_USE, BR_U.BRANCH_NAME BRANCH_NAME_USE,
    AMORT_MONTH,ISNULL(AMORT_MONTH-AMORTIZED_MONTH,AMORT_MONTH) AS REMAIN_AMORT_MONTH,
	DP_U.DEP_CODE AS DEPT_CODE_USE, DP_U.DEP_NAME AS DEPT_NAME_USE,B.BUY_DATE_KT,B.AMORTIZED_MONTH,B.AMORTIZED_AMT,
    TY.TYPE_NAME,convert(nvarchar(20),convert(INT,AMORT_MONTH/12) ) + N' năm' as R_AMORT_MONTH,CM.TERM_TYPE, BD.CREATE_DT, B.USE_DATE, 
    BR_C.BRANCH_CODE
	FROM ASS_LIQUIDATION_DT A 
	LEFT JOIN ASS_MASTER B ON A.ASSET_ID=B.ASSET_ID
	LEFT JOIN ASS_TYPE TY ON B.TYPE_ID=TY.TYPE_ID
	LEFT JOIN ASS_LIQ_REQUEST BDD ON A.LIQ_ID=BDD.LIQ_ID
	LEFT JOIN CM_TERM CM ON BDD.TERM_ID=CM.TERM_ID
	LEFT JOIN ASS_LIQUIDATION BD ON A.LIQ_ID=BD.LIQ_ID
	LEFT JOIN ASS_STATUS E ON B.ASS_STATUS = E.STATUS_ID
	--LUCTV: 19-12-2018 BO SUNG LEFT JOIN DE LAY THONG TIN DON VI NHAP TAI SAN, DON VI DANG SU SUNG TAI SAN
	LEFT JOIN CM_BRANCH BR_C ON B.BRANCH_CREATE = BR_C.BRANCH_ID
	LEFT JOIN CM_BRANCH BR_U ON B.BRANCH_ID = BR_U.BRANCH_ID
	LEFT JOIN dbo.CM_DEPARTMENT DP_U ON B.DEPT_ID = DP_U.DEP_ID
	WHERE 1 = 1 AND A.LIQ_ID = @p_LIQ_ID
END