ECC iProcurement, iProcurement Frequently Requested Items, SQL1

➜ Back to Library
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
x.*
from
(
SELECT * FROM  ( SELECT /*+ leading(a.freqs) no_push_pred(a.ecc_items)*/
              ecc_spec_id,
	      org_id,
	      description,
	      display_price,
	      thumbnail_image,
	      language,
	      Sum(reqs_count) frequency,
              hide_addtocart,
              item_rating
              from icx_cat_ecc_freq_items_v a WHERE LANGUAGE in ( 'US')
              GROUP BY ecc_spec_id,
	      org_id,
	      description,
	      display_price,
	      thumbnail_image,
              language,
              hide_addtocart,
              item_rating ) PIVOT(
              MAX(description) AS DESCRIPTION,
              MAX(display_price) AS DISPLAY_PRICE,
              COUNT(1) AS IS_TRANSLATION_AVAILABLE
              FOR LANGUAGE IN ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit 
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
 LOV
Download
 
Related Blitz Reports
ECC iProcurement, iProcurement Frequently Requested Items, SQL2 ECC Procurement, Requisitions ECC Sourcing, Negotiations, SQL2 ECC Sourcing, Negotiations, SQL1 ECC Procurement, Indirect Procurement, SQL1 ECC Procurement, Indirect Procurement, SQL3 ECC Procurement, Indirect Procurement, SQL4 ECC iProcurement, iProcurement Top Categories, SQL2 ECC iProcurement, iProcurement Purchasing News
Blitz Report™

Blitz Report™ provides multiple benefits: