eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CN_SRP_RC_ACHIEVEMENT_ITD

Source

View Text - Preformatted


SELECT srcap_p.srp_plan_assign_id, srcap_p.revenue_class_id, srcap_p.quota_id, srcap_p.period_id, srcap_p.salesrep_id, srcap_p.interval_type_id, SUM(NVL(srcap_i.perf_achieved_ptd,0)), SUM(NVL(srcap_i.quota_ptd,0)), SUM(NVL(srcap_i.performance_goal_ptd,0)) FROM cn_srp_rc_achievement_ptd srcap_p, cn_srp_rc_achievement_ptd srcap_i, cn_cal_per_int_types cpit_p, cn_cal_per_int_types cpit_i WHERE srcap_p.period_id = cpit_p.cal_period_id AND srcap_p.interval_type_id = cpit_p.interval_type_id AND srcap_i.period_id = cpit_i.cal_period_id AND srcap_i.interval_type_id = cpit_i.interval_type_id AND cpit_p.interval_number >= cpit_i.interval_number AND srcap_p.srp_plan_assign_id = srcap_i.srp_plan_assign_id AND srcap_p.revenue_class_id = srcap_i.revenue_class_id AND srcap_p.quota_id = srcap_i.quota_id AND srcap_p.salesrep_id = srcap_i.salesrep_id GROUP BY srcap_p.interval_type_id, srcap_p.revenue_class_id, srcap_p.quota_id, srcap_p.period_id, srcap_p.srp_plan_assign_id, srcap_p.salesrep_id

View Text - HTML Formatted

SELECT SRCAP_P.SRP_PLAN_ASSIGN_ID
, SRCAP_P.REVENUE_CLASS_ID
, SRCAP_P.QUOTA_ID
, SRCAP_P.PERIOD_ID
, SRCAP_P.SALESREP_ID
, SRCAP_P.INTERVAL_TYPE_ID
, SUM(NVL(SRCAP_I.PERF_ACHIEVED_PTD
, 0))
, SUM(NVL(SRCAP_I.QUOTA_PTD
, 0))
, SUM(NVL(SRCAP_I.PERFORMANCE_GOAL_PTD
, 0))
FROM CN_SRP_RC_ACHIEVEMENT_PTD SRCAP_P
, CN_SRP_RC_ACHIEVEMENT_PTD SRCAP_I
, CN_CAL_PER_INT_TYPES CPIT_P
, CN_CAL_PER_INT_TYPES CPIT_I
WHERE SRCAP_P.PERIOD_ID = CPIT_P.CAL_PERIOD_ID
AND SRCAP_P.INTERVAL_TYPE_ID = CPIT_P.INTERVAL_TYPE_ID
AND SRCAP_I.PERIOD_ID = CPIT_I.CAL_PERIOD_ID
AND SRCAP_I.INTERVAL_TYPE_ID = CPIT_I.INTERVAL_TYPE_ID
AND CPIT_P.INTERVAL_NUMBER >= CPIT_I.INTERVAL_NUMBER
AND SRCAP_P.SRP_PLAN_ASSIGN_ID = SRCAP_I.SRP_PLAN_ASSIGN_ID
AND SRCAP_P.REVENUE_CLASS_ID = SRCAP_I.REVENUE_CLASS_ID
AND SRCAP_P.QUOTA_ID = SRCAP_I.QUOTA_ID
AND SRCAP_P.SALESREP_ID = SRCAP_I.SALESREP_ID GROUP BY SRCAP_P.INTERVAL_TYPE_ID
, SRCAP_P.REVENUE_CLASS_ID
, SRCAP_P.QUOTA_ID
, SRCAP_P.PERIOD_ID
, SRCAP_P.SRP_PLAN_ASSIGN_ID
, SRCAP_P.SALESREP_ID