TR_REQ_PAY_BUDGET_ByID.txt
| 1 |
|
|---|---|
| 2 |
ALTER PROC [dbo].[TR_REQ_PAY_BUDGET_ByID] |
| 3 |
@p_REQ_PAY_ID VARCHAR(1500) = NULL |
| 4 |
AS |
| 5 |
BEGIN |
| 6 |
-- NHIEU PO HOAC SO PHIEU TAM UNG / THANH TOAN |
| 7 |
DECLARE @l_LSTSERI TABLE ( |
| 8 |
[ID] [int] IDENTITY(1,1) NOT NULL, |
| 9 |
[VALUE] [NVARCHAR](MAX) NULL) |
| 10 |
DECLARE @l_FILENAME VARCHAR(MAX) |
| 11 |
INSERT INTO @l_LSTSERI SELECT VALUE FROM WSISPLIT(@p_REQ_PAY_ID,';') |
| 12 |
---- |
| 13 |
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, |
| 14 |
0.0 AMT_REMAIN_HIS |
| 15 |
FROM TR_REQ_PAY_BUDGET A |
| 16 |
LEFT JOIN PL_TRADEDETAIL B ON A.TRADE_ID = B.TRADE_ID |
| 17 |
LEFT JOIN CM_GOODS G ON B.GOODS_ID = G.GD_ID |
| 18 |
LEFT JOIN dbo.PL_IMPORT_DT LOG_DT ON LOG_DT.TRADE_ID=A.TRADE_ID |
| 19 |
WHERE A.REQ_PAY_ID IN (SELECT VALUE FROM @l_LSTSERI) |
| 20 |
END |