/*
[ASS_TRANSFER_MULTI_MASTER_ById] 'TFS000000000017'
*/
ALTER PROCEDURE dbo.ASS_TRANSFER_MULTI_MASTER_ById
@TRANS_MULTI_MASTER_ID	varchar(15)
AS
SELECT
				A.ASSET_ID, A.[TYPE_ID],C.[TYPE_CODE],  C.[TYPE_NAME], A.GROUP_ID,B.GROUP_CODE, B.GROUP_NAME, A.ASSET_CODE, A.ASSET_NAME, A.ASSET_SERIAL_NO, A.ASSET_DESC,
				A.SUP_ID, A.BUY_PRICE, A.AMORT_AMT, A.ASS_TYPE, TR.BRANCH_ID,BR_R.BRANCH_CODE,BR_R.BRANCH_NAME,H.DEP_ID, H.DEP_CODE,
				H.DEP_NAME, A.EMP_ID,EM_R.EMP_CODE,EM_R.EMP_NAME,
				A.BUY_DATE, A.USE_DATE, A.SPECIAL_ASS, A.AMORT_MONTH, A.AMORT_RATE, A.AMORT_START_DATE, A.AMORT_END_DATE,
				A.FIRST_AMORT_AMT, 
				A.AMORTIZED_MONTH, 
				(A.AMORT_MONTH - A.AMORTIZED_MONTH) AS REMAIN_MONTH,
				A.AMORTIZED_AMT, 
				ISNULL((A.AMORT_AMT - A.AMORTIZED_AMT), A.AMORT_AMT) AS REMAIN_AMORTIZED_AMT,  --So tien khau hao con lai
				A.PO_ID, A.WAREHOUSE_ID, A.LOCATION, A.REF_ASSET_ID,
				A.REF_AMORTIZED_AMT,
				A.WARRANTY_MONTHS, 				
				A.AMORT_STATUS, 
				D.STATUS_NAME AMORT_STATUS_NAME, 
				A.ASS_STATUS, 
				E.STATUS_NAME ASS_STATUS_NAME, --Tinh trang tai san
				A.ASS_STATUS_DESC,
				A.RECORD_STATUS, 
				A.AUTH_STATUS, 
				ZZ.AUTH_STATUS_NAME,
				A.MAKER_ID, 
				A.CREATE_DT, 
				A.CHECKER_ID, 
				A.APPROVE_DT,
				TR.[DESCRIPTION], TR.BRANCH_CREATE,TR.LOCATION,TR.[DESCRIPTION],TR.TRANSFER_MULTI_ID,
				ISNULL(TR.REMAIN_VALUE,A.AMORT_AMT-A.AMORTIZED_AMT) ASREMAIN_AMT,
				--B.CREATE_DT AS CREATE_DT_ASS,
				A.CREATE_DT AS CREATE_DT_ASS, -- HUNDGDV FIX NGAY NHAP TAI SAN
				MK.BRANCH_NAME AS BRANCH_CREATE_NAME,MK.TLSUBBRID,A.BUY_DATE, TR.REMAIN_VALUE,
				BR_R.FATHER_ID, TR.EMP_ID AS EMP_CONTRACT_ID,

				-- hungdv fix hien don vi su dung
--				A.BRANCH_ID as BRANCH_ID_OLD,
--				B_A.BRANCH_NAME AS BRANCH_NAME_OLD,
--				A.DEPT_ID AS DEPT_ID_OLD,
--				D_A.DEP_NAME AS DEPT_NAME_OLD,
--				A.EMP_ID AS EMP_ID_OLD,
--				E_A.EMP_NAME AS EMP_NAME_OLD,
                TR.BRANCH_ID_OLD,
				B_A.BRANCH_NAME AS BRANCH_NAME_OLD,
                TR.DEPT_ID_OLD,
				D_A.DEP_NAME AS DEPT_NAME_OLD,
                TR.EMP_ID_OLD,
				E_A.EMP_NAME AS EMP_NAME_OLD,
        (CASE WHEN EXISTS(SELECT 1 FROM dbo.ASS_ENTRIES_POST WHERE TRN_ID=@TRANS_MULTI_MASTER_ID AND REF_NO IS NULL) THEN 1
        ELSE 0
        END) AS IS_REF_NO


		FROM [dbo].[ASS_TRANSFER_MULTI_DT] TR
		LEFT JOIN ASS_MASTER A ON A.ASSET_ID = TR.ASSET_ID
		LEFT JOIN ASS_GROUP B ON A.GROUP_ID = B.GROUP_ID
		LEFT JOIN ASS_TYPE C ON A.[TYPE_ID] = C.[TYPE_ID]
		LEFT JOIN ASS_AMORT_STATUS D ON A.AMORT_STATUS = D.STATUS_CODE
		LEFT JOIN ASS_STATUS E ON A.ASS_STATUS = E.STATUS_ID
		LEFT JOIN CM_AUTH_STATUS ZZ ON ZZ.AUTH_STATUS = TR.AUTH_STATUS
		LEFT JOIN CM_BRANCH BR_R ON BR_R.BRANCH_ID=TR.BRANCH_ID
		LEFT JOIN CM_EMPLOYEE EM_R ON EM_R.EMP_ID=TR.EMP_ID
		LEFT JOIN CM_DEPARTMENT H ON H.DEP_ID = TR.DEPT_ID
		LEFT JOIN TL_USER MK ON MK.TLNANME = TR.MAKER_ID
		-- HUNGDV FIX HIEN THI DON VI SU DUNG
--		LEFT JOIN CM_BRANCH B_A ON A.BRANCH_ID = B_A.BRANCH_ID
--		LEFT JOIN CM_DEPARTMENT D_A ON A.DEPT_ID = D_A.DEP_ID
--		LEFT JOIN CM_EMPLOYEE E_A ON A.EMP_ID = E_A.EMP_ID
        
		LEFT JOIN CM_BRANCH B_A ON TR.BRANCH_ID_OLD = B_A.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT D_A ON TR.DEPT_ID_OLD = D_A.DEP_ID
		LEFT JOIN CM_EMPLOYEE E_A ON TR.EMP_ID_OLD = E_A.EMP_ID

 WHERE 1=1 
  AND TR.TRANS_MULTI_MASTER_ID= @TRANS_MULTI_MASTER_ID