ECC Quality Management, Quota and Attainment, SQL1

Description
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 ECC
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"))