[Home] [Help] [Dependency Information]
Object Name: | AS_INTERNAL_FORECASTS |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_INTERNAL_FORECASTS |
Subobject Name: | |
Status: | VALID |
Table to store the summary forecast information for individual sales person or sales group.
The forecast be submitted any number of times . The status of forecast determines if the superiors can view the forecast of subordinates. Pipeline amounts are calculated from sales credits and opportunity data .Initial forecast amounts are defaulted as per user profile . User can then change the forecast amounts and submit the forecast.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_INTERNAL_FORECASTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FORECAST_ID |
AS_INTERNAL_FORECASTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_NAME
SALES_GROUP_ID SALESFORCE_ID END_DATE_ACTIVE |
AS_INTERNAL_FORECASTS_N10 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORIGINAL_FORECAST_ID |
AS_INTERNAL_FORECASTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_NAME
SALES_GROUP_ID END_DATE_ACTIVE |
AS_INTERNAL_FORECASTS_N50 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
AS_INTERNAL_FORECASTS_N6 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRUNC("SUBMISSION_DATE") |
AS_INTERNAL_FORECASTS_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SUBMISSION_DATE |
AS_INTERNAL_FORECASTS_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SALES_GROUP_ID
PERIOD_NAME FORECAST_CATEGORY_ID CREDIT_TYPE_ID STATUS_CODE SALESFORCE_ID |
AS_INTERNAL_FORECASTS_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FORECAST_CATEGORY_ID
CREDIT_TYPE_ID PERIOD_NAME SALES_GROUP_ID SALESFORCE_ID END_DATE_ACTIVE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_ID | NUMBER | Yes | Forecast Identifier | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
REQUEST_ID | NUMBER | Request Identifier | ||
PROGRAM_APPLICATION_ID | NUMBER | Program Application Identifier | ||
PROGRAM_ID | NUMBER | Program Identifier | ||
PROGRAM_UPDATE_DATE | DATE | Program Update Date | ||
SUBMISSION_DATE | DATE | Forecast Submission Date | ||
PERIOD_NAME | VARCHAR2 | (15) | Yes | Period Name (e.g. Q4-00 ,MAR-00,...) |
SALESFORCE_ID | NUMBER | Salesforce Identifier | ||
EMPLOYEE_PERSON_ID | NUMBER | Employee Person Identifier from HR | ||
SALES_GROUP_ID | NUMBER | Yes | Sales Group Identifier | |
PARTNER_ADDRESS_ID | NUMBER | Partner Address Identifier | ||
PARTNER_CUSTOMER_ID | NUMBER | Partner Customer Identifier | ||
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Forecast Currency Code (e.g. USD,CAD .etc) |
CREDIT_TYPE_ID | NUMBER | Yes | Type identifier of the sales credit .(If this sales credit is for FORECAST or not.) | |
REVENUE_FLAG | VARCHAR2 | (1) | Obsolete | |
WORKSHEET_TYPE | VARCHAR2 | (30) | Obsolete | |
ACTIVE_FLAG | VARCHAR2 | (1) | Obsolete | |
WORST_FORECAST_AMOUNT_FLAG | VARCHAR2 | (1) | Flag to indicate the currency conversion rate was not found while rolling up the worst forecast amount) | |
WORST_FORECAST_AMOUNT | NUMBER | Worst Forecast Amount | ||
FORECAST_AMOUNT_FLAG | VARCHAR2 | (1) | Flag to indicate the currency conversion rate was not found while rolling up the forecast amount) | |
FORECAST_AMOUNT | NUMBER | Forecast Amount | ||
BEST_FORECAST_AMOUNT_FLAG | VARCHAR2 | (1) | Flag to indicate the currency conversion rate was not found while rolling up the best forecast amount) | |
BEST_FORECAST_AMOUNT | NUMBER | Best Forecast Amount | ||
WEIGHTED_PIPELINE_AMOUNT_FLAG | VARCHAR2 | (1) | Flag to indicate the currency conversion rate was not found while rolling up the weighted pipeline amount) | |
WEIGHTED_PIPELINE_AMOUNT | NUMBER | Weighted Pipeline Amount | ||
PIPELINE_AMOUNT_FLAG | VARCHAR2 | (1) | Flag to indicate the currency conversion rate was not found while rolling up the pipeline amount) | |
PIPELINE_AMOUNT | NUMBER | Pipeline Amount .This represents total amount which can be forecasted within a given period for a sales rep or Sales Group | ||
WON_PIPELINE_AMOUNT_FLAG | VARCHAR2 | (1) | Flag to indicate the currency conversion rate was not found while rolling up the won pipeline amount) | |
WON_PIPELINE_AMOUNT | NUMBER | Amount Won till date | ||
QUOTA_AMOUNT_FLAG | VARCHAR2 | (1) | Obsolete | |
QUOTA_AMOUNT | NUMBER | Obsolete | ||
ORIGINAL_FORECAST_ID | NUMBER | Id of Original forecast record | ||
STATUS_CODE | VARCHAR2 | (30) | Yes | Status of forecast (SUBMITTED or SAVED) |
START_DATE_ACTIVE | DATE | Not Currently Used | ||
END_DATE_ACTIVE | DATE | End Date for the forecast .You can not make any changes once end date is stored in this column. | ||
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 | |
SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use | ||
FORECAST_CATEGORY_ID | NUMBER | Yes | Foreign Key to AS_FORECAST_CATEGORIES | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
OPP_WORST_FORECAST_AMOUNT | NUMBER | Worst Forecast Amount for Opportunity | ||
OPP_FORECAST_AMOUNT | NUMBER | Forecast Amount for Opportunity | ||
OPP_BEST_FORECAST_AMOUNT | NUMBER | Best Forecast Amount for Opportunity |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SUBMISSION_DATE
, PERIOD_NAME
, SALESFORCE_ID
, EMPLOYEE_PERSON_ID
, SALES_GROUP_ID
, PARTNER_ADDRESS_ID
, PARTNER_CUSTOMER_ID
, CURRENCY_CODE
, CREDIT_TYPE_ID
, REVENUE_FLAG
, WORKSHEET_TYPE
, ACTIVE_FLAG
, WORST_FORECAST_AMOUNT_FLAG
, WORST_FORECAST_AMOUNT
, FORECAST_AMOUNT_FLAG
, FORECAST_AMOUNT
, BEST_FORECAST_AMOUNT_FLAG
, BEST_FORECAST_AMOUNT
, WEIGHTED_PIPELINE_AMOUNT_FLAG
, WEIGHTED_PIPELINE_AMOUNT
, PIPELINE_AMOUNT_FLAG
, PIPELINE_AMOUNT
, WON_PIPELINE_AMOUNT_FLAG
, WON_PIPELINE_AMOUNT
, QUOTA_AMOUNT_FLAG
, QUOTA_AMOUNT
, ORIGINAL_FORECAST_ID
, STATUS_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, FORECAST_CATEGORY_ID
, OBJECT_VERSION_NUMBER
, OPP_WORST_FORECAST_AMOUNT
, OPP_FORECAST_AMOUNT
, OPP_BEST_FORECAST_AMOUNT
FROM OSM.AS_INTERNAL_FORECASTS;
OSM.AS_INTERNAL_FORECASTS does not reference any database object
OSM.AS_INTERNAL_FORECASTS is referenced by following:
|
|
|