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

AS
	
BEGIN 
    SELECT A.LIQDT_ID,A.LIQ_ID,A.ASSET_ID,A.LIQ_PRICE,A.LIQ_TYPE,A.AUTH_STATUS,A.MAKER_ID, A.NOTE,
	A.CREATE_DT,A.CHECKER_ID,A.APPROVE_DT, B.ASSET_NAME, B.ASSET_CODE, B.BUY_PRICE,
	A.REMAIN_AMORTIZED_AMT, A.BUY_PRICE, A.BUY_PRICE_LIQ, A.REMAIN_VALUE, A.LIQ_AMT,
    CASE 
    	WHEN A.ASS_STATUS IS NULL OR A.ASS_STATUS = '' THEN ASS.STATUS_NAME 
    	ELSE ASS2.STATUS_NAME 
    END AS ASS_STATUS_NAME, --Tinh trang tai san

	B.ASS_STATUS_DESC, B.AMORT_STATUS, 
    CASE 
    	WHEN A.AMORT_STATUS IS NULL OR A.AMORT_STATUS = '' THEN AAS.STATUS_NAME
    	ELSE AAS2.STATUS_NAME
    END AS AMORT_STATUS_NAME, -- Trang thai khau hao

    CB.BRANCH_NAME AS BRANCH_NAME_USE, CB.BRANCH_ID AS BRANCH_ID_USE,
    CD.DEP_NAME AS DEPT_NAME_USE, CD.DEP_ID AS DEPT_ID_USE
    , AZ.LIST_LIQ_REQUEST
    , A.LIQ_REQ_ID, 
    CASE WHEN A.ASS_AMORTIZED_MONTH IS NULL THEN ISNULL(B.AMORTIZED_MONTH,0) ELSE ISNULL(A.ASS_AMORTIZED_MONTH,0) END ASS_AMORTIZED_MONTH,
    CASE WHEN A.ASS_AMORTIZED_AMT IS NULL THEN ISNULL(B.AMORTIZED_AMT,0) ELSE ISNULL(A.ASS_AMORTIZED_AMT,0) END ASS_AMORTIZED_AMT
    , CASE WHEN A.LIQ_VAT IS NULL THEN 0 ELSE A.LIQ_VAT END AS LIQ_VAT
    , CASE WHEN A.LIQ_VAT IS NULL THEN 0 ELSE A.LIQ_PRICE_VAT END AS LIQ_PRICE_VAT
    ,A.REQ_AMT
--    ,A.REQ_AMT - ISNULL(A.LIQ_PRICE_VAT, 0) AS LIQ_AMT_BE_VAT
    , A.LIQ_AMT_BE_VAT
    ,A.LIQ_REASON
	FROM ASS_LIQUIDATION_DT A 
	LEFT JOIN ASS_MASTER B ON A.ASSET_ID=B.ASSET_ID
    LEFT JOIN ASS_AMORT_STATUS AAS ON AAS.STATUS_CODE = B.AMORT_STATUS
	LEFT JOIN ASS_STATUS ASS ON B.ASS_STATUS = ASS.STATUS_ID
    LEFT JOIN ASS_AMORT_STATUS AAS2 ON AAS.STATUS_CODE = A.AMORT_STATUS
	LEFT JOIN ASS_STATUS ASS2 ON A.ASS_STATUS = ASS.STATUS_ID
    LEFT JOIN CM_BRANCH CB ON A.BRANCH_ID_USE = CB.BRANCH_ID
    LEFT JOIN CM_DEPARTMENT CD ON CD.DEP_ID = A.DEP_ID_USE
	LEFT JOIN ASS_LIQUIDATION AZ ON A.LIQ_ID = AZ.LIQ_ID
	WHERE 1 = 1 AND A.LIQ_ID = @p_LIQ_ID
END