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
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |