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

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'