ECC Inventory Management, Activities

select
x.*
from
(
SELECT * FROM (SELECT * FROM inv_ecc_activity_v
	 WHERE language in ('US'))
	 	 PIVOT (MAX(SOURCE_ZONE) AS SOURCE_ZONE
   ,MAX(DESTINATION_ZONE) AS DESTINATION_ZONE
   ,MAX(ACTIVITY) AS ACTIVITY
   ,MAX(ACTIVITY_DETAIL) AS ACTIVITY_DETAIL
   ,MAX(OPERATION) AS OPERATION
   ,MAX(TRANSACTION_TYPE) AS TRANSACTION_TYPE
   ,MAX(EXECUTIONMODES) AS EXECUTIONMODES
   ,MAX(TASKMETHOD) AS TASKMETHOD
   for LANGUAGE in ('US' "US"))
) x
where
2=2