[Home] [Help]
View: AS_SALES_FORECAST_UWQ_V
Product: | AS - Sales Foundation |
Description: | This view is used for Universal Work Queue |
Implementation/DBA Data: |
APPS.AS_SALES_FORECAST_UWQ_V
|
View Text
SELECT INF.FORECAST_ID
, INF.PERIOD_NAME
, INF.STATUS_CODE
, INF.SALESFORCE_ID
, DECODE(RES.CATEGORY
, 'EMPLOYEE'
, 'RS_EMPLOYEE'
, 'PARTNER'
, 'RS_PARTNER'
, NULL)
, 'FORECAST'
, INF.SALES_GROUP_ID
, INF.FORECAST_AMOUNT
, INF.BEST_FORECAST_AMOUNT
, INF.WORST_FORECAST_AMOUNT
FROM AS_INTERNAL_FORECASTS INF
, JTF_RS_RESOURCE_EXTNS RES
WHERE INF.SALESFORCE_ID = RES.RESOURCE_ID(+)
Columns
Name |
FORECAST_ID |
PERIOD_NAME |
STATUS_CODE |
RESOURCE_ID |
RESOURCE_TYPE |
OBJECT_CODE |
RESOURCE_GROUP_ID |
FORECAST_AMOUNT |
BEST_FORECAST_AMOUNT |
WORST_FORECAST_AMOUNT |