ALTER PROCEDURE [dbo].[TR_REQ_PAY_TRANSFER_DT_BYID]
@p_TRANSER_ID VARCHAR(15) =NULL
AS
BEGIN
SELECT A.TRAN_DT_ID, A.TRANSFER_ID,A.REQ_PAY_ID,A.TOTAL_AMT,A.TOAL_AMT_DO AS TOTAL_AMT_DO,A.TOTAL_AMT_REMAIN, A.TOTAL_AMT_REAL,A.TOTAL_AMT_REMAIN_FN,A.NOTES,A.REASON , B.REQ_PAY_CODE, B.REQ_REASON , B.REQ_TYPE AS REQ_TYPE_NAME, C.BRANCH_CODE, C.BRANCH_NAME, D.DEP_CODE, D.DEP_NAME,
'' AS CREATE_NAME, '' AS CHECKER_NAME, '' AS CREATE_KT_NAME, '' AS CHECKER_KT_NAME, B.CREATE_DT AS NGAY_TAO, B.APPROVE_DT AS NGAY_DUYET, B.MAKER_ID_KT, B.CHECKER_ID_KT, B.REQ_TYPE_CURRENCY, B.RATE ,
A.TOTAL_AMT_REMAIN* B.RATE AS THANH_TIEN_QD, B.REQ_TYPE
FROM TR_REQ_PAY_TRANSFER_DT  A
LEFT JOIN TR_REQ_ADVANCE_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID
LEFT JOIN CM_BRANCH C ON B.BRANCH_CREATE = C.BRANCH_ID
LEFT JOIN CM_DEPARTMENT D ON B.DEP_ID= D.DEP_ID
LEFT JOIN TL_USER E ON B.MAKER_ID = E.TLNANME
WHERE A.TRANSFER_ID =@p_TRANSER_ID
END