ECC iProcurement, iProcurement Frequently Requested Items, SQL2

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Business Group Id ...
Imported from Enterprise Command Center
Dataset Key: icx-freq-items
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure:
select
x.*
from
(
SELECT DISTINCT
              ecc_spec_id,
              business_group_id
              from icx_cat_ecc_freq_items_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