ECC iProcurement, iProcurement Top Categories, SQL2
Description
- Categories
- Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: icx-top-categories
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure: icx_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Dataset Key: icx-top-categories
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure: icx_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
SQL 13 lines
select x.* from ( SELECT ecc_spec_id, business_group_id , ORG_ID, preparer_id from icx_cat_ecc_top_categories_v ) x where 2=2 |
Parameters 1
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Operating Unit | LOV |
|