ECC iProcurement, iProcurement Frequently Requested Items, SQL2

Description
Categories: Enterprise Command Center
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
Run ECC iProcurement, iProcurement Frequently Requested Items, SQL2 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT /*+ leading(a.freqs) no_push_pred(a.ecc_items)*/DISTINCT
              ecc_spec_id,
              business_group_id
              from icx_cat_ecc_freq_items_v a
) x
where
2=2
Blitz Report™