ECC Quality Management, Quota and Attainment
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
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
Run
ECC Quality Management, Quota and Attainment and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
|
LOV |