|
1
|
DECLARE @listTRADE TABLE
|
|
2
|
(
|
|
3
|
GOODS_ID VARCHAR(20),
|
|
4
|
TRADE_ID VARCHAR(20),
|
|
5
|
PLAN_ID VARCHAR(20),
|
|
6
|
AMT_APP DECIMAL(18,2),
|
|
7
|
AMT_EXE DECIMAL (18,2),
|
|
8
|
AMT_ETM DECIMAL (18,2),
|
|
9
|
AMT_TF DECIMAL (18,2),
|
|
10
|
AMT_RECEIVE_TF DECIMAL (18,2),
|
|
11
|
NOTES NVARCHAR(1000),
|
|
12
|
AMT_ETM_TMP DECIMAL (18,2)
|
|
13
|
)
|
|
14
|
INSERT INTO @listTRADE
|
|
15
|
(GOODS_ID,TRADE_ID,PLAN_ID,AMT_APP,AMT_EXE,AMT_ETM,AMT_TF,AMT_RECEIVE_TF,NOTES,AMT_ETM_TMP)
|
|
16
|
SELECT * FROM
|
|
17
|
(
|
|
18
|
SELECT DISTINCT GOODS_ID,TRADE_ID,PLAN_ID,ISNULL(AMT_APP,0) AS AMT_APP,ISNULL(AMT_EXE,0) AS AMT_EXE,ISNULL(AMT_ETM,0) AS AMT_ETM,ISNULL(AMT_TF,0) AS AMT_TF,ISNULL(AMT_RECEIVE_TF,0) AS AMT_RECEIVE_TF,'' NOTES,ISNULL(AMT_ETM_TMP,0) AS AMT_ETM_TMP
|
|
19
|
FROM dbo.PL_REQUEST_DOC_DT WHERE REQ_ID='PLRD00000205773'
|
|
20
|
UNION ALL
|
|
21
|
SELECT DISTINCT FR_GOOD_ID GOODS_ID,FR_TRADE_ID TRADE_ID,FR_PLAN_ID PLAN_ID,ISNULL(FR_AMT_APP,0) AMT_APP,ISNULL(FR_AMT_EXE,0) AMT_EXE,ISNULL(FR_AMT_ETM,0) AMT_ETM,ISNULL(FR_AMT_TF,0) AMT_TF,ISNULL(FR_AMT_RECEIVE_TF,0) AMT_RECEIVE_TF,'' NOTES,ISNULL(FR_AMT_ETM_TMP,0) AMT_ETM_TMP
|
|
22
|
FROM dbo.PL_REQUEST_TRANSFER WHERE REQ_DOC_ID='PLRD00000205773'
|
|
23
|
UNION ALL
|
|
24
|
SELECT DISTINCT TO_GOOD_ID GOODS_ID,TO_TRADE_ID TRADE_ID,TO_PLAN_ID PLAN_ID,ISNULL(TO_AMT_APP,0) AMT_APP,ISNULL(TO_AMT_EXE,0) AMT_EXE,ISNULL(TO_AMT_ETM,0) AMT_ETM,ISNULL(TO_AMT_TF,0) AMT_TF,ISNULL(TO_AMT_RECEIVE_TF,0) AMT_RECEIVE_TF,'' NOTES,ISNULL(TO_AMT_ETM_TMP,0) AMT_ETM_TMP
|
|
25
|
FROM dbo.PL_REQUEST_TRANSFER WHERE REQ_DOC_ID='PLRD00000205773'
|
|
26
|
)
|
|
27
|
T GROUP BY GOODS_ID,TRADE_ID,PLAN_ID,AMT_APP,AMT_EXE,AMT_ETM,AMT_TF,AMT_RECEIVE_TF,NOTES,AMT_ETM_TMP
|
|
28
|
|
|
29
|
SELECT * FROM @listTRADE
|