[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 |