VIEW: APPS.CN_SRP_RC_ACHIEVEMENT_PTD

Source

View Text - Preformatted

SELECT spqrc.srp_plan_assign_id, spqrc.revenue_class_id, spqrc.quota_id, spqrc.period_id, spqrc.salesrep_id, q.interval_type_id, Nvl(spqrc.period_to_date,0), decode(spq.target_amount , 0 ,0 ,spq.target_amount *(sqr.target/decode(sqa.Target, 0 ,1,sqa.Target))) , Nvl(sqr.performance_goal,0), q.org_id FROM cn_srp_per_quota_rc spqrc, cn_srp_quota_rules_all sqr, cn_quota_rules_all qr, cn_quotas_all q, cn_srp_period_quotas spq , cn_srp_quota_assigns sqa WHERE spqrc.srp_plan_assign_id = sqr.srp_plan_assign_id AND spqrc.revenue_class_id = sqr.revenue_class_id AND sqa.srp_plan_assign_id = spqrc.srp_plan_assign_id AND sqr.quota_rule_id = qr.quota_rule_id AND qr.quota_id = spqrc.quota_id AND spq.quota_id = spqrc.quota_id AND spq.quota_id = qr.quota_id AND sqa.quota_id = spqrc.quota_id AND sqa.quota_id = qr.quota_id AND spq.quota_id = q.quota_id AND qr.revenue_class_id = sqr.revenue_class_id AND q.quota_id = spqrc.quota_id AND q.delete_flag = 'N' AND spqrc.org_id = sqr.org_id AND sqr.org_id = qr.org_id AND spq.org_id =q.org_id AND sqr.org_id =q.org_id AND spq.period_id = spqrc.period_id

View Text - HTML Formatted

SELECT SPQRC.SRP_PLAN_ASSIGN_ID
, SPQRC.REVENUE_CLASS_ID
, SPQRC.QUOTA_ID
, SPQRC.PERIOD_ID
, SPQRC.SALESREP_ID
, Q.INTERVAL_TYPE_ID
, NVL(SPQRC.PERIOD_TO_DATE
, 0)
, DECODE(SPQ.TARGET_AMOUNT
, 0
, 0
, SPQ.TARGET_AMOUNT *(SQR.TARGET/DECODE(SQA.TARGET
, 0
, 1
, SQA.TARGET)))
, NVL(SQR.PERFORMANCE_GOAL
, 0)
, Q.ORG_ID
FROM CN_SRP_PER_QUOTA_RC SPQRC
, CN_SRP_QUOTA_RULES_ALL SQR
, CN_QUOTA_RULES_ALL QR
, CN_QUOTAS_ALL Q
, CN_SRP_PERIOD_QUOTAS SPQ
, CN_SRP_QUOTA_ASSIGNS SQA
WHERE SPQRC.SRP_PLAN_ASSIGN_ID = SQR.SRP_PLAN_ASSIGN_ID
AND SPQRC.REVENUE_CLASS_ID = SQR.REVENUE_CLASS_ID
AND SQA.SRP_PLAN_ASSIGN_ID = SPQRC.SRP_PLAN_ASSIGN_ID
AND SQR.QUOTA_RULE_ID = QR.QUOTA_RULE_ID
AND QR.QUOTA_ID = SPQRC.QUOTA_ID
AND SPQ.QUOTA_ID = SPQRC.QUOTA_ID
AND SPQ.QUOTA_ID = QR.QUOTA_ID
AND SQA.QUOTA_ID = SPQRC.QUOTA_ID
AND SQA.QUOTA_ID = QR.QUOTA_ID
AND SPQ.QUOTA_ID = Q.QUOTA_ID
AND QR.REVENUE_CLASS_ID = SQR.REVENUE_CLASS_ID
AND Q.QUOTA_ID = SPQRC.QUOTA_ID
AND Q.DELETE_FLAG = 'N'
AND SPQRC.ORG_ID = SQR.ORG_ID
AND SQR.ORG_ID = QR.ORG_ID
AND SPQ.ORG_ID =Q.ORG_ID
AND SQR.ORG_ID =Q.ORG_ID
AND SPQ.PERIOD_ID = SPQRC.PERIOD_ID