[Home] [Help] [Dependency Information]

TABLE: CN.CN_QUOTAS_ALL

Object Details

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

CN_QUOTAS contains information about your plan elements.
You need one row for each plan element you create. 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"}}
Quota based plan elements do not use the CUMULATIVE_FLAG.
.
Revenue based plan elements do not use TARGET. They do use the
CUMULATIVE_FLAG. It is set to Y by default.
.
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, TRX_GROUP_CODE, CUMULATIVE_FLAG 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,
TRX_GROUP_CODE, CUMULATIVE_FLAG, PERIOD_TARGET_UNIT_CODE
or RATE_SCHEDULE_ID.
.
QUOTA_ID is the unique system-generated primary key and is invisible
to the user.
NAME is the unique user defined value you use to identify the plan
element in forms and reports.
.
Currently USAGE_CODE is invisible to the user and is always set to
'ABSOLUTE'
.
ITD_GLAG when checked enable to define different quotas for the valid
periods as defined by the start_preiod and the end_period of the Plan
Element.
.
SPLIT_FLAG when checked splits the commission across the commission
rate tiers. If the SPLIT_FLAG is not checked then the commission will
be be paid at the higher rate tier. SPLIT_FLAG is checked as default
for the Revene Quota Plan Element type when the Apply Trasnaction is
INDIVIDUAL.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CN_QUOTAS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUOTA_ID ORG_ID
CN_QUOTAS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALC_FORMULA_ID
CN_QUOTAS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NAME ORG_ID

Columns

Query Text

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

SELECT ORG_ID
,      QUOTA_ID
,      NAME
,      RATE_SCHEDULE_ID
,      DISC_RATE_SCHEDULE_ID
,      QUOTA_TYPE_CODE
,      DISCOUNT_OPTION_CODE
,      TARGET
,      DESCRIPTION
,      PERIOD_TYPE_CODE
,      USAGE_CODE
,      PAYMENT_TYPE_CODE
,      PAYMENT_AMOUNT
,      TRX_GROUP_CODE
,      CUMULATIVE_FLAG
,      ITD_FLAG
,      SPLIT_FLAG
,      QUOTA_UNSPECIFIED
,      START_PERIOD_ID
,      END_PERIOD_ID
,      START_NUM
,      END_NUM
,      INCREMENTAL_TYPE
,      ATTRIBUTE_CATEGORY
,      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
,      START_DATE
,      END_DATE
,      INCENTIVE_TYPE_CODE
,      CREDIT_TYPE_ID
,      BONUS_CREDIT_TYPE_ID
,      INTERVAL_TYPE_ID
,      CALC_FORMULA_ID
,      RT_SCHED_CUSTOM_FLAG
,      PAYEE_ASSIGN_FLAG
,      VESTING_FLAG
,      PERFORMANCE_GOAL
,      QUOTA_STATUS
,      PACKAGE_NAME
,      ADDUP_FROM_REV_CLASS_FLAG
,      LIABILITY_ACCOUNT_ID
,      EXPENSE_ACCOUNT_ID
,      QUOTA_GROUP_CODE
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      DELETE_FLAG
,      PAYMENT_GROUP_CODE
,      INDIRECT_CREDIT
,      SALESREPS_ENDDATED_FLAG
FROM CN.CN_QUOTAS_ALL;

Dependencies

[top of page]

CN.CN_QUOTAS_ALL does not reference any database object

CN.CN_QUOTAS_ALL is referenced by following:

APPS

CN_QUOTAS

CN_QUOTAS_ALL