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