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
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 ( 'US') ) PIVOT( MAX(news_text) AS news_text, MAX(news_url) AS news_url FOR LANGUAGE IN ('US' "US")) ) x where 2=2 |