ECC iProcurement, iProcurement Purchasing News

➜ Back to Library
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 ( 'US')  ) PIVOT(
              MAX(news_text) AS news_text,
              MAX(news_url) AS news_url
              FOR LANGUAGE IN ('US' "US"))
) x
where
2=2
Download
 
Related Blitz Reports
ECC Procurement, Requisitions ECC iProcurement, iProcurement Top Categories, SQL2 ECC Sourcing, Negotiations, SQL2 ECC iProcurement, iProcurement Top Categories, SQL1 ECC iProcurement, iProcurement Frequently Requested Items, SQL2 ECC Sourcing, Negotiations, SQL1 ECC iProcurement, iProcurement Frequently Requested Items, SQL1 ECC Procurement, Indirect Procurement, SQL1 ECC Procurement, Indirect Procurement, SQL4
Blitz Report™

Blitz Report™ provides multiple benefits: