[Home] [Help] [Dependency Information]
Object Name: | CN_PERIOD_QUOTAS_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_PERIOD_QUOTAS_ALL |
Subobject Name: | |
Status: | VALID |
CN_PERIOD_QUOTAS_ALL stores period target and payment amounts
associated with a plan element.
.
The user cannot directly insert into or delete from this table. Rows
are automatically created for each period that the plan element
is active if the plan element is of type Revenue Quota or Unit
Quota and Apply Trx is Individual and has itd_flag checked. Rows
are deleted when the user turns the itd_flag off or the associated
plan element is deleted. Rows will also be deleted when the active
period range is reduced.
.
PERIOD_QUOTA_ID is the unique system generated primary key invisible
to the user.
.
QUOTA_ID referes to the Quota_ID in the CN_Quotas_ALL.
.
PERIOD_ID refers to the PERIOD_ID in the CN_PERIODS view.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_PERIOD_QUOTAS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_QUOTA_ID
ORG_ID |
CN_PERIOD_QUOTAS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_ID
QUOTA_ID ORG_ID |
CN_PERIOD_QUOTAS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | QUOTA_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_QUOTA_ID | NUMBER | (15) | Yes | Unique identifier |
PERIOD_ID | NUMBER | (15) | Yes | Unique identifier of period to which the target/payment applies |
QUOTA_ID | NUMBER | (15) | Yes | Plan element unique identifier |
PERIOD_TARGET | NUMBER | Target amount of the period | ||
ITD_TARGET | NUMBER | Interval-to-date target | ||
PERIOD_PAYMENT | NUMBER | Payment amount of the period | ||
ITD_PAYMENT | NUMBER | Interval-to-date payment | ||
QUARTER_NUM | NUMBER | (15) | Quarter to which the period belongs | |
PERIOD_YEAR | NUMBER | (15) | Year in which the period resides | |
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 | |
ORG_ID | NUMBER | (15) | Organization identifier | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
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). | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
PERFORMANCE_GOAL | NUMBER | Performance Goal | ||
PERFORMANCE_GOAL_ITD | NUMBER | Interval To Date 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 PERIOD_QUOTA_ID
, PERIOD_ID
, QUOTA_ID
, PERIOD_TARGET
, ITD_TARGET
, PERIOD_PAYMENT
, ITD_PAYMENT
, QUARTER_NUM
, PERIOD_YEAR
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATED_BY
, PERFORMANCE_GOAL
, PERFORMANCE_GOAL_ITD
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM CN.CN_PERIOD_QUOTAS_ALL;
CN.CN_PERIOD_QUOTAS_ALL does not reference any database object
CN.CN_PERIOD_QUOTAS_ALL is referenced by following:
|
|
|