VIEW: APPS.AMS_CAMPAIGN_FORECASTS_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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