DECLARE @listTRADE TABLE
			(
				GOODS_ID VARCHAR(20),
				TRADE_ID VARCHAR(20),
				PLAN_ID VARCHAR(20),
				AMT_APP DECIMAL(18,2),
				AMT_EXE DECIMAL (18,2),
				AMT_ETM DECIMAL (18,2),
				AMT_TF DECIMAL (18,2),
				AMT_RECEIVE_TF DECIMAL (18,2),
        NOTES NVARCHAR(1000),
        AMT_ETM_TMP DECIMAL (18,2)
			)
INSERT INTO @listTRADE
		  (GOODS_ID,TRADE_ID,PLAN_ID,AMT_APP,AMT_EXE,AMT_ETM,AMT_TF,AMT_RECEIVE_TF,NOTES,AMT_ETM_TMP)
          SELECT * FROM
          (
          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 
		  FROM dbo.PL_REQUEST_DOC_DT WHERE REQ_ID='PLRD00000205773'
          UNION ALL
          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 
		  FROM dbo.PL_REQUEST_TRANSFER WHERE REQ_DOC_ID='PLRD00000205773'
          UNION ALL
          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
		  FROM dbo.PL_REQUEST_TRANSFER WHERE REQ_DOC_ID='PLRD00000205773'
          )
		  T GROUP BY GOODS_ID,TRADE_ID,PLAN_ID,AMT_APP,AMT_EXE,AMT_ETM,AMT_TF,AMT_RECEIVE_TF,NOTES,AMT_ETM_TMP

	SELECT * FROM @listTRADE