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, Fixed Amount, Plan Element, Quota Target, Plan Element Description, Usage Code, Payment Type Code, Quota Fixed Amount, Trx Group Code, Cumulative Flag, Split Flag, Incremental Type, Start Date, End Date, Incentive Type Code, Credit Type Id, Bonus Credit Type Id, Interval Type Id, Calc Formula Id, Rt Sched Custom Flag, Quota Status, Package Name, Addup From Rev Class Flag, Liability Account Id, Expense Account Id, Quota Group Code, Delete Flag, Payment Group Code, Indirect Credit, Salesreps Enddated Flag, Srp Period Quota Id, Srp Plan Assign Id, Srp Quota Assign Id, Salesrep Id, Employee Number, Resource Id, Period Id, Quota Id, Ptd Target Amt, Quota Achieved Ptd, Commission Payed Ptd, Commission Payed Ytd, Quota Achieved Ytd, Created By, Creation Date, Last Updated By, Last Update Date, Last Update Login, Org Id, Itd Target Amt, Ptd Fixed Amt, Itd Fixed Amt, Trx Amount Ptd, Trx Amount Ytd, Quantity Ptd, Quantity Ytd, Commission Payed Itd, Input Achieved Ptd, Input Achieved Itd, Output Achieved Ptd, Output Achieved Itd, Perf Achieved Ptd, Perf Achieved Itd, Advance Recovered Ptd, Advance Recovered Itd, Advance To Rec Ptd, Advance To Rec Itd, Comm Pend Ptd, Comm Pend Itd, Recovery Amount Ptd, Recovery Amount Itd, Ptd Perf Goal, Itd Perf Goal, Last Rate Tier Id, Last Rates, Rollover, Total Rollover, Transaction Amount Ptd, Transaction Amount Itd, Rate Schedule Id, Srp Quota Target, Customized Flag, Period Target Dist Rule Code, Quota Type Code, Draw Amount, Period Type Code, Period Target Unit Code, Disc Rate Schedule Id, Payee Salesrep Id, Shared Acc Salesrep Id, Performance Goal, Quota Ptd, Ptd Attainment, Itd Attainment, Comp Plan Id, Role Id, Period, Year, Interval Number, Product, Compplan Name, Us Operating Unit, Us Role, Us Salesrep, Us Interval Type

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:

Copy

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 Project Procurement, Procurement Plan JA Cash Flow Statement Program - Cash Flow Detail ECC Receivables, Billing Process, SQL2 ECC Receivables, Billing Process, SQL1 ECC Payables, Installments, SQL1 ECC Payables, Payments

Blitz Report In Action

Blitz Report™

Blitz Report™ provides multiple benefits:

Perfectly formatted Excel reports
Create new or ad-hoc reports in minutes
User configurable reports
Includes seeded reports for all core areas
Toolkits for tuning, management and support
Data governance and audit tracking
Central report repository & version control
Imports BI-Publisher and Discoverer reports
EBS forms interface for user adoption

Find out more

Features

Download

FAQ