ALTER PROC [dbo].[RET_MASTER_ById]
@p_RET_ID varchar(15)
AS
	SELECT A.*, 
	B.AUTH_STATUS_NAME, 
	C.CONTENT, 
	D.ASSET_NAME,
	G.DIV_CODE,
	G.DIV_NAME,
	G.ADDR ASS_ADDR,
	E.CONTENT AS RET_STATUS,
	F.TLFullName AS SIGN_USER_FULLNAME,
	D.BRANCH_ID

	FROM RET_MASTER A 
	INNER JOIN CM_AUTH_STATUS B ON B.AUTH_STATUS = A.AUTH_STATUS
	INNER JOIN CM_ALLCODE C ON C.CDVAL = A.RET_TYPE AND C.CDNAME = 'RET_TYPE_2'AND C.CDTYPE = 'RET'
	INNER JOIN CM_ALLCODE E ON E.CDVAL = A.[STATUS] AND E.CDNAME = 'RET_STATUS' AND E.CDTYPE = 'RET'
	INNER JOIN ASS_MASTER D ON D.ASSET_ID = A.ASSET_ID
	LEFT JOIN CM_DIVISION G ON G.DIV_ID=D.DIVISION_ID
	-------------------BAODNQ 16/2/2022: Kết thêm bảng--------------
	LEFT JOIN TL_USER F ON A.SIGN_USER = F.TLNANME

	WHERE A.RET_ID=@p_RET_ID