ECC iProcurement, iProcurement Top Categories, SQL1

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Thumbnail Image, Frequency, Us Category Name, Us Is Translation Available ...
Imported from Enterprise Command Center
Dataset Key: icx-top-categories
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure:
select
x.*
from
(
SELECT * FROM  ( SELECT
              ecc_spec_id,
              max(category_name) AS CATEGORY_NAME,
              thumbnail_image,
              language,
              sum(reqs_count) frequency
              from icx_cat_ecc_top_categories_v  WHERE LANGUAGE in ( 'US')    --pivot uptake in v4
              GROUP BY ecc_spec_id, thumbnail_image, language  ) PIVOT(
              MAX(category_name) AS CATEGORY_NAME,
              COUNT(1) AS IS_TRANSLATION_AVAILABLE
              FOR LANGUAGE IN ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code
x.organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:organization_code)
LOV