View: BIM_SUMV_SLIST_PERF

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

View Text

SELECT BTS.CAMPAIGN_ID CAMPAIGN_ID
, BTS.PERIOD_NAME PERIOD_NAME
, BTS.PERIOD_START_DATE START_DATE
, BTS.PERIOD_END_DATE END_DATE
, BTS.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BTS.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BTS.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BTS.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME
, BTS.TARGET_SEGMENT_ID TARGET_SEGMENT_ID
, BTG.TARGET_SEGMENT_NAME TARGET_SEGMENT_NAME
, BTS.BILL_TO_GEOGRAPHY_CODE GEOGRAPHY_CODE
, BTS.NUM_OF_LEADS NUM_OF_LEADS
, BTS.INITIATED_REVENUE INITIATED_REVENUE
, BTS.NUM_OF_NEW_ACCTS NUM_OF_NEW_ACCTS
FROM BIM_TRGT_SGMT_PERF_SUMM BTS
, BIM_DIMV_MEDIA_CHANNELS BMC
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_SALES_CHANNELS BSC
, BIM_DIMV_TARGET_SGMTS BTG
WHERE BTS.MEDIA_ID = BMC.MEDIA_ID
AND BTS.CHANNEL_ID = BMC.CHANNEL_ID
AND BTS.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BTS.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE
AND BTS.TARGET_SEGMENT_ID = BTG.TARGET_SEGMENT_ID WITH READ ONLY

Columns