[Home] [Help] [Dependency Information]
Object Name: | CN_SRP_QUOTA_ASSIGNS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SRP_QUOTA_ASSIGN_ID | NUMBER | (15) | Yes | |
SRP_PLAN_ASSIGN_ID | NUMBER | (15) | Yes | |
QUOTA_ID | NUMBER | (15) | Yes | |
QUOTA_NAME | VARCHAR2 | (80) | Yes | |
QUOTA_DESCRIPTION | VARCHAR2 | (1900) | ||
QUOTA_START_DATE | DATE | Yes | ||
QUOTA_END_DATE | DATE | |||
INTERVAL_TYPE_ID | NUMBER | (15) | ||
INTERVAL_TYPE | VARCHAR2 | (80) | Yes | |
INCENTIVE_TYPE_CODE | VARCHAR2 | (30) | Yes | |
INCENTIVE_TYPE | VARCHAR2 | (80) | Yes | |
CREDIT_TYPE_ID | NUMBER | (15) | ||
CREDIT_TYPE | VARCHAR2 | (80) | Yes | |
ELIGIBLE_FOR_PAYEE | VARCHAR2 | (1) | ||
CALCULATE_LAST | VARCHAR2 | (1) | ||
QUOTA | NUMBER | Yes | ||
FIXED_AMOUNT | NUMBER | |||
PERFORMANCE_GOAL | NUMBER | |||
ADDUP_REV_CLASS_FLAG | VARCHAR2 | (1) | ||
CUSTOMIZED_FLAG | VARCHAR2 | (1) | Yes | |
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. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
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). | |
PERIOD_TARGET_DIST_RULE_CODE | VARCHAR2 | (30) | Yes | |
PERIOD_TARGET_UNIT_CODE | VARCHAR2 | (30) | Yes | |
QUOTA_TYPE_CODE | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT SRP_QUOTA_ASSIGN_ID
, SRP_PLAN_ASSIGN_ID
, QUOTA_ID
, QUOTA_NAME
, QUOTA_DESCRIPTION
, QUOTA_START_DATE
, QUOTA_END_DATE
, INTERVAL_TYPE_ID
, INTERVAL_TYPE
, INCENTIVE_TYPE_CODE
, INCENTIVE_TYPE
, CREDIT_TYPE_ID
, CREDIT_TYPE
, ELIGIBLE_FOR_PAYEE
, CALCULATE_LAST
, QUOTA
, FIXED_AMOUNT
, PERFORMANCE_GOAL
, ADDUP_REV_CLASS_FLAG
, CUSTOMIZED_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PERIOD_TARGET_DIST_RULE_CODE
, PERIOD_TARGET_UNIT_CODE
, QUOTA_TYPE_CODE
FROM APPS.CN_SRP_QUOTA_ASSIGNS_V;
|
|
|