ALTER PROC [dbo].[TR_REQ_PAY_TRANSFER_OUTSIDE_TRANS_ById]
@p_REQ_PAY_ID varchar(15) = NULL
AS
BEGIN
	SELECT A.*, CM1.CONTENT as TYPE_TRANSFER_NAME, CM2.CONTENT AS PRODUCT_NAME, CM3.CONTENT AS OBJECT_TRANSFER_NAME, CM4.ACC_NAME AS ACC_NAME_TRANSFER,
	'VND' AS CURRENCY, BR.BRANCH_NAME, BR.BRANCH_CODE
	FROM TR_REQ_PAY_TRANS_OUTSIDE_TRANS A 
	--LEFT JOIN TL_USER T ON A.EMP_ID = T.TLNANME
	LEFT JOIN CM_ALLCODE CM1 ON A.TYPE_TRANSFER_ID = CM1.CDVAL AND CM1.CDNAME = 'TR_REQ' AND CM1.CDTYPE = 'TYPE_TRANSFER'
	LEFT JOIN CM_ALLCODE CM2 ON A.PRODUCT_ID = CM2.CDVAL AND CM2.CDNAME = 'TR_REQ' AND CM2.CDTYPE = 'OBJECT_TRANSFER'
	LEFT JOIN CM_ALLCODE CM3 ON A.OBJECT_TRANSFER_ID = CM3.CDVAL AND CM3.CDNAME = 'TR_REQ' AND CM3.CDTYPE = 'PRODUCT_TRANS'
	LEFT JOIN CM_ACCOUNT CM4 ON A.ACC_NO_TRANSFER = CM4.ACC_NO
	LEFT JOIN CM_BRANCH BR ON A.BRANCH_ID = BR.BRANCH_ID
	--LEFT JOIN CM_ALLCODE CM4 ON A.BRANCH_ID = CM4.CDVAL AND CM4.CDNAME = 'TR_REQ' AND CM4.CDTYPE = 'REQ_DRIVE'
	 WHERE A.REQ_PAY_ID =@p_REQ_PAY_ID

END