[Home] [Help]
View: BIL_FCTV_QUOTAS
Product: | BIL - Sales Intelligence (Obsolete) |
Description: | Qunatitative measures related to salesforce quotas |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CPS.PERIOD_NAME
, JRS.RESOURCE_ID
, CSPQ.QUOTA_ID
, CSPA.COMP_PLAN_ID
, CSPQ.ORG_ID
, CPS.START_DATE
, CPS.END_DATE
, CSPQ.TARGET_AMOUNT
, CSPQ.PERF_ACHIEVED_PTD
FROM CN_PERIOD_STATUSES_ALL CPS
, CN_SRP_PLAN_ASSIGNS_ALL CSPA
, CN_SRP_PERIOD_QUOTAS_ALL CSPQ
, JTF_RS_SALESREPS JRS
WHERE CSPQ.PERIOD_ID = CPS.PERIOD_ID
AND CSPQ.SRP_PLAN_ASSIGN_ID = CSPA.SRP_PLAN_ASSIGN_ID
AND JRS.SALESREP_ID = CSPQ.SALESREP_ID WITH READ ONLY
Columns
Name |
PERIOD_NAME |
SALESFORCE_FK |
QUOTA_FK |
COMP_PLAN_FK |
ORG_FK |
START_DATE |
END_DATE |
TARGET_AMOUNT |
QUOTA_ACHIEVED_PTD |