ECC Quality Management, Quota and Attainment
Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Ecc Last Update Date, Srp Per Quota Rc Id, Revenue Class Id, Target Achv Year To Date, Target Achv Period To Date, Target Achv Quota To Date, Srp Quota Rule Id, Quota Rule Id, Revenue Class Target ...
Columns: Ecc Spec Id, Ecc Last Update Date, Srp Per Quota Rc Id, Revenue Class Id, Target Achv Year To Date, Target Achv Period To Date, Target Achv Quota To Date, Srp Quota Rule Id, Quota Rule Id, Revenue Class Target ...
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:
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:
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 |