FILE 2.txt
| 1 |
SELECT TB.GOODS_ID ,SUM(TB.TOTAL_AMT) AS TOTAL_AMT_EXE, |
|---|---|
| 2 |
SUM(ISNULL(PT.AMT_APP,0) + ISNULL(PT.AMT_RECEIVE_TF,0) - ISNULL(PT.AMT_TF,0) - ISNULL(PT.AMT_ETM,0)) AS TOTAL_AMT_REMAIN , |
| 3 |
SUM(ISNULL(PLTF.TOTAL_AMT,0)) AS TOTAL_TF |
| 4 |
FROM dbo.PL_REQUEST_DOC_DT TB |
| 5 |
LEFT JOIN dbo.PL_TRADEDETAIL PT ON PT.TRADE_ID=TB.TRADE_ID |
| 6 |
LEFT JOIN dbo.PL_REQUEST_TRANSFER PLTF ON PLTF.TO_GOOD_ID=TB.GOODS_ID AND PLTF.REQ_DOC_ID=TB.REQ_ID |
| 7 |
WHERE TB.REQDT_TYPE='O' AND TB.REQ_ID='PLRD00000200324' |
| 8 |
GROUP BY TB.GOODS_ID |