[Home] [Help] [Dependency Information]
Object Name: | AS_SALES_FORECAST_UWQ_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AS.AS_SALES_FORECAST_UWQ_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_ID | NUMBER | Yes | Forecast Identifier | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | Period Name |
STATUS_CODE | VARCHAR2 | (30) | Yes | status code of forecast (e.g. SUBMITTED or SAVED) |
RESOURCE_ID | NUMBER | Resource Identifier | ||
RESOURCE_TYPE | VARCHAR2 | (11) | Resource Type | |
OBJECT_CODE | CHAR | (8) | Object Code | |
RESOURCE_GROUP_ID | NUMBER | Yes | Resource Group Identifier (Salesgroup Identifier) | |
FORECAST_AMOUNT | NUMBER | Forecast Amount | ||
BEST_FORECAST_AMOUNT | NUMBER | Best Forecast Amount | ||
WORST_FORECAST_AMOUNT | NUMBER | Worst Forecast Amount |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_ID
, PERIOD_NAME
, STATUS_CODE
, RESOURCE_ID
, RESOURCE_TYPE
, OBJECT_CODE
, RESOURCE_GROUP_ID
, FORECAST_AMOUNT
, BEST_FORECAST_AMOUNT
, WORST_FORECAST_AMOUNT
FROM APPS.AS_SALES_FORECAST_UWQ_V;
|
|
|