ECC iProcurement, iProcurement Purchasing News
Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, News Code, Us News Text, Us News Url ...
Columns: Ecc Spec Id, News Code, Us News Text, Us News Url ...
Imported from Enterprise Command Center
Dataset Key: icx-news
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure:
Dataset Key: icx-news
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure:
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Organization Code |
|
LOV |