View: BIM_SUMV_CAMP_COST

Product:	BIM - Marketing Intelligence
Description:	Joins the summary table to the dimension views.
Implementation/DBA Data:	APPS.BIM_SUMV_CAMP_COST

View Text

SELECT BCR.CAMPAIGN_ID CAMPAIGN_ID
, BCR.PERIOD_NAME PERIOD_NAME
, BCR.PERIOD_START_DATE START_DATE
, BCR.PERIOD_END_DATE END_DATE
, BCR.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BCR.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BCR.FORECASTED_REVENUE FORECASTED_REVENUE
, BCR.FORECASTED_COST FORECASTED_COST
, BCR.INITIATED_REVENUE INITIATED_REVENUE
, BCR.ACTUAL_COST ACTUAL_COST
, BCR.NUM_OF_LEADS NUM_OF_LEADS
FROM BIM_CMPGN_REVCOST_SUMM BCR
, BIM_DIMV_MEDIA_CHANNELS BMC
WHERE BCR.MEDIA_ID = BMC.MEDIA_ID
AND BCR.CHANNEL_ID = BMC.CHANNEL_ID WITH READ ONLY

Columns