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

ALTER   PROC [dbo].[TR_REQ_PAY_PERIOD_BYID]

@p_REQ_PAY_ID VARCHAR(15)= NULL

AS

BEGIN

SELECT A.* ,ISNULL(B.CONTRACT_CODE,B.CONTRACT_ID) AS CONTRACT_CODE , B.CONTRACT_NAME, C.REQ_PAY_CODE, S.ACC_NUM,S.ACC_NAME,S.BANK_NAME,S.ACC_NUM_OUT,S.ACC_NAME_OUT,S.BANK_NAME_OUT, D.REQ_PAY_CODE AS SO_PHIEU_TAM_UNG,D.REQ_DT AS NGAY_TAM_UNG,

	S.TAX_NO AS SUP_TAX_NO, B.END_DT AS END_DT

FROM TR_REQ_PAY_PERIOD A

LEFT JOIN TR_CONTRACT B ON A.CONTRACT_ID = B.CONTRACT_ID

LEFT JOIN CM_SUPPLIER S ON B.SUP_ID = S.SUP_ID

LEFT JOIN TR_REQ_PAYMENT C ON A.REQ_PAY_ID = C.REQ_PAY_ID

LEFT JOIN TR_REQ_ADVANCE_PAYMENT D ON A.AD_PAY_ID = D.REQ_PAY_ID

WHERE A.REQ_PAY_ID =@p_REQ_PAY_ID

END