ALTER PROC [dbo].[TR_REQ_PAY_BUDGET_ByID]
@p_REQ_PAY_ID VARCHAR(1500) = NULL
AS
BEGIN
-- NHIEU PO HOAC SO PHIEU TAM UNG / THANH TOAN
		DECLARE @l_LSTSERI TABLE (
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[VALUE] [NVARCHAR](MAX) NULL)
		DECLARE @l_FILENAME VARCHAR(MAX)
		INSERT INTO @l_LSTSERI SELECT VALUE FROM WSISPLIT(@p_REQ_PAY_ID,';')
	----
SELECT A.*,ISNULL(G.GD_CODE,LOG_DT.GOOD_CODE) AS GOODS_CODE,B.GOODS_ID AS GOODS_ID,ISNULL( G.GD_NAME,LOG_DT.GOOD_NAME) AS GOODS_NAME,A.RATE,  A.CURRENCY,
 0.0 AMT_REMAIN_HIS
FROM TR_REQ_PAY_BUDGET A
LEFT JOIN PL_TRADEDETAIL B ON A.TRADE_ID = B.TRADE_ID
LEFT JOIN CM_GOODS G ON B.GOODS_ID = G.GD_ID
LEFT JOIN dbo.PL_IMPORT_DT LOG_DT ON LOG_DT.TRADE_ID=A.TRADE_ID
WHERE A.REQ_PAY_ID IN (SELECT VALUE FROM @l_LSTSERI)
END