View: AMS_CAMPAIGN_FORECASTS_ALL_V

Product:	AMS - Marketing
Description:	Contains all forecast information for a campaign.
Implementation/DBA Data:	APPS.AMS_CAMPAIGN_FORECASTS_ALL_V

View Text

SELECT F.ROWID
, F.FORECAST_ID
, F.FORECAST_TYPE
, F.ACT_FCAST_USED_BY_ID
, F.CREATION_DATE
, F.CREATED_FROM
, F.CREATED_BY
, F.LAST_UPDATE_DATE
, F.LAST_UPDATED_BY
, F.LAST_UPDATE_LOGIN
, F.PROGRAM_APPLICATION_ID
, F.PROGRAM_ID
, F.PROGRAM_UPDATE_DATE
, F.REQUEST_ID
, F.OBJECT_VERSION_NUMBER
, F.HIERARCHY
, F.HIERARCHY_LEVEL
, F.LEVEL_VALUE
, F.FORECAST_CALENDAR
, F.PERIOD_LEVEL
, F.FORECAST_PERIOD_ID
, F.FORECAST_DATE
, F.FORECAST_UOM_CODE
, F.FORECAST_QUANTITY
, F.FORECAST_REMAINING_QUANTITY
, F.FORECAST_REMAINING_PERCENT
, F.FORWARD_BUY_QUANTITY
, F.FORWARD_BUY_PERIOD
, F.CUMULATION_PERIOD_CHOICE
, F.BASE_QUANTITY
, F.BASE_QUANTITY_TYPE
, LKP1.MEANING
, F.FORECAST_SPREAD_TYPE
, LKP2.MEANING
, F.CONTEXT
, F.ATTRIBUTE_CATEGORY
, F.ATTRIBUTE1
, F.ATTRIBUTE2
, F.ATTRIBUTE3
, F.ATTRIBUTE4
, F.ATTRIBUTE5
, F.ATTRIBUTE6
, F.ATTRIBUTE7
, F.ATTRIBUTE8
, F.ATTRIBUTE9
, F.ATTRIBUTE10
, F.ATTRIBUTE11
, F.ATTRIBUTE12
, F.ATTRIBUTE13
, F.ATTRIBUTE14
, F.ATTRIBUTE15
, F.ORG_ID
, C.CAMPAIGN_NAME
, C.CAMPAIGN_THEME
, C.DESCRIPTION
, C.ACTUAL_EXEC_START_DATE
, C.ACTUAL_EXEC_END_DATE
FROM AMS_ACT_FORECASTS_ALL F
, AMS_CAMPAIGNS_VL C
, AMS_LOOKUPS LKP1
, AMS_LOOKUPS LKP2
WHERE F.ARC_ACT_FCAST_USED_BY = 'CAMP'
AND F.ACT_FCAST_USED_BY_ID = C.CAMPAIGN_ID
AND LKP1.LOOKUP_TYPE = 'AMS_FCAST_BASE_VOL_SOURCE'
AND F.BASE_QUANTITY_TYPE = LKP1.LOOKUP_CODE
AND LKP2.LOOKUP_TYPE = 'AMS_FCAST_SPREAD'
AND F.FORECAST_SPREAD_TYPE = LKP2.LOOKUP_CODE

Columns