ECC Quality Management, Quota and Attainment

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Incentive Compensation Quota and Attainment Data Set
Dataset Key: cn-quota
Query Procedure: CN_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CN_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 * FROM CN_ECC_QUOTA_V WHERE LANGUAGE IN ('US')) PIVOT
                                        (max(OPERATING_UNIT) as OPERATING_UNIT,
										 max(ROLE)      	 as ROLE,
										 max(SALESREP)       as SALESREP,
										 max(interval_type)  as interval_type
										 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 Quality Management, Recent Jobs ECC Quality Management, Sales Transaction ONT Salesperson Order Summary ECC Receivables, Payment Process, SQL2 ECC Lease Contracts, Fees ECC Assets, Pipeline ECC Receivables, Outstanding Receivables (14) ECC Service, Service Notes ECC Process Manufacturing, Production Quality
Blitz Report™

Blitz Report™ provides multiple benefits: