[Home] [Help] [Dependency Information]
Object Name: | AS_FORECAST_PROB_ALL_B |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_FORECAST_PROB_ALL_B |
Subobject Name: | |
Status: | VALID |
AS_FORECAST_PROB_ALL defines win probability values for sales
opportunities. When LEAD_STATUS_CHANGE_CODE is present, the
record associates the win probability with the opportunity status. The
association affects the opportunity from behavior, such that changing
update on either win probability or opportunity status affects the
counterpart as specified by the association in AS_FORECAST_PROB.
.
.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_FORECAST_PROB_ALL_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
PROBABILITY_VALUE
ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROBABILITY_VALUE | NUMBER | Yes | Win probability value of sales opportunity in the range from 0 to 100 | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
START_DATE_ACTIVE | DATE | Yes | Date which the win probability becomes active | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the win probability is enabled |
MEANING | VARCHAR2 | (80) | Obsolete | |
LEAD_STATUS_CHANGE_CODE | VARCHAR2 | (30) | After an opportunity win probability exceeds this record's value, the opportunity status changes to this value | |
END_DATE_ACTIVE | DATE | Date which the win probability becomes inactive | ||
ORG_ID | NUMBER | Operating unit which performed this transaction | ||
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 | |
USAGE_INDICATOR | VARCHAR2 | (30) | Indicates to whom the data will be exposed to. valid values are "OS" ,"PRM","ALL" | |
SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use | ||
INTERNAL_UPGRADE_PROB_VALUE | NUMBER | For internal use only on data migration- to keep the new probability value | ||
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT PROBABILITY_VALUE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, ENABLED_FLAG
, MEANING
, LEAD_STATUS_CHANGE_CODE
, END_DATE_ACTIVE
, ORG_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, USAGE_INDICATOR
, SECURITY_GROUP_ID
, INTERNAL_UPGRADE_PROB_VALUE
, OBJECT_VERSION_NUMBER
FROM OSM.AS_FORECAST_PROB_ALL_B;
OSM.AS_FORECAST_PROB_ALL_B does not reference any database object
OSM.AS_FORECAST_PROB_ALL_B is referenced by following:
|
|
|