DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CNSRMT_RC_ACHIEVEMENT_V

Object Details
Object Name: CNSRMT_RC_ACHIEVEMENT_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Show performance for each revenue class of each plan element


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30)
Salespeople name
PERIOD_TO_DATE NUMBER
Yes period-to-date achievement
YEAR_TO_DATE NUMBER

Year-to-date achievement
PERIOD_TO_DATE_F NUMBER

Forecast period to date achievement
YEAR_TO_DATE_F NUMBER

Forecast year to date achievement
PERIOD_ID NUMBER (15) Yes Period unique identifier
QUOTA_ID NUMBER (15) Yes Quota unique identifier
SALESREP_ID NUMBER (15) Yes Salespeople unique identifier
REVENUE_CLASS_ID NUMBER (15) Yes Revenue class unique identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      PERIOD_TO_DATE
,      YEAR_TO_DATE
,      PERIOD_TO_DATE_F
,      YEAR_TO_DATE_F
,      PERIOD_ID
,      QUOTA_ID
,      SALESREP_ID
,      REVENUE_CLASS_ID
FROM APPS.CNSRMT_RC_ACHIEVEMENT_V;

Dependencies

[top of page]

APPS.CNSRMT_RC_ACHIEVEMENT_V references the following:

SchemaAPPS
SynonymCN_REVENUE_CLASSES
SynonymCN_SRP_PER_QUOTA_RC

APPS.CNSRMT_RC_ACHIEVEMENT_V is not referenced by any database object