[Home] [Help] [Dependency Information]

TABLE: CN.CN_SRP_QUOTA_ASSIGNS_ALL

Object Details

Object Name:	CN_SRP_QUOTA_ASSIGNS_ALL
Object Type:	TABLE
Owner:	CN
FND Design Data:	CN.CN_SRP_QUOTA_ASSIGNS_ALL
Subobject Name:
Status:	VALID

CN_SRP_QUOTA_ASSIGNS contains information about the plan elements
that have been assigned to a salesperson.You need one row for each
plan element that belongs to the compensation plan.
.
Most values in this table are denormalized from the source plan elemen
t in table CN_QUOTAS.
You can customize the TARGET or PAYMENT_AMOUNT by setting the
CUSTOMIZED_FLAG TO 'Y' - these values are now 'local' and will
not be changed by an update to the corresponding columns in
CN_QUOTAS. When the plan element is not customized all changes
to the record in CN_QUOTAS will be propogated to all occurrences of
the plan element in CN_SRP_QUOTA_ASSIGNS
.
The user cannot directly insert into or delete from this table. Rows
are automatically created when you assign a compensation plan to a
salesperson and when you add a plan element to the source
compensation plan. Rows are deleted when you delete the
compensation plan assignment from CN_SRP_PLAN_ASSIGNS
or the source record from CN_QUOTAS.
.
There are four types of plan element:
.
{{"bul:1"}}Revenue Quota
.
{{"bul:1"}}Revenue Non Quota
.
{{"bul:1"}}Draw
.
{{"bul:1"}}Manual
.
{{"bul:1"}}Unit Quota
.
{{"bul:1"}}Unit Non Quota
.
{{"bul:1"}}Discount
.
{{"bul:1"}}Margin
.
{{"bodytext"}}
Revenue based plan elements do not use TARGET.
.
Draw plan elements store the draw amount in the PAYMENT_AMOUNT column.

They do not have revenue classes or a rate table. They do not use
TARGET, PAYMENT_TYPE_CODE or RATE_SCHEDULE_ID
.
Manual plan elements do not have revenue classes, period targets or a
rate table.
They do not use TARGET, PAYMENT_TYPE_CODE, PAYMENT_AMOUNT,
PERIOD_TARGET_UNIT_CODE or RATE_SCHEDULE_ID.
.
SRP_QUOTA_ASSIGN_ID is the unique system-generated primary key and is
invisible to the user.
Currently PERIOD_TARGET_DIST_RULE_CODE is invisible to the user and i
s always set to 'EQUAL'.
.
There are three types of period target unit: Period, Quarter and
Year.
They determine how period target/draw values are displayed. Period
displays values for each individual period, quarter displays the total
for each quarter and year displays the total for the calendar year.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CN_SRP_QUOTA_ASSIGNS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SRP_QUOTA_ASSIGN_ID ORG_ID
CN_SRP_QUOTA_ASSIGNS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SRP_PLAN_ASSIGN_ID QUOTA_ID
CN_SRP_QUOTA_ASSIGNS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTA_ID

Columns

Query Text

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

SELECT SRP_QUOTA_ASSIGN_ID
,      SRP_PLAN_ASSIGN_ID
,      QUOTA_ID
,      RATE_SCHEDULE_ID
,      DISC_RATE_SCHEDULE_ID
,      TARGET
,      CUSTOMIZED_FLAG
,      PERIOD_TARGET_DIST_RULE_CODE
,      QUOTA_TYPE_CODE
,      PAYMENT_AMOUNT
,      PERIOD_TYPE_CODE
,      ATTRIBUTE_CATEGORY
,      PERIOD_TARGET_UNIT_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      PAYEE_SALESREP_ID
,      SHARED_ACC_SALESREP_ID
,      PERFORMANCE_GOAL
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM CN.CN_SRP_QUOTA_ASSIGNS_ALL;

Dependencies

[top of page]

CN.CN_SRP_QUOTA_ASSIGNS_ALL does not reference any database object

CN.CN_SRP_QUOTA_ASSIGNS_ALL is referenced by following:

CN

CN_SRP_QUOTA_ASSIGNS_ALL#