VIEW: APPS.CNSRMT_RC_ACHIEVEMENT_V

Source

View Text - Preformatted

SELECT max( RC.NAME ) , SRP.PERIOD_TO_DATE , SUM (srp2.period_to_date) ,srp.period_to_date_f , SUM (srp2.period_to_date_f) , SRP.PERIOD_ID , SRP.QUOTA_ID , SRP.SALESREP_ID , SRP.REVENUE_CLASS_ID FROM CN_SRP_PER_QUOTA_RC SRP2, CN_REVENUE_CLASSES RC, CN_SRP_PER_QUOTA_RC SRP WHERE SRP.REVENUE_CLASS_ID = RC.REVENUE_CLASS_ID AND SRP2.REVENUE_CLASS_ID = SRP.REVENUE_CLASS_ID AND SRP2.PERIOD_ID <= SRP.PERIOD_ID AND floor(srp2.period_id/1000) =floor(srp.period_id/1000) AND SRP2.SALESREP_ID = SRP.SALESREP_ID AND SRP2.QUOTA_ID = SRP.QUOTA_ID AND SRP2.SRP_PLAN_ASSIGN_ID = SRP.SRP_PLAN_ASSIGN_ID GROUP BY SRP.PERIOD_ID, SRP.SALESREP_ID, SRP.REVENUE_CLASS_ID, SRP.QUOTA_ID, SRP.PERIOD_TO_DATE, SRP.PERIOD_TO_DATE_f

View Text - HTML Formatted

SELECT MAX( RC.NAME )
, SRP.PERIOD_TO_DATE
, SUM (SRP2.PERIOD_TO_DATE)
, SRP.PERIOD_TO_DATE_F
, SUM (SRP2.PERIOD_TO_DATE_F)
, SRP.PERIOD_ID
, SRP.QUOTA_ID
, SRP.SALESREP_ID
, SRP.REVENUE_CLASS_ID
FROM CN_SRP_PER_QUOTA_RC SRP2
, CN_REVENUE_CLASSES RC
, CN_SRP_PER_QUOTA_RC SRP
WHERE SRP.REVENUE_CLASS_ID = RC.REVENUE_CLASS_ID
AND SRP2.REVENUE_CLASS_ID = SRP.REVENUE_CLASS_ID
AND SRP2.PERIOD_ID <= SRP.PERIOD_ID
AND FLOOR(SRP2.PERIOD_ID/1000) =FLOOR(SRP.PERIOD_ID/1000)
AND SRP2.SALESREP_ID = SRP.SALESREP_ID
AND SRP2.QUOTA_ID = SRP.QUOTA_ID
AND SRP2.SRP_PLAN_ASSIGN_ID = SRP.SRP_PLAN_ASSIGN_ID GROUP BY SRP.PERIOD_ID
, SRP.SALESREP_ID
, SRP.REVENUE_CLASS_ID
, SRP.QUOTA_ID
, SRP.PERIOD_TO_DATE
, SRP.PERIOD_TO_DATE_F