ECC iProcurement, iProcurement Purchasing News, SQL1

Description
Columns: Ecc Spec Id, News Code, Us News Text, Us News Url ...
Imported from ECC
SELECT * FROM  ( SELECT
              ecc_spec_id,
              news_code,
              news_text,
              news_url,
              language
              from icx_cat_ecc_news_v WHERE LANGUAGE in ( 'US')  ) PIVOT(
              MAX(news_text) AS news_text,
              MAX(news_url) AS news_url
              FOR LANGUAGE IN ('US' "US"))