SELECT TB.GOODS_ID ,SUM(TB.TOTAL_AMT) AS TOTAL_AMT_EXE,
		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 ,
		SUM(ISNULL(PLTF.TOTAL_AMT,0)) AS TOTAL_TF
		FROM dbo.PL_REQUEST_DOC_DT TB
		LEFT JOIN dbo.PL_TRADEDETAIL PT ON PT.TRADE_ID=TB.TRADE_ID
		LEFT JOIN dbo.PL_REQUEST_TRANSFER PLTF ON PLTF.TO_GOOD_ID=TB.GOODS_ID AND PLTF.REQ_DOC_ID=TB.REQ_ID
		WHERE TB.REQDT_TYPE='O' AND TB.REQ_ID='PLRD00000200324'
		GROUP BY TB.GOODS_ID