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_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