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

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