ECC iProcurement, iProcurement Frequently Requested Items, SQL2

➜ Back to Library
XLSExcel example XMLXML import file

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

SQL 12 lines

select
x.*
from
(
SELECT /*+ leading(a.freqs) no_push_pred(a.ecc_items)*/DISTINCT
              ecc_spec_id,
              business_group_id,
              preparer_id
              from icx_cat_ecc_freq_items_v a
) x
where
2=2

Parameters 1

ParameterTypeList of values SQL
Operating UnitLOV
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)