[Home] [Help] [Dependency Information]
Object Name: | CN_QUOTA_RULES_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_QUOTA_RULES_ALL |
Subobject Name: | |
Status: | VALID |
CN_QUOTA_RULES contains information about the revenue classes
assigned to a plan element. You need one row for each revenue class
you use.
QUOTA_RULE_ID is the unique system generated primary key and is
invisible to the user.
Each row contains the revenue class, its target amount and the
payment and target uplift percentages.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_QUOTA_RULES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
QUOTA_RULE_ID
ORG_ID |
CN_QUOTA_RULES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
QUOTA_ID
REVENUE_CLASS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Organization identifier | |
QUOTA_RULE_ID | NUMBER | (15) | Yes | Primary key |
NAME | VARCHAR2 | (30) | Yes | No longer used |
REVENUE_CLASS_ID | NUMBER | (15) | Yes | Revenue class unique identifier |
QUOTA_ID | NUMBER | (15) | Yes | Plan element unique identifier |
TARGET | NUMBER | Yes | Revenue class target amount | |
DESCRIPTION | VARCHAR2 | (1900) | No longer used | |
PAYMENT_FACTOR | NUMBER | |||
QUOTA_FACTOR | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
PAYMENT_AMOUNT | NUMBER | fixed amount at revenue class level | ||
PERFORMANCE_GOAL | NUMBER | Performance Goal | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | This column is used for locking purposes | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, QUOTA_RULE_ID
, NAME
, REVENUE_CLASS_ID
, QUOTA_ID
, TARGET
, DESCRIPTION
, PAYMENT_FACTOR
, QUOTA_FACTOR
, 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
, PAYMENT_AMOUNT
, PERFORMANCE_GOAL
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM CN.CN_QUOTA_RULES_ALL;
CN.CN_QUOTA_RULES_ALL does not reference any database object
CN.CN_QUOTA_RULES_ALL is referenced by following:
|
|
|