ECC iProcurement, iProcurement Frequently Requested Items, SQL1

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 30 lines

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)