ECC iProcurement, iProcurement Top Categories, SQL2

➜ Back to Library
Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Business Group Id, Org Id ...
Imported from Enterprise Command Center
Dataset Key: icx-top-categories
Query Procedure: ICX_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure: 
select
x.*
from
(
SELECT
              ecc_spec_id,
              business_group_id ,
              ORG_ID
              from icx_cat_ecc_top_categories_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
Download
Related Blitz Reports
ECC iProcurement, iProcurement Top Categories, SQL1 ECC Procurement, Requisitions ECC Sourcing, Negotiations, SQL2 ECC Sourcing, Negotiations, SQL1 ECC Procurement, Indirect Procurement, SQL1 ECC Procurement, Indirect Procurement, SQL4 ECC Procurement, Indirect Procurement, SQL3 ECC Lease Contracts, Lease Meter Errors ECC iProcurement, iProcurement Frequently Requested Items, SQL1
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: