我目前有以下SQL，在CTE中有2个联合表。目前，MAX（DSTAMP）正在从2个联合表（2条记录）返回最大值，我想要的是两者结合时的最大日期（1条记录）。
SQL在Oracle Server中。

With TA as

(select
    SKU_ID, CODE, FROM_LOC_ID, TO_LOC_ID, EXTRA_NOTES, CONTAINER_ID,
    PALLET_ID, DSTAMP, USER_ID, UPDATE_QTY, ORIGINAL_QTY, LOCK_CODE
from  table 1
WHERE CODE = '####'
AND SITE_ID = '9999'
AND FROM_LOC_ID NOT IN ('####')

UNION

select
    SKU_ID, CODE, FROM_LOC_ID, TO_LOC_ID, EXTRA_NOTES, CONTAINER_ID, 
    PALLET_ID, DSTAMP, USER_ID, UPDATE_QTY, ORIGINAL_QTY, LOCK_CODE
from  table 2
WHERE CODE = '####'
AND SITE_ID = '9999'
AND FROM_LOC_ID NOT IN ('####')

)

SELECT
    SKU_ID, CODE, FROM_LOC_ID, TO_LOC_ID, EXTRA_NOTES, CONTAINER_ID, 
    PALLET_ID, USER_ID, UPDATE_QTY, ORIGINAL_QTY, LOCK_CODE,
    MAX(DSTAMP) as DSTAMP

FROM TA
GROUP BY
   SKU_ID, CODE, FROM_LOC_ID, TO_LOC_ID, EXTRA_NOTES, CONTAINER_ID,
   PALLET_ID, USER_ID, UPDATE_QTY, ORIGINAL_QTY, LOCK_CODE