ECC iProcurement, iProcurement Top Categories, SQL2

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Business Group Id, Org Id ...
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
              ecc_spec_id,
              business_group_id ,
              ORG_ID
              from icx_cat_ecc_top_categories_v 
) 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