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 ...
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:
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