ECC iProcurement, iProcurement Frequently Requested Items, SQL1

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Org Id, Thumbnail Image, Frequency, Hide Addtocart, Item Rating, Us Description, Us Display Price, Us Is Translation Available ...
Imported from Enterprise Command Center
Dataset Key: icx-freq-items
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure: icx_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
select
x.*
from
(
SELECT * FROM  ( SELECT /*+ leading(a.freqs) no_push_pred(a.ecc_items)*/
              ecc_spec_id,
	      org_id,
	      description,
	      display_price,
	      thumbnail_image,
	      language,
	      Sum(reqs_count) frequency,
              hide_addtocart,
              item_rating
              from icx_cat_ecc_freq_items_v a WHERE LANGUAGE in ( 'US')
              GROUP BY ecc_spec_id,
	      org_id,
	      description,
	      display_price,
	      thumbnail_image,
              language,
              hide_addtocart,
              item_rating ) PIVOT(
              MAX(description) AS DESCRIPTION,
              MAX(display_price) AS DISPLAY_PRICE,
              COUNT(1) AS IS_TRANSLATION_AVAILABLE
              FOR LANGUAGE IN ('US' "US"))
) x
where
2=2