ALTER PROCEDURE [dbo].[TR_CONTRACT_DT_BY_REF]
@p_BUILDING_ID varchar(15)
AS
SELECT 
	A.CONTRACT_ID, 
	A.CONTRACT_CODE, 
	A.CONTRACT_NAME, 
	C.CONTENT AS CONTRACT_TYPE,
	D.SUP_ID,
	D.SUP_NAME,
	--A.TOTAL_AMT,
	ISNULL((B.QUANTITY * B.PRICE),0) AS TOTAL_AMT,
	E.BRANCH_ID,
	E.BRANCH_CODE,
	E.BRANCH_NAME,
	A.SIGN_DT,
	A.START_DT,
	A.END_DT
FROM TR_CONTRACT A
	INNER JOIN TR_CONTRACT_DT B ON A.CONTRACT_ID = B.CONTRACT_ID
	LEFT JOIN CM_ALLCODE C ON A.CONT_TYPE = C.CDVAL AND C.CDTYPE = 'CONTRACT' AND C.CDNAME = 'CONTRACT_TYPE'
	LEFT JOIN CM_SUPPLIER D ON A.SUP_ID = D.SUP_ID
	LEFT JOIN CM_BRANCH E ON A.BRANCH_ID = E.BRANCH_ID
WHERE B.BUILDING_ID = @p_BUILDING_ID
AND A.CONT_TYPE IN ('DK', 'MS')
AND A.AUTH_STATUS = 'A'