ECC iProcurement, iProcurement Purchasing News

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: icx-news
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure: icx_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC iProcurement, iProcurement Purchasing News and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * FROM  ( SELECT
              ecc_spec_id,
              news_code,
              news_text,
              news_url,
              language
              from icx_cat_ecc_news_v WHERE LANGUAGE in ( 'FRC')  ) PIVOT(
              MAX(news_text) AS news_text,
              MAX(news_url) AS news_url
              FOR LANGUAGE IN ('US' "US"))
) x
where
2=2